Issue Description:

There may be cases where customer is applying replication over ephesoft & report database for database backup. However there are issues observed in reporting where the reports are not synced due to replication applied on few tables.

 

Sample Error Log:

Couldn’t execute SQL: truncate table finished_batch_xml_data

Cannot truncate table ‘finished_batch_xml_data’ because it is published for replication or enabled for Change Data Capture.

 

Solution:

Below is the list of tables where replication should not be applied as truncations are being performed on these tables:

–Ephesoft–
No truncations are performed in the Ephesoft database.

–Reporting–
batch_per_batch_class
batch_per_priority
batch_per_priority_status
batch_count_per_priority_1
batch_count_per_status_1
finished_batch_xml_data
finished_batch_instance
modified_batch_instance
review_validate_backlog_dtls
batch_execution_data_advanced
modified_batch_instance_advanced
post_review_xml_details
global_data
field_details
last_plugin_per_module_advanced
batch_per_batch_class
batch_per_priority
batch_per_priority_status
last_execution

–Report_Archive(Added in ver. 4.0.6.0)–
batch_class
filter_columns_1

Was this article helpful to you?

Abhishek Jain

Comments are closed.