Re: ITSM Upgrade completed with warnings - In fact failed to upgrade

[William Rentfrow]

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.

___
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

[Nagidi Pavan]

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

[Grooms, Frederick W]

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

[Nagidi Pavan]

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

[Ken Pritchard]

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

[Nagidi Pavan]

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

[Nagidi Pavan]

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

[Aditya Shrivastava]

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

[Nagidi Pavan]

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

[Aditya Shrivastava]

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

[Nagidi Pavan]

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

[Aditya Shrivastava]

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

[Jameela s]

>>
>>>
>>> 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.