My Oracle Support Banner

Error When Attempting To Migrate Live Data Table: [ORA-00942: table or view does not exist ] (Doc ID 2746102.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 21 A Patch 1 and later
Information in this document applies to any platform.


When attempting to migrate a package containing a live data table, the following error will appear in the migration logs:

Some error has occurred, contact site administrator


In the bm.logs an error will be displayed ending in "ORA-00942: table or view does not exist" for example:

[ERROR] - Error while trying to execute a sql statement (0e1b962c-f3bb-4c97-a53c-be24c37eac71)<BAD SQL!!!> SELECT id, table_id, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, date_added, date_modified, field52, field76, validation_flag FROM bm_xxxxx_depdata ORDER BY id
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist





To view full details, sign in with your My Oracle Support account.

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

In this Document

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