mxexport failed - Migration Failed.Error while packing HPE System Insight Manager migration files.

[shatra]

Hello All

Currently I have a problem, actually from the begining of this year I opened a case at HPE support unfortunately no solution yet, and I feel a little bit pushed to do a fresh install and move systems manually, which is not good for me as there are a lot of systems with unknown credentials(wbem, sign in) + custom collections + system details, etc.

My own investigation lead me to Credential table, some data present there is inconsistent, unfortunately I have no cloue right now how to find the faulty data.

What I did I deleted all Credentials table from databes and mxexport executed succesfully, so the problem is isolated to that table....

Any thoughts?

D:\>mxversion
Systems Insight Manager 7.6.0 - Windows C.07.06.00.00r76rc05 ( 2016-11-29 07:00

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<MigrationStatus name="EXPORT" status="false" statusMsg="&#xA;Migration Failed.Error while packing HPE System Insight Manager migration files.">
    <Product name="hpsim" status="false" statusMsg="javax.crypto.BadPaddingException: Given final block not properly padded"/>
</MigrationStatus>

tUtils-20] (hpsim) LEAVING: readSecretKey()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [CryptUtils-20] (hpsim) LEAVING: initKey()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) ENTERING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) Property = ENCRYPT_SIM53_CREDENTIAL_TRANSFORM
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-40] (hpsim) not checking file last mod time, debounced.
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) ENTERING: getSystemProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) Property = ENCRYPT_SIM53_CREDENTIAL_TRANSFORM
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) ENTERING: getDefaultProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) Property = ENCRYPT_SIM53_CREDENTIAL_TRANSFORM
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-10] (hpsim) No internal default property value found for DEFAULT_ENCRYPT_SIM53_CREDENTIAL_TRANSFORM
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getDefaultProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) ENTERING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) Property = ENCRYPT_SIM53_CREDENTIAL_IV_BYTES
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-40] (hpsim) not checking file last mod time, debounced.
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) ENTERING: getSystemProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) Property = ENCRYPT_SIM53_CREDENTIAL_IV_BYTES
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) ENTERING: getDefaultProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) Property = ENCRYPT_SIM53_CREDENTIAL_IV_BYTES
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-10] (hpsim) No internal default property value found for DEFAULT_ENCRYPT_SIM53_CREDENTIAL_IV_BYTES
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getDefaultProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxPropertyFile-20] (hpsim) LEAVING: getProperty()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [CryptUtils-20] (hpsim) LEAVING: initCiphers()
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [Panic Logger-0] (hpsim) Given final block not properly padded
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [DecryptColumnRule-5] (hpsim) Given final block not properly padded
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxApplyTableRulesOnCsv-20] (hpsim) LEAVING: processMigTableRules(String tableNameStr, TableRule tableRule, String csvDir) throws Exception
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [Panic Logger-0] (hpsim) ERROR: Failed to process rule for Table Name: Credential
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxMigrationStatusUtil-20] (hpsim) ENTERING: updateFailedProductStatus for product hpsim Status :: javax.crypto.BadPaddingException: Given final block not properly padded

[asyed01]

Hi Shatra

Well how did you find the problem was with the credentials table? 

Did you try doing an mxexport before deleting the table and what error were you getting?

I see that you have deleted the credential database, was it using the sql management studio ?

Now the below error output which you have pasted, was it from the log file or from the mxexport output failure.

I see this a bit of complex situation at the moment.

[shatra]

Hi asyed01 

Well how did you find the problem was with the credentials table? 

1-19 12:13:29,139 INFO  [HPSIM_DEBUG] [Panic Logger-0] (hpsim) Given final block not properly padded
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [DecryptColumnRule-5] (hpsim) Given final block not properly padded
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [MxApplyTableRulesOnCsv-20] (hpsim) LEAVING: processMigTableRules(String tableNameStr, TableRule tableRule, String csvDir) throws Exception
2018-11-19 12:13:29,139 INFO  [HPSIM_DEBUG] [Panic Logger-0] (hpsim) ERROR: Failed to process rule for Table Name: Credential

Did you try doing an mxexport before deleting the table and what error were you getting?

Migration Failed.Error while packing HPE System Insight Manager migration files

DMTStatus.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<MigrationStatus name="EXPORT" status="false" statusMsg="&#xA;Migration Failed.Error while packing HPE System Insight Manager migration files.">
    <Product name="hpsim" status="false" statusMsg="javax.crypto.BadPaddingException: Given final block not properly padded"/>
</MigrationStatus>

I see that you have deleted the credential database, was it using the sql management studio ?

Yes

Error outputs are grabbed from migration_log4j.log

[asyed01]

Hi Shatra

You can try uploading the log file along with simcapture here.

Also if you could show the steps you initially performed to perform the mxexport. I just have a feeling that might be ending up redoing a fresh installation becuase from the errors I dont think we can get this back and up.