Hi Dwayne, What version of CMDB are you on? AssetBase indicates an older version of CMDB unless you are referring to the SHR:SchemaName reference.
Normally, one adds attributes from the CMDB Console and then runs the CMDB2ASSET synchronize which places the fields on the Asset related forms. You can then position your fields on the Asset forms b/c the fields are then on the Custom(x) tabs. Your email sounds like you are adding fields directly to the Forms in the Admin tool? Have you also added the fields to the CMDB metadata? The SQL view error indicates that the actual SQL view (not the table), does not exist in the DB. Do you have access to your DB directly? The index error may be a result of a either an actual duplicate index because of the name, fieldid or because there may be an internal SQL problem with the parent forms. The indexes you mentioned for the parents sound like they are shy of about 7 others that are normally defined. Are you able to save either parent form without adding a new field with no error? Let me know what version of the CMDB you're dealing with. Thanks, Janie -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, April 17, 2009 10:33 AM To: arslist@ARSLIST.ORG Subject: Error adding field to join form 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) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"