axapta - Try/Catch does not work on conversion error, while importing data from excel in X++

Question

I am trying to import data from excel to my journal, but if there is a conversion error, it just blocks my journal. I want to make try/catch exception, but it does not work.

My code looks like this:

try
{
    [My insert code]
}
catch (Exception::Error)
{                    
    throw error("error here");
}

Error looks like this:

Error executing code: Wrong type of argument for conversion function.

And first suggestion probably will be "Fix the conversion code", but it wouldnt resolve my problem... Does anyone know why my catch block does not see that error?
I tried to find exception for conversion errors, but there is like 0 information about it on internet.

question from:https://stackoverflow.com/questions/65881633/try-catch-does-not-work-on-conversion-error-while-importing-data-from-excel-in

Answer 1

Try without this (Exception::Error) because it is probably that your code does not give an Error exception.

try
{
    [My insert code]
}
catch
{                    
    throw error("error here");
}