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

Upgrading from SM 7.11 to SM 9.30

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