Buen día.
Se actualizó evolution de la 1.10.0.6 a 1.11.1.6, pero estoy experimentando problemas al momento de ingresar a la pantalla de ejecución de alertas, presenta el siguiente error:
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-00932: tipos de dato inconsistentes: se esperaba - se ha obtenido CLOB en OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) en OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF) en Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) en Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) en System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) en System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) en System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- Fin del seguimiento de la pila de la excepción interna --- en System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) en System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) en System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) en System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5() en System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) en System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() en System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() en System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) en System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) en Aseinfo.VH4.General.Controllers.AlertaController.GetAlertasAutorizadas(String nombreAlerta) en C: h4VH4GeneralControllersAlertaController.cs:línea 172 en lambda_method(Closure , ControllerBase , Object[] ) en System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) en System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) en System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) en System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) en System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) en System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d() en System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() en System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() en System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() en System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() en System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() en System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) en System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() en System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
Habilitando el profiler que tiene evolution, genera un query y el mismo lo ejecute en el esquema evoData de Oracle, devolviendo el mismo error, pero el problema de ese query está específicamente en el campo ALE_MENSAJE de la tabla CFG_ALE_ALERTAS. Si hago una consulta directamente a esa tabla me percató que no tiene ningún inconveniente, ¿a que se debe el problema y cual sería la solución?, éste es el query:
SELECT
"Distinct1"."ALE_CODIGO" AS "ALE_CODIGO",
"Distinct1"."ALE_TITULO" AS "ALE_TITULO",
"Distinct1"."ALE_DESCRIPCION" AS "ALE_DESCRIPCION",
"Distinct1"."ALE_FECHA_INI" AS "ALE_FECHA_INI",
"Distinct1"."ALE_FECHA_FIN" AS "ALE_FECHA_FIN",
"Distinct1"."ALE_ESTADO" AS "ALE_ESTADO",
"Distinct1"."ALE_NOMBRE_PROCEDIMIENTO" AS "ALE_NOMBRE_PROCEDIMIENTO",
"Distinct1"."ALE_TEXTO_RESUMEN" AS "ALE_TEXTO_RESUMEN",
"Distinct1"."ALE_ES_AUTOMATICA" AS "ALE_ES_AUTOMATICA",
"Distinct1"."ALE_EJECUTA_UNA_VEZ" AS "ALE_EJECUTA_UNA_VEZ",
"Distinct1"."ALE_CRON_EXPRESSION" AS "ALE_CRON_EXPRESSION",
"Distinct1"."ALE_DESC_PROGRAMACION" AS "ALE_DESC_PROGRAMACION",
"Distinct1"."ALE_FRECUENCIA" AS "ALE_FRECUENCIA",
"Distinct1"."ALE_MES_OCURRE_DIA_DEL_MES" AS "ALE_MES_OCURRE_DIA_DEL_MES",
"Distinct1"."ALE_OCURRE_CADA" AS "ALE_OCURRE_CADA",
"Distinct1"."ALE_DIA_DEL_MES" AS "ALE_DIA_DEL_MES",
"Distinct1"."ALE_DIA_DE_LA_SEMANA" AS "ALE_DIA_DE_LA_SEMANA",
"Distinct1"."ALE_SEMANA_DEL_MES" AS "ALE_SEMANA_DEL_MES",
"Distinct1"."ALE_DIAS_SEMANA_FLAG" AS "ALE_DIAS_SEMANA_FLAG",
"Distinct1"."ALE_MESES_ANIO_FLAG" AS "ALE_MESES_ANIO_FLAG",
"Distinct1"."ALE_OCURRE_UNA_VEZ_AL_DIA" AS "ALE_OCURRE_UNA_VEZ_AL_DIA",
"Distinct1"."ALE_OCURRE_A_ESTA_HORA" AS "ALE_OCURRE_A_ESTA_HORA",
"Distinct1"."ALE_OCURRE_CADA_HORAS_MINS" AS "ALE_OCURRE_CADA_HORAS_MINS",
"Distinct1"."ALE_SON_HORAS" AS "ALE_SON_HORAS",
"Distinct1"."ALE_OCURRE_HORA_INCIO" AS "ALE_OCURRE_HORA_INCIO",
"Distinct1"."ALE_OCURRE_HORA_FINAL" AS "ALE_OCURRE_HORA_FINAL",
"Distinct1"."ALE_USUARIO_GRABACION" AS "ALE_USUARIO_GRABACION",
"Distinct1"."ALE_FECHA_GRABACION" AS "ALE_FECHA_GRABACION",
"Distinct1"."ALE_USUARIO_MODIFICACION" AS "ALE_USUARIO_MODIFICACION",
"Distinct1"."ALE_FECHA_MODIFICACION" AS "ALE_FECHA_MODIFICACION",
"Distinct1"."ALE_MENSAJE" AS "ALE_MENSAJE",
"Distinct1"."ALE_DATA_DESTINATARIO" AS "ALE_DATA_DESTINATARIO",
"Distinct1"."ALE_ASOC_DESTINATARIOS" AS "ALE_ASOC_DESTINATARIOS",
"Distinct1"."ALE_TIPO" AS "ALE_TIPO",
"Distinct1"."ALE_TIPO_REPORTE" AS "ALE_TIPO_REPORTE",
"Distinct1"."ALE_CODREP" AS "ALE_CODREP",
"Distinct1"."ALE_CODWRD" AS "ALE_CODWRD",
"Distinct1"."ALE_CODREP_EXCEL" AS "ALE_CODREP_EXCEL",
"Distinct1"."ALE_PROGRA_AVANZADA" AS "ALE_PROGRA_AVANZADA"
FROM ( SELECT DISTINCT
"Join1"."ALE_CODIGO" AS "ALE_CODIGO",
"Join1"."ALE_TITULO" AS "ALE_TITULO",
"Join1"."ALE_DESCRIPCION" AS "ALE_DESCRIPCION",
"Join1"."ALE_MENSAJE" AS "ALE_MENSAJE",
"Join1"."ALE_FECHA_INI" AS "ALE_FECHA_INI",
"Join1"."ALE_FECHA_FIN" AS "ALE_FECHA_FIN",
"Join1"."ALE_TIPO" AS "ALE_TIPO",
"Join1"."ALE_TIPO_REPORTE" AS "ALE_TIPO_REPORTE",
"Join1"."ALE_CODREP" AS "ALE_CODREP",
"Join1"."ALE_CODWRD" AS "ALE_CODWRD",
"Join1"."ALE_CODREP_EXCEL" AS "ALE_CODREP_EXCEL",
"Join1"."ALE_ESTADO" AS "ALE_ESTADO",
"Join1"."ALE_ASOC_DESTINATARIOS" AS "ALE_ASOC_DESTINATARIOS",
"Join1"."ALE_NOMBRE_PROCEDIMIENTO" AS "ALE_NOMBRE_PROCEDIMIENTO",
"Join1"."ALE_DATA_DESTINATARIO" AS "ALE_DATA_DESTINATARIO",
"Join1"."ALE_TEXTO_RESUMEN" AS "ALE_TEXTO_RESUMEN",
"Join1"."ALE_ES_AUTOMATICA" AS "ALE_ES_AUTOMATICA",
"Join1"."ALE_PROGRA_AVANZADA" AS "ALE_PROGRA_AVANZADA",
"Join1"."ALE_EJECUTA_UNA_VEZ" AS "ALE_EJECUTA_UNA_VEZ",
"Join1"."ALE_CRON_EXPRESSION" AS "ALE_CRON_EXPRESSION",
"Join1"."ALE_DESC_PROGRAMACION" AS "ALE_DESC_PROGRAMACION",
"Join1"."ALE_FRECUENCIA" AS "ALE_FRECUENCIA",
"Join1"."ALE_MES_OCURRE_DIA_DEL_MES" AS "ALE_MES_OCURRE_DIA_DEL_MES",
"Join1"."ALE_OCURRE_CADA" AS "ALE_OCURRE_CADA",
"Join1"."ALE_DIA_DEL_MES" AS "ALE_DIA_DEL_MES",
"Join1"."ALE_DIA_DE_LA_SEMANA" AS "ALE_DIA_DE_LA_SEMANA",
"Join1"."ALE_SEMANA_DEL_MES" AS "ALE_SEMANA_DEL_MES",
"Join1"."ALE_DIAS_SEMANA_FLAG" AS "ALE_DIAS_SEMANA_FLAG",
"Join1"."ALE_OCURRE_UNA_VEZ_AL_DIA" AS "ALE_OCURRE_UNA_VEZ_AL_DIA",
"Join1"."ALE_OCURRE_A_ESTA_HORA" AS "ALE_OCURRE_A_ESTA_HORA",
"Join1"."ALE_OCURRE_CADA_HORAS_MINS" AS "ALE_OCURRE_CADA_HORAS_MINS",
"Join1"."ALE_SON_HORAS" AS "ALE_SON_HORAS",
"Join1"."ALE_OCURRE_HORA_INCIO" AS "ALE_OCURRE_HORA_INCIO",
"Join1"."ALE_OCURRE_HORA_FINAL" AS "ALE_OCURRE_HORA_FINAL",
"Join1"."ALE_MESES_ANIO_FLAG" AS "ALE_MESES_ANIO_FLAG",
"Join1"."ALE_USUARIO_GRABACION" AS "ALE_USUARIO_GRABACION",
"Join1"."ALE_FECHA_GRABACION" AS "ALE_FECHA_GRABACION",
"Join1"."ALE_USUARIO_MODIFICACION" AS "ALE_USUARIO_MODIFICACION",
"Join1"."ALE_FECHA_MODIFICACION" AS "ALE_FECHA_MODIFICACION"
FROM (SELECT
rol_roles_v.rol_id rol_id,
rol_roles_v.rol_descripcion rol_descripcion,
rol_roles_v.rol_activo rol_activo,
rol_roles_v.rol_fecha_creacion rol_fecha_creacion,
rol_roles_v.rol_usuario_creacion rol_usuario_creacion,
rol_roles_v.rol_fecha_modificacion rol_fecha_modificacion,
rol_roles_v.rol_usuario_modificacion rol_usuario_modificacion
FROM SEC_ROL_ROLES_V rol_roles_v) "Extent1"
INNER JOIN (SELECT "Extent2"."ALR_CODALE" AS "ALR_CODALE", "Extent2"."ALR_CODROL" AS "ALR_CODROL", "Extent3"."ALE_CODIGO" AS "ALE_CODIGO", "Extent3"."ALE_TITULO" AS "ALE_TITULO", "Extent3"."ALE_DESCRIPCION" AS "ALE_DESCRIPCION", "Extent3"."ALE_MENSAJE" AS "ALE_MENSAJE", "Extent3"."ALE_FECHA_INI" AS "ALE_FECHA_INI", "Extent3"."ALE_FECHA_FIN" AS "ALE_FECHA_FIN", "Extent3"."ALE_TIPO" AS "ALE_TIPO", "Extent3"."ALE_TIPO_REPORTE" AS "ALE_TIPO_REPORTE", "Extent3"."ALE_CODREP" AS "ALE_CODREP", "Extent3"."ALE_CODWRD" AS "ALE_CODWRD", "Extent3"."ALE_CODREP_EXCEL" AS "ALE_CODREP_EXCEL", "Extent3"."ALE_ESTADO" AS "ALE_ESTADO", "Extent3"."ALE_ASOC_DESTINATARIOS" AS "ALE_ASOC_DESTINATARIOS", "Extent3"."ALE_NOMBRE_PROCEDIMIENTO" AS "ALE_NOMBRE_PROCEDIMIENTO", "Extent3"."ALE_DATA_DESTINATARIO" AS "ALE_DATA_DESTINATARIO", "Extent3"."ALE_TEXTO_RESUMEN" AS "ALE_TEXTO_RESUMEN", "Extent3"."ALE_ES_AUTOMATICA" AS "ALE_ES_AUTOMATICA", "Extent3"."ALE_PROGRA_AVANZADA" AS "ALE_PROGRA_AVANZADA", "Extent3"."ALE_EJECUTA_UNA_VEZ" AS "ALE_EJECUTA_UNA_VEZ", "Extent3"."ALE_CRON_EXPRESSION" AS "ALE_CRON_EXPRESSION", "Extent3"."ALE_DESC_PROGRAMACION" AS "ALE_DESC_PROGRAMACION", "Extent3"."ALE_FRECUENCIA" AS "ALE_FRECUENCIA", "Extent3"."ALE_MES_OCURRE_DIA_DEL_MES" AS "ALE_MES_OCURRE_DIA_DEL_MES", "Extent3"."ALE_OCURRE_CADA" AS "ALE_OCURRE_CADA", "Extent3"."ALE_DIA_DEL_MES" AS "ALE_DIA_DEL_MES", "Extent3"."ALE_DIA_DE_LA_SEMANA" AS "ALE_DIA_DE_LA_SEMANA", "Extent3"."ALE_SEMANA_DEL_MES" AS "ALE_SEMANA_DEL_MES", "Extent3"."ALE_DIAS_SEMANA_FLAG" AS "ALE_DIAS_SEMANA_FLAG", "Extent3"."ALE_OCURRE_UNA_VEZ_AL_DIA" AS "ALE_OCURRE_UNA_VEZ_AL_DIA", "Extent3"."ALE_OCURRE_A_ESTA_HORA" AS "ALE_OCURRE_A_ESTA_HORA", "Extent3"."ALE_OCURRE_CADA_HORAS_MINS" AS "ALE_OCURRE_CADA_HORAS_MINS", "Extent3"."ALE_SON_HORAS" AS "ALE_SON_HORAS", "Extent3"."ALE_OCURRE_HORA_INCIO" AS "ALE_OCURRE_HORA_INCIO", "Extent3"."ALE_OCURRE_HORA_FINAL" AS "ALE_OCURRE_HORA_FINAL", "Extent3"."ALE_MESES_ANIO_FLAG" AS "ALE_MESES_ANIO_FLAG", "Extent3"."ALE_USUARIO_GRABACION" AS "ALE_USUARIO_GRABACION", "Extent3"."ALE_FECHA_GRABACION" AS "ALE_FECHA_GRABACION", "Extent3"."ALE_USUARIO_MODIFICACION" AS "ALE_USUARIO_MODIFICACION", "Extent3"."ALE_FECHA_MODIFICACION" AS "ALE_FECHA_MODIFICACION"
FROM "CFG_ALR_ALERTAS_ROLES" "Extent2"
INNER JOIN "CFG_ALE_ALERTAS" "Extent3" ON "Extent3"."ALE_CODIGO" = "Extent2"."ALR_CODALE" ) "Join1" ON "Extent1"."ROL_ID" = "Join1"."ALR_CODROL"
WHERE ( EXISTS (SELECT
1 AS "C1"
FROM (SELECT
rus_roles_users_v.rus_rol_id rus_rol_id,
rus_roles_users_v.rus_codusr rus_codusr
FROM SEC_RUS_ROLES_USERS_V rus_roles_users_v) "Extent4"
INNER JOIN (SELECT
usr_users_v.usr_codigo usr_codigo,
usr_users_v.usr_username usr_username,
usr_users_v.usr_nombre_usuario usr_nombre_usuario,
usr_users_v.usr_codexp usr_codexp,
usr_users_v.usr_activo usr_activo,
usr_users_v.usr_modo_autenticacion usr_modo_autenticacion,
usr_users_v.usr_ultimo_acceso usr_ultimo_acceso,
usr_users_v.usr_email usr_email,
usr_users_v.usr_password usr_password,
usr_users_v.usr_pass_vence usr_pass_vence,
usr_users_v.usr_pass_ultimo_cambio usr_pass_ultimo_cambio,
usr_users_v.usr_pass_cambiar_prox_acceso usr_pass_cambiar_prox_acceso,
usr_users_v.usr_default_domain usr_default_domain,
usr_users_v.usr_fecha_creacion usr_fecha_creacion,
usr_users_v.usr_usuario_creacion usr_usuario_creacion,
usr_users_v.usr_fecha_modificacion usr_fecha_modificacion,
usr_users_v.usr_usuario_modificacion usr_usuario_modificacion,
usr_users_v.usr_ver_mismo usr_ver_mismo,
usr_users_v.usr_ver_subalternos usr_ver_subalternos,
usr_users_v.usr_ver_solo_subalt_inmediat usr_ver_solo_subalt_inmediat
FROM SEC_USR_USERS_V usr_users_v) "Extent5" ON "Extent5"."USR_CODIGO" = "Extent4"."RUS_CODUSR"
WHERE (("Extent1"."ROL_ID" = "Extent4"."RUS_ROL_ID"))
))
) "Distinct1";
Muchass gracias, de antermano.
