Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Issue while upgrading SM from 9.30 to 9.32

SOLVED
Go to Solution
Valued Contributor

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
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 :)
Highlighted
Valued Contributor

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.