Unable to Create a New Folder After Upgrading to Folders_g, Error: "Cannot insert the value NULL into column 'dPromptForMetadata', table '10gr3.dbo.Collections'; column does not allow nulls" (Doc ID 751515.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Universal Content Management - Version: 10.1.3.3.0 and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.
***Checked for relevance on 30-Apr-2010***

Symptoms

You upgraded to Folders_g from an earlier version of Folders.  You restarted Content Server after installing Folders_g. 

You are now unable to create a new folder.  The error generated is:

Content Server Request Failed
Unable to execute service COLLECTION_ADD and function addCollectionInCollection.
(System Error: Unable to execute query 'Icollection(INSERT INTO Collections (dCollectionID, dCollectionGUID, dParentCollectionID, dCollectionName, dCollectionType, dCollectionQueries, dCollectionEnabled, dPromptForMetadata, dCollectionInherit, dChildManipulation, dCreateDate)
values(5, N'7F7741AF-5E50-A960-0CBB-FF4DCFB38394', 2, N'Folder 2', 0, 1, 1, null, 0, 1, {ts '2008-11-20 09:54:05.881'}))'.
Cannot insert the value NULL into column 'dPromptForMetadata', table '10gr3.dbo.Collections'; column does not allow nulls. INSERT fails.)
[ Details ]

The service stack for this request is
--COLLECTION_ADD (**no captured values**)
intradoc.data.DataException: !csDbUnableToExecuteQuery,Icollection(INSERT INTO Collections (dCollectionID\, dCollectionGUID\, dParentCollectionID\, dCollectionName\, dCollectionType\, dCollectionQueries\, dCollectionEnabled\, dPromptForMetadata\, dCollectionInherit\, dChildManipulation\, dCreateDate)
values(5\, N'7F7741AF-5E50-A960-0CBB-FF4DCFB38394'\, 2\, N'Folder 2'\, 0\, 1\, 1\, null\, 0\, 1\, {ts '2008-11-20 09:54:05.881'}))
!$Cannot insert the value NULL into column 'dPromptForMetadata'\, table '10gr3.dbo.Collections'; column does not allow nulls. INSERT fails.

at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:662)
at collections.CollectionStructure.forceChildEx(CollectionStructure.java:2218)
at collections.CollectionStructure.forceChild(CollectionStructure.java:2179)
at collections.CollectionStructure.forceChild(CollectionStructure.java:2174)
at collections.CollectionUserHandler.addCollectionInCollection(CollectionUserHandler.java:483)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:461)
at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:142)
at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:75)
at intradoc.server.Service.doCodeEx(Service.java:488)
at intradoc.server.Service.doCode(Service.java:470)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1350)
at intradoc.server.Service.doAction(Service.java:450)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1191)
at intradoc.server.Service.doActions(Service.java:445)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1111)
at intradoc.server.Service.executeActions(Service.java:431)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:632)
at intradoc.server.Service.doRequest(Service.java:1709)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:357)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:195)

Caused by: java.sql.SQLException: Cannot insert the value NULL into column 'dPromptForMetadata', table '10gr3.dbo.Collections'; column does not allow nulls. INSERT fails.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1120)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1073)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:651)
... 23 more

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