Oracle WebCenter Content (MOSC)

MOSC Banner

getting error upon importing webcenter capture workspace from one environment to other

edited Apr 8, 2016 8:30AM in Oracle WebCenter Content (MOSC) 2 commentsAnswered ✓

Dear Experts,

We are getting following error when trying to import Workspace from Dev environment to QA. Please help ::

wls:/fmw_domain/serverConfig> importWorkspace('E:\\Workspaces_bkp\\5thAprilDevWo

rkspace\\Workspace_5thApril_2016.xml')

A run time MBean exception has occurred.

java.lang.RuntimeException: Error committing transaction:; nested exception is:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10

243): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400

: cannot insert NULL into ("QA_CAPTURE"."ECDBSEARCHFIELDS"."ECINDEXDEFID")

Error Code: 1400

Call: INSERT INTO ECDBSEARCHFIELDS (ECDBSEARCHFIELDID, ECDBFIELDNAME, ECDATABASE

SCHEMA, ECDATABASEDATATYPE, ECEXACTMATCH, ECFIELDTYPE, ECMAXRESULTS, ECPRIMARYSO

RTFIELD, ECPRIMARYSORTORDER, ECSECONDARYSORTFIELD, ECSECONDARYSORTORDER, ECTABLE

, ECINDEXDEFID, ECDBSEARCHID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

        bind => [14 parameters bound]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center