Question
Mercedes Benz Mobility
DE
Last activity: 12 Jan 2023 14:54 EST
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536
Dear PEGA community,
We are facing below error in the absence of SYSADMIN database server role to account configured in data source:
An error occurred on executing the query for the report definition - There was a problem getting a list: code: 10314 SQLState: S00011 Message: An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:
System.IO.FileLoadException: Could not load file or assembly 'prreadstream, Version= Proprietary information hidden, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An error relating to security occurred. (Exception from HRESULT: 0x8013150A)
As per organizational standards, SYSADMIN role is not provided to any accounts. We need an alternative to solve this issue.
We have raised INC-223317 & INC-236601 SR to get the issue solved. Meanwhile, if any of you or your team encountered same issue and solved it and you can share the solution, it will be helpful.
PRPC V8.4.1 is hosted in IBM Websphere with SQL server
Thanks in advance,
S Ch Avinash
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 12 Jan 2023 14:54 EST
Pegasystems Inc.
GB
INC-223317 and INC-236601 were logged for issue: Display error 'Could not load file or assembly 'prreadstream' when execute query without sys admin access
Root cause description:
Sysadmin is required to execute this report as Sysadmin will have access to predefined/internal classes( not just RD class) which are required to execute the report
Solution description:
Sysadmin is required to execute this report as Sysadmin will have access to predefined/internal classes( not just RD class) which are required to execute the report. In both scenarios we need sysadmin access .
When you search "An error occurred in the Microsoft .NET Framework while trying to load assembly" online, there are many results with the same exception, i.e.
Please check if those solutions can help or not. From all of the search results it can be seen it is DB platform/deployment issue.
- CLR (Common Language Runtime) should be enabled.
- The user role by Pega is correct.
Accepted Solution
Updated: 12 Jan 2023 14:54 EST
Pegasystems Inc.
GB
INC-223317 and INC-236601 were logged for issue: Display error 'Could not load file or assembly 'prreadstream' when execute query without sys admin access
Root cause description:
Sysadmin is required to execute this report as Sysadmin will have access to predefined/internal classes( not just RD class) which are required to execute the report
Solution description:
Sysadmin is required to execute this report as Sysadmin will have access to predefined/internal classes( not just RD class) which are required to execute the report. In both scenarios we need sysadmin access .
When you search "An error occurred in the Microsoft .NET Framework while trying to load assembly" online, there are many results with the same exception, i.e.
Please check if those solutions can help or not. From all of the search results it can be seen it is DB platform/deployment issue.
- CLR (Common Language Runtime) should be enabled.
- The user role by Pega is correct.