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:[email protected]] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:52 PM To: [email protected] 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:[email protected]<mailto:[email protected]>] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:14 PM To: [email protected]<mailto:[email protected]> 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"
