Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
>> >>> >>> On Tue, Mar 17, 2015 at 9:07 AM, Aditya Shrivastava >> > wrote: >>> >>>> ** >>>> Hi Pavan, >>>> >>>> 1) Which database you have? If you have Oracle, did you check for >>>> INVALID objects while installing/upgrading? >>>> 2) Hope you must have seen ITSM install log files, but would again >>>> suggest you to look through logs and find out which .def failed to import. >>>> For ex chg_deplapp.def etc >>>> 3) Go through all INC/PBM/CHG and import all the failed def files. >>>> 4) If you are facing issues with specific form import also - suggest >>>> you to modify them, save changes and again try to import them. >>>> >>>> Let us know how it goes. Thanks! >>>> >>>> Regards, >>>> Aditya >>>> >>>> On Tue, Mar 17, 2015 at 5:59 AM, Nagidi Pavan >>>> wrote: >>>> >>>>> ** >>>>> Hello Experts, >>>>> >>>>> Do anyone has any suggestions for me!! >>>>> >>>>> On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan >>>>> wrote: >>>>> >>>>>> Hi Ken, >>>>>> >>>>>> Thanks for your response. >>>>>> >>>>>> For the form which we are facing the issue, in the Base devleopment >>>>>> mode it shows its "overlaid", in the Best Practice Customization mode it >>>>>> shows "unmodified". >>>>>> >>>>>> Is this the issue? If so, how to overcome this? >>>>>> >>>>>> On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard >>>>>> wrote: >>>>>> >>>>>>> ** >>>>>>> >>>>>>> I’ve seen the unique index error occur when there is a form with and >>>>>>> without the __c designation. Seems like the system thinks they are two >>>>>>> different forms, but the same form. >>>>>>> >>>>>>> >>>>>>> >>>>>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>>>>> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >>>>>>> *Sent:* Thursday, March 12, 2015 2:03 PM >>>>>>> >>>>>>> *To:* arslist@ARSLIST.ORG >>>>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact >>>>>>> failed to upgrade >>>>>>> >>>>>>> >>>>>>> >>>>>>> ** >>>>>>> >>>>>>> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >>>>>>> >>>>>>> >>>>>>> >>>>>>> Sounds like your database had an error with connecting to it. I >>>>>>> believe there is an SQL log made during the upgrade. See if it has any >>>>>>> more information >>>>>>> >>>>>>> >>>>>>> >>>>>>> Look to see what the SQL was doing when you got the >>>>>>> >>>>>>> The value(s) for this entry violate a unique index that has been >>>>>>> defined for this form; , 382 >>>>>>> >>>>>>> >>>>>>> >>>>>>> That will tell you which forms tried to create duplicate records >>>>>>> >>>>>>> >>>>>>> >>>>>>> Fred >>>>>>> >>>>>>> >>>>>>> >>>>>>> *From:* Action Request System discussion list(ARSList) [ >>>>>>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi >>>>>>> Pavan >>>>>>> *Sent:* Thursday, March 12, 2015 12:52 PM >>>>>>> *To:* arslist@ARSLIST.ORG >>>>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact >>>>>>> failed to upgrade >>>>>>> >>>>>>> >>>>>>> >>>>>>> ** >>>>>>> >>>>>>> Hi William, >>>>>>> >>>>>>> Firstly, thanks for your response. >>>>>>> >>>>>>> Below was done prior to ITSM upgrade.
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
a >> > wrote: >>> >>>> ** >>>> Hi Pavan, >>>> >>>> 1) Which database you have? If you have Oracle, did you check for >>>> INVALID objects while installing/upgrading? >>>> 2) Hope you must have seen ITSM install log files, but would again >>>> suggest you to look through logs and find out which .def failed to import. >>>> For ex chg_deplapp.def etc >>>> 3) Go through all INC/PBM/CHG and import all the failed def files. >>>> 4) If you are facing issues with specific form import also - suggest >>>> you to modify them, save changes and again try to import them. >>>> >>>> Let us know how it goes. Thanks! >>>> >>>> Regards, >>>> Aditya >>>> >>>> On Tue, Mar 17, 2015 at 5:59 AM, Nagidi Pavan >>>> wrote: >>>> >>>>> ** >>>>> Hello Experts, >>>>> >>>>> Do anyone has any suggestions for me!! >>>>> >>>>> On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan >>>>> wrote: >>>>> >>>>>> Hi Ken, >>>>>> >>>>>> Thanks for your response. >>>>>> >>>>>> For the form which we are facing the issue, in the Base devleopment >>>>>> mode it shows its "overlaid", in the Best Practice Customization mode it >>>>>> shows "unmodified". >>>>>> >>>>>> Is this the issue? If so, how to overcome this? >>>>>> >>>>>> On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard >>>>>> wrote: >>>>>> >>>>>>> ** >>>>>>> >>>>>>> I’ve seen the unique index error occur when there is a form with and >>>>>>> without the __c designation. Seems like the system thinks they are two >>>>>>> different forms, but the same form. >>>>>>> >>>>>>> >>>>>>> >>>>>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>>>>> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >>>>>>> *Sent:* Thursday, March 12, 2015 2:03 PM >>>>>>> >>>>>>> *To:* arslist@ARSLIST.ORG >>>>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact >>>>>>> failed to upgrade >>>>>>> >>>>>>> >>>>>>> >>>>>>> ** >>>>>>> >>>>>>> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >>>>>>> >>>>>>> >>>>>>> >>>>>>> Sounds like your database had an error with connecting to it. I >>>>>>> believe there is an SQL log made during the upgrade. See if it has any >>>>>>> more information >>>>>>> >>>>>>> >>>>>>> >>>>>>> Look to see what the SQL was doing when you got the >>>>>>> >>>>>>> The value(s) for this entry violate a unique index that has been >>>>>>> defined for this form; , 382 >>>>>>> >>>>>>> >>>>>>> >>>>>>> That will tell you which forms tried to create duplicate records >>>>>>> >>>>>>> >>>>>>> >>>>>>> Fred >>>>>>> >>>>>>> >>>>>>> >>>>>>> *From:* Action Request System discussion list(ARSList) [ >>>>>>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi >>>>>>> Pavan >>>>>>> *Sent:* Thursday, March 12, 2015 12:52 PM >>>>>>> *To:* arslist@ARSLIST.ORG >>>>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact >>>>>>> failed to upgrade >>>>>>> >>>>>>> >>>>>>> >>>>>>> ** >>>>>>> >>>>>>> Hi William, >>>>>>> >>>>>>> Firstly, thanks for your response. >>>>>>> >>>>>>> Below was done prior to ITSM upgrade. >>>>>>> >>>>>>> >>>>>>
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
est you >>> to modify them, save changes and again try to import them. >>> >>> Let us know how it goes. Thanks! >>> >>> Regards, >>> Aditya >>> >>> On Tue, Mar 17, 2015 at 5:59 AM, Nagidi Pavan >>> wrote: >>> >>>> ** >>>> Hello Experts, >>>> >>>> Do anyone has any suggestions for me!! >>>> >>>> On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan >>>> wrote: >>>> >>>>> Hi Ken, >>>>> >>>>> Thanks for your response. >>>>> >>>>> For the form which we are facing the issue, in the Base devleopment >>>>> mode it shows its "overlaid", in the Best Practice Customization mode it >>>>> shows "unmodified". >>>>> >>>>> Is this the issue? If so, how to overcome this? >>>>> >>>>> On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard wrote: >>>>> >>>>>> ** >>>>>> >>>>>> I’ve seen the unique index error occur when there is a form with and >>>>>> without the __c designation. Seems like the system thinks they are two >>>>>> different forms, but the same form. >>>>>> >>>>>> >>>>>> >>>>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>>>> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >>>>>> *Sent:* Thursday, March 12, 2015 2:03 PM >>>>>> >>>>>> *To:* arslist@ARSLIST.ORG >>>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed >>>>>> to upgrade >>>>>> >>>>>> >>>>>> >>>>>> ** >>>>>> >>>>>> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >>>>>> >>>>>> >>>>>> >>>>>> Sounds like your database had an error with connecting to it. I >>>>>> believe there is an SQL log made during the upgrade. See if it has any >>>>>> more information >>>>>> >>>>>> >>>>>> >>>>>> Look to see what the SQL was doing when you got the >>>>>> >>>>>> The value(s) for this entry violate a unique index that has been >>>>>> defined for this form; , 382 >>>>>> >>>>>> >>>>>> >>>>>> That will tell you which forms tried to create duplicate records >>>>>> >>>>>> >>>>>> >>>>>> Fred >>>>>> >>>>>> >>>>>> >>>>>> *From:* Action Request System discussion list(ARSList) [ >>>>>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi >>>>>> Pavan >>>>>> *Sent:* Thursday, March 12, 2015 12:52 PM >>>>>> *To:* arslist@ARSLIST.ORG >>>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed >>>>>> to upgrade >>>>>> >>>>>> >>>>>> >>>>>> ** >>>>>> >>>>>> Hi William, >>>>>> >>>>>> Firstly, thanks for your response. >>>>>> >>>>>> Below was done prior to ITSM upgrade. >>>>>> >>>>>> >>>>>> 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any >>>>>> issues. >>>>>> 2) Ran BPCU in overlay mode to preserve our customizations >>>>>> 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 >>>>>> 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing >>>>>> issues with field mappings using the option "Only copy CI attributes from >>>>>> CDM to ITSM Foundation". >>>>>> 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 >>>>>> but don not remove CI attributes from CDM". After 13 hours we got the >>>>>> results as "BMC Remedy ITSM Suite 8.1.02 install completed with >>>>>> warnings." >>>>>> >>>>>> I believe I am going in the correct direction. Please advise. >>>>>> >>>>>> Thanks
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
pment >>>> mode it shows its "overlaid", in the Best Practice Customization mode it >>>> shows "unmodified". >>>> >>>> Is this the issue? If so, how to overcome this? >>>> >>>> On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard wrote: >>>> >>>>> ** >>>>> >>>>> I’ve seen the unique index error occur when there is a form with and >>>>> without the __c designation. Seems like the system thinks they are two >>>>> different forms, but the same form. >>>>> >>>>> >>>>> >>>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>>> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >>>>> *Sent:* Thursday, March 12, 2015 2:03 PM >>>>> >>>>> *To:* arslist@ARSLIST.ORG >>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed >>>>> to upgrade >>>>> >>>>> >>>>> >>>>> ** >>>>> >>>>> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >>>>> >>>>> >>>>> >>>>> Sounds like your database had an error with connecting to it. I >>>>> believe there is an SQL log made during the upgrade. See if it has any >>>>> more information >>>>> >>>>> >>>>> >>>>> Look to see what the SQL was doing when you got the >>>>> >>>>> The value(s) for this entry violate a unique index that has been >>>>> defined for this form; , 382 >>>>> >>>>> >>>>> >>>>> That will tell you which forms tried to create duplicate records >>>>> >>>>> >>>>> >>>>> Fred >>>>> >>>>> >>>>> >>>>> *From:* Action Request System discussion list(ARSList) [ >>>>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi >>>>> Pavan >>>>> *Sent:* Thursday, March 12, 2015 12:52 PM >>>>> *To:* arslist@ARSLIST.ORG >>>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed >>>>> to upgrade >>>>> >>>>> >>>>> >>>>> ** >>>>> >>>>> Hi William, >>>>> >>>>> Firstly, thanks for your response. >>>>> >>>>> Below was done prior to ITSM upgrade. >>>>> >>>>> >>>>> 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. >>>>> 2) Ran BPCU in overlay mode to preserve our customizations >>>>> 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 >>>>> 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing >>>>> issues with field mappings using the option "Only copy CI attributes from >>>>> CDM to ITSM Foundation". >>>>> 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but >>>>> don not remove CI attributes from CDM". After 13 hours we got the results >>>>> as "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." >>>>> >>>>> I believe I am going in the correct direction. Please advise. >>>>> >>>>> Thanks >>>>> >>>>> Pavan >>>>> >>>>> >>>>> >>>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>>> arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan >>>>> *Sent:* Thursday, March 12, 2015 12:14 PM >>>>> *To:* arslist@ARSLIST.ORG >>>>> *Subject:* ITSM Upgrade completed with warnings - In fact failed to >>>>> upgrade >>>>> >>>>> >>>>> >>>>> ** >>>>> >>>>> Hello Experts, >>>>> >>>>> We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed >>>>> with warnings. From the logs we could find many def files failed to >>>>> import. >>>>> We have sorted out issues related to Asset, incident and Problem >>>>> Management. But facing issues while importing the def files related to >>>>> Change Module. >>>>> >>>>> We could see the below error messages while importing the file. >>>>> >>>>> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, >>>>> The following item was not imported; >>>>> CHG:ChangeImpactedAreaCIAssociation_Join, 55, >>>>> The following item was not imported; >>>>> CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, >>>>> The following item was not imported; CHG:ChangeRelationshipInterface, >>>>> 55 >>>>> >>>>> We have restarted Remedy services and tried importing that again. This >>>>> time we could find the below messages. >>>>> >>>>> The value(s) for this entry violate a unique index that has been >>>>> defined for this form; , 382, >>>>> The following item was not imported; >>>>> CHG:ChangeImpactedAreaCIAssociation_Join, 55, >>>>> The following item was not imported; >>>>> CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, >>>>> The following item was not imported; CHG:ChangeRelationshipInterface, >>>>> 55, >>>>> >>>>> >>>>> >>>>> I have opened a ticket with BMC but as as usual very poor response in >>>>> this week. Any suggestions are highly appreciated. >>>>> >>>>> Thanks >>>>> >>>>> Pavan >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>> >>>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Hi Aditya, Thank you very much for your reply. Please find my answers below. 1) Which database you have? If you have Oracle, did you check for INVALID objects while installing/upgrading? ANS: Oracle, How do we checked INVALID objects by the below query and it fetched almost 65 entries select object_name,object_type,status from user_objects where status='INVALID'; Any suggestions to correct them is highly appreciated, also I would like to know why they are INVALID. How to troubleshoot that? 2) Hope you must have seen ITSM install log files, but would again suggest you to look through logs and find out which .def failed to import. For ex chg_deplapp.def etc ANS: Fixed all most all the issues that we could see in the logs. The issues which we are seeing now is while importing CHG:ChangeRelationshipinterface form, which doesnot exist in 7.6.03 but seems like newly added in 8.1.02 3) Go through all INC/PBM/CHG and import all the failed def files. ANS: imported all the def files related to INC and PBM only facing issues while importing chg_deplapp.def and especially with CHG:ChangeRelationshipinterface form. 4) If you are facing issues with specific form import also - suggest you to modify them, save changes and again try to import them. ANS: Since we are only facing issues with CHG:ChangeRelationshipinterface form, is that fine modifying that form? My only concern is the above mentioned form does not exist in 7.603. We are upgrading ITSM from 7.6.03 to 8.1.02. Please let me now your thoughts and any suggestions to move forward!! Thanks once again. On Tue, Mar 17, 2015 at 9:07 AM, Aditya Shrivastava wrote: > ** > Hi Pavan, > > 1) Which database you have? If you have Oracle, did you check for INVALID > objects while installing/upgrading? > 2) Hope you must have seen ITSM install log files, but would again suggest > you to look through logs and find out which .def failed to import. For ex > chg_deplapp.def etc > 3) Go through all INC/PBM/CHG and import all the failed def files. > 4) If you are facing issues with specific form import also - suggest you > to modify them, save changes and again try to import them. > > Let us know how it goes. Thanks! > > Regards, > Aditya > > On Tue, Mar 17, 2015 at 5:59 AM, Nagidi Pavan wrote: > >> ** >> Hello Experts, >> >> Do anyone has any suggestions for me!! >> >> On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan >> wrote: >> >>> Hi Ken, >>> >>> Thanks for your response. >>> >>> For the form which we are facing the issue, in the Base devleopment mode >>> it shows its "overlaid", in the Best Practice Customization mode it shows >>> "unmodified". >>> >>> Is this the issue? If so, how to overcome this? >>> >>> On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard wrote: >>> >>>> ** >>>> >>>> I’ve seen the unique index error occur when there is a form with and >>>> without the __c designation. Seems like the system thinks they are two >>>> different forms, but the same form. >>>> >>>> >>>> >>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >>>> *Sent:* Thursday, March 12, 2015 2:03 PM >>>> >>>> *To:* arslist@ARSLIST.ORG >>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed >>>> to upgrade >>>> >>>> >>>> >>>> ** >>>> >>>> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >>>> >>>> >>>> >>>> Sounds like your database had an error with connecting to it. I >>>> believe there is an SQL log made during the upgrade. See if it has any >>>> more information >>>> >>>> >>>> >>>> Look to see what the SQL was doing when you got the >>>> >>>> The value(s) for this entry violate a unique index that has been >>>> defined for this form; , 382 >>>> >>>> >>>> >>>> That will tell you which forms tried to create duplicate records >>>> >>>> >>>> >>>> Fred >>>> >>>> >>>> >>>> *From:* Action Request System discussion list(ARSList) [ >>>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi >>>> Pavan >>>> *Sent:* Thursday, March 12, 2015 12:52 PM >>>> *To:* arslist@ARSLIST.ORG >>>> *Subject:* Re: ITSM Upgrade completed with warnings - In fac
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Hi Pavan, 1) Which database you have? If you have Oracle, did you check for INVALID objects while installing/upgrading? 2) Hope you must have seen ITSM install log files, but would again suggest you to look through logs and find out which .def failed to import. For ex chg_deplapp.def etc 3) Go through all INC/PBM/CHG and import all the failed def files. 4) If you are facing issues with specific form import also - suggest you to modify them, save changes and again try to import them. Let us know how it goes. Thanks! Regards, Aditya On Tue, Mar 17, 2015 at 5:59 AM, Nagidi Pavan wrote: > ** > Hello Experts, > > Do anyone has any suggestions for me!! > > On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan wrote: > >> Hi Ken, >> >> Thanks for your response. >> >> For the form which we are facing the issue, in the Base devleopment mode >> it shows its "overlaid", in the Best Practice Customization mode it shows >> "unmodified". >> >> Is this the issue? If so, how to overcome this? >> >> On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard wrote: >> >>> ** >>> >>> I’ve seen the unique index error occur when there is a form with and >>> without the __c designation. Seems like the system thinks they are two >>> different forms, but the same form. >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >>> *Sent:* Thursday, March 12, 2015 2:03 PM >>> >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to >>> upgrade >>> >>> >>> >>> ** >>> >>> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >>> >>> >>> >>> Sounds like your database had an error with connecting to it. I believe >>> there is an SQL log made during the upgrade. See if it has any more >>> information >>> >>> >>> >>> Look to see what the SQL was doing when you got the >>> >>> The value(s) for this entry violate a unique index that has been defined >>> for this form; , 382 >>> >>> >>> >>> That will tell you which forms tried to create duplicate records >>> >>> >>> >>> Fred >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [ >>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi >>> Pavan >>> *Sent:* Thursday, March 12, 2015 12:52 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to >>> upgrade >>> >>> >>> >>> ** >>> >>> Hi William, >>> >>> Firstly, thanks for your response. >>> >>> Below was done prior to ITSM upgrade. >>> >>> >>> 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. >>> 2) Ran BPCU in overlay mode to preserve our customizations >>> 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 >>> 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues >>> with field mappings using the option "Only copy CI attributes from CDM to >>> ITSM Foundation". >>> 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but >>> don not remove CI attributes from CDM". After 13 hours we got the results >>> as "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." >>> >>> I believe I am going in the correct direction. Please advise. >>> >>> Thanks >>> >>> Pavan >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan >>> *Sent:* Thursday, March 12, 2015 12:14 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* ITSM Upgrade completed with warnings - In fact failed to >>> upgrade >>> >>> >>> >>> ** >>> >>> Hello Experts, >>> >>> We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed >>> with warnings. From the logs we could find many def files failed to import. >>> We have sorted out issues related to Asset, incident and Problem >>> Management. But facing issues while importing the def files related to >>> Change Module. >>> >>> We could see t
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Hello Experts, Do anyone has any suggestions for me!! On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan wrote: > Hi Ken, > > Thanks for your response. > > For the form which we are facing the issue, in the Base devleopment mode > it shows its "overlaid", in the Best Practice Customization mode it shows > "unmodified". > > Is this the issue? If so, how to overcome this? > > On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard wrote: > >> ** >> >> I’ve seen the unique index error occur when there is a form with and >> without the __c designation. Seems like the system thinks they are two >> different forms, but the same form. >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >> *Sent:* Thursday, March 12, 2015 2:03 PM >> >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to >> upgrade >> >> >> >> ** >> >> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >> >> >> >> Sounds like your database had an error with connecting to it. I believe >> there is an SQL log made during the upgrade. See if it has any more >> information >> >> >> >> Look to see what the SQL was doing when you got the >> >> The value(s) for this entry violate a unique index that has been defined >> for this form; , 382 >> >> >> >> That will tell you which forms tried to create duplicate records >> >> >> >> Fred >> >> >> >> *From:* Action Request System discussion list(ARSList) [ >> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi >> Pavan >> *Sent:* Thursday, March 12, 2015 12:52 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to >> upgrade >> >> >> >> ** >> >> Hi William, >> >> Firstly, thanks for your response. >> >> Below was done prior to ITSM upgrade. >> >> >> 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. >> 2) Ran BPCU in overlay mode to preserve our customizations >> 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 >> 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues >> with field mappings using the option "Only copy CI attributes from CDM to >> ITSM Foundation". >> 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but >> don not remove CI attributes from CDM". After 13 hours we got the results >> as "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." >> >> I believe I am going in the correct direction. Please advise. >> >> Thanks >> >> Pavan >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan >> *Sent:* Thursday, March 12, 2015 12:14 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* ITSM Upgrade completed with warnings - In fact failed to >> upgrade >> >> >> >> ** >> >> Hello Experts, >> >> We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed >> with warnings. From the logs we could find many def files failed to import. >> We have sorted out issues related to Asset, incident and Problem >> Management. But facing issues while importing the def files related to >> Change Module. >> >> We could see the below error messages while importing the file. >> >> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, >> The following item was not imported; >> CHG:ChangeImpactedAreaCIAssociation_Join, 55, >> The following item was not imported; >> CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, >> The following item was not imported; CHG:ChangeRelationshipInterface, 55 >> >> We have restarted Remedy services and tried importing that again. This >> time we could find the below messages. >> >> The value(s) for this entry violate a unique index that has been defined >> for this form; , 382, >> The following item was not imported; >> CHG:ChangeImpactedAreaCIAssociation_Join, 55, >> The following item was not imported; >> CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, >> The following item was not imported; CHG:ChangeRelationshipInterface, >> 55, >> >> >> >> I have opened a ticket with BMC but as as usual very poor response in >> this week. Any suggestions are highly appreciated. >> >> Thanks >> >> Pavan >> >> >> >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Hi Ken, Thanks for your response. For the form which we are facing the issue, in the Base devleopment mode it shows its "overlaid", in the Best Practice Customization mode it shows "unmodified". Is this the issue? If so, how to overcome this? On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard wrote: > ** > > I’ve seen the unique index error occur when there is a form with and > without the __c designation. Seems like the system thinks they are two > different forms, but the same form. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > *Sent:* Thursday, March 12, 2015 2:03 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to > upgrade > > > > ** > > The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 > > > > Sounds like your database had an error with connecting to it. I believe > there is an SQL log made during the upgrade. See if it has any more > information > > > > Look to see what the SQL was doing when you got the > > The value(s) for this entry violate a unique index that has been defined > for this form; , 382 > > > > That will tell you which forms tried to create duplicate records > > > > Fred > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Nagidi > Pavan > *Sent:* Thursday, March 12, 2015 12:52 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to > upgrade > > > > ** > > Hi William, > > Firstly, thanks for your response. > > Below was done prior to ITSM upgrade. > > > 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. > 2) Ran BPCU in overlay mode to preserve our customizations > 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 > 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues > with field mappings using the option "Only copy CI attributes from CDM to > ITSM Foundation". > 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but don > not remove CI attributes from CDM". After 13 hours we got the results as > "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." > > I believe I am going in the correct direction. Please advise. > > Thanks > > Pavan > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan > *Sent:* Thursday, March 12, 2015 12:14 PM > *To:* arslist@ARSLIST.ORG > *Subject:* ITSM Upgrade completed with warnings - In fact failed to > upgrade > > > > ** > > Hello Experts, > > We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with > warnings. From the logs we could find many def files failed to import. We > have sorted out issues related to Asset, incident and Problem Management. > But facing issues while importing the def files related to Change Module. > > We could see the below error messages while importing the file. > > The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, > The following item was not imported; > CHG:ChangeImpactedAreaCIAssociation_Join, 55, > The following item was not imported; > CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, > The following item was not imported; CHG:ChangeRelationshipInterface, 55 > > We have restarted Remedy services and tried importing that again. This > time we could find the below messages. > > The value(s) for this entry violate a unique index that has been defined > for this form; , 382, > The following item was not imported; > CHG:ChangeImpactedAreaCIAssociation_Join, 55, > The following item was not imported; > CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, > The following item was not imported; CHG:ChangeRelationshipInterface, > 55, > > > > I have opened a ticket with BMC but as as usual very poor response in this > week. Any suggestions are highly appreciated. > > Thanks > > Pavan > > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
I’ve seen the unique index error occur when there is a form with and without the __c designation. Seems like the system thinks they are two different forms, but the same form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, March 12, 2015 2:03 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 Sounds like your database had an error with connecting to it. I believe there is an SQL log made during the upgrade. See if it has any more information Look to see what the SQL was doing when you got the The value(s) for this entry violate a unique index that has been defined for this form; , 382 That will tell you which forms tried to create duplicate records Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:52 PM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option "Only copy CI attributes from CDM to ITSM Foundation". 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but don not remove CI attributes from CDM". After 13 hours we got the results as "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." I believe I am going in the correct direction. Please advise. Thanks Pavan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:14 PM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
I could see the below in the log files /* Wed Mar 11 2015 22:39:50.8992 */INSERT INTO field_permissions (recordId,schemaId,fieldId,groupId,permission,overlayExtended) VALUES (2074676,3530,23009,0,1,0) /* Wed Mar 11 2015 22:39:50.9352 */ /* Wed Mar 11 2015 22:39:50.9353 */SELECT T1.C1,C152,C155,C156 FROM T1 WHERE ((T1.C8 = '382') AND (T1.C7 = 0) AND (T1.C150 = 0) AND ((T1.C152 LIKE 'NO LOCALE') OR (T1.C152 IS NULL))) ORDER BY C152 ASC, 1 ASC /* Wed Mar 11 2015 22:39:50.9415 */OK /* Wed Mar 11 2015 22:39:50.9420 */ROLLBACK WORK Its almost some 3mb file after zipping it. I will send the logs shortly. On Fri, Mar 13, 2015 at 12:16 AM, Nagidi Pavan wrote: > Okay.. Attaching the SQL log that is captured while importing the def file > using the developer studio. > > On Thu, Mar 12, 2015 at 11:32 PM, Grooms, Frederick W < > frederick.w.gro...@xo.com> wrote: > >> ** >> >> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 >> >> >> >> Sounds like your database had an error with connecting to it. I believe >> there is an SQL log made during the upgrade. See if it has any more >> information >> >> >> >> Look to see what the SQL was doing when you got the >> >> The value(s) for this entry violate a unique index that has been defined >> for this form; , 382 >> >> >> >> That will tell you which forms tried to create duplicate records >> >> >> >> Fred >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan >> *Sent:* Thursday, March 12, 2015 12:52 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to >> upgrade >> >> >> >> ** >> >> Hi William, >> >> Firstly, thanks for your response. >> >> Below was done prior to ITSM upgrade. >> >> >> 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. >> 2) Ran BPCU in overlay mode to preserve our customizations >> 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 >> 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues >> with field mappings using the option "Only copy CI attributes from CDM to >> ITSM Foundation". >> 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but >> don not remove CI attributes from CDM". After 13 hours we got the results >> as "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." >> >> I believe I am going in the correct direction. Please advise. >> >> Thanks >> >> Pavan >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan >> *Sent:* Thursday, March 12, 2015 12:14 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* ITSM Upgrade completed with warnings - In fact failed to >> upgrade >> >> >> >> ** >> >> Hello Experts, >> >> We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed >> with warnings. From the logs we could find many def files failed to import. >> We have sorted out issues related to Asset, incident and Problem >> Management. But facing issues while importing the def files related to >> Change Module. >> >> We could see the below error messages while importing the file. >> >> The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, >> The following item was not imported; >> CHG:ChangeImpactedAreaCIAssociation_Join, 55, >> The following item was not imported; >> CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, >> The following item was not imported; CHG:ChangeRelationshipInterface, 55 >> >> We have restarted Remedy services and tried importing that again. This >> time we could find the below messages. >> >> The value(s) for this entry violate a unique index that has been defined >> for this form; , 382, >> The following item was not imported; >> CHG:ChangeImpactedAreaCIAssociation_Join, 55, >> The following item was not imported; >> CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, >> The following item was not imported; CHG:ChangeRelationshipInterface, >> 55, >> >> >> >> I have opened a ticket with BMC but as as usual very poor response in >> this week. Any suggestions are highly appreciated. >> >> Thanks >> >> Pavan >> >> >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 Sounds like your database had an error with connecting to it. I believe there is an SQL log made during the upgrade. See if it has any more information Look to see what the SQL was doing when you got the The value(s) for this entry violate a unique index that has been defined for this form; , 382 That will tell you which forms tried to create duplicate records Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option "Only copy CI attributes from CDM to ITSM Foundation". 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but don not remove CI attributes from CDM". After 13 hours we got the results as "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." I believe I am going in the correct direction. Please advise. Thanks Pavan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:14 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option "Only copy CI attributes from CDM to ITSM Foundation". 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but don not remove CI attributes from CDM". After 13 hours we got the results as "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." I believe I am going in the correct direction. Please advise. Thanks Pavan On Thu, Mar 12, 2015 at 11:01 PM, William Rentfrow < wrentf...@stratacominc.com> wrote: > ** > > Um...where to start. > > > > You can't upgrade - as far as I know - from 7.6.03 to 8.1. > > > > You first have to upgrade to 7.6.04 - but prior to that you have to do the > whole BPCU utility to convert any customizations you have to overlays > and/or deal with them according to the guidelines BMC gives. > > > > William Rentfrow > > wrentf...@stratacominc.com > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan > *Sent:* Thursday, March 12, 2015 12:14 PM > *To:* arslist@ARSLIST.ORG > *Subject:* ITSM Upgrade completed with warnings - In fact failed to > upgrade > > > > ** > > Hello Experts, > > We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with > warnings. From the logs we could find many def files failed to import. We > have sorted out issues related to Asset, incident and Problem Management. > But facing issues while importing the def files related to Change Module. > > We could see the below error messages while importing the file. > > The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, > The following item was not imported; > CHG:ChangeImpactedAreaCIAssociation_Join, 55, > The following item was not imported; > CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, > The following item was not imported; CHG:ChangeRelationshipInterface, 55 > > We have restarted Remedy services and tried importing that again. This > time we could find the below messages. > > The value(s) for this entry violate a unique index that has been defined > for this form; , 382, > The following item was not imported; > CHG:ChangeImpactedAreaCIAssociation_Join, 55, > The following item was not imported; > CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, > The following item was not imported; CHG:ChangeRelationshipInterface, > 55, > > > > I have opened a ticket with BMC but as as usual very poor response in this > week. Any suggestions are highly appreciated. > > Thanks > > Pavan > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > -- > > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2014.0.4800 / Virus Database: 4257/9209 - Release Date: 03/01/15 > Internal Virus Database is out of date. > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Um...where to start. You can't upgrade - as far as I know - from 7.6.03 to 8.1. You first have to upgrade to 7.6.04 - but prior to that you have to do the whole BPCU utility to convert any customizations you have to overlays and/or deal with them according to the guidelines BMC gives. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:14 PM To: arslist@ARSLIST.ORG Subject: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2014.0.4800 / Virus Database: 4257/9209 - Release Date: 03/01/15 Internal Virus Database is out of date. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
ITSM Upgrade completed with warnings - In fact failed to upgrade
Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" BMCRemedyChangeManagement_error.log Description: Binary data