My Oracle Support Banner

New Install "/Portal" Throws Error "Table or view does not exist" When Importing the Database (Doc ID 2465432.1)

Last updated on JUNE 04, 2019

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 6.2.1.0 and later
Information in this document applies to any platform.

Symptoms

After installing PLM for Process, "/Portal" throws error while importing database:

Error message:

[OracleException (0x80004005): ORA-00942: table or view does not exist]
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable) +1954
Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) +91
Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) +9346
Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +747
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +122
Xeno.Data.Meta.XMetaData.getDbInfoIntoDataSet(String sql, String tableName) +245
Xeno.Data.Meta.XMetaData.LoadMetaClassHelpers() +99
Xeno.Data.Meta.XMetaDataBase.Initialize_Internal() +32
Import: Release 12.2.0.1.0


Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_04" successfully loaded/unloaded
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in AL32UTF8 character set and UTF8 NCHAR character set
Warning: possible data loss in character set conversions
Starting "SYSTEM"."SYS_IMPORT_FULL_04": system/********@THEL71 CLUSTER=NO dumpfile=CERTIFIEDDB_V6210.DMP logfile=THEL71_imp_3_88MFBW5.log directory=imp_3_88MFBW5
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"PLM4P" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"PLM4P"."ANALYTICALPROPERTYBAK" failed to create with error:
ORA-00910: specified length too long for its datatype

Failing sql is:
CREATE TABLE "PLM4P"."ANALYTICALPROPERTYBAK" ("PKID" CHAR(40 BYTE) NOT NULL ENABLE, "PROPERTYNAME" NVARCHAR2(256) NOT NULL ENABLE, "TESTUSED" NVARCHAR2(4000), "DEFAULTSYNTAX" NVARCHAR2(4000), "SPECIALNOTES" NVARCHAR2(4000), "FKANALYTICALCLASSIFICATION" CHAR(40 BYTE) NOT NULL ENABLE, "PROPERTYNUM" VARCHAR2(50 BYTE)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE( INITIAL 524288 NEXT 1048576 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS"

ORA-39083: Object type TABLE:"PLM4P"."AUDITCOVERPAGEFIELDS" failed to create with error:
ORA-00910: specified length too long for its datatype

Steps to reproduce:

  1. Install PLM for Process.
  2. Import database.

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!


In this Document
Symptoms
Cause
Solution


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