Subject | External Table Size |
---|---|
Author | Hardy Sherwood |
Post date | 2007-07-06T16:03:37Z |
The following error occurred when attempted to insert an external table into
an internal table. The external table is about 2.1 GB. This occurred on a
windows XP pro system with an NTFS file system.
Unhandled Exception: FirebirdSql.Data.FirebirdClient.FbException: I/O error
for file fseek "C:\DATABASE\INST360DATA20060630CFLN.XTN"
Error while trying to open file ---> FirebirdSql.Data.Common.IscException:
Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector()
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsStatement.Execute()
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior
behavior, Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
--- End of inner exception stack trace ---
Is the error due to a limit on external table size? Is it possible to
insert an external table larger than 2GB into an internal table? If so,
please let me know how?
Thank you,
Hardy Sherwood
801 429-2153
-----------------------------------------------------------------------------------
This message and contents are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you
have received this email in error please notify the system manager.
The original email message has been scanned for computer viruses.
-----------------------------------------------------------------------------------
[Non-text portions of this message have been removed]
an internal table. The external table is about 2.1 GB. This occurred on a
windows XP pro system with an NTFS file system.
Unhandled Exception: FirebirdSql.Data.FirebirdClient.FbException: I/O error
for file fseek "C:\DATABASE\INST360DATA20060630CFLN.XTN"
Error while trying to open file ---> FirebirdSql.Data.Common.IscException:
Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector()
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsStatement.Execute()
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior
behavior, Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
--- End of inner exception stack trace ---
Is the error due to a limit on external table size? Is it possible to
insert an external table larger than 2GB into an internal table? If so,
please let me know how?
Thank you,
Hardy Sherwood
801 429-2153
-----------------------------------------------------------------------------------
This message and contents are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you
have received this email in error please notify the system manager.
The original email message has been scanned for computer viruses.
-----------------------------------------------------------------------------------
[Non-text portions of this message have been removed]