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

Upgrading from SM 7.11 to SM 9.30

Advisor

Upgrading from SM 7.11 to SM 9.30

Hi Experts,

I am trying to upgrade SM 7.11 to 9.30.

But while upgrading I found a error  message after which the upgradation process stopped suddenly.

Which is as follows-

 

"The record being added contains a NULL key (message,add.schedule)
file:(schedule) key:(schedule.id=) (message,add.schedule)
Key #7 is empty. (message,add.schedule)
The record being added contains a NULL key (message,add.schedule)
file:(schedule) key:(schedule.id=) (message,add.schedule)
Key #7 is empty. (message,add.schedule)
The record being added contains a NULL key (message,add.schedule)
file:(schedule) key:(schedule.id=) (message,add.schedule)
Key #7 is empty. (message,add.schedule)
An error occurred while attempting to update a record (apm.upgrade.dbdict,save.dbdict)
file:(dbdict) key:(name=kmquery) (apm.upgrade.dbdict,save.dbdict)
ALTER TABLE KMQUERYM1 ADD "SMDOCS" CHAR(1)  NULL (apm.upgrade.dbdict,save.dbdict)
Cancelling dbdict update, failed to execute the following SQL: (apm.upgrade.dbdict,save.dbdict)
API=SQLExecute [in sqmssqlExecOne], Statement=ALTER TABLE KMQUERYM1 ADD "SMDOCS" CHAR(1)  NULL (apm.upgrade.dbdict,save.dbdict)
SQL State: 42000-8180  Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. (apm.upgrade.dbdict,save.dbdict)
SQL State: 42S21-2705  Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Column names in each table must be unique. Column name 'SMDOCS' in table '
KMQUERYM1' is specified more than once. (apm.upgrade.dbdict,save.dbdict)
Unrecoverable error in application:  sm.upgrade on panel call.service.pack
Unrecoverable error in application:  apm.upgrade.wizard on panel process.dbdict
Unrecoverable error in application:  apm.upgrade.dbdict on panel save.dbdict"

 

I have alos attached the log files .

Kindly share your suggestions to troubleshoot this error.

 

Thanks and Regards

Sandeep.S

3 REPLIES
Highlighted
Frequent Advisor

Re: Upgrading from SM 7.11 to SM 9.30

hello,

 

did you run "Data scan utility" in smupgrade?

is there issue reported?

 

 

Occasional Contributor

Re: Upgrading from SM 7.11 to SM 9.30

Try to delete the field "SMDOCS" in dbdict and continous the upgrade

HPE Expert

Re: Upgrading from SM 7.11 to SM 9.30

Hi, Sandeep

In the error,  Column name 'SMDOCS' in table '
KMQUERYM1' is specified more than once

Please check if the field "SMDOCS" in the table "KMQUERYM1" has been defined correctly.

 

Thanks

Desmond