Import custom data into AX 2012 R3 with DIXF/DMF tool

(0) Share

Report

Posted on by Mark88

Hi all,

I'm trying to import a basic custom table I created in AX 2009 into AX 2012 R3. I've recreated the table with the identical fields in the AOT in 2012, now I want to get the data there. I followed the steps in an MS video to create the custom entity and map the fields, everything seems to go well. I connected directly to the table through SQL (since the 2009 version of the table is there) and I can preview all the data just fine. I can also stage the data, however, when I try to copy to target I get the stack trace error below:

SysDictIndex object not initialized.

Stack trace

(C)\Classes\DMFEntityWriter\write - line 135
(S)\Classes\DMFEntityWriter\runOnServerWriter - line 47
(C)\Classes\DMFEntityWriter\run - line 110
(C)\Classes\DMFEntityWriter\main - line 24
(C)\Classes\xMenuFunction\run
(C)\Classes\MenuFunction\run - line 85
(C)\Forms\DMFWriteData\Designs\DesignList\DMFEntityWriterBatch\Methods\Clicked

Line 135 in the DMFEntityWriter\write method is:

noOfFields = keyIndexTable.numberOfFields();

I also get errors when I try to validate the fields in Staging in the validateFields methods. I couldn't find much on this error, so any help or pointers would be great!

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Martin Dráb 237,693 Most Valuable Professional on at

Like (0)

Report

RE: Import custom data into AX 2012 R3 with DIXF/DMF tool

Does your target table have primary index? If not, please create it.

Was this reply helpful? Yes No
Mark88 on at

Like (0)

Report

RE: Import custom data into AX 2012 R3 with DIXF/DMF tool

Hi Martin, thanks so much for the reply. There was no primary index specified on the target table. I created one for the ItemID and also there was an index for the RecId. I've tried using both as primary indexes, but I got the same error when trying to copy data to target, but I think this on the right track...any other ideas?

The staging table should already have the correct properties generated I assume since there were no errors during staging.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,721 Super User 2025 Season 2 on at

Like (0)

Report

RE: Import custom data into AX 2012 R3 with DIXF/DMF tool

Hi Mark,

Did you use the wizard to create the staging table, helper class and target query?

Does your base table have some indexes or only a RecId (SurrogateID) index?

Was this reply helpful? Yes No
Mark88 on at

Like (0)

Report

RE: Import custom data into AX 2012 R3 with DIXF/DMF tool

Hi Andre,

Yes, I used the wizard to generate everything.

Initially my target table only had: 1 index - "Index1" (which was based on the RecID field), but this index was not set as the PrimaryIndex on the table. I created another index for the ItemID field and set that to the primary index. The copy to target still failed.

Here are some more stack trace error I get when I attempt to validate the staging data:

Stack trace: The method has been called with an invalid number of parameters.

Stack trace

(S)\Data Dictionary\Tables\DMFDC_CustomEntity\Methods\validateField (S)\Classes\DMFCheckField\validateFieldValues - line 114 (S)\Classes\DMFCheckField\validateRecordsServer - line 81 (C)\Classes\DMFCheckField\validateRecords - line 24 (C)\Classes\DMFCheckField\main - line 25 (C)\Classes\FormFunctionButtonControl\Clicked

Was this reply helpful? Yes No
Mark88 on at

Like (1)

Report

RE: Import custom data into AX 2012 R3 with DIXF/DMF tool

Hey guys,

I finally solved the issue. I had to delete the custom entity and recreate it from the custom table with the new properties configured, which included the primary index on the ItemID field. It creates the staging table/target entity with the same properties applied, modeled after the target.

Thanks a ton for the help!

Was this reply helpful? Yes No