Applies to Product - FnO Platform
What’s happening?
The customer is unable to remove a data entity from the BYOD export jobs, experiencing significant delays and error messages during the process.
Reason:
The underlying cause of this is identified as the presence of a large amount of data in the table associated with the data entity, specifically the table VENDINVOICEJOURSTAGING_ECL, which contains a substantial number of rows and has a size of 10 GB. This large volume of data is causing slowness when attempting to remove the entity.
Resolution:
- Instruct the customer to refresh the entity list by navigating to Data management workspace > Framework parameters > Entity setting > Refresh entity list button.
- Truncate the staging table VENDINVOICEJOURSTAGING_ECL from Data management could help in improving the performance of the BYOD export.
- Make sure there is no other jobs running against the staging table during Truncate.
- Review any customizations that causing delay of the export jobs.
- Review the Tier of the Target BYOD SQL database. The target DB needs to be in higher tier to handle the amount of the data that is being exported.