While creating a report after a successful automated scan, the following error gets generated:

[6/18/2024 6:00:58 PM]: Report Failed System.Data.SqlClient.SqlException (0x80131904): Failed to load Msxmlsql.dll.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
Invalid object name '#temp'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at HP.AppSec.Reporting.DataProviders.ScanDataProvider.executeReader(SqlCommand command, CommandBehavior behavior)
at HP.AppSec.Reporting.DataProviders.ScanDataProvider.getReportDataBasic(IQuery queryDescriptor, Boolean topZeroFlag, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
at HP.AppSec.Reporting.DataProviders.ScanDataProvider.GetData(IQuery queryDescriptor, Boolean topZeroFlag, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
at HP.AppSec.Reporting.ReportDataSource.getReportData(IQuery queryDescriptor, Boolean topZeroFlag, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
at HP.AppSec.Reporting.ReportDescriptor.getReportRunInstance(ActiveReport3 clonedReport, ReportDescriptor mainReport)
at HP.AppSec.Reporting.ReportDescriptor.getLinkedReportRunInstance(ActiveReport3 clonedReport, ReportDescriptor parentReport, ReportDescriptor mainReport, Dictionary`2 dynamicMapping)
at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.handleLinkedSubReports(LinkedSubReportModel lsrm, Section sendingSection)
at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.handleActiveReportSubReports(SubReport sr, Section sendingSection)
at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.formatHandler(Object sender, EventArgs ea)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at DataDynamics.ActiveReports.Section.#7kf()
at DataDynamics.ActiveReports.Section.#Clf(ActiveReport3 report)
at #kyd.#TD.#1mf(Section section)
at #kyd.#TD.#Nqf()
at #kyd.#TD.#Iqf(Page newPage, Single left, Single top, Single right, Single bottom, UInt32 flags, UInt32& status)
at DataDynamics.ActiveReports.Section.#wlf(ActiveReport3 parentReport, #Oaf rData)
at #kyd.#Haf.#Ukf(Int32 pieceIndex)
at #kyd.#Haf.#Skf()
at #kyd.#Haf.#lW(Section section, Int32 insPos)
at #kyd.#Haf.#lW(Section section)
at #kyd.#TD.#Nqf()
at #kyd.#TD.#Iqf(Page newPage, Single left, Single top, Single right, Single bottom, UInt32 flags, UInt32& status)
at DataDynamics.ActiveReports.ActiveReport3.#Smf()
at DataDynamics.ActiveReports.ActiveReport3.Run(Boolean syncDocument)
at HP.AppSec.Reporting.ReportDescriptor.runReport(Boolean syncDocument)
ClientConnectionId:e4677fd4-0089-44df-ba80-2491cbf5a6bb
Error Number:6610,State:1,Class:16
[6/18/2024 6:00:58 PM]: Exception in Viewer doWork: Failed to load Msxmlsql.dll.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
Invalid object name '#temp'.
The statement has been terminated.

kindly guide us to proceed further.