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

                      • 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 ...
                      • 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: 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 ...
                      • Time delay in exporting reports

                        One of the main reasons for delay in report exports is the large volume of report entries. To reduce the report export time, we recommend you generate and export only the information needed. Select the exact time period and columns that are required ...
                      • 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 ...