We are facing a length problem in Persistant MDO in MII 12.2SP03. Here, we generate a guid which is 36char .But the MDO table can't insert the parameter with 36char, it gives the following error:
[Details :com.sap.sql.log.OpenSQLException: Failed to set the parameter 1 of the statement >>INSERT INTO MDO4551 (FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10,FIELD11,LASTQUERYEXECUTION,LASTQUERYEXECUTIONBY) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)<<: Cannot assign a >>java.lang.String<< object of length 36 to a parameter with JDBC type >>VARCHAR(13)<<]
In the MDO,this field is already assigned with varchar(40).
Infact, it also can't insert more than 6char string value.
It was all okey in the 12.2SP02. Is it a problem of new patch?
We have tried to solve the problem but unfortunately we couldn't find any solution.
If any one can plz help us out in any other ways it would be very helpful.
Thanks & Regards,
Edited by: Michael Appleby on Feb 8, 2012 1:41 PM used to display error message better.