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

Last updated on MAY 09, 2023

Applies to:

Symptoms

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

intradoc.data.DataException: !syParameterNotFound,dLastModifiedDate
at intradoc.data.DataBinder.getEx(DataBinder.java:1096)
at intradoc.data.DataBinder.get(DataBinder.java:895)
at intradoc.server.SerializeTable.createQuery(Unknown Source)
at intradoc.server.SerializeTable.mergeTable(Unknown Source)
at intradoc.server.SerializeTable.importTable(Unknown Source)

Cause

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