Question
HCL Technologies
IN
Last activity: 9 Jul 2025 21:03 EDT
code: 10314 SQLState: S0011 Message: An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536.
We are encountering the below error when tried to execute the RD (SQL query pasted below). It's working after removed few of the columns like "pxRefObjectPageName". Tried to execute the same query directly in the DB still failing. So, kindly guide us how to mitigate this issue.
We are encountering the below error when tried to execute the RD (SQL query pasted below). It's working after removed few of the columns like "pxRefObjectPageName". Tried to execute the same query directly in the DB still failing. So, kindly guide us how to mitigate this issue.
SQL: SELECT "PC0"."pxUrgencyAssign" AS "pxUrgencyAssign" , "PC0"."pxRefObjectInsName" AS "pxRefObjectInsName" , "PC0"."pyLabel" AS "pyLabel" , "PC0"."pyAssignmentStatus" AS "pyAssignmentStatus" , "PC0"."pyInstructions" AS "pyInstructions" , "PC0"."pxAssignedOperatorID" AS "pxAssignedOperatorID" , "PC0"."pyAssignmentStatus" AS "pyAssignmentStatus" , "PC0"."pxDeadlineTime" AS "pxDeadlineTime" , "PC0"."pxAssignedOperatorID" AS "pxAssignedOperatorID" , "PC0"."pxUpdateOperator" AS "pxUpdateOperator" , "PC0"."pxUpdateDateTime" AS "pxUpdateDateTime" , "PC0"."pxGoalTime" AS "pxGoalTime" , "PC0"."pxCreateDateTime" AS "pxCreateDateTime" , "PC0"."pxTaskLabel" AS "pxTaskLabel" , "PC0"."pxRefObjectClass" AS "pxRefObjectClass" , "PC0"."pxRefObjectKey" AS "pxRefObjectKey" , "PC0"."pxCreateOperator" AS "pxCreateOperator" , "Sub"."pyStatusWork" AS "pyStatusWork" , "Sub"."Workflow" AS "Workflow" , pegadata.pr_read_from_stream('.pxRefObjectPageName', "PC0".pzInsKey, "PC0".pzPVStream) AS "pxRefObjectPageName" , "PC0"."pzInsKey" AS "pzInsKey" FROM pegadata.pc_assign_workbasket "PC0" INNER JOIN pegadata.pc_EC_ESS_Work "Sub" ON ( ( ( ( "Sub"."pzInsKey" = "PC0"."pxRefObjectKey" AND "Sub"."pxObjClass" LIKE ? ) AND "PC0"."pxObjClass" = ? ) ) ) WHERE ( "PC0"."pxApplication" = ? ) ORDER BY 13 DESC, 1 DESC, 8 ASC
Error: An error occured on executing the query for the report definition - There was a problem getting a list: code: 10314 SQLState: S0011 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) System.IO.FileLoadException: at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString) DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: 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) System.IO.FileLoadException: at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString) | SQL Code: 10314 | SQL State: S0011
HCA Healthcare
US
We are getting this error because SQL Server is trying to use a .NET assembly (ID 65536), but it is either broken or missing. This happens when certain columns in the Report Definition (like "pxRefObjectPageName") internally rely on this assembly. Removing such columns avoids the issue. To fix it, check if CLR is enabled in SQL Server and if the assembly is correctly loaded. You can run a query to see details of the assembly and ask the DBA to drop and re-create it if needed. As a workaround, remove or avoid the columns causing the error.