topic Re: SYS,GENERAL_EXCEPTION,Input string was not in a correct format during MARTS Validation in Qlik Compose

SYS,GENERAL_EXCEPTION,Input string was not in a correct format during MARTS Validation

ubanerjee — Fri, 14 Mar 2025 20:49:07 GMT

In our Environment we have a master project and several other projects where developers make changes. For one of these projects I imported the Entity and Mapping changes from the UI. Validate worked for the DW and DM.

Next I exported the project CSVs and merged the DM changes from the Developer's project into the Master. There were changes to around 5 Facts and 6 Dimensions. The import completed successfully using the CLI.

Upon running validate Compose throws the following error in Master.

How should we go about debugging this issue? In the past I have tried to restore a backup and tried to bring one Dimension or fact at a time. Is that the ideal way or is there a way to query the sqllite db or json file to identify the root cause of this issue?

Re: SYS,GENERAL_EXCEPTION,Input string was not in a correct format during MARTS Validation

Adam_Herman — Wed, 09 Mar 2022 13:01:26 GMT

Hi @ubanerjee ,

I can confirm that you've raised a case for this issue back then, although, as per the case details, I'm not sure if you have managed to resolve this.

If you still need any further assistance in regards, then kindly raise a new incident for the same, attaching the previous one, so we can continue with our investigation.

Regards,

Adam

Re: SYS,GENERAL_EXCEPTION,Input string was not in a correct format during MARTS Validation

Nanda_Ravindra — Fri, 01 Apr 2022 14:17:19 GMT

Hello @ubanerjee,

Let me know if you still seeing this issue, and I'll happy to re-open the case for you and work towards getting a solution for this issue.

Thanks,

Nanda

Re: SYS,GENERAL_EXCEPTION,Input string was not in a correct format during MARTS Validation

ubanerjee — Mon, 11 Apr 2022 22:29:54 GMT

Hey @Nanda_Ravindra

This issue is closed now.