HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Issue while upgrading SM from 9.30 to 9.32

SOLVED
Go to Solution
Highlighted
Super Advisor

Issue while upgrading SM from 9.30 to 9.32

Hi Experts

 

I am getting below error while upgrading application of HPSM from 9.30 to 9.32:-

 

The record being added contains a duplicate key (file.load,add.record.0)

 

Below are the data file for which i am getting error:-

 

HPPCHRELcalholidays.dta,HPPCHRELinbox.dta and HPPCHRELdevtype.dta

 

Any idea or Anybody else has faced this issue earlier.

Thanks,

Deepesh
1 ACCEPTED SOLUTIONS
Honored Contributor

Re: Issue while upgrading SM from 9.30 to 9.32

Sounds like this issue. http://support.openview.hp.com/selfsolve/document/KM00609467
SM 9.32 patch fails with error on script patchrelHelper line 349.
Log a call with HP.
3 REPLIES
Honored Contributor

Re: Issue while upgrading SM from 9.30 to 9.32

Hi,

 

This may be caused by a case insensitive RDBMS.

The cause of the issue is sqlbasename is a "no duplicates" key in the datadict so these values must be unique without regard to case or it will fail to load.

You can check the following document, where by upgrade there was the same error but for svcCatApprovalLog:

 

http://support.openview.hp.com/selfsolve/document/KM1166519

 

Best regards

Dimitar Peychev

HP Support
If you find that this or any post resolved your issue, please be sure
to mark it as an accepted solution.
Please also give kudo if you find it interesting :)
Super Advisor

Re: Issue while upgrading SM from 9.30 to 9.32

Hi Dimitar

 

Thanks for your inputs. Error was related to DB specifically which i could able to rectify

 

However after that as well i am getting below errors:-

 

Process panel add.rename in RAD sm.patchrel.data encountered error in line 1 (sm.patchrel.data,add.rename)
Cannot evaluate expression (sm.patchrel.data,add.rename)
Bad arg(2) oper = (sm.patchrel.data,add.rename)
Cannot evaluate expression (sm.patchrel.data,add.rename)
Script 'patchrelHelper' line 349:ERROR Cannot store a string into an Object of type number at char 1

 

Any inputs or suggestions for above errors?

Thanks,

Deepesh
Honored Contributor

Re: Issue while upgrading SM from 9.30 to 9.32

Sounds like this issue. http://support.openview.hp.com/selfsolve/document/KM00609467
SM 9.32 patch fails with error on script patchrelHelper line 349.
Log a call with HP.