Support Article
SQL Exception ORA-12899 occurs on creating a case
SA-43466
Summary
SQL Exception ORA-12899 occurs on creating a case.
Error Messages
Last SQL: insert into your_data_schema.pr_sys_locks ( pxCreateDateTime, pxCreateOpName, pxCreateOperator, pxCreateSystemID, pxExpireDateTime, pxLockHandle, pxObjClass, pxOwnerId, pxSystemName, pxSystemNode, pxUpdateDateTime, pxUpdateOpName, pxUpdateOperator, pxUpdateSystemID, pxUserHost, pyLabel, pzInsKey) values (?, ?, ?, ?, ?, ?, 'System-Locks', ?, ?, ?, ?, ?, ?, ?, ?, '', ?)
java.sql.SQLException: ORA-12899: value too large for column "your_data_schema"."PR_SYS_LOCKS"."PXUSERHOST" (actual: 82, maximum: 64)
Steps to Reproduce
Create a host name with more than 64 characters.
Root Cause
A defect in Pegasystems’ code or rules. The fully qualified Domain name is longer than the available PXUSERHOST column in the table.
Resolution
Perform the following local-change:Increase the column width to 255.
Published February 20, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.