Ensemble Administration Console Will Not Start, Hibernate Error Thrown (Doc ID 1272246.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle WebCenter Ensemble - Version 10.3.0.0 and later
Information in this document applies to any platform.

Symptoms

Ensemble's Admin Console service does not start up and you observe a hibernate Java exception in a PTSpy capture:

Tried to commit a transaction, but couldn't do it. Now attempting a rollback. Thread id=16.
[DB] Database error was caught.
[DB] [JavaError]: Could not execute JDBC batch update
[DB] [SqlStatement]: insert into BASICLOG ININFO (VERSION, IS_DELETED,
ISENABLED, USERNAMEFIELDNAME, USERNAMEFIELDVALUE, USERNAMEFIELDTYPE,
PASS WORDFIELDNAME, PASS WORDFIELDVALUE, PASS WORDFIELDTYPE, ID) values (?, ?,
?, ?, ?, ?, ?, ?, ?, ?)
[DB] [SqlState]: 22018
[DB] [SqlErrorCode]: 1722
[DB] [UnderlyingSql.SqlStatement]: [plumtree][Oracle JDBC
Driver][Oracle]ORA-01722: invalid number

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms