2 Replies Latest reply on Jun 13, 2018 5:09 AM by Albert Bihler

    AR System Metadata: field_dispprop column label not filled

    Albert Bihler

      Hi everybody,

       

      ARS: 7.6.04 SP4 201209051922

      OS: SunOS 5.10

      DB: Oracle 10.2

       

      we have three servers (production, test and development) running with nearly identical setup. On the production server column "label" in "AR System Metadata: field_dispprop" doesn't get filled when the corresponding field is changed. On the other servers the column is filled with the current label of the field.

       

      SQL log clearly shows that AR Server on one system just sets "label" to NULL:

       

      ok server:

      INSERT INTO field_dispprop (recordId,schemaId,fieldId,listIndex,vuiId,label,propShort, propLong) VALUES (1264695,3537,536870913,0,536870912,'Display3yyy','18\3\41\2\55230\10200\82226\12300\4\6\1\5\6\2\7\40\2147483648\14\40\1\20\4\11\Display3yyy\21\41\2\0\400\8323\2100\60\40\1\66\41\2\24634\0\26996\2100\143\40\4294967295\151\41\2\8886\0\24071\2100\170\40\0\231\6\0\288\6\0\289\4\4\0x00\290\4\4\0x00\310\6\0\5116\6\0\', NULL)

       

      NOK server:

      INSERT INTO field_dispprop (recordId,schemaId,fieldId,listIndex,vuiId,label,propShort, propLong) VALUES (401205,3290,536870913,0,536870912,NULL, '18\3\41\2\53993\8000\82114\10100\4\6\1\5\6\2\7\40\2147483648\14\40\1\20\4\15\displayNamexxx4\21\41\2\0\400\9448\2100\60\40\1\66\41\2\25759\0\28121\2100\143\40\4294967295\151\41\2\10011\0\25196\2100\170\40\0\231\6\0\288\6\0\289\4\4\0x00\290\4\4\0x00\310\6\0\5116\6\0\', NULL)

       

      I couldn't find anything usefull in the documentation. In an old thread the use of -checkdb war recommended. So we ran ./arserevrd -checkdb. But this didn't change the behaviour. The created report file gives a lot of information for all kind of stuff but nothing usefull regarding metadata.

       

      Is there a configuration setting that I am not aware of? Or do you have any other idea?

       

      Best regards,

      Albert

        • 1. Re: AR System Metadata: field_dispprop column label not filled
          Robert Poulos

          Hi Albert,

           

          The difference in the two behaviors would be the Record Object Relationships option.  Your production system does not have the option set.  If I'm remembering correctly, the "label" column is only used by the Object Relationships feature, so the column is not populated if the feature is off.

           

          Regards,

           

          Bob P.

          2 of 2 people found this helpful
          • 2. Re: AR System Metadata: field_dispprop column label not filled
            Albert Bihler

            Hi Robert,

             

            you are right. Activating "Record Object Relationships" was one key point to get this running. The whole process was like this:

            • Activate "Record Object Relationships" on all servers of the server group (we have a group of four servers)
            • Stop all ARS servers
            • Execute some SQL commands to properly reset/prepare relationship recording

            delete from ardefnrel;

            update control set relgenstate = '';

            commit;

            • Start just one ARS server (the one normaly running admin actions) and wait until it is completely up and you can connect to it. (took about 30 minutes for us) This ist just for the first startup after the configuration change. Later starts are much faster.
            • Start the remaining ARS servers

             

            Regards,

            Albert