SSRS GetParameters() returns empty string/ null.

Ram PS 0

SSRS report when requested for parameter columns using GetParameters() method returns empty string. This is inconsistently causing application errors. Looking for some help.

We are invoking the below method within our PowerBuilder code by connecting to the library file.

Below is the code we try to invoke the method GetParameters. This gives the blank xml string...

User's image

Below is the definition from vb of the method GetParameters()

User's image

1 answer

Jiachen Li-MSFT 32,961 Reputation points Microsoft Vendor

2024-12-11T09:30:20.4433333+00:00

Hi @Ram PS ,

Ensure that all parameters are correctly defined in your SSRS report.

Check the PowerBuilder code that invokes the GetParameters() method. Ensure that the method is being called correctly and that any necessary parameters are being passed.

Best Regards.

Jiachen Li

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 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.
Please sign in to rate this answer.
Ram PS 0 Reputation points

2024-12-11T09:43:31.5666667+00:00

Hi @Jiachen Li-MSFT

Thank you for your kind response. If you look at the method at .NET it does not take any input parameters. Also., the Powerbuilder code invokes the same. Intermittently the library fails to return value. The same method works most of the time. We are not sure if that could be a permission issue or connectivity issue. Not sure how to do more trace on this. We also verified on services logs and databases logs too. Still missing something.

Jiachen Li-MSFT 32,961 Reputation points Microsoft Vendor

2024-12-11T10:02:12.7266667+00:00

Hi @Ram PS ,

For the possibility of connectivity problems, you can consider monitoring the network traffic between your application and the SSRS server. Tools like Wireshark can help you capture and analyze network packets to identify any connectivity problems.

Sometimes, intermittent issues can be caused by temporary permission problems. Double-check the permissions for the user account that is running the PowerBuilder application. Ensure that this account has the necessary permissions to access the SSRS server and retrieve parameters.

Ram PS 0 Reputation points

2024-12-11T10:28:09.2666667+00:00

Sure., Thank you.

Can I ask for, any typical log from SSRS server from where i can see the incoming requests and their failures?

right now i am monitoring from below folder:

Should i enable any trace element so that it gets created in this file. I mean the events.

Is there any way i can trace remotely the COM libraries that are connecting to SSRS pages.

Jiachen Li-MSFT 32,961 Reputation points Microsoft Vendor

2024-12-12T07:06:00.6533333+00:00

ReportingServicesService_*.log: This log captures detailed information about server-side activities, including incoming requests, their processing, and errors. Look for entries related to the status of requests and error messages.

RSHostingService_*.log: Logs related to the SSRS hosting service, which may include details about web service operations and any hosting-related errors.

To capture more granular details, such as specific incoming requests and their statuses, you may need to enable verbose logging or tracing in SSRS.

To trace the COM library, you can use the WMI provider to monitor and log the interactions between the COM library and the SSRS pages. This involves setting up event listeners and logging mechanisms to capture the relevant data. You can use the MSReportServer_ConfigurationSetting class to access and log the necessary information. Check Access the WMI Provider programmatically.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSRS GetParameters() returns empty string/ null.

1 answer

Your answer