My Oracle Support Banner

Errors with dLastModifiedDate when Trying to Import Folders Structure (Doc ID 557802.1)

Last updated on MAY 17, 2021

Applies to:

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


After trying to import a Folder structure from another instance the following SQL error is received in the Content Server log:

csFoldersArchiveError Unable to execute SQL statement 'UPDATE Collections SET dCollectionName=N'Contribution
Folders',dCollectionQueries=1,dDocType=NULL,dDependent=NULL,dReleaseDate=NULL,dDocName=NULL,dDocAuthor=NULL,dChildManipulation=1,dOutDate=NULL,dInDate=NULL,dLastModifiedDate={ts '2008-03-10 17:29:38.561'},dCollectionOwner=N'sysadmin',dDocTitle=NULL,dCollectionType=0,dCollectionEnabled=1,dRevLabel=NULL,dSecurityGroup=NULL,dCollectionMark=N'HIERARCHY ROOT',dDocAccount=NULL,DLASTMODIFIEDDATE=NULL WHERE dCollectionID=2'. ORA-00957: duplicate column name

Alternatively, if you are using the Folder Structure Archive component you may receive this error:

!csUnableToImportTableValue,Collections!syParameterNotFound,dLastModifiedDate !syParameterNotFound,dLastModifiedDate
at intradoc.server.SerializeTable.createQuery(Unknown Source)
at intradoc.server.SerializeTable.mergeTable(Unknown Source)
at intradoc.server.SerializeTable.importTable(Unknown Source)


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

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