Sorry I miss read as importing the form instead of importing the database table.
I'm not sure that this would be a solution since the pre-upgrade table is a 5.1.2 format table and the 7.0.1 table contains a different structure, I'd still be missing these fields in the T table. I'm not sure that the AR database would be capable of dealing with this any better than it can deal with the fields not being in the T table to start with. While it may be possible to do a fresh installation of a 7.0.1 system and then move the clean T table over to to my production system, it is possible that there may be other problems with the Group schema. If I'm having problems with the T table what other parts of the schema may be corrupt? The production system has been running on 7.0.1 for a couple of weeks now so dropping back to the pre-upgrade database is not an option. Unfortunately, we did not need to modify any of our groups until now so the error did not appear until after we were beyond our commit point with the new software. Thanks for the input, anything I get here is better than what I am getting from BMC at this point. Thanks, Dave ----- Original Message ---- From: Rahul AR User <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, October 19, 2007 2:32:07 PM Subject: Re: Help with ARERR 552 ** Deleting the Group Form is not advised. If you are not comfortable with the option I suggested then you need to import this form. You may try exporting the Group Form from any running AR System and then importing the same in the current box. Well the database style was what we did once when we came across the similar error, not exactly the same but some what similar. Again...... please take a database back, proactively, before continuing with any of the steps as advised. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: ** Yes, we do have a backup of the pre-upgrade database (we still have the pre-upgrade database server in pristine condition). While restoring the database would provide a means to recover the data in the Group form, it would not resolve the error with the 7.01 Group form. While it would be possible to recover the Group form data and then delete the current Group form and Reimport a valid Group form, I'm not sure that it is possible to delete the Group form and maintain an operational system. Like you, we had this occur on a test upgrade to 7.0 to the User form. The end result was, because it was a test upgrade, to dump the system and redo the upgrade process. However, with 7.0 this happened every time we tried the upgrade, thus the wait for 7.0.1 for the upgrade. During testing with 7.0.1 this error did not occur, so we thought we were out of the woods on it. Thanks, Dave ----- Original Message ---- From: Rahul AR User < [EMAIL PROTECTED]> To: [email protected] Sent: Friday, October 19, 2007 2:02:06 PM Subject: Re: Help with ARERR 552 ** Did u take the database backup before the upgrade?? If yes then restore the backup on some other database server and import the table from this restored database to the existing database. I'll again remind you to take a database backup before proceeding with the steps as mentioned above. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: ** Anyone have a recommendation for this. When accessing the Group form we receive the error "ARERR 552 Failure during SQL operation to the database: Invalid column name 'C179', (SQL Server 207)Invalid column name 'C121', (SQL Server 207)Invalid column name 'C120', (SQL Server 207) This error prevents us from viewing, creating or modifying records on the Group form. The fields exist in the 'field' table but do not exist in the 'T9' table. All efforts to resolve this through the Admin tool have been unsuccessful. My best guess on cause would be a problem with the form creation/import during our database upgrade to 7.0.1. I would try to manually create the fields in the T table, but do not want to cause more issues than what I have. Equally unsuccessful was to open a high impact ticket with BMC Support over 24 hours ago (ISS03190758). They have been unresponsive and have failed to meet the Fast-Track SLA. (If anyone from BMC is monitoring the list any assistance would be greatly appreciated.) Windows 2003 Server / MSSQL 2000 / BMC Remedy AR System 7.0.1 P4 Thanks in advance, Dave Fincher __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125_______________________This posting was submitted with HTML in it___ -- Regards Rahul __20060125_______________________This posting was submitted with HTML in it___ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125_______________________This posting was submitted with HTML in it___ -- Regards Rahul __20060125_______________________This posting was submitted with HTML in it___ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
