Re: Upgrading from SM 7.11 to SM 9.30 (678 Views)
Reply
Advisor
Sandeep1
Posts: 35
Registered: ‎03-01-2010
Message 1 of 2 (711 Views)

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

Frequent Advisor
bzember
Posts: 42
Registered: ‎10-09-2011
Message 2 of 2 (678 Views)

Re: Upgrading from SM 7.11 to SM 9.30

hello,

 

did you run "Data scan utility" in smupgrade?

is there issue reported?

 

 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.