getting error upon importing webcenter capture workspace from one environment to other
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]