On Sat, Nov 18, 2017 at 7:31 PM, <
firebird-net-provider-requ...@lists.sourceforge.net> wrote:
> Send Firebird-net-provider mailing list submissions to
> firebird-net-provider@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
> firebird-net-provider-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> firebird-net-provider-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
> 1. Error reading data from the connection Re:
> Firebird-net-provider Digest, Vol 139, Issue 6 (LtColRDSChauhan)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 18 Nov 2017 19:31:44 +0530
> From: LtColRDSChauhan <rdsc1...@gmail.com>
> To: firebird-net-provider@lists.sourceforge.net
> Subject: [Firebird-net-provider] Error reading data from the
> connection Re: Firebird-net-provider Digest, Vol 139, Issue 6
> Message-ID:
> <CAMG8wxj8BvBGE88rEvN=2zhg7-W9u-VSZPU_wtCJkok1WKrXgg@mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Sat, Nov 18, 2017 at 5:46 PM, <
> firebird-net-provider-requ...@lists.sourceforge.net> wrote:
>
> > Send Firebird-net-provider mailing list submissions to
> > firebird-net-provider@lists.sourceforge.net
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-
> provider
> > or, via email, send a message with subject or body 'help' to
> > firebird-net-provider-requ...@lists.sourceforge.net
> >
> > You can reach the person managing the list at
> > firebird-net-provider-ow...@lists.sourceforge.net
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of Firebird-net-provider digest..."
> >
> >
> > Today's Topics:
> >
> > 1. Re: Error reading data from the connection Re:
> > Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Sat, 18 Nov 2017 09:07:35 +0100
> > From: Ji?? ?in?ura <j...@cincura.net>
> > To: firebird-net-provider@lists.sourceforge.net
> > Subject: Re: [Firebird-net-provider] Error reading data from the
> > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> > Message-ID:
> > <1510992455.1577004.1176679856.4C4DB47A@webmail.
> > messagingengine.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > I would check inner exception to see what happened.
> >
> >
> Thanks for responding, Jiri.
> The details of exception are as under please. Let me know if more details
> are required.
>
>
> - ex {"Error reading data from the
> connection."} FirebirdSql.Data.FirebirdClient.FbException
>
> + Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
> ErrorCode 335544726 int
>
> + Errors
> {FirebirdSql.Data.FirebirdClient.FbErrorCollection}
> FirebirdSql.Data.FirebirdClient.FbErrorCollection
>
> HResult -2147467259 int
>
> HelpLink null string
>
> - InnerException {"Error reading data from
> the connection."} System.Exception
> {FirebirdSql.Data.Common.IscException}
>
> + Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
> ErrorCode 335544726 int
>
> + Errors Count = 2
> System.Collections.Generic.List<FirebirdSql.Data.Common.IscError>
>
> HResult -2146233088 int
>
> HelpLink null string
>
> - InnerException {"I/O error occurred."}
> System.Exception
> {System.IO.IOException}
>
> + Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
> HResult -2146232800 int
>
> HelpLink null string
>
> - InnerException null
> System.Exception
>
> + Static members
>
> Message "I/O error occurred."
> string
>
> Source
> "FirebirdSql.Data.FirebirdClient"
> string
>
> StackTrace " at
> FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n at
> FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n at
> FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()\r\n
> at
> FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()"
> string
>
> + TargetSite {Byte[]
> ReadBytes(Int32)}
> System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}
>
> + Static members
>
> + Non-Public members
>
> IsWarning false bool
>
> Message "Error reading data from
> the connection." string
>
> SQLSTATE "08006"
> string
>
> Source
> "FirebirdSql.Data.FirebirdClient"
> string
>
> StackTrace " at
> FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n at
> FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()" string
>
> + TargetSite
> {FirebirdSql.Data.Common.DbValue[]
> Fetch()} System.Reflection.MethodBase
> {System.Reflection.RuntimeMethodInfo}
>
> + Static members
>
> + Non-Public members
>
> Message "Error reading data from
> the connection." string
>
> SQLSTATE "08006"
> string
>
> Source
> "FirebirdSql.Data.FirebirdClient"
> string
>
> StackTrace " at
> FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n at
> FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n at
> System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
> mapping)\r\n at
> System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
> datatable, String srcTable, DataReaderContainer dataReader, Int32
> startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
> parentChapterValue)\r\n at System.Data.Common.DataAdapter.Fill(DataSet
> dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32
> maxRecords)\r\n at System.Data.Common.DbDataAdapter.FillInternal(DataSet
> dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
> String srcTable, IDbCommand command, CommandBehavior behavior)\r\n at
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
> behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet,
> String srcTable)\r\n at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String
> tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in
> D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294"
> string
>
> + TargetSite
> {FirebirdSql.Data.Common.DbValue[]
> Fetch()} System.Reflection.MethodBase
> {System.Reflection.RuntimeMethodInfo}
>
> + Static members
>
> + Non-Public members
>
>
Additional inputs:
I observed that while copying 13,26,000 records from source in batches of
50,000 each, exception was raised after copying 12,50,000.
So from the source I deleted the already copied 12,50,000 records and
resumed to copy the remaining 76,000.
This also failed.
Attempted versions: 6 Alpha 2, 5.12.0.0, 5.11.0.0 and 4.5.2.0.
However, I could manually insert the 76,000 records using flamerobin.
Now to copy this particular table of the database I am using
FbCommand's ExecuteNonQuery to run a stored procedure which copies record
using Execute Statement On External database.
This works fine and faster.
For the time being, I appear to have manoeuvred out of dead end.
>
> > --
> > Mgr. Ji?? ?in?ura
> > https://www.tabsoverspaces.com/
> >
> >
> >
> >
> > ------------------------------
> >
> > ------------------------------------------------------------
> > ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> >
> > ------------------------------
> >
> > Subject: Digest Footer
> >
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Firebird-net-provider@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
> > ------------------------------
> >
> > End of Firebird-net-provider Digest, Vol 139, Issue 6
> > *****************************************************
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------
>
> End of Firebird-net-provider Digest, Vol 139, Issue 7
> *****************************************************
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
