Troubleshooting
Problem
Creating a partner to Onboard in the PEM Community Manager (PCM) a pop up message is given after selecting the Submit button:
"could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement"
Diagnosing The Problem
You must look at the PCM log to see:
status Code: 404
SI Error Details: {
"errorCode": 404,
"errorDescription": "API000464: User Account \"YY-XXXX-ZZZZZZ\" not found."
}
Exception occurred: 'at updateUser'
com.pe.pcm.exception.CommunityManagerServiceException: null
at com.pe.pcm.exception.GlobalExceptionHandler.internalServerError(GlobalExceptionHandler.java:68)
SI Error Details: {
"errorCode": 404,
"errorDescription": "API000464: User Account \"YY-XXXX-ZZZZZZ\" not found."
}
Exception occurred: 'at updateUser'
com.pe.pcm.exception.CommunityManagerServiceException: null
at com.pe.pcm.exception.GlobalExceptionHandler.internalServerError(GlobalExceptionHandler.java:68)
SQL Error: 2628, SQLState: S0001
String or binary data would be truncated in table 'sfg.dbo.YFS_USER', column 'PWD_POLICY_KEY'. Truncated value: 'WWW_RRRRRRRRRRRRRR_TTTTT'.
Runtime Exception:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:259)
String or binary data would be truncated in table 'sfg.dbo.YFS_USER', column 'PWD_POLICY_KEY'. Truncated value: 'WWW_RRRRRRRRRRRRRR_TTTTT'.
Runtime Exception:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:259)
Resolving The Problem
The error message is caused because one is trying to enter more characters in the field that are allowed in the database column. In this case the column 'PWD_POLICY_KEY' in the table "YFS_USER" can only handle 24 characters.
The resolution is to make the value mentioned in the SQL error truncated to the correct size of the column.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFG8Z","label":"IBM Sterling Partner Engagement Manager Software"},"ARM Category":[{"code":"a8m50000000L0lJAAS","label":"User Interface-\u003EUI Errors"}],"ARM Case Number":"TS017108686","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
More support for:
IBM Sterling Partner Engagement Manager Software
Component:
User Interface->UI Errors
Software version:
All Versions
Document number:
7167764
Modified date:
06 September 2024
UID
ibm17167764
Manage My Notification Subscriptions