UltraLiteJ Error[-857]: Synchronization failed due to an error on the server

[Former Member]

Hi,

I have been trying to sync with a syncronization group, In SUP 2.2 and android.

But my android eclipse log cat shows...

Caused by: com.ianywhere.ultralitejni12.implementation.JniException: UltraLiteJ Error[-857]: Synchronization failed due to an error on the server: [-10225] Message: Failure occurred while executing user supplied code

and my SCC logs

shows this type error info,

{"_op":"C","level":5,"code":412,"eisCode":"9502","message":"java.sql.SQLException:SQL Anywhere Error -638: Right truncation of string data","component":"NFAApp_QASDB","entityKey":null,"operation":"synchronize","requestId":null,"timestamp":"2014-04-21 11:50:15.997","messageId":0,"_rc":0}

I have prepared my mbo for SQL store procedure. Please help me!

Thank you.

[midhun_vp · Accepted solution]

Can you give the screen shot of MBO created. Have you written any custom query?

Midhun VP

[Former Member · Accepted solution]

Thank you so much Midhun for replying me.

I have resolved the issue of synchronization.

Actually after too much work we found that the name of stored procedure should be

minimal in length. That is why generated mbo will be get small length name.

I mean when tested same Stored procedure with small name(etc abc_xyz) rather than

original one(eg: achdhss_hsfhfhshf_hfsffh_fsjhfsjf_fjsfj) it works fine.  

[agentry_src · Accepted solution]

Hi Prashant,

Please mark this Discussion with a Correct Answer and Helpful Answer where appropriate.  See http://scn.sap.com/community/support/blog/2013/04/03/how-to-close-a-discussion-and-why   Even if you discovered the solution without any outside contributions, it helps others to understand what the solution turned out to be.

Regards, Mike
SAP Customer Experience Group - CEG