My Oracle Support Banner

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 JANUARY 10, 2025

Applies to:

Oracle WebLogic Portal - Version 10.3.2 to 10.3.2 [Release AS10gR3]
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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.