Rational Insight ETL job 'bind error'
We are on Rational Insight 1.1.1.2, Windows 2008 Server R2, MS SQL Server 2008 R2
We have a new Development environment which we are setting up. Taken the ETL repository from Production. Upon executing the first job, we get the following error:
DM-DBM-3661 A bind error occurred on column 'LAST_CHANGED_DATE'; the value is to
o large (length 9 vs 10).
DM-DBM-0355 Value in error:
ERROR=255
DM-DLV-0101 Delivery 'Fact1': failed on statement .....
I looked up the error code and found the following link which was not helpful. Does anyone know how to resolve this? These jobs are working in Production.
http://www-01.ibm.com/support/docview.wss?uid=swg1PM32107
Thanks.
Kunal
2 answers
Hello Kunal,
this problem could be related to a specific object in CLM that returns incorrect data when queried by the REST API.
You should try to identify the problematic object and see if there is any incorrect data showing in the WebUI.
The job where you have the failure could give an hint on the type of object that is affected.
Checking the last entry in the JDBC log (ri_jdbc.log) at the time the error occurs, can give you the last REST call that was sent to the server before the error occurred and that could also help in identifying the object.
Best Regards,
Francesco Chiossi
this problem could be related to a specific object in CLM that returns incorrect data when queried by the REST API.
You should try to identify the problematic object and see if there is any incorrect data showing in the WebUI.
The job where you have the failure could give an hint on the type of object that is affected.
Checking the last entry in the JDBC log (ri_jdbc.log) at the time the error occurs, can give you the last REST call that was sent to the server before the error occurred and that could also help in identifying the object.
Best Regards,
Francesco Chiossi