AnsweredAssumed Answered

Problem with Editing contacts

Question asked by avinash.kande on Jul 14, 2015
Latest reply on Jul 15, 2015 by avinash.kande

Hi ,

 

We have an issue when trying to edit contacts from interface the changes happen and after a minute it get disappeared, any modification to the contact.

 

We tried using webservices, pdm_load, update command on the database nothing worked.

 

Below are the errors

 

1. In stdlogs when tried using interface

07/08 11:26:46.79 "Server name" sqlagt:upinde 3968 ERROR sqlclass.c 1002 SQL Execute failed: [Microsoft OLE DB Provider for SQL Server] [ SQL Code=3621 SQL State=01000] The statement has been terminated.; [Microsoft OLE DB Provider for SQL Server] [ SQL Code=8152 SQL State=22001] String or binary data would be truncated.

07/08 11:26:46.79 "Server name" sqlagt:upinde 3968 ERROR sqlclass.c 1003 Clause (UPDATE ca_contact SET first_name = ? , last_update_date = ? , last_update_user = ? , version_number = ? WHERE contact_uuid = ?) Input (<first_name:string>Anthony_1|<last_update_date:time>07/08/2015 11:26:46|<last_update_user:string>userid|<version_number:int>37|<contact_uuid:uuid>)

07/08 11:26:46.79 "Server name" sqlagt:upinde 3968 ERROR sqlsrvr.c 651 Execution failed. MISC_DB_ERROR

 

2. using update command

 

(1 row(s) affected)

 

(0 row(s) affected)

 

(0 row(s) affected)

 

(1 row(s) affected)

 

(0 row(s) affected)

 

(1 row(s) affected)

Msg 8152, Level 16, State 13, Procedure ca_tr_upd_ca_contact, Line 111

String or binary data would be truncated.

The statement has been terminated.

 

Is something happened wrong on the DB, please help on this. We have opened a CA case and also working with DB to resolve this.

 

Thanks & Regards,
Avinash Kande

Outcomes