question

PengxinFan-7045 avatar image
1 Vote"
PengxinFan-7045 asked OrejudoAgustin-7923 commented

SSRS 2019 failed to Generate Reports after installed to Windows Server 2019

Hello,

I have got a problem to generate SSRS reports from SSRS 2019 on Windows Server 2019, but it starts to work after installed SSRS 2019 to Windows Server 2016.

Here is the exception messages:
[2021-01-19 12:26:23Z] [ERR] Report generation task threw an exception
Message = This operation is not supported on a report server that runs in native mode. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: This operation is not supported on a report server that runs in native mode.
Source = System.Private.ServiceModel
Stacktrace = at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
at System.ServiceModel.Channels.ServiceChannelProxy.TaskCreator.<>c_DisplayClass1_0.<CreateGenericTask>b_0(IAsyncResult asyncResult)
--- End of stack trace from previous location where exception was thrown ---
at UserInterfaceBusinessObject.BusinessObjects.ReportingBackgroundTasks.SsrsReportBuilder.BuildSummaryReport(ReportExecutionServiceSoap reportingService, IReportRequestParameters request, String clientUiCulture) in E:\Jenkins\workspace-UiApiService-V3-CI\svn\UiApiService\UserInterfaceBusinessObject\BusinessObjects\ReportingBackgroundTasks\SsrsReportBuilder.cs:line 181
at UserInterfaceBusinessObject.BusinessObjects.ReportingBackgroundTasks.SsrsReportBuilder.CreateClinicalDataReport(String reportDirPath, String reportFilePathAndName, IReportRequestParameters request, String clientUiCulture, CancellationToken token) in E:\Jenkins\workspace-UiApiService-V3-CI\svn\UiApiService\UserInterfaceBusinessObject\BusinessObjects\ReportingBackgroundTasks\SsrsReportBuilder.cs:line 136

Many thanks,

sql-server-reporting-serviceswindows-server-2019
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Any solution for this thread? I am facing exactly same issue with SSRS 2019 + SQL 2019

0 Votes 0 ·
PengxinFan-7045 avatar image
0 Votes"
PengxinFan-7045 answered

NOTE: The SSRS reports are generated programmtically throught API call.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

visakh16 avatar image
0 Votes"
visakh16 answered

The error message says
This operation is not supported on a report server that runs in native mode
May I know what type of report you're trying to generate? Does it have any unsupported features being used?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PengxinFan-7045 avatar image
1 Vote"
PengxinFan-7045 answered PengxinFan-7045 edited

Hi @visakh16,

Thanks for your reply. They are rdl reports. These reports are developed from VS2012 SSDT, which have been used many years.

They have been programmatically deployed to SSRS 2016, SSRS 2017, SSRS 2019, but all OS are Windows Server 2016 downward.

The issue is only occurring after installed SSRS 2017 or SSRS 2019 to Windows Server 2019.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @PengxinFan-7045,

Could you please help check below:

Create a simple report with VS or Report Builder.

Deploy the report directly to the report server with Windows Server 2019 to see if it could succeed or not.

If failed you may also show the error message to us.

In addition, here is the hardware and software requirements for SSRS2017 and later, just for reference.

hardware-and-software-requirements-for-installing-sql-server

Regards,
Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YanLisa-1481 avatar image
0 Votes"
YanLisa-1481 answered OrejudoAgustin-7923 commented

Hello,

We encountered the exact issue when we upgrade the reports to SQL2019 + Windows2019.

The report is able to be generated directly through SSRS browser view, but not through the web service call: ReportExecution2005.asmx.

Any solution?

Thanks,
Lisa

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

If you are using NTLM authentication and passing trustedHeader as an argument on any native method (LoadReport, SetParameters, Execute, etc), just set trustedHeader = null. This worked for me.
Seems trustedHeader is not neccesary when using NTLM on the ExecutionService.

Best regards,

Agu

1 Vote 1 ·