Try Importing the form, then using the archgid utility to change the Schema ID to 2993
What database are you working with? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of SUBSCRIBE arslist Chuck Benesh Sent: Friday, October 11, 2013 8:34 AM To: [email protected] Subject: db restore, schema error Hello, I'm in the process of restoring ARSystem db from one environment to another (from PROD to QA). On start of AR System service, I'm getting errors, snippet shown below. It's unable to load an AIF form, schema id 2993. It then reports a number of filter and active link definition errors, because it hasn't loaded the schema. I have tried importing the form definition, but get a unique index violation error in dev studio, likely because it finds the form name in the db. If I delete the form record from arschema, I am able to import the obj def, but it gets a new schema id, and thus loses the data (which is still in T2993, of course). But, the filter and link definitions are still invalid. Also, the string in the field_dispprop.propShort contains some single quotes, i.e. 'Type'. I tried updating this string with something simpler, but the schema will still not load. I have restored the db, and am back at starting point. I have thought of deleting the form record from arschema, and doing an import of the form def with related objects. However, we then have systems that are out-of-alignment at the least, and who knows what other anomalies this could cause. Any suggestions, please? Thank you in advance! Chuck Fri Oct 11 08:07:03 2013 : Action Request System(R) Server x64 Version 7.6.04 SP2 201110080614 (c) Copyright 1991-2011 BMC Software, Inc. Fri Oct 11 08:07:18 2013 390600 : Missing data in the SQL database (propList format -- 16\1\6\3\3\41\2\57930\3200\91900\8600\4\6\1\5\6\2\7\40\2147483647\14\40\1\24\4\4\0x00\80\4\209\ҔypeҠis used to route your request.If you have multiple requests of different types, select one.The EDC (ARERR 556) Fri Oct 11 08:07:18 2013 CDW:SRS:AdvancedInterface:EDCNewItemCreation_V2 Fri Oct 11 08:07:24 2013 390600 : Invalid filter definition. (ARERR 343) Fri Oct 11 08:07:24 2013 : SRS:ADN:SHR_PermissionGroups_200_SetID_CustomForm__o Error loading schema id<2993> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
