1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Site Assets [Error on Add Assets to Site]

Discussion in 'Oracle Webcenter Suite (formerly Oracle ECM)' started by harmaildhiman, Mar 5, 2009.

  1. harmaildhiman

    harmaildhiman Active Member

    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    80
    When I try to add an Asset to Site Like [Site Asset - Add Assets - CSS], Content Server return with following Error:

    Content Server Request Failed
    Unable to retrieve search results. Unable to retrieve search results. Unable to create result set for query 'SELECT IdcColl2.dID, dDocName, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, VaultFileSize, WebFileSize, URL, dFullTextFormat, dFullTextCharset, DocMeta.*
    FROM IdcColl2, DocMeta
    WHERE IdcColl2.dID=DocMeta.dID AND (((( NOT ( (CONTAINS(xWebsites, '{sonygames}') > 0) )) AND ( xWebsiteObjectType LIKE 'Stylesheet' )))) ORDER BY dDocName ASC'. ORA-20000: Oracle Text error:
    DRG-10599: column is not indexed

    [ Details ]
    intradoc.common.ServiceException: !csSearchUnableToRetrieveSearchResult!csDbUnableToCreateResultSet,SELECT IdcColl2.dID\, dDocName\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dCreateDate\, dPublishType\, dRendition1\, dRendition2\, VaultFileSize\, WebFileSize\, URL\, dFullTextFormat\, dFullTextCharset\, DocMeta.*
    FROM IdcColl2\, DocMeta
    WHERE IdcColl2.dID=DocMeta.dID AND (((( NOT ( (CONTAINS(xWebsites\, '{sonygames}') > 0) )) AND ( xWebsiteObjectType LIKE 'Stylesheet' )))) ORDER BY dDocName ASC!$ORA-20000: Oracle Text error:
    DRG-10599: column is not indexed

    at intradoc.server.SearchManager.retrieveSearchInfo(SearchManager.java:254)
    at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1275)
    at intradoc.server.SearchService.doLocalSearch(SearchService.java:1045)
    at intradoc.server.SearchService.getSearchResults(SearchService.java:528)
    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.executeMethodEx(ClassHelperUtils.java:128)
    at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:113)
    at intradoc.server.Service.doCodeEx(Service.java:505)
    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)







    Please help me to fix this error,

    Harry
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi the reason for the error happening is that the xWebsites and xWebsiteObjectType colums need to be full text indexed and are not full indexed.

    The resolve this issue go to Administration -> Zoned security fields and there add xWebsites and xWebsiteObjectType colums to be full indexed. Update the setting and the try to add the assets from the SS designer.