Microsoft Dynamics AX (Archived)

DIXF: when is executed postGetStagingData()?

(0) Share

Report

Posted on by Arkadia2

427

Greetings,

We are using AX 2012 r3 cu8.

I created a custom entity with DIXF.

I want to add some advance filtering on the staging data extracted from AX to reduce the number of rows exported to a csv files. The standard AX filtering applied to the query is not sufficient.

My understanding was to override the postGetStagingData() method on my custom entity class; it is supposed to be executed after the execution of the SSIS package.

Well, this method does not seem to be called. Or more probably... my understanding is wrong! :)

Or one needs to do more than overriding the method; i.e. something else must be changed/coded in another object (entity table? entity query?)

Regards,

Eric

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Mea_ 60,284 on at

Like (0)

Report

Hi Eric Lepage,

It is called by DMFGenerateSSISPackage.generateStagingData() method, you can find next line

DictClass.callObject(methodStr(DMFEntityBase,postGetStagingData), entityClass, _dmfDefinitionGroupExecution)

and put breakpoint there to see if it it gets executed, it should be last step after SSIS import data to staging table.

Was this reply helpful? Yes No
Arkadia2 427 on at

Like (0)

Report

Hello ievgen,

Thanks for the reply.

Yeah, I did set a breakpoint, at the very beginning of DMFGenerateSSISPackage::generateStagingData() to be sure that I would trap the method being called. But it is not called. Which is what lead me to think my assumptions were wrong about postGetStagingData() usage.

Maybe it is not called when using this function in processing group:

1) Select the group and choose Get staging data

2) use the Select button to apply some filters then run the job, not in batch of course.

Information is surprisingly sparse on DIXF if one wants to use customize entity.

Well, if you have other ideas, please let me know.

Regards,

Eric

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Do you have "Execute Business Operation In CIL" disabled in user parameters ?

Was this reply helpful? Yes No
Arkadia2 427 on at

Like (0)

Report

Yes, it is disabled.

Was this reply helpful? Yes No
Arkadia2 427 on at

Like (0)

Report

I'm pulling data from AX to write it to staging. It does not seem to allow postProcessing to filter data extracted. I am looking atDMFStagingWriter::execute(), around line 293:

if (definitionGroupExecution.FilePath || definitionGroupExecution.QueryForODBC)

{

[recCountCon, errorCountCon, entityCon, exceptionFound,stagingLogRecId] = DMFGenerateSSISPackage::generateStagingData(definitionGroupExecution, dmfEntity.EntityType, _batchId, _runOnService);

}

There is no filepath when coming from AX as far as I can see.

If anyone has an idea how I could write some advanced filtering when creating staging data from AX, I'm open to suggestions! :)

Regards,

Eric

Was this reply helpful? Yes No
Arkadia2 427 on at

Like (0)

Report

In this thread:

community.dynamics.com/.../237965

The original poster seems to have succeeded in implementing the getpostProcessingData, but he is reading in data from a CSV file.

Was this reply helpful? Yes No
Verified answer

Arkadia2 427 on at

Like (1)

Report

I think I *may* have found a way to postprocess the data. I will test it furthermore and try heavier data load.

In my custom entity class, I override the copyTargetToStaging() method. At this point, the staging has been loaded in the entity table and the entityId is provided as one of the parameter. So it is possible to write more advanced clean-up code in there.

I'll come back to this thread later on... but of course if anyone sees a reason NOT TO perform data clean-up in copyTargetToStaging(), please let me know! :)

Regards,

Eric

Was this reply helpful? Yes No