STATUS_MARKED_ROLLBACK in export

STATUS_MARKED_ROLLBACK in export

Issue: STATUS_MARKED_ROLLBACK in export
Steps to fix:
i) For postgres Database, download attachment<StatusMarkedRollback.txt> and rename file extension to .bat.
1. Copy patch statusMarkedRollback.bat to <ELA-HOME>\pgsql\bin folder.
2. Open Command prompt from above folder and run StatusMarkedRollback.bat file.
3. An output similar to "update <number>" should appear.
4. Stop Eventlog service.
5. Start Eventlog service after service stops.
6. Now export should work well.
ii) For other Database, run Query:
  1. update scheduled_task set transaction_time=-1 from exportscheduleconfigurations where scheduled_task.schedule_id=exportscheduleconfigurations.schedule_id and exportscheduleconfigurations.table_name='ADS_SCHEDULED_REPORTS_TABLE';

                  New to ADSelfService Plus?

                    • Related Articles

                    • What to do if the IIS Site status shows "Failed"?

                      Troubleshooting: Open the server out log file and search for the exception following the line "New Import File Arrived". a. Exception: "File not found" Probable cause(s) and troubleshooting step(s): Log file was not created for the particular day. ...
                    • Windows device status: RPC server is unavailable

                      The RPC server is unavailable error will be displayed in the device status field if there isn’t any communication between the EventLog Analyzer server and the respective machine from which the logs should be collected. This lack of communication ...
                    • Windows device status: Access denied

                      The Access denied error indicates that the user account dedicated for log collection does not have the necessary access and permissions to collect logs from the respective devices. There are two approaches to fixing the error: Using a domain admin ...
                    • What to do if the IIS Configuration logs are not collected?

                      Ensure that the configuration log status column is success. If not, click on "Configure" and configure it. Check whether the configured device is enabled. If not, enable the device. Check whether "Microsoft-IIS-Configuration/Operational" is enabled ...
                    • Offline Logs Management

                      How to: change the Archive (Offline Logs) Location - Applicable for Builds <= 12203 Log on to the EventLog Analyzer UI. Go to Settings Tab ⇾ Admin settings ⇾ Manage Archives ⇾ Settings (right-top corner) Update the new Archive location ⇾ click on ...