Receiving Error "BEA-001112 Test SELECT COUNT(*) FROM SYSTABLES set up for pool p13nDataSource failed with exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist" During Startup or in Stdout
Last updated on JULY 05, 2017
Applies to:Oracle WebLogic Portal - Version 10.3.2 and later
Information in this document applies to any platform.
There can be different symptoms based on the Database (DB) being used:
1. For Sybase, the servers won't start up and will throw the following exception:
<Error> <JDBC> <AdminServer> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1273516761272> <BEA-001112> <Test "SELECT COUNT(*) FROM SYSTABLES" set up for pool "p13nDataSource" failed with exception: "java.sql.SQLSyntaxErrorException: [OWLS][Sybase JDBC Driver][Sybase]SYSTABLES not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
2. For Oracle, the servers do start up but they continually print the following exception to stdout:
<Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM SYSTABLES" set up for pool "p13nDataSource" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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