Skip to Content
0
Former Member
Feb 08, 2012 at 12:24 PM

MDO issue in SAP MII 12.2SP03

132 Views

Hi,

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,

Ritwika.

Edited by: Michael Appleby on Feb 8, 2012 1:41 PM used to display error message better.