Re: Error adding field to join form
Have you recently been able to have the DB bounced and restart the ARS service? It sounds like you are either experiencing database corruption or ARS is all mixed up. I'd try bouncing the DB and restarting ARS before doing anything else. If your items are still missing then you most likely will have to do some manual DB things. Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Monday, April 20, 2009 9:59 AM To: arslist@ARSLIST.ORG Subject: Re: Error adding field to join form 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 >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 >>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 Me
Re: Error adding field to join form
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 >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 >>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 field
Re: Error adding field to join form
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 >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) > >__
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 >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"
Re: Error adding field to join form
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"
