1 Reply Latest reply: Dec 1, 2009 3:26 AM by 11611 RSS

    Folder_g component wizard failure from R35UpdateBundle Extra patch

    716457
      Installed and had running the 10gR3 version 10.1.3.3.3 (version 20080807) using MS sqlserver as backend db http://download.oracle.com/otn/content_management/V13682-01.zip. See edit for additional details at the resource level.

      Applied the patches in the following order:
      CS10gR35UpdateBundle-20090707-11 (Version 10.1.3.5.0) http://download.oracle.com/otn/content_management/CS10gR35UpdateBundle-20090707-11.zip
      CS10gR34ContentAccessUpdate-20090505-4 (Version 10.1.3.4.1) http://download.oracle.com/otn/content_management/CS10gR34ContentAccessUpdate-20090505-4.zip
      CS10gR34NativeUpdate-20090708-5 (Version 10.1.3.4.1) http://download.oracle.com/otn/content_management/CS10gR34NativeUpdate-20090708-5.zip
      IBR10gR3UpdateBundle-20090630-26 (Version: 10.1.3) http://download.oracle.com/otn/content_management/IBR10gR3UpdateBundle-20090630-26.zip

      Able to log into content server with the admin user, checked that Version 10.1.3.5.0 has been applied

      Lost the ability to edit the folder structure under the Browse content option

      Launched the component wizard to examine if the Folder_g was enabled
      Custom Component List shows
      Folders_g     Enabled     c:/oracle/UCM/server/install/custom/Folders_g/Folders_g.hda

      Attempted to open this component I receive the following error dialog box

      “Please correct the following errors:

      !csCompWizMergeTableNotFound, VCR_FOLDERS_ServiceHandlersFile ‘c:/oracle/UCM/server/install/custom/Folders_g/resources/vcr_folders_tables.idoc’ is invalid resource file type.
      File ‘c:/oracle/UCM/server/install/custom/Folders_g/resources/lang/en/vcr_folders_strings.idoc’ is invalid resource file type.

      Can anyone give me a starting point to how to resolve this error.

      Regards

      Rob

      The contents of ‘ c:/oracle/UCM/server/install/custom/Folders_g/resources/vcr_folders_tables.idoc’ is

      <html>
      <head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
      <title>VCR_FOLDERS htmlIncludeOrString</title>
      </head>
      <body>

      <@table VCR_FOLDERS_ServiceHandlers@>
      <table>
      <tr>
           <td>serviceName</td>
           <td>handler</td>
           <td>searchOrder</td>
      </tr>
      <tr>
           <td>Service</td>
           <td>vcr_folders.VcrFoldersServiceHandler</td>
           <td>100</td>
      </tr>
      </table>
      <@end@>

      <@table VcrFoldersFieldDefinitions@>
      <table>
           <tr>
                <td>name</td>
                <td>description</td>
                <td>propertyDefinitionType</td>
                <td>propertyType</td>
                <td>isMandatory</td>
                <td>isReadOnly</td>
                <td>isMultiValued</td>
                <td>isRestricted</td>
                <td>isSearchable</td>
                <td>isPrimary</td>
                <td>nestedClass</td>
           </tr>
           <tr>
                <td>dCollectionID</td>
                <td>wwCollectionID</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionPath</td>
                <td>wwCollectionPath</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionGUID</td>
                <td>wwCollectionGUID</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dParentCollectionID</td>
                <td>wwCollectionParentCollectionID</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionName</td>
                <td>wwCollectionCollectionName</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionType</td>
                <td>wwCollectionType</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionMark</td>
                <td>wwCollectionMark</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dDependent</td>
                <td>wwCollectionDependent</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionQueries</td>
                <td>wwCollectionQueries</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionEnabled</td>
                <td>wwCollectionEnabled</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionInherit</td>
                <td>wwCollectionInherit</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dChildManipulation</td>
                <td>wwCollectionChildManipulation</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dLastModifiedDate</td>
                <td>wwCollectionModified</td>
                <td>NATIVE</td>
                <td>CALENDAR</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionOwner</td>
                <td>wwCollectionOwner</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dPromptForMetadata</td>
                <td>wwPromptForMetaData</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionCreator</td>
                <td>wwCollectionCreator</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCollectionModifier</td>
                <td>wwCollectionModifier</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dDocName</td>
                <td>apTitleDocName</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dDocType</td>
                <td>apTitleDocType</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dDocTitle</td>
                <td>apTitleDocTitle</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dDocAuthor</td>
                <td>apTitleDocAuthor</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
                <tr>
                <td>dRevLabel</td>
                <td>apTitleRevisionLabel</td>
                <td>NATIVE</td>
                <td>LONG</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
                <tr>
                <td>dSecurityGroup</td>
                <td>apTitleSecurityGroup</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dDocAccount</td>
                <td>apTitleAccount</td>
                <td>NATIVE</td>
                <td>STRING</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dCreateDate</td>
                <td>apTitleCreateDate</td>
                <td>NATIVE</td>
                <td>CALENDAR</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dInDate</td>
                <td>apTitleInDate</td>
                <td>NATIVE</td>
                <td>CALENDAR</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dOutDate</td>
                <td>apTitleOutDate</td>
                <td>NATIVE</td>
                <td>CALENDAR</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
           <tr>
                <td>dReleaseDate</td>
                <td>apTitleReleaseDate</td>
                <td>NATIVE</td>
                <td>CALENDAR</td>
                <td>1</td>
                <td>1</td>
                <td>0</td>
                <td>0</td>
                <td>1</td>
                <td>0</td>
           </tr>
      </table>
      <@end@>

      </body>
      </html>


      The contents of c:/oracle/UCM/server/install/custom/Folders_g/resources/lang/en/vcr_folders_strings.idoc is below
      <html>
      <head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
      <title>
      VCR_FOLDERS htmlIncludeOrString
      </title>
      </head>
      <body>

      <@wwCollectionID=Virtual Folder ID@>
      <@wwCollectionGUID=Virtual Folder GUID@>
      <@wwCollectionType=Virtual Folder Type@>
      <@wwCollectionMark=Virtual Folder Mark@>
      <@wwCollectionEnabled=Folder Enabled@>
      <@wwCollectionPath=Virtual Folder Path@>

      <@csVcrFoldersFolderArgMissing=Neither dCollectionID or dCollectionPath are included in the request.@>

      </body>
      </html>

      Edited by: RSward on 28-Oct-2009 20:40
      Again using the Component Wizard, selecting the component 'Folder_g' and resouce resources/vcr_folders_tables.idoc
      I disabled it due to the error and then tried to enable it. I got this further error
      "the table 'VCR_FOLDERS_ServiceHandlers' that is specified in the MergeRules table is not defined. Please either remove it form the MergeRules table or add to the ResourceDefinition table.

      Does anyone know if a script exists to create the VCR_FOLDERS to upgrade the MergeRules table.