It's all about the answers!

Ask a question

Rational Insight ETL job 'bind error'


Kunal Bajaj (26510) | asked Mar 31 '15, 3:14 p.m.

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



permanent link
Donald Nong (14.4k313) | answered Apr 01 '15, 1:28 a.m.
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.

permanent link
Francesco Chiossi (5.7k1719) | answered Apr 01 '15, 5:01 a.m.
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


Register or to post your answer.