Hi Dave,
I got this error on the Change Console form after I did the Patch 5 upgrade to
ITSM 7. For some reason, the upgrade failed to create the requisite field 179
that is called by the table in the form. I reported this as a high urgency
issue and logging of the error revealed that "something had gone wrong" with
the install, but it was not in their knowledge base as a known issue. Because
the installation was a test installation it made the most sense to simply
reinstall CM. this may be a flaw in your installation or upgrade that
might be
best suited to reinstallation, but it is alarming that the error is
happening on
the Group form.
--
Regards,
Louise van Hine
Quoting "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
** 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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"