Dear List,
I am trying to add two database fields to the Asset Management Module
“AST:ComputerSystem” form. This is a three-layer join form, which starts by
joining “BMC:BMC_ComputerSystem_” with “BMC:BMC_AssetBase” to get
“BMC:BMC_ComputerSystem.”
When I add the fields to either of the two base forms I get:
“Creation of one of the SQL views for the form failed within the SQL database.
Operation completed successfully, but the SQL view is not in place. (ARWARN
69).”
First sign of trouble.
When I go to “BMC:BMC_ComputerSystem” and try to bring the fields into that
form I get:
“Field : Equipment Status [the name of the new field] :
The value(s) for this entry violate a unique index that has been
defined for this form (ARERR 382).” and “Some field could not be saved in this
form.”
There are no errors in the SQL log.
To make things still more complicated, there are fields that I added to
“BMC:BMC_AssetBase” in a previous project that I can bring into
“BMC:BMC_ComputerSystem” with no problem.
Both “BMC:BMC_AssetBase” and “BMC:BMC_ComputerSystem” have indexes on
InstanceId. What index might they be talking about?
Any suggestions?
Dwayne Martin
James Madison University
(ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db)
