web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error invalid paramete...
Microsoft Dynamics AX (Archived)

Error invalid parameters when Generate Sample File Product DIXF

(0) ShareShare
ReportReport
Posted on by pearl_jo 640

Dear all,

I am using AX 2012 R3 Cumulative Update 12.

I want to generate sample file for "Product" entity, but I got error like below.

Error executing code: SysExcelRange (object), method construct called with invalid parameters.

Stack trace

(C)\Classes\SysExcelRange\construct
(C)\Classes\SysExcelWorksheet\columns - line 3
(C)\Classes\SysExcelWorksheetHelper\autoFitColumns - line 13
(C)\Forms\DMFXMLWizard\Methods\excelFileGeneration - line 23
(C)\Forms\DMFXMLWizard\Designs\DesignList\GenerateCSV\Methods\Clicked - line 21

Steps :

1. In "Data import export framework", click "processing group"

2. Click "New" > fill with "Product"

3. Click "Entities"

4. In "Entity", fill with "Product"

5. In "Source data format", fill with "Excel"

6. Click "Generate Source File"

7. Click "Next"

8. Check all fields

9. Click "Generate sample file" (in this step, I got error like above)

Please help. Thanks in advance.

Thank you.

Best regards,

Johanna 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,796 User Group Leader on at

    Hi Pearl,

    Is this a standard AX system or has customization in it? Make sure the application is compiled and CIL is generated without any errors.

  • pearl_jo Profile Picture
    pearl_jo 640 on at

    Dear Faisal,

    Thank you for your response.

    This is standard AX system.

    Application is compiled and CIL is generated without any errors.

    Best regards,

    Johanna

  • Suggested answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,796 User Group Leader on at

    I just tried with minimal set of fields (In your step 8 I haven't selected all fields) and I did work for me in standard AX. Can you please try with selection of few fields first?

  • pearl_jo Profile Picture
    pearl_jo 640 on at

    Dear Faisal,

    Thank you for trying the scenario.

    If I just select  few fields (100 fields), there is no error when generate sample file.

    If I select all fields (319 fields), there is error like above.

    Is it the limitations of AX 2012 R3?

    Best regards,

    Johanna

  • Suggested answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,796 User Group Leader on at

    Hi,

    Are you really going to use all 319 fields? I dont think so that would be the case so please share your business requirement or use it realistically.

  • pearl_jo Profile Picture
    pearl_jo 640 on at

    You are right, Faisal. I am not going to use all 319 fields. :p

    I just want to try it and I got that error.  :D

    I am curious whether there is limitation when we generate sample file in DIXF.

    Why there is error when we generate sample file for all fields?

    The output file is xls, isn't it? So, does it means that we can only export 256 fields?

    Why the output file is not xlsx? :D

    Best regards,

    Johanna

  • Verified answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,796 User Group Leader on at

    If you are not going to use all 319 fields then select those which you would use please.

    I am not sure about any limitation here. Xls and Xlsx file extension is depend on which version of excel is installed on your machine. For me I am on office 2016 and getting data exported into an excel file with extension .xlsx. You might be on older version. However, this does not limit fields I wonder.

    Please verify answer if it helps you.

  • Verified answer
    pearl_jo Profile Picture
    pearl_jo 640 on at

    Dear Faisal,

    Thank you for your concern.

    I am using Office 2013.

    I need to change code in "excelFileGeneration" method in "DMFWizard" form so AX will generate sample file in xlsx extension.

    ...

    sysExcelHelper.launchExcel();

    //closed by me sysExcelHelper.save(dmfDefinitionGroupEntityXMLFields.Entity);

    sysExcelHelper.save(dmfDefinitionGroupEntityXMLFields.Entity + '.xlsx'); //added by me

    ...

    I don't know whether is it alright to do this change. But, Now I can generate sample file for 319 fields in xlsx file. :)

    It is strange to know in "version" method in "SysExcelApplication" class, there is no applicationVersion handling for Office2013 (15) and Office2016 (16) as follow.

    public MSOfficeVersion version()

    {

       MSOfficeVersion   ret;

       ;

       switch (applicationVersion)

       {

           case 10.0:

               ret = MSOfficeVersion::OfficeXP;

               break;

           case 12.0:

               ret = MSOfficeVersion::Office2007;

               break;

           default:

               ret = MSOfficeVersion::Office2000;

       }

       return ret;

    }

    Best regards,

    Johanna

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans