Skip to Main Content
Forums

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error while update content in UCM

V07Apr 15 2011 — edited May 14 2011
Hi all,

Getting error while updating the existing content.

Let me know

Error Info :-
Unable to execute service UPDATE_DOCINFO_BYFORM and function Umeta.
*(System Error: Unable to execute query 'Umeta(update/*+ INDEX (DocMeta PK_DocMeta)*/ DocMeta SET xCollectionID = 0, xTrashDeleteDate = null, xForceFolderSecurity = 'FALSE', xComments = '', xTrashDeleter = '', xInhibitUpdate = 'FALSE', xTrashDeleteLoc = 0, xReadOnly = 'FALSE', xHidden = 'FALSE', xInihibitUpdate = '', xTrashDeleteName = '', xPartitionId = '', xWebFlag = '', xStorageRule = '', xDiscussionCount = 0, xCpdIsLocked = 0, xCpdIsTemplateEnabled = 0, xDiscussionType = 'N/A', xRegionDefinition = 'PORTDETPAGESSPREGDEF', xWebsites = 'QTelSite', xDontShowInListsForWebsites = '', xWebsiteSection = 'QTelSite:12', xTradingDate = null, xlocale = '', xIdcProfile = '', xCategory = '', xNewsCategory = '', xPortletType = '', xSections = '', xWebsiteObjectType = 'Data File', xStep1User = '', xStep1UserComments = '', xStep2User = '', xStep2UserComments = '', xStep3User = '', xStep3UserComments = '', xStep4User = '', xStep4UserComments = '', xStep5User = '', xStep5UserComments = '', xStep6User = '', xStep6UserComments = '', xStep7User = '', xStep7UserComments = '', xStep8User = '', xStep8UserComments = '', xStep9User = '', xStep9UserComments = '', xStep10User = '', xStep10UserComments = '', xContentGroup = '', xReferredBy = '', xYear = '', xNewsAlertType = '', xPromotionPortletType = '', xAssociatedContent = '', xSyncUpTheMobileItem = '', xRefersTo = '', xSyncUpMobileItemChildren = '', xDocumentReferences = '' WHERE dID = 15031)'. ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine*
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column XDONTSHOWINLISTSFORWEBSITES for primary key AAAXLrAAGAAACDKAAQ
DRG-50857: oracle error in drekqkd (n_stmt)
ORA-06550: line 1, column 257:
PLS-00103: Encountered the symbol "" when expecting one of the following:

*; <an identifier> <a double-quoted delimited-identifier>*

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 747)

The service stack for this request is
--UPDATE_DOCINFO_BYFORM (dID=15031,dDocName=MOBILEENTERTAINMENT_AR)
intradoc.data.DataException: !csDbUnableToExecuteQuery,Umeta(update/*+ INDEX (DocMeta PK_DocMeta)*/ DocMeta SET xCollectionID = 0\, xTrashDeleteDate = null\, xForceFolderSecurity = &#39;FALSE&#39;\, xComments = &#39;&#39;\, xTrashDeleter = &#39;&#39;\, xInhibitUpdate = &#39;FALSE&#39;\, xTrashDeleteLoc = 0\, xReadOnly = &#39;FALSE&#39;\, xHidden = &#39;FALSE&#39;\, xInihibitUpdate = &#39;&#39;\, xTrashDeleteName = &#39;&#39;\, xPartitionId = &#39;&#39;\, xWebFlag = &#39;&#39;\, xStorageRule = &#39;&#39;\, xDiscussionCount = 0\, xCpdIsLocked = 0\, xCpdIsTemplateEnabled = 0\, xDiscussionType = &#39;N/A&#39;\, xRegionDefinition = &#39;PORTDETPAGESSPREGDEF&#39;\, xWebsites = &#39;QTelSite&#39;\, xDontShowInListsForWebsites = &#39;&#39;\, xWebsiteSection = &#39;QTelSite:12&#39;\, xTradingDate = null\, xlocale = &#39;&#39;\, xIdcProfile = &#39;&#39;\, xCategory = &#39;&#39;\, xNewsCategory = &#39;&#39;\, xPortletType = &#39;&#39;\, xSections = &#39;&#39;\, xWebsiteObjectType = &#39;Data File&#39;\, xStep1User = &#39;&#39;\, xStep1UserComments = &#39;&#39;\, xStep2User = &#39;&#39;\, xStep2UserComments = &#39;&#39;\, xStep3User = &#39;&#39;\, xStep3UserComments = &#39;&#39;\, xStep4User = &#39;&#39;\, xStep4UserComments = &#39;&#39;\, xStep5User = &#39;&#39;\, xStep5UserComments = &#39;&#39;\, xStep6User = &#39;&#39;\, xStep6UserComments = &#39;&#39;\, xStep7User = &#39;&#39;\, xStep7UserComments = &#39;&#39;\, xStep8User = &#39;&#39;\, xStep8UserComments = &#39;&#39;\, xStep9User = &#39;&#39;\, xStep9UserComments = &#39;&#39;\, xStep10User = &#39;&#39;\, xStep10UserComments = &#39;&#39;\, xContentGroup = &#39;&#39;\, xReferredBy = &#39;&#39;\, xYear = &#39;&#39;\, xNewsAlertType = &#39;&#39;\, xPromotionPortletType = &#39;&#39;\, xAssociatedContent = &#39;&#39;\, xSyncUpTheMobileItem = &#39;&#39;\, xRefersTo = &#39;&#39;\, xSyncUpMobileItemChildren = &#39;&#39;\, xDocumentReferences = &#39;&#39; WHERE dID = 15031)!$ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column XDONTSHOWINLISTSFORWEBSITES for primary key AAAXLrAAGAAACDKAAQ
DRG-50857: oracle error in drekqkd (n_stmt)
ORA-06550: line 1\, column 257:
PLS-00103: Encountered the symbol &quot;&quot; when expecting one of the following:

; &lt;an identifier&gt; &lt;a double-quoted delimited-identifier&gt;

ORA-06512: at &quot;CTXSYS.DRUE&quot;\, line 160
ORA-06512: at &quot;CTXSYS.TEXTINDEXMETHODS&quot;\, line 747

at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:650)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1333)
at intradoc.server.Service.doAction(Service.java:452)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1201)
at intradoc.server.Service.doActions(Service.java:447)
at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1071)
at intradoc.server.Service.executeSubServiceCode(Service.java:3497)
at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:942)
at intradoc.server.Service.executeServiceEx(Service.java:3492)
at intradoc.server.Service.executeService(Service.java:3476)
at intradoc.server.Service.doSubService(Service.java:3465)
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:597)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:617)
at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:279)
at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:264)
at intradoc.server.Service.doCodeEx(Service.java:507)
at intradoc.server.Service.doCode(Service.java:472)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1360)
at intradoc.server.Service.doAction(Service.java:452)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1201)
at intradoc.server.Service.doActions(Service.java:447)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1121)
at intradoc.server.Service.executeActions(Service.java:433)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:635)
at intradoc.server.Service.doRequest(Service.java:1707)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:359)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:197)
Caused by: java.sql.SQLException: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column XDONTSHOWINLISTSFORWEBSITES for primary key AAAXLrAAGAAACDKAAQ
DRG-50857: oracle error in drekqkd (n_stmt)
ORA-06550: line 1, column 257:
PLS-00103: Encountered the symbol &quot;&quot; when expecting one of the following:

; &lt;an identifier&gt; &lt;a double-quoted delimited-identifier&gt;

ORA-06512: at &quot;CTXSYS.DRUE&quot;, line 160
ORA-06512: at &quot;CTXSYS.TEXTINDEXMETHODS&quot;, line 747

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4086)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4234)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1661)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:643)
... 29 more
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2011
Added on Apr 15 2011
#content, #error, #update, #webcenter, #webcenter-content
2 comments
3,281 views