Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Has the externalise export file path behaviour changed in v12?

Stephen ThompsonNov 6 2019 — edited Nov 6 2019

We have a screening job that is called from a .bat file.  In the .bat file we provide an override string to override the location of an export so that our file is written out to a sub-folder of landingarea.  In v11 this was successfully writing out a .jmp file to our landingarea/Customer/Batch/ExportToHub folder.  In v12, with no other apparent changes, the export now writes out straight into landingarea and not the sub-folder..

The default data store used in the export is defined as Customer/Batch/ExportToHub/entities.jmp

The override string we use in the .bat file is -D phase.*.export.CUST_Entity_FilteredExport.file_in_server_work_area=\%OutputEnt%  where %OutputEnt% is just the filename of the .jmp file, with no path provided.

The folder security permissions all look to be correct.  Is it possible the behaviour of the externalised exports and data stores has changed at all from v11 to v12?

(We can of course use a workaround and prefix the variable with a hard-coded path in the .bat file, but that would mean changing multiple scripts.  We would rather understand why this is happening).

Comments

SureshM-Oracle

Are you triggering import via Batch or through manual process?

Does the process logs shows two ODI process that gets execute one after another?

What version of FDMEE are you in?

athlon007

Hello,

The import is triggered manually

The process logs shows different ODI process numbers.

FDMEE version 11.1.2.4.210

Thanks alot for helping

Roman

SureshM-Oracle

Is it a distributed environment? If yes, do you have multiple FDMEE servers?

I would advise to raise an SR with Oracle Support at this point in time to review your environment and provide you the solution.

athlon007
Answer

Hello,

In case somebody else runs into this issue it was the following:

Since Upgrading to Windows 10 our FDMEE import from a Staging table never stopped, it just kept reimporting after the validation step.

Solution was to amend the timeout setting in our Load Balance from 5min to 10min.

Hope this may help somebody else once.

Cheers

Marked as Answer by athlon007 · Sep 27 2020
1 - 4

Post Details

Added on Nov 6 2019
1 comment
125 views