Central Coding Fails after CC Database Users Migrate to Different Database Instance/Server - ORA-00942
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.
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.
DB users are migrated to different db instance/server.
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