FDI BIP Connector - Run In Chunk Mode - Invalid parameters for BIP chunking error

Question

Hi,

I am trying to use the Run In Chunk Mode option in the BIP Connector configuration in FDI to handle a large BIP report (~4M rows).We have configured the following in the connection:

→ Run In Chunk Mode:  enabled

→ Chunk Days: 30

I get the following error when testing the connection:

oracle.apps.bi.extractservice.exception.DataExtractException:

Invalid parameters for BIP chunking - Internal Server Errororacle.apps.bi.extractservice.exception.DataExtractException:

Invalid parameters for BIP chunking - Internal Server Error

I have tried the following approaches in the BIP Data Model parameters:

* Parameters P_FROM_DATE / P_TO_DATE with values fromDate / toDate
* Single parameter lastUpdateDate with no parameters in connection config
* No parameters at all

None of these worked.

Questions:

* What exact parameter names are required in the BIP Data Model for Chunk Mode to work?
* What values should be set in the connection configuration Parameters field?
* Is there any documentation or example of a working Chunk Mode configuration?

Thank you!

RVohra · Answer

I believe chunk mode in FDI only works when the BIP Data Model uses specific date parameters that FDI can override dynamically. Can you try FROM_DATE and TO_DATE? Please make sure that it is used in the query.

Hope it helps!

Mallikarjuna Kuppauru-Oracle · Answer

Hi @ClaudiaManea Are you able to run the report from direct OAC with out any issue? can you confirm below options are enabled at DM & report level? Data Model editor —>Properties —> XML Data Chunking option is enabled Configure Report Properties * Edit the report and navigate to Report Properties > General tab. * Select Enable Chunking. Regards Arjun