Symptom
In the SMP 3.0 Server log, the errors shown depend on the database in use:
- Microsoft SQL Server
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
Error Code: 8152
Call: INSERT INTO SMP_AUDIT_LOG_DATA (ID, ACTIONTYPE, CHANGEDATTRIBUTES, "COMMENT", LOGTIME, OBJECTID, OBJECTTYPE, SOURCEIP, SUCCESS, USERNAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [10 parameters bound]
Query: InsertObjectQuery(com.sap.mobile.platform.server.auditlog.persistence.model.AuditLogData@d5aaaeb)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
at com.sap.mobile.platform.server.online.common.service.base.AbstractServicePersistenceBase.commitTransaction(AbstractServicePersistenceBase.java:177)
at com.sap.mobile.platform.server.online.common.service.base.AbstractServicePersistenceBase.executeInTransaction(AbstractServicePersistenceBase.java:231)
- SAP SQL Anywhere
Internal Exception: java.sql.SQLException: SQL Anywhere Error -638: Right truncation of string data
Error Code: 9502
Call: INSERT INTO SMP_AUDIT_LOG_DATA (ID, ACTIONTYPE, CHANGEDATTRIBUTES, "COMMENT", LOGTIME, OBJECTID, OBJECTTYPE, SOURCEIP, SUCCESS, USERNAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [10 parameters bound]
Read more...
Environment
- SMP 3.0 SP 16
- Microsoft SQL Server
- SAP SQL Anywhere
- Oracle DB
Product
Keywords
SMP 3.0, MSSQL, DBMS, com.microsoft.sqlserver.jdbc.SQLServerException, SQLServerException, String or binary data would be truncated, INSERT INTO SMP_AUDIT_LOG_DATA (ID, ACTIONTYPE, CHANGEDATTRIBUTES, "COMMENT", LOGTIME, OBJECTID, OBJECTTYPE, SOURCEIP, SUCCESS, USERNAME) VALUES , KBA , MOB-ONP , SAP Mobile Platform on Premise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.