Joel, You most certainly have DB corruption issues going on...I'm not entirely sure what to tell you to do about them. The metadata isn't all that complex...but here is the basic layout.
arschema tells you what forms exist, and various other information about the form schema_* is 'detail' type of information about the form that is type specific field is going to give you generic information about the fields in arschema field_* is going to give you detailed field details about each field type vui will give you view information about the views defined for the form there are T/H/B tables for each form, with multiple B for each attachment field on the form So, with all of that laid out, when Remedy starts, it tries to load information for all of that into Memory (and allot more of course).... What you may be experiencing is a mis-match between one of the records in one of these tables and the others. I would recommend a restore of the DB to back before you started having these issues, but assuming that it's not available...I would NOT recommend doing anything further without a full backup....and I would proceed with caution with anything I'm saying :) I would go into arschema and find the record with the 'name' that is being reported on startup in the arerror.log file. Get the schemaID of that form, and then cleanse any records out of the above mentioned tables that have records relating to this schema id, and then the record out of arschema itself as well, and delete any T/H/B tables that match the ID of the record in question. Once that is done, try to start up Remedy and see if you get ANY errors in the arerror.log file. If everything was done 'properly', then there shouldn't be any errors Then I would recommend trying to import it again (or start over from scratch)....but you may be able to continue from there... I would think that you more than likely came up against an error at the DB that you either didn't see or ignored, which caused this problem. I would recommend working with your DBA to ensure that the DB is fully functional with enough temp db space and such. Please report back and let me know how this went, if you choose to undertake the endeavor. On Fri, Jul 12, 2013 at 2:34 PM, Joel Sender <[email protected]> wrote: > ** > > ** ** > > ARSListers,**** > > I’m wondering if anyone else has seen this:**** > > ** ** > > Clean install of ARS 8.1 on Windows Server and MS/SQL on separate machine. > **** > > Using custom applications only, imported a display-only form with an > ‘Applications List’ field.**** > > It worked at first, but then gave an internal error. No messages in the > ARS logs**** > > While waiting for a solution from BMC Support, I created a view with > Buttons & Active Links to replace the AppList. **** > > Buttons were working fine, so I ended my day with a definition export and > a reboot of the ARS server.**** > > Next morning the form was ‘not found’.**** > > In dev studio, the form was on the list, but opening it gave a “ form not > found on server” message; then it wasn’t on the list.**** > > Attempted to import the definition, with ‘overwrite’, but generated an > error that the form was violating a unique index.**** > > I found a read-only entry in the AR System Metadata form, but the > ‘overwrite’ option didn’t help the import.**** > > I edited the form name in the definition file, tried to import, and got > the same ‘unique index violation’ error. **** > > Now the AR Server won’t accept any imported forms, including UN-edited > definition files.**** > > ** ** > > And a second AR Server (dev) is showing the same symptoms.**** > > ** ** > > BMC Support has the definitions and logs, however, they said that they > have seen this before. **** > > So … anyone solved this already?**** > > ** ** > > *Joel*** > > Joel Sender [email protected] 310.829.5552**** > > **** > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
