Versión 1.8.4.4
Al momento de dar clic en mostrar expediente impreso no pudo ver la ventana emergente generada al tratar de levantar la vista (por cierto si existe), el elmah registra el siguiente error:
System.Data.SqlClient.SqlExceptionError grave en el comando actual. Los resultados, si los hay, se deben descartar. Error grave en el comando actual. Los resultados, si los hay, se deben descartar.
System.Web.HttpUnhandledException (0x80004005): Se produjo una excepción de tipo 'System.Web.HttpUnhandledException'. ---> System.Data.EntityCommandExecutionException: Se produjo un error al ejecutar la definición del comando. Vea la excepción interna para obtener detalles. ---> System.Data.SqlClient.SqlException: Error grave en el comando actual. Los resultados, si los hay, se deben descartar.
Error grave en el comando actual. Los resultados, si los hay, se deben descartar.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
en System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
en System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
en System.Data.SqlClient.SqlDataReader.get_MetaData()
en System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
en System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
en System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
en System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
en System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- Fin del seguimiento de la pila de la excepción interna ---
Al ejecutar la consulta del expediente impreso.
http://192.168.1.235/Evolution/Reports/MostrarExpedienteImpreso.aspx?codexp=3273
La instrucción select que se ejecuta es:
SELECT
[Extent1].[sex_categoria] AS [sex_categoria],
[Extent1].[sex_grupo] AS [sex_grupo],
[Extent1].[sex_codigo] AS [sex_codigo],
[Extent1].[sex_localization_key_nombre] AS [sex_localization_key_nombre],
[Extent1].[sex_controller_area] AS [sex_controller_area],
[Extent1].[sex_controller_name] AS [sex_controller_name],
[Extent1].[sex_controller_action_name] AS [sex_controller_action_name],
[Extent1].[sex_orden] AS [sex_orden],
[Extent1].[sex_es_grupo] AS [sex_es_grupo],
[Extent1].[sex_entidad_propertybag] AS [sex_entidad_propertybag],
[Extent1].[sex_muestra_propertybag] AS [sex_muestra_propertybag],
[Extent1].[sex_es_de_empleo] AS [sex_es_de_empleo],
[Extent1].[sex_es_modificable] AS [sex_es_modificable]
FROM (SELECT
[sex_secciones_expediente].[sex_categoria] AS [sex_categoria],
[sex_secciones_expediente].[sex_grupo] AS [sex_grupo],
[sex_secciones_expediente].[sex_codigo] AS [sex_codigo],
[sex_secciones_expediente].[sex_localization_key_nombre] AS [sex_localization_key_nombre],
[sex_secciones_expediente].[sex_controller_area] AS [sex_controller_area],
[sex_secciones_expediente].[sex_controller_name] AS [sex_controller_name],
[sex_secciones_expediente].[sex_controller_action_name] AS [sex_controller_action_name],
[sex_secciones_expediente].[sex_orden] AS [sex_orden],
[sex_secciones_expediente].[sex_es_grupo] AS [sex_es_grupo],
[sex_secciones_expediente].[sex_entidad_propertybag] AS [sex_entidad_propertybag],
[sex_secciones_expediente].[sex_muestra_propertybag] AS [sex_muestra_propertybag],
[sex_secciones_expediente].[sex_es_de_empleo] AS [sex_es_de_empleo],
[sex_secciones_expediente].[sex_es_modificable] AS [sex_es_modificable]
FROM [sec].[sex_secciones_expediente] AS [sex_secciones_expediente]) AS [Extent1]
WHERE ( EXISTS (SELECT
1 AS [C1]
FROM [sec].[pse_permisos_secc_expdiente] AS [Extent2]
WHERE ( EXISTS (SELECT
1 AS [C1]
FROM [sec].[rol_roles] AS [Extent3]
WHERE ( EXISTS (SELECT
1 AS [C1]
FROM [sec].[rus_roles_users] AS [Extent4]
INNER JOIN [sec].[usr_users] AS [Extent5] ON [Extent5].[usr_codigo] = [Extent4].[rus_codusr]
WHERE ([Extent3].[rol_id] = [Extent4].[rus_rol_id]) AND ([Extent5].[usr_username] = @p__linq__0)
)) AND ([Extent3].[rol_id] = [Extent2].[pse_codrol])
)) AND ([Extent2].[pse_es_permitido] = 1) AND ([Extent2].[pse_seccion] = [Extent1].[sex_codigo])
)) OR ([Extent1].[sex_es_grupo] = 1)
