Tushar Dikshit

Tushar Dikshit

  • 724
  • 1.9k
  • 356.5k

SSIS -Internal .Net Framework Data Provider error 30.

Apr 20 2018 3:54 PM
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)
 

Answers (1)