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 <pavan....@gmail.com> wrote: > ** > Hello Experts, > > Do anyone has any suggestions for me!! > > On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan <pavan....@gmail.com> 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 <pri...@ptd.net> 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 <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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
