SQL Execute failed
Moderators: chulett, rschirm, roy
SQL Execute failed
Hi,
I am having an issue with one of the sub job in a controller job. Sub job is logging Warning messages as below. Its logging warning messages only but not causing any job abort.
emailLoad..emailLoadProcess.emailLoad: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO survey_email(email_to, email_from, email_cc, email_bcc, email_subject, email_charset, email_body, ci_survey_requestor_name, ci_sce_name, ci_cc_name, ci_project_survey_close_date) VALUES (?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=S1009, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Invalid argument value
email_to = "jenny.south@examhub.exch.cspss.com"
email_from = "eclient@eds.com"
email_cc = "jeremy.south@examhub.exch.cspss.com,mark.kizzar@examhub.exch.cspss.com,tim.harvey@examhub.exch.cspss.com"
email_bcc = "ServExcProductionSupport@exsc01.exch.cspss.com"
email_subject = "CSPSS Survey Request Notification"
email_charset = "iso-8859-1"
email_body =
ci_survey_requestor_name = "Anitha Sharma"
ci_sce_name = "Jenny South"
ci_cc_name = "Rajiv Joshi"
ci_project_survey_close_date = NULL
Please advise me on this. One more thing. Same project is available on another server, hence tried processing the same data. Data is processed w/o any warning messages.
Appreciate your help.
Thanks,
I am having an issue with one of the sub job in a controller job. Sub job is logging Warning messages as below. Its logging warning messages only but not causing any job abort.
emailLoad..emailLoadProcess.emailLoad: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO survey_email(email_to, email_from, email_cc, email_bcc, email_subject, email_charset, email_body, ci_survey_requestor_name, ci_sce_name, ci_cc_name, ci_project_survey_close_date) VALUES (?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=S1009, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Invalid argument value
email_to = "jenny.south@examhub.exch.cspss.com"
email_from = "eclient@eds.com"
email_cc = "jeremy.south@examhub.exch.cspss.com,mark.kizzar@examhub.exch.cspss.com,tim.harvey@examhub.exch.cspss.com"
email_bcc = "ServExcProductionSupport@exsc01.exch.cspss.com"
email_subject = "CSPSS Survey Request Notification"
email_charset = "iso-8859-1"
email_body =
ci_survey_requestor_name = "Anitha Sharma"
ci_sce_name = "Jenny South"
ci_cc_name = "Rajiv Joshi"
ci_project_survey_close_date = NULL
Please advise me on this. One more thing. Same project is available on another server, hence tried processing the same data. Data is processed w/o any warning messages.
Appreciate your help.
Thanks,
dsx
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Was wondering about that. What kind of value would leave the entry completely blank like that? It's not null or it would say NULL like it does for the date. An empty string would show a pair of double-quotes I would think.
Or is this some kind of copy/paste error?
Or is this some kind of copy/paste error?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
... or use Debugger or stage tracing to figure out what value was sent to email_body column.
There used to be a bug in ODBC (2.0 from memory) where too long a string for the max length of a VarChar would exhibit this kind of reporting behaviour.
However, on closer inspection, I note that the error message comes from the ODBC Driver Manager, so we may be barking up the wrong tree completely - you will also need to test whether the particular DSN is correctly configured.
There used to be a bug in ODBC (2.0 from memory) where too long a string for the max length of a VarChar would exhibit this kind of reporting behaviour.
However, on closer inspection, I note that the error message comes from the ODBC Driver Manager, so we may be barking up the wrong tree completely - you will also need to test whether the particular DSN is correctly configured.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How this issue needs to be handled?That's probably because both the SQL CAE Access Group standards and the ODBC standards specify single-quoted string literals.
The same project is successfully running on Windows 2000 server, no warning messages & no insert fail statements at all. We are finding the issue only on Win 2003 server. Any suggestions.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
All complaints to billg@microsoft.com then. DataStage engineers can not be responsible for differences between the way the two Microsoft products work.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.