I fail to create a custom patch from 9.32 to 9.41

Hi,

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?

Option:
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"

 


Check log:
-detail.log: stop when create upgrade.inf
-upgrade.log: stop log "**** Start Phase [Export Data] ****"
-sm.log: no error about create custom upgrade

-sm_xxxx_stdouterror.log:

..\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

 


Result:
create below files, but other file didn't create


data folder (empty)
detail.log
upgrade.inf
upgrade.log
upgrade-ja.inf


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.
Why ??


Best Regards,
Ayako

Parents
  • Hi Ayako,

     

    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.

     

    BRs,

    Khalil

     

Reply
  • Hi Ayako,

     

    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.

     

    BRs,

    Khalil

     

Children
  • Verified Answer

    Hi Khalil

    Thank you for your reply!!

    I try your instruction.

    NEW or PRE record delete the *aapm.upgrade.purge.

    But Result is the same.

     

    Why I cannot create custom patch?

     

    Best Regards,

    Ayako

  • 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.

     

  • 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.

     

    Khalll>

    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.

     

    Best Regards,

    Ayako

  • 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.

     

    Khalll>

    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.

     

    Best Regards,

    Ayako

  • Hi, all

     

    I tried continuously upgrade test.

    Above purge timing is not correct....  maybe.

    I seem to create custom upgrade  with  executed each phase....

     

    Best Regards,

    Ayako