Old, outdated or unused WorkFlowGroups could cause ORA-01722: invalid number error (Doc ID 2047508.1)

Last updated on JUNE 05, 2023

Applies to:

Symptoms

Log file shows a lot of repetitive entries that caused performance issues, such as

[ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xcelerate] [pagename=OpenMarket/Xcelerate/Actions/StatusDetailsFront] Error: com.openmarket.xcelerate.commands.TypeListDispatcher: GetAllAssetTypes: com.openmarket.basic.interfaces.AssetException: Argument 'NAME' is not a valid object name: 'typesobj'

[ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xcelerate] [pagename=OpenMarket/Xcelerate/Actions/StatusDetailsFront] Error: com.openmarket.xcelerate.commands.WorkflowStepDispatcher: GetAuthorizationRoles: com.openmarket.basic.interfaces.AssetException: Argument 'NAME' is not a valid object name: 'stepobj'

[ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xcelerate] [pagename=OpenMarket/Xcelerate/Actions/StatusDetailsFront] Error: com.openmarket.xcelerate.commands.SiteListDispatcher: GetAll: com.openmarket.basic.interfaces.AssetException: Argument 'NAME' is not a valid object name: 'sitesobj'

[ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xcelerate] [pagename=OpenMarket/Xcelerate/Actions/StatusDetailsFront] Error: com.openmarket.xcelerate.commands.WorkflowProcessDispatcher: GetTypes: com.openmarket.basic.interfaces.AssetException: Argument 'NAME' is not a valid object name: 'workflow'

And eventually, an error logs as follows:

[2015-08-10 15:05:00,210 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing query: SELECT * FROM WorkflowGroups WHERE id=?
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at COM.FutureTense.Servlet.JDBCConn.executeStatement_trans(JDBCConn.java:519)
at COM.FutureTense.Servlet.JDBCConn.executeStatement(JDBCConn.java:344)
at COM.FutureTense.CatalogManager.CatalogEngine._executePreparedStmt(CatalogEngine.java:5167)
at COM.FutureTense.CatalogManager.CatalogEngine._executeQueryAndCache(CatalogEngine.java:5143)
at COM.FutureTense.CatalogManager.CatalogEngine._executeQueryAndCacheTrans(CatalogEngine.java:5115)
at COM.FutureTense.CatalogManager.CatalogEngine.executeStatement(CatalogEngine.java:5091)
at COM.FutureTense.Common.CS.SQL(CS.java:1164)
at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:320)
at com.openmarket.xcelerate.workflow.WorkflowGroupManager.getGroupID(WorkflowGroupManager.java:303)
at com.openmarket.xcelerate.workflow.WorkflowEngine.canEditGroup(WorkflowEngine.java:2418)
at com.openmarket.xcelerate.commands.WorkflowEngineDispatcher.CanEditGroup(WorkflowEngineDispatcher.java:1996)

...

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.