December 17, 2008 at 6:25 pm
I wrote a query in the Expression window but I get an error msg when I try to preview it with the OLEDB Source.
ORA-12801: error signaled in parallel query server P001
ORA-01861: literal does not match format string (OraOLEDB)
-- Bad query, fails to preview.
"SELECt a.petky from dwods.pet a where
a.dw_load_date <= " + "'"
+
(DT_STR, 4, 1252) DATEPART("yyyy", getdate())
+
(DT_STR, 4, 1252) DATEPART("mm", getdate())
+
(DT_STR, 4, 1252) DATEPART("dd", getdate())
+"'" + " and
rownum < 5"
-- Good query.
"SELECt a.petky from dwods.pet a where rownum < 5"
This bad query works with different table called dwoods.cus
"SELECt a.cusky from dwods.cus a where
a.dw_load_date <= " + "'"
+
(DT_STR, 4, 1252) DATEPART("yyyy", getdate())
+
(DT_STR, 4, 1252) DATEPART("mm", getdate())
+
(DT_STR, 4, 1252) DATEPART("dd", getdate())
+"'" + " and
rownum < 5"
Can anyone provide some input how to fix it?
Looks like a.dw_load_date is the problem. But I'm not sure.
December 18, 2008 at 6:33 am
This looks like an issue with the query when being passed to Oracle. You are building a date and apparently the format you are passing from your concatenation is incorrect. I really don't know anything about Oracle, but based on the error message this seems like the answer.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 18, 2008 at 11:16 am
It works with table cus. Having the same data type DATE
December 18, 2008 at 5:01 pm
I solved it. Oracle DBA helped me.
December 18, 2008 at 5:32 pm
Could you post the solution so if someone else has the same problem and finds this thread they'll know too?
Thanks,
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply