Sent via Micromax On Mar 21, 2015 7:59 PM, Aditya Shrivastava <iadity...@gmail.com> wrote: Hi Pavan,
Hope you too resolve it soon., good luck!! Regards, Aditya On Thu, Mar 19, 2015 at 6:27 PM, Nagidi Pavan <pavan....@gmail.com> wrote: > ** > Thanks Aditya, > > One of my senior colleagues had resolved this issue with all trail and > error method. I will get from him what has been done to fix this issue. > > > > On Thu, Mar 19, 2015 at 11:37 AM, Aditya Shrivastava <iadity...@gmail.com> > wrote: > >> ** >> Hi Pavan, >> >> Please find my responses inline. Thanks! >> >> Bottomline: >> 1) Compile all the 65 INVALID objects, in fact they are the reason for >> longer run of your ITSM upgrade installer. They should have been identified >> before running installer and must have been re-compiled. Keep checking for >> them when installer is running and compile them. >> 2) You have trouble importing one join form. Take backup of base forms in >> your environment. Import OOTB 8.1.02 version of the form directly. >> >> Regards, >> Aditya Shrivastava >> >> On Tue, Mar 17, 2015 at 6:50 PM, Nagidi Pavan <pavan....@gmail.com> >> wrote: >> >>> ** >>> 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'; >>> >> >> >>> [APS]: Yes, this query gives you count of INVALID objects. You can >>> re-compile these objects using "Compile" option from whatever software you >>> are using. or run query to compile those objects. >>> >> Any suggestions to correct them is highly appreciated, also I would like >>> to know why they are INVALID. How to troubleshoot that? >>> >> There are INVALID objects because of the fact that there are some >> structural differences between how Remedy and Oracle creates tables and >> views. But this is not a big problem as those INVALID objects can be >> "Compiled" and then everything would be in sync. >> >>> >>> 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 does not exist in 7.6.03 but >>> seems like newly added in 8.1.02 >>> >>> [APS]: I believe you have already followed recommended upgrade path >> 7.6.03 to 7.6.04 to 8.1.02. >> Since this form doesn't exist in 7.6.03, I would like to try out >> following: >> 1. Identify the def to which it belong like chg_deplapp**.def and try to >> import this form alone from 8.1.02_install folder. >> 2. If unable to find the def, you can try importing def of this form >> alone obtained from an OOTB environment. Please note this is a join form so >> you should have the base forms inn your environment >> CHG:ChangeRelationshipinterface -> CHG:Associations + CHG:ChangeInterface >> >> >>> 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. >>> >> >> [APS]: You can try importing def of this form alone obtained from an >> OOTB environment. >> >>> >>> 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. >>> >> >> [APS]: As you said, this form doesn't exist in old environment and might >> be newly added one. Would suggest take backup of base forms and import the >> newly added join form obtained from an OOTB environement. >> >>> >>> 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 <iadity...@gmail.com >>> > 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 <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_ >>>>> >>>> >>>> _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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"