I would like to upgrade from SM9.32 to SM9.41.
But I fail to create a custom patch.
I installed Upgrade Utility.
And I resolve conflict.
I would create custom patch, but it stop when export.
Why SM Application upgrade builder cannot create?
Step 6-1 Purge dupulicate data」 [Yes]
Step 6-2 Check information [English, Japanese]
Step 6-3 Input the name [SM941CustomPatch]
Step 6-4 Patch path [C:\CustomPatch]
Step 6-5 choose action [Complete Upgrade Build(recoommend)]
Step 6-6 Decide to filter [check] (if un-check, the result is the same)
Step 6-7 create update [Next]
See below to resolve conflict:
- "Renamed" type -> "Mass Auto Update" and "Mass Mark as Reconciled"
- "Previsiously Reconciled" type -> "Merge" ,research conflict, manual merge,"Mark as Reconciled"
- "Auto Merge" -> "Mass Mark as Reconciled"
- "Kept Customer Non - OOB" type -> "Merge" ,research conflict, manual merge,"Mark as Reconciled"
-detail.log: stop when create upgrade.inf
-upgrade.log: stop log "**** Start Phase [Export Data] ****"
-sm.log: no error about create custom upgrade
..\bin\diff3: C:\temp\upgrade\sm9.41.0020_UP\AppUpgrade\application-9.41.0020-UP\localized_app_upgrade\SM7.10-9.41.0020_L10N\3waymerge\work\base\globallists\KM_Status.xml: No such file or directory
..\bin\diff3: C:\temp\upgrade\sm9.41.0020_UP\AppUpgrade\application-9.41.0020-UP\localized_app_upgrade\SM7.10-9.41.0020_L10N\3waymerge\work\base\globallists\ICM_Status.xml: No such file or directory
..\bin\diff3: C:\temp\upgrade\sm9.41.0020_UP\AppUpgrade\application-9.41.0020-UP\localized_app_upgrade\SM7.10-9.41.0020_L10N\3waymerge\work\base\SearchConfig\probsummary.xml: No such file or directory
..\bin\diff3: C:\temp\upgrade\sm9.41.0020_UP\AppUpgrade\application-9.41.0020-UP\localized_app_upgrade\SM7.10-9.41.0020_L10N\3waymerge\work\base\globallists\scripts.xml: No such file or directory
..\bin\diff3: C:\temp\upgrade\sm9.41.0020_UP\AppUpgrade\application-9.41.0020-UP\localized_app_upgrade\SM7.10-9.41.0020_L10N\3waymerge\work\base\screlconfig\problem.xml: No such file or directory
create below files, but other file didn't create
data folder (empty)
Windows client error:
Unrecoverable error in application: sm.upgrade.ux on panel call.create.upgrade
SQL State: 42S02-208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]object name 'UPGRADETOCM1' is invalid. (apm.upgrade.export,prep.dump.code)
SQL State: 42000-11529 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server] cannot specify meta data. It occured all code path. (apm.upg
Additional errors have been written to the log. Contact your system administrator (apm.upgrade.export,prep.dump.code)
SCFile name upgradetoc is not a Service Manager file.
Script 'upgradeUtility' line 9: ERROR TypeError: file.doSelect is not a function at char 1
Cannot evaluate expression jscall("upgradeHelper.addFileToTOC", "upgradecode.dta") (apm.upgrade.export,prep.dump.code)
Bad arg(2) oper = (apm.upgrade.export,prep.dump.code)
Cannot evaluate expression (apm.upgrade.export,prep.dump.code)
Process panel prep.dump.code in RAD apm.upgrade.export encountered error in line 2 (apm.upgrade.export,prep.dump.code)
-> I research dbdict and MS SQL Management studio, but SM has not UPGRADETOCM1 table.
I'm not sure but maybe you need to clean up artifacts by:
- Type " *aapm.upgrade.purge " in HP Service Manager command
- Click I'm done, and I want to remove the duplicate data prefixed by "NEW", "PRE" and "OLD"
Then you can retry to create custom upgrade.
In my view, the key point is in the error message:
"SQL State: 42S02-208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]object name 'UPGRADETOCM1' is invalid."
That file has to be deleted, because SM does not seem to like it. What I would try to do, is to delete the dbdict of "upgradetoc" to hide it from the upgrade process.
1. Choose Tailoring > Database Dictionary
2. Search for "upgradetoc"
3. If the file exists, delete it.
Try to build the custom patch again.
Moving on, this account is no longer active. Best regards, Kelalek
- So Long, and Thanks for All the Fish
Hi, Khalll and Kelalek2
Kelalek2 , Thank you for your reply !
My envoronment has not upgradetoc. Thus I wonder at "object name 'UPGRADETOCM1" Is Invalid, error message.
I try below step, then I can create custom upgrade!
1) Resolve Conflict
2) [*aapm.upgrade.purge]command, choose [I’m done, and I want to remove the upgrade files completely.] option
and execute purge file.
3) click "Create a Custom Upgrade".
This problem is "Create a Custom Upgrade" wizard doesn't purge files.
As if wizard purge files, especially Step 6-1 "Purge dupulicate data".
Khalll, I am grateful for your support.
I tried continuously upgrade test.
Above purge timing is not correct.... maybe.
I seem to create custom upgrade with executed each phase....