Central Coding Fails after CC Database Users Migrate to Different Database Instance/Server - ORA-00942 (Doc ID 1555279.1)

Last updated on AUGUST 01, 2014

Applies to:

Oracle Health Sciences Central Coding - Version 2.0.0 to 3.0.2 [Release 2.0.0 to 3.0.0]
Information in this document applies to any platform.

Symptoms

Central Coding fails after CC db users migrate to different db instance/server.

The error from event log shows:
Exception Type: Platform.Storage.Exceptions.DBProviders.Messages.DbProviderException MessageId: DBReadError ResourceArguments: 0: 1: SELECT COUNT(*) AS resultCount FROM (SELECT llt_code, llt_name FROM <customer mnemonic for cc>MedDRA151.l_low_level_term WHERE UPPER(llt_name) = UPPER('<value>')) 2:  Oracle.DataAccess.Client.OracleException ORA-00942: table or view does not exist.

Changes

 DB users are migrated to different db instance/server.

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