Hi All,
Job designing like this :
DB2 stage - > XFM stage -> DB2 stage
source query used in db2 stage:
'select 'S' as no ,'Sucess' as def_va ,REQUEST_ID,REQUEST_SEQ_NO from MDCRDBA.textract_recurr_tbl WHERE REQUEST_ID=#REQUEST_ID# AND REQUEST_SEQ_NO=#REQUEST_SEQ_NO# and REQUEST_STATUS_CD <> 'F' ; '
Query in taget( db2 ) stage
'UPDATE MDCRDBA.textract_recurr_tbl SET REQUEST_STATUS_CD=?,ERROR_MSG_TX=?,REQUEST_END_TS=? WHERE REQUEST_ID=? AND REQUEST_SEQ_NO=?;'
we are getting following error frequently .
FATAL Error :
'MDCR_Success_Update..Success_Update: SQLExecDirect: DB2 error info message '[IBM][CLI Driver] CLI0143E Invalid precision value. SQLSTATE=HY104'.
DSTAGE-DB2CLI-0009`:`SQLBindParameter: Failed to bind a parameter. '
WARNING:
'Attempting to Cleanup after ABORT was raised in stage MDCR_Success_Update..Success_Update'.
please help me how to resolve this error.
Thanks & Regards,
[IBM][CLI Driver] CLI0143E Invalid precision value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 135
- Joined: Tue Dec 09, 2008 10:35 am
-
- Participant
- Posts: 135
- Joined: Tue Dec 09, 2008 10:35 am
A couple of things. If you Reset the aborted job, does an message appear in the log labelled "From previous run..."? If so, please post the contents. Also, are any of your values NULL? Googling around finds some articles on NULL values causing that error but other than that there's not much information out there. Worst case, you may need to involve your official support provider.
-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:
-
- Participant
- Posts: 135
- Joined: Tue Dec 09, 2008 10:35 am