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
DM-DBM-0355 Value in error:
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
Since it's a development environment, I believe you can do something that may be deemed unsafe for a production environment - just increase the length of the field 'LAST_CHANGED_DATE'. You can easily find out the affected table from the quoted SQL statement.
|
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 |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.