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"
