Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: NHiberbnate 1.2.0

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

NHibernate.ADOException: could not execute query
[ select mledger0_.Institution as Institut1_5_, mledger0_.TransactionNumber as Transact2_5_, mledger0_.Portfolio as Portfolio5_, mledger0_.ControlCode as ControlC4_5_, mledger0_.StatusCode as StatusCode5_, mledger0_.CUSIP as CUSIP5_, mledger0_.SType as SType5_, mledger0_.SecMstRecordType as SecMstRe8_5_, mledger0_.CurParValue as CurParVa9_5_, mledger0_.CurBookValue as CurBook10_5_, mledger0_.CurMktPrice as CurMktP11_5_, TO_SQL_DATE(mledger0_.MaturityDateC, mledger0_.MaturityDateY, mledger0_.MaturityDateM, mledger0_.MaturityDateD) as formula7_, TO_SQL_DATE(mledger0_.SettlementDateC, mledger0_.SettlementDateY, mledger0_.SettlementDateM, mledger0_.SettlementDateD) as formula8_, TO_SQL_DATE(mledger0_.DispositionEffdC, mledger0_.DispositionEffdY, mledger0_.DispositionEffdM, mledger0_.DispositionEffdD) as formula9_ from MLedger mledger0_ where mledger0_.Institution in (:InstitutionFilter.Institutions) and mledger0_.SecMstRecordType NOT IN (:SecMstRecordTypesNotFilter.SecMstRecordTypes) and mledger0_.StatusCode IN (:StatusCode.StatusCodes) and mledger0_.ControlCode='A' ]
[SQL: select mledger0_.Institution as Institut1_5_, mledger0_.TransactionNumber as Transact2_5_, mledger0_.Portfolio as Portfolio5_, mledger0_.ControlCode as ControlC4_5_, mledger0_.StatusCode as StatusCode5_, mledger0_.CUSIP as CUSIP5_, mledger0_.SType as SType5_, mledger0_.SecMstRecordType as SecMstRe8_5_, mledger0_.CurParValue as CurParVa9_5_, mledger0_.CurBookValue as CurBook10_5_, mledger0_.CurMktPrice as CurMktP11_5_, TO_SQL_DATE(mledger0_.MaturityDateC, mledger0_.MaturityDateY, mledger0_.MaturityDateM, mledger0_.MaturityDateD) as formula7_, TO_SQL_DATE(mledger0_.SettlementDateC, mledger0_.SettlementDateY, mledger0_.SettlementDateM, mledger0_.SettlementDateD) as formula8_, TO_SQL_DATE(mledger0_.DispositionEffdC, mledger0_.DispositionEffdY, mledger0_.DispositionEffdM, mledger0_.DispositionEffdD) as formula9_ from MLedger mledger0_ where mledger0_.Institution in (:InstitutionFilter.Institutions) and mledger0_.SecMstRecordType NOT IN (:SecMstRecordTypesNotFilter.SecMstRecordTypes) and mledger0_.StatusCode IN (:StatusCode.StatusCodes) and mledger0_.ControlCode='A'] ---> Pervasive.Data.SqlClient.PsqlException: System.IO.EndOfStreamException: Unable to read beyond the end of the stream.
at System.IO.__Error.EndOfFile()
at System.IO.MemoryStream.InternalReadInt32()
at System.IO.BinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.NetworkBinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.ColumnInfo.ReadValueFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.ReadFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.LnaStatement.ExtendedFetch(Int16 fetchType, Int32 rowNumber, ColumnInfoSet cis, FetchReader fr)
at Pervasive.Data.SqlClient.Lna.LnaStatement.ExtendedFetch(Int16 fetchType, Int32 rowNumber, ColumnInfoSet cis, FetchReader fr)
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.DoFetch()
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.Relative(Int32 rows, Boolean adjacent)
at Pervasive.Data.SqlClient.PsqlDataReader.doRead()
at Pervasive.Data.SqlClient.PsqlDataReader.Read()
at NHibernate.Driver.NHybridDataReader.Read()
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

Name and version of the database you are using:

Pervasive SQL V.9

The generated SQL (show_sql=true):

[SQL: select mledger0_.Institution as Institut1_5_, mledger0_.TransactionNumber as Transact2_5_, mledger0_.Portfolio as Portfolio5_, mledger0_.ControlCode as ControlC4_5_, mledger0_.StatusCode as StatusCode5_, mledger0_.CUSIP as CUSIP5_, mledger0_.SType as SType5_, mledger0_.SecMstRecordType as SecMstRe8_5_, mledger0_.CurParValue as CurParVa9_5_, mledger0_.CurBookValue as CurBook10_5_, mledger0_.CurMktPrice as CurMktP11_5_, TO_SQL_DATE(mledger0_.MaturityDateC, mledger0_.MaturityDateY, mledger0_.MaturityDateM, mledger0_.MaturityDateD) as formula7_, TO_SQL_DATE(mledger0_.SettlementDateC, mledger0_.SettlementDateY, mledger0_.SettlementDateM, mledger0_.SettlementDateD) as formula8_, TO_SQL_DATE(mledger0_.DispositionEffdC, mledger0_.DispositionEffdY, mledger0_.DispositionEffdM, mledger0_.DispositionEffdD) as formula9_ from MLedger mledger0_ where mledger0_.Institution in (:InstitutionFilter.Institutions) and mledger0_.SecMstRecordType NOT IN (:SecMstRecordTypesNotFilter.SecMstRecordTypes) and mledger0_.StatusCode IN (:StatusCode.StatusCodes) and mledger0_.ControlCode='A']

Debug level Hibernate log excerpt:

13:59:04.856 [4] DEBUG NHibernate.Loader.Loader - result row: CORFS.Paragon.PositionMonitor.Dto.MLedger
13:59:04.856 [4] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: [CORFS.Paragon.PositionMonitor.Dto.MLedger#CORFS.Paragon.PositionMonitor.Dto.MLedger]
13:59:04.856 [4] DEBUG NHibernate.Loader.Loader - Hydrating entity: CORFS.Paragon.PositionMonitor.Dto.MLedger#CORFS.Paragon.PositionMonitor.Dto.MLedger
13:59:04.856 [4] DEBUG NHibernate.Type.DecimalType - returning '176600.0000' as column: CurParVa9_5_
13:59:04.856 [4] DEBUG NHibernate.Type.DecimalType - returning '176600.0000' as column: CurBook10_5_
13:59:04.856 [4] DEBUG NHibernate.Type.DoubleType - returning '0' as column: CurMktP11_5_
13:59:04.856 [4] DEBUG NHibernate.Type.DateTimeType - returning '01/01/0001' as column: formula7_
13:59:04.856 [4] DEBUG NHibernate.Type.DateTimeType - returning '18/12/2006' as column: formula8_
13:59:04.856 [4] DEBUG NHibernate.Type.DateTimeType - returning '01/01/0001' as column: formula9_
13:59:04.856 [4] DEBUG NHibernate.Loader.Loader - result set row: 499
13:59:04.856 [4] DEBUG NHibernate.Type.StringType - returning 'CFG' as column: Institut1_5_
13:59:04.856 [4] DEBUG NHibernate.Type.StringType - returning '0612193405' as column: Transact2_5_
13:59:04.856 [4] DEBUG NHibernate.Loader.Loader - result row: CORFS.Paragon.PositionMonitor.Dto.MLedger
13:59:04.856 [4] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: [CORFS.Paragon.PositionMonitor.Dto.MLedger#CORFS.Paragon.PositionMonitor.Dto.MLedger]
13:59:04.856 [4] DEBUG NHibernate.Loader.Loader - Hydrating entity: CORFS.Paragon.PositionMonitor.Dto.MLedger#CORFS.Paragon.PositionMonitor.Dto.MLedger
13:59:04.856 [4] DEBUG NHibernate.Type.DecimalType - returning '101909.0000' as column: CurParVa9_5_
13:59:04.856 [4] DEBUG NHibernate.Type.DecimalType - returning '101909.0000' as column: CurBook10_5_
13:59:04.856 [4] DEBUG NHibernate.Type.DoubleType - returning '0' as column: CurMktP11_5_
13:59:04.856 [4] DEBUG NHibernate.Type.DateTimeType - returning '01/01/0001' as column: formula7_
13:59:04.856 [4] DEBUG NHibernate.Type.DateTimeType - returning '19/12/2006' as column: formula8_
13:59:04.856 [4] DEBUG NHibernate.Type.DateTimeType - returning '01/01/0001' as column: formula9_
13:59:35.098 [4] DEBUG NHibernate.Driver.NHybridDataReader - running NHybridDataReader.Dispose()
13:59:35.098 [4] DEBUG NHibernate.Impl.BatcherImpl - Closed IDataReader, open IDataReaders :0
13:59:35.098 [4] DEBUG NHibernate.Impl.BatcherImpl - Closed IDbCommand, open IDbCommands: 0
13:59:35.098 [4] DEBUG NHibernate.Util.ADOExceptionReporter - could not execute query
[ select mledger0_.Institution as Institut1_5_, mledger0_.TransactionNumber as Transact2_5_, mledger0_.Portfolio as Portfolio5_, mledger0_.ControlCode as ControlC4_5_, mledger0_.StatusCode as StatusCode5_, mledger0_.CUSIP as CUSIP5_, mledger0_.SType as SType5_, mledger0_.SecMstRecordType as SecMstRe8_5_, mledger0_.CurParValue as CurParVa9_5_, mledger0_.CurBookValue as CurBook10_5_, mledger0_.CurMktPrice as CurMktP11_5_, TO_SQL_DATE(mledger0_.MaturityDateC, mledger0_.MaturityDateY, mledger0_.MaturityDateM, mledger0_.MaturityDateD) as formula7_, TO_SQL_DATE(mledger0_.SettlementDateC, mledger0_.SettlementDateY, mledger0_.SettlementDateM, mledger0_.SettlementDateD) as formula8_, TO_SQL_DATE(mledger0_.DispositionEffdC, mledger0_.DispositionEffdY, mledger0_.DispositionEffdM, mledger0_.DispositionEffdD) as formula9_ from MLedger mledger0_ where mledger0_.Institution in (:InstitutionFilter.Institutions) and mledger0_.SecMstRecordType NOT IN (:SecMstRecordTypesNotFilter.SecMstRecordTypes) and mledger0_.StatusCode IN (:StatusCode.StatusCodes) and mledger0_.ControlCode='A' ]
Pervasive.Data.SqlClient.PsqlException: System.IO.EndOfStreamException: Unable to read beyond the end of the stream.
at System.IO.__Error.EndOfFile()
at System.IO.MemoryStream.InternalReadInt32()
at System.IO.BinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.NetworkBinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.ColumnInfo.ReadValueFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.ReadFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.LnaStatement.ExtendedFetch(Int16 fetchType, Int32 rowNumber, ColumnInfoSet cis, FetchReader fr)
at Pervasive.Data.SqlClient.Lna.LnaStatement.ExtendedFetch(Int16 fetchType, Int32 rowNumber, ColumnInfoSet cis, FetchReader fr)
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.DoFetch()
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.Relative(Int32 rows, Boolean adjacent)
at Pervasive.Data.SqlClient.PsqlDataReader.doRead()
at Pervasive.Data.SqlClient.PsqlDataReader.Read()
at NHibernate.Driver.NHybridDataReader.Read()
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
13:59:35.099 [4] WARN NHibernate.Util.ADOExceptionReporter - Pervasive.Data.SqlClient.PsqlException: System.IO.EndOfStreamException: Unable to read beyond the end of the stream.
at System.IO.__Error.EndOfFile()
at System.IO.MemoryStream.InternalReadInt32()
at System.IO.BinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.NetworkBinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.ColumnInfo.ReadValueFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.ReadFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.LnaStatement.ExtendedFetch(Int16 fetchType, Int32 rowNumber, ColumnInfoSet cis, FetchReader fr)
at Pervasive.Data.SqlClient.Lna.LnaStatement.ExtendedFetch(Int16 fetchType, Int32 rowNumber, ColumnInfoSet cis, FetchReader fr)
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.DoFetch()
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.Relative(Int32 rows, Boolean adjacent)
at Pervasive.Data.SqlClient.PsqlDataReader.doRead()
at Pervasive.Data.SqlClient.PsqlDataReader.Read()
at NHibernate.Driver.NHybridDataReader.Read()
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
13:59:35.100 [4] ERROR NHibernate.Util.ADOExceptionReporter - System.IO.EndOfStreamException: Unable to read beyond the end of the stream.
at System.IO.__Error.EndOfFile()
at System.IO.MemoryStream.InternalReadInt32()
at System.IO.BinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.NetworkBinaryReader.ReadInt32()
at Pervasive.Data.SqlClient.Lna.ColumnInfo.ReadValueFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.ForwardReadResultCache.ReadFrom(LnaResponse res)
at Pervasive.Data.SqlClient.Lna.LnaStatement.ExtendedFetch(Int16 fetchType, Int32 rowNumber, ColumnInfoSet cis, FetchReader fr)
13:59:35.142 [4] DEBUG NHibernate.Impl.SessionImpl - flushing session
13:59:35.142 [4] DEBUG NHibernate.Impl.SessionImpl - Flushing entities and processing referenced collections
13:59:35.142 [4] DEBUG NHibernate.Impl.SessionImpl - Processing unreferenced collections
13:59:35.142 [4] DEBUG NHibernate.Impl.SessionImpl - scheduling collection removes/(re)creates/updates
13:59:35.142 [4] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 insertions, 0 updates, 0 deletions to 501 objects
13:59:35.142 [4] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - listing entities:
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0409012263, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0801313985, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0512282565, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0301242219, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0712274022, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0612043315, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0410080038, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0506302630, CurBookValue=0}
13:59:35.143 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0708174034, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0306302313, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0508252541, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0611143291, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0603302712, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0606273025, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0711194188, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0702273453, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0709133899, CurBookValue=0}
13:59:35.144 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0708303838, CurBookValue=0}
13:59:35.145 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0107022125, CurBookValue=0}
13:59:35.145 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0404052192, CurBookValue=0}
13:59:35.145 [4] DEBUG NHibernate.Impl.Printer - CORFS.Paragon.PositionMonitor.Dto.MLedger{CUSIP=null, StatusCode=null, ControlCode=null, CurParValue=0, SettlementDate=01/01/0001, CurMktPrice=0, MaturityDate=01/01/0001, Portfolio=null, SType=null, Institution=CFG, DispositionEffDate=01/01/0001, SecMstRecordType=null, TransactionNumber=0403022203, CurBookValue=0}
13:59:35.145 [4] DEBUG NHibernate.Impl.Printer - more......
13:59:35.145 [4] DEBUG NHibernate.Impl.SessionImpl - executing flush
13:59:35.145 [4] DEBUG NHibernate.Impl.ConnectionManager - registering flush begin
13:59:35.145 [4] DEBUG NHibernate.Impl.ConnectionManager - registering flush end
13:59:35.145 [4] DEBUG NHibernate.Impl.SessionImpl - post flush
13:59:35.145 [4] DEBUG NHibernate.Impl.SessionImpl - closing session
13:59:35.145 [4] DEBUG NHibernate.Impl.BatcherImpl - running BatcherImpl.Dispose(true)
13:59:35.145 [4] DEBUG NHibernate.Transaction.AdoTransaction - running AdoTransaction.Dispose()
13:59:35.146 [4] DEBUG NHibernate.Impl.ConnectionManager - aggressively releasing database connection
13:59:35.146 [4] DEBUG NHibernate.Connection.ConnectionProvider - Closing connection
13:59:35.146 [4] DEBUG NHibernate.Impl.SessionImpl - transaction completion

-----------------------------------------------------------------------------------

The strange part is that this exception will be thrown the first 5-8 times I run the program, but after that it won't be thrown and the program executes successfully.

The w3dbsmgr process which is the prevasive engine grabs more ram each time the program is run. Initially at start-up it has 10Mb but it keeps grabbing and when it successfully runs it has about 600-700 Mb.

Any help appreciated as I am running out of ideas.

Thanks in advance

Regards

Dean O'Gallagher