SSIS -Internal .Net Framework Data Provider error 30.

Question

Hi,

 

I have alegacy SSIS package which is started failing  suddenly.

It has select query from Oracle.

SELECT a.INVENTORY_ID,

a.VERSION_NAME

FROM TESTDATA.INVENTORY_VERSION a

 

INNER JOIN

(SELECT INVENTORY_ID, MAX(LAST_UPDT_DTTIME) AS mupdtdt

FROM TESTDATA.INVENTORY_VERSION b

WHERE (ACTIVE_FLAG = 'Y')

GROUP BY INVENTORY_ID) maxinv

ON maxinv.INVENTORY_ID = a.INVENTORY_ID

AND maxinv.mupdtdt = a.LAST_UPDT_DTTIME

WHERE (a.ACTIVE_FLAG = 'Y')

GROUP BY a.INVENTORY_ID, a.VERSION_NAME

ORDER BY a.INVENTORY_ID

I don't have any oracle experience, getting following error 

  

 

Error: System.InvalidOperationException: Internal .Net Framework Data Provider error 30.

at System.Data.ProviderBase.DbBuffer.Validate(Int32 offset, Int32 count)

at System.Data.ProviderBase.DbBuffer.PtrToStringUni(Int32 offset)

at System.Data.OracleClient.OciHandle.PtrToString(NativeBuffer buf)

at System.Data.OracleClient.OracleInternalConnection.get_ServerVersion()

at System.Data.OracleClient.OracleInternalConnection.get_ServerVersionAtLeastOracle8()

at System.Data.OracleClient.OracleConnection.get_ServerVersionAtLeastOracle8()

at System.Data.OracleClient.OracleColumn.Describe(Int32& offset, OracleConnection connection, OciErrorHandle errorHandle)

at System.Data.OracleClient.OracleDataReader.FillColumnInfo()

at System.Data.OracleClient.OracleDataReader..ctor(OracleCommand command, OciStatementHandle statementHandle, String statementText, CommandBehavior commandBehavior)

at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute()

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)