You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can an EPM Agent AftExport Writeback Event Script return an error back to EPM Cloud Data Exchange?

edited Nov 6, 2024 12:02PM in Data Integration 3 comments

Summary:

We are using EPM Integration Agent to writeback data from FCCS and PBCS integrations to an on-prem database table and then run a script in the Agent AftExport event to process the data. If the data processing fails, the AftExport script returns an error but the Data Exchange integration started in FCCS or PBCS still reports success.

Content:

We have two EPM Agents: one connected to FCCS and the other connected to PBCS. The "data processing" is an FDMEE data load rule to load the data extracted from FCCS and PBCS into HFM. We use a Groovy script for the AftExport event of the EPM Agent to run the FDMEE data load rule, which may reasonably fail due to data validation errors. In case of an error, the Groovy script writes the error to the log (using agentAPI.logError) and sets the returnValue to false (we have also tried throwing an exception). This is correctly logged, but the process

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!