SAP Knowledge Base Article - Preview

2809585 - OBJECTID Column size in SMP_AUDIT_LOG_DATA Table causes data truncation in SAP Mobile Platform

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

SAP Mobile Platform 3.0

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.