Can an EPM Agent AftExport Writeback Event Script return an error back to EPM Cloud Data Exchange?
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