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 (Doc ID 1110764.1)

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.

Symptoms

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

Changes

 

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