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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
