Need help! Error: System.ArgumentException

More
3 months 2 weeks ago #14606 by euroinmus33
Good day.
There is a source base based on PG9, and the SSIS has many packages using the PGNP-Postgres-SE-1.4.0.3494-x64 driver version. Everything works correctly in it.
Now we are planning to update the PG to version 12. Accordingly, we purchased the PGNP-Postgres-SE-1.4.0.3624-x64 driver for these purposes. We decided to update the driver, since the PG will be updated according to the plan a little later. After updating the driver, errors of the form began to pour in in large numbers:

Error: System.ArgumentException: Value does not fall within the expected range.
at System.Data.Common.UnsafeNativeMethods.ISQLErrorInfo.GetSQLInfo (String & pbstrSQLState)
at System.Data.OleDb.OleDbError..ctor (IErrorRecords errorRecords, Int32 index)
at System.Data.OleDb.OleDbErrorCollection..ctor (IErrorInfo errorInfo)
at System.Data.OleDb.OleDbException.CreateException (IErrorInfo errorInfo, OleDbHResult errorCode, Exception inner)
at System.Data.OleDb.OleDbConnection.ProcessResults (OleDbHResult hresult, OleDbConnection connection, Object src)
at System.Data.OleDb.OleDbDataReader.ProcessResults (OleDbHResult hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles ()
at System.Data.OleDb.OleDbDataReader.ReadRowset ()
at System.Data.OleDb.OleDbDataReader.Read ()
at System.Data.OleDb.OleDbDataReader.NextResult ()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal (CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute ()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute (IDTSManagedComponentWrapper100 wrapper)


Is the PGNP-Postgres-SE-1.4.0.3624-x64 driver backward compatible with PG9? If so, what could be the reason?

Please Log in or Create an account to join the conversation.

More
3 months 2 weeks ago - 3 months 2 weeks ago #14607 by admin
Hello,
yes, build 3624 is back compatible with PG9. What is OS where the packages are executed? In case of Windows Server 2003 we can send a different build (because build 3624 uses a function that is not available on WinSvr 2003).
If you are running a later OS, then please collect trace in PGNProfiler on Comment Level 2, and email it to use for analysis.
Also, it could be helpful for us to have a sample package that reproduces the issue.
Thank you!
Last edit: 3 months 2 weeks ago by admin.

Please Log in or Create an account to join the conversation.

Time to create page: 0.050 seconds
Powered by Kunena Forum