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!

Error :Site Studio Component is from Older Version

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
    I am using Site Studio and getting this error when connecting to after it get authenticated from Content Server.

    Error :Site Studio Component is from Older Version

    Please Help
     
  2. harmaildhiman

    harmaildhiman Active Member

    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    80
  3. harmaildhiman

    harmaildhiman Active Member

    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    80
    Re: Steps to install Site Studio and other components

    Exactly this is error is coming up...... Please help
    Code (Text):

    Unable to retrieve search results. Unable to create result set for query
    'SELECT   index2.did, ddocname, ddoctitle, ddoctype, drevisionid,
             dsecuritygroup, ddocauthor, ddocaccount, drevlabel, dformat,
             doriginalname, dextension, dwebextension, dindate, doutdate,
             dpublishtype, drendition1, drendition2, vaultfilesize, webfilesize,
             url, dfulltextformat, dfulltextcharset, docmeta.*
        FROM index2, docmeta
       WHERE index2.did = docmeta.did
         AND (((    (((contains (xwebsites, '{testSite}') > 0)))
                AND (xwebsiteobjecttype LIKE 'Layout File')
               )
              )
             )
    ORDER BY dindate DESC'.
    ORA-00942: table or view does not exist
     
    Thanks,

    Harry
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    hi Harry, it's very difficult to diagnose an error if you don't provide proper details. As a first step you should always check the Admin-server log for the exact error. From the error you have posted, it's obvious isn't it? The query could not run because either the index2 or docmeta table does not exist.

    What were you trying to do when this error appeared?
     
  5. markH

    markH Forum Advisor

    Messages:
    88
    Likes Received:
    10
    Trophy Points:
    180
    Location:
    Kansas
    it seems on or other component is not installed properly. are you trying to search for documents when this error is coming? try disabling the components one by one and see if you can search without the error.
     
  6. harmaildhiman

    harmaildhiman Active Member

    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    80
    Error: Site Assets [Add to Site]

    When I try to add Assets Like [Adding CSS] to site It throws an 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

    Please provide Solution,

    Thanks In Advance,

    Harry
     
  7. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: Error: Site Assets [Add to Site]

    please don't double post. Your thread was already replied to:

    Site Assets [Error on Add Assets to Site]
     
  8. harmaildhiman

    harmaildhiman Active Member

    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    80
  9. Rahul vaid

    Rahul vaid Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    75
    Dear Sadik

    I am facing the same issue, would request you to provide the step by step resolution for the same.

    Unable to retrieve search results. Unable to create result set for query
    'SELECT index2.did, ddocname, ddoctitle, ddoctype, drevisionid,
    dsecuritygroup, ddocauthor, ddocaccount, drevlabel, dformat,
    doriginalname, dextension, dwebextension, dindate, doutdate,
    dpublishtype, drendition1, drendition2, vaultfilesize, webfilesize,
    url, dfulltextformat, dfulltextcharset, docmeta.*
    FROM index2, docmeta
    WHERE index2.did = docmeta.did
    AND ((( (((contains (xwebsites, '{testSite}') > 0)))
    AND (xwebsiteobjecttype LIKE 'Layout File')
    )
    )
    )
    ORDER BY dindate DESC'.
    ORA-00942: table or view does not exist


    Thanks in advance.