Today I got a mail from one of my team member with the following error. It will comes when user try to import data from excel. (SysDataImportExcel)
If we comment following line of code it will execute without error. And also if we debug the code it will execute without any error.
can someone help to resolve this issue...
Open AOT and compile the class SysDataImportExcel Class also check correct version of MS Excel has been installed.
yes. We did it earlier. This error comes only for one company.
I experienced another weird behaviour of progress bar in excel import. Normally there should be two bars but the second which provides progress on records in actual table is not visible. It's annoying when you can't see the progress especially if importing large data.
I found the reason. The progress bar form is created on calling the incCount for the first time. All the bars that have at this moment total equal to zero are set invisible! And this is indeed what occurs in the class SysDataImportDefBase, the totals for the second bar set only after the incCount for the first bar is called. Therefore the workaround is to set for all the bars the total greater then zero (or alt. change the code in class SysOperationProgressForm to not set bars invisible).
Have fun with AX!