Hi Jane, Yes, I'm able to save the two base fields if I just reposition a field.
I decided to delete the fields I am trying to add and start over from scratch, but now the whole middle-layer BMB:BMC_ComputerSystem (no final "_") has disappeared. I don't THINK I deleted it. When I try to import it from our live system I once again get, "The value(s) for this entry violate a unique index that has been defined for this form: (ARERR 382)." And that is without the added fields. Thanks again, Dwayne ---- Original message ---- >Date: Mon, 20 Apr 2009 07:19:25 -0700 >From: Janie Sprenger <jrsrem...@gmail.com> >Subject: Re: Error adding field to join form >To: arslist@ARSLIST.ORG > >Hi Dwayne, > >Are you able to save the Parent form AssetBase and ComputerSystem without an >error, if you don't add a field -- just reposition a field? > >Janie > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin >Sent: Monday, April 20, 2009 5:28 AM >To: arslist@ARSLIST.ORG >Subject: Re: Error adding field to join form > >Hi Janie, > >You are right. I am trying to add fields directly to the form in the Admin >tool. > >We purchased the v6 Asset Management module about five years ago, but out of >its vast potential, we have only used two of its forms. When we upgraded our >ARSystem to V7 we were told that we needed to hire a consultant to upgrade the >CMDB. We consulted with a consultant, and he said that since we are only >using a small portion of the module the best thing to do was just go on using >the two form and not bother upgrading the CMDB until we decided to use the >entire system. > >So now we are at ARS 7.1, with a v6 CMDB, and trying to use two Asset >Management forms as regular Remedy forms. > >What puzzles me is that I have added fields directly into >BMC:BMC_ComputerSystem_ before and I never got that "SQL view" error. Now I >get the error message when adding new fields, and the system will let me add >those old fields to BMC:BMC_ComputerSystem, but not the new ones. > >I tried checking out the "CMDB Console" and "CMDB2ASSET synchronization" and >it looks like something requiring an extra layer of knowledge, and which >probably won't work anyway given that our CMDB version doesn't match our ARS >version. > >So, any suggestions for a workaround? If not, I'll just say a big THANK YOU! >for your reply and abandon the project. At least I know WHY it isn't working. > >Gratefully yours, >Dwayne Martin > >---- Original message ---- >>Date: Sun, 19 Apr 2009 08:39:29 -0700 >>From: Janie Sprenger <jrsrem...@gmail.com> >>Subject: Re: Error adding field to join form >>To: arslist@ARSLIST.ORG >> >>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" > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"