Hola a todos,me gustaría que me pudieran orientar con el problema que tengo:
Aplicación web MVC 3
.NET framework 4
nHibernate 4.0.0
Tengo la entidad recibos que está relacionado de muchos a uno con la
entidad empleados. Y en la aplicación web tengo dos componentes utilizando
grids de kendo para consultar los recibos por tipos de recibos. Uno de los
grids me debe de regresar un total de más de 3000 recibos. Al tratar de
hacer una consulta como la que les presento y que me debe de regresar los
más de 3000 registros me regresa el error que también les anexo en el
cuerpo de este mensaje.
Lo preocupante de este tema es que el error no es consistente, en ocasiones
me ha regresado ese error cuando hago la primer carga del grid de kendo , y
otras ocasioes hasta la 2da o tercera carga/actualización del grid.
Receipt result = null;
QueryOver<Receipt> queries = QueryOver.Of<Receipt>()
.WhereRestrictionOn(c => c.CreatedDate)
.IsBetween(startDate).And(endDate)
.Where(conjunction)
.SelectList(list => list
.Select(pr => pr.Uuid).WithAlias(() => result.Uuid)
.Select(pr => pr.Status).WithAlias(() => result.
Status)
.Select(pr => pr.Empleado).WithAlias(() => result.
Empleado)
.Select(pr => pr.PayrollType).WithAlias(() => result
.PayrollType)
.Select(pr => pr.PaymentPeriodStart).WithAlias(() =>
result.PaymentPeriodStart)
.Select(pr => pr.PaymentPeriodFinish).WithAlias(()
=> result.PaymentPeriodFinish)
.Select(pr => pr.PayrollPeriod).WithAlias(() =>
result.PayrollPeriod)
.Select(pr => pr.PaymentDate).WithAlias(() => result
.PaymentDate)
.Select(pr => pr.StampingDate).WithAlias(() =>
result.StampingDate)
.Select(pr => pr.SignedDate).WithAlias(() => result.
SignedDate)
.Select(pr => pr.CreatedDate).WithAlias(() => result
.CreatedDate) )
.TransformUsing(Transformers.AliasToBean<Receipt>());
BeginTransaction();
var resultado = queries.GetExecutableQueryOver(
CurrentSession);
CommitTransaction();
NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT
this_.CFDI_UUID as y0_, this_.REGISTRY_STATUS as y1_, this_.COMPANY_ID as
y2_, this_.EMPLOYEE_ID_DBA as y3_, this_.PAYROLL_TYPE as y4_,
this_.PAYMENT_PERIOD_INITIAL_DATE as y5_, this_.PAYMENT_PERIOD_FINAL_DATE
as y6_, this_.PAYROLL_PERIOD as y7_, this_.PAYMENT_DATE as y8_,
this_.FISCAL_STAMPING_DATE as y9_, this_.SIGNED_DATE as y10_,
this_.CREATED_DATE as y11_ FROM FEL_PCR_PAYROLL_CFDI_RECEIPT this_ WHERE
this_.CREATED_DATE between :p0 and :p1 and (this_.SIGNATURE_MARK = :p2 and
this_.PAYROLL_TYPE = :p3 and this_.COMPANY_ID = :p4) ] Name:cp0 -
Value:07/06/2016 12:00:00 a.m. Name:cp1 - Value:07/06/2016 11:59:59 p.m.
Name:cp2 - Value:N Name:cp3 - Value:3 Name:cp4 - Value:18 [SQL: SELECT
this_.CFDI_UUID as y0_, this_.REGISTRY_STATUS as y1_, this_.COMPANY_ID as
y2_, this_.EMPLOYEE_ID_DBA as y3_, this_.PAYROLL_TYPE as y4_,
this_.PAYMENT_PERIOD_INITIAL_DATE as y5_, this_.PAYMENT_PERIOD_FINAL_DATE
as y6_, this_.PAYROLL_PERIOD as y7_, this_.PAYMENT_DATE as y8_,
this_.FISCAL_STAMPING_DATE as y9_, this_.SIGNED_DATE as y10_,
this_.CREATED_DATE as y11_ FROM FEL_PCR_PAYROLL_CFDI_RECEIPT this_ WHERE
this_.CREATED_DATE between :p0 and :p1 and (this_.SIGNATURE_MARK = :p2 and
this_.PAYROLL_TYPE = :p3 and this_.COMPANY_ID = :p4)] --->
System.InvalidOperationException:
Operation is not valid due to the current state of the object. at
Oracle.DataAccess.Client.OracleDataReader.GetOrdinal(String name) at
NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) at
NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name,
ISessionImplementor session, Object owner) at
NHibernate.Loader.Criteria.CriteriaLoader.GetResultRow(Object[] row,
IDataReader rs, ISessionImplementor session) at
NHibernate.Loader.Criteria.CriteriaLoader.GetResultColumnOrRow(Object[]
row, IResultTransformer customResultTransformer, IDataReader rs,
ISessionImplementor session) at
NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet,
ISessionImplementor session, QueryParameters queryParameters, LockMode[]
lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects,
EntityKey[] keys, Boolean returnProxies, IResultTransformer
forcedResultTransformer) at
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session,
QueryParameters queryParameters, Boolean returnProxies, IResultTransformer
forcedResultTransformer) at
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor
session, QueryParameters queryParameters, Boolean returnProxies,
IResultTransformer forcedResultTransformer) at
NHibernate.Loader.Loader.DoList(ISessionImplementor session,
QueryParameters queryParameters, IResultTransformer
forcedResultTransformer) --- End of inner exception stack trace --- at
Tenaris.FEL.DataAccess.Repository`1.ReceiptsWithFilter(String
stringCompany, String stringEmployeeId, Dictionary`2 parameters) in
D:\TFS\Local\New
Features\Development\Tenaris.FEL\Tenaris.FEL.DataAccess\Repository.cs:line
1436 at
Tenaris.FrameworkUX.Web.Controllers.ChiefController.ReceiptsFilter(Int32
skip, Int32 take, Int32 page, Int32 pageSize, String stringSignOrigin,
String stringPeriod, String stringPayrollType, String stringStartPeriod,
String stringEndPeriod, String stringReceiptStatus, String stringCompany,
String stringEmployee) in D:\TFS\Local\New
Features\Development\Tenaris.FEL\Tenaris.UX.Framework\Controllers\ChiefController.cs:line
739
--
--
Para escribir al Grupo, hágalo a esta dirección:
[email protected]
Para más, visite: http://groups.google.com/group/NHibernate-Hispano
---
Has recibido este mensaje porque estás suscrito al grupo "NHibernate-Hispano"
de Grupos de Google.
Para anular la suscripción a este grupo y dejar de recibir sus mensajes, envía
un correo electrónico a [email protected].
Para obtener más opciones, visita https://groups.google.com/d/optout.
Employees.hbm.xml
Description: XML document
Receipts.hbm.xml
Description: XML document
