IdcAnalyzer or FoldersStructureArchive Fails Due to Invalid Column Name IdcSeqRevID (Doc ID 1416669.1)

Last updated on OCTOBER 10, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

This error can occur when using the IdcAnalyzer:

After selecting either check database or check file system in Analyzer and hitting Start Analysis it comes up with the following error:

Unable to create the result set for query........ invalid column name 'IdcSeqRevID'.



It can also occur when doing a FolderStructureArchive import. Importing the archive does complete but the following exception is generated:

intradoc.data.DataException:
!csDbUnableToCreateResultSet,QnativeCurrentCounter(SELECT
IDENT_CURRENT(IdcSeqColID) AS dCurrentIndex)!$[FMWGEN][SQLServer JDBC
Driver][SQLServer]Invalid column name 'IdcSeqColID'.


 

Changes

 

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