mxexport.bat : export doesn't work, CLI error

[OlivierV]

Hello.

I've installed the migration.exe tool and now
I'm using the Mxexport.bat file for exporting the configuration of a Sim 5.3.1 CMS.
I run "mxexport.bat -f e:\export.zip", enter the password when asked to, the script runs and after about one hour displays the following messages :
- HpSim Completed successfully
- Error invoking the CLI.
None zip file is created at the root of E: or in the configdata-export folder.

Hp Sim service is stopped during the export, SQL is version 2005 with SP3. Any idea of what causes this problem ?

Thank you.

[OlivierV]

Hello.

I've noticed some points :
- the line 'SET SIMLIB=%SIMPATH%\lib' has 5 trailing spaces. Is it normal ?
- Using procmon, I found that the export tool creates many CSV files in the folder [hpsim]\data\configdata-export\migrationtemp\HPSIM\Tables\HPSIM. Can they be used for importing the datas in the targert CMS ?
- During the export, a zip file is created in [hpsim]\config\migration, named tmpzip.... . It's 28 Mb big at the moment. Can it be used (if not cleared at the end of the export process) for importing the data to the target CSM ?

Thank you.

[Change_happens]

i ran it this way:
run command without giving zip file name, like: mxexport -p

this will create zip file under: [hpsim]\data\configdata-export\Products.zip

This products.zip is exported zip file.

remove those spaces from end of SIM-LIB variable that's issue.

+++++++++++++
-HpSim Completed successfully
-Error invoking the CLI.
these both above looks contradictory. you have only hpsim installed or some other HPSIM plugin also?

[OlivierV]

PMP and VMM were installed but I uninstalled them before exporting the datas because the new CMD doesn't use them.
I'm running the export with your suggestion, wait and see ..

[pirate_2]

hi,
you will not be able to use the csv files directly for import. Also the temp zip will not be useful.

Just check if enough free space was available at the sim installed dir.
also try using mxexport without specifying the default file name.

Thanks

[Change_happens]

hey Olivier, just remove any xml file related to PMP, VMM which is present in [hpsim]\config\migration

[OlivierV]

Than kyou for your replies.

I removed the XML files for the products that are not installed. This solved the message displayed at the beginning of the export process telling that VMM data won't be exported.

I also ran the mxexport.bat file without the file name, only -p switch.

There is also 33 Gb of free space on the drive where I export the configuration.

But unfortunately, I'm still getting the message "Error while invoking the CLI" after "HPSIM completed successfully". For information, the error message appears about 10 minutes after "HPSIM completed successfully".

There is several .jar files in [hpsim]/config/migration/lib where there is only simmigrate.jar on the new SIM6 server. So I removed the other ones and re-launched the migration batch. Result in one hour.

[Change_happens]

we are one step further now. good you deleted those jars.
now best will be enable logs described here below:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1425183

upload or check log file that will tell you all.

[OlivierV]

Usefull information, thank you.

I enabled the logging and used "%java%" in mxexport.bat. But the problem is still present, the last entries of the logs are :

03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] LEAVING: exportMigrFiles
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] Exporting files that have environment variables
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] LEAVING: exportMigrFiles
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] Exporting files that have absolute paths
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] LEAVING: exportMigrFiles
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] LEAVING: exportFiles
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] Export of files to recover is successful.
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] Create Manifest...
03 Jun 2010 14:19:41,192 INFO [HPSIM_DEBUG] ENTERING: writeManifest
03 Jun 2010 14:19:41,223 INFO [HPSIM_DEBUG] LEAVING: writeManifest
03 Jun 2010 14:19:41,223 INFO [HPSIM_DEBUG] Manifest created...
03 Jun 2010 14:19:41,223 INFO [HPSIM_DEBUG] THREAD STATUS of : hpsim_migrate modified to COMPLETED
03 Jun 2010 14:19:41,223 INFO [HPSIM_DEBUG] Counter: true
03 Jun 2010 14:19:41,223 INFO [HPSIM_DEBUG] hpsim completed successfully.
HPSIM completed successfully.
03 Jun 2010 14:19:41,223 INFO [HPSIM_DEBUG] Threads complete execution
03 Jun 2010 14:19:41,223 INFO [HPSIM_DEBUG] Compressing hpsim data from E:\Program Files\HP\Systems
Insight Manager\data\configdata-export\migrationtemp\hpsim to E:\Program Files\HP\Systems Insight M
anager\data\configdata-export\migrationtemp\hpsim1.zip
Error while invoking the CLI

So the error occurs immediately after the process started compressing the file. I don't know if it has succeeded.
I'm going to check the rights on these folders

[Change_happens]

one more good catch about java variable. how can they create such a batch file. :)

are u able to see "hpsim1.zip" at that point of time @ specified place?
they have -Xmx512m inside batch. try increasing this value if its memory issue. just a guess.