Failed to obtain shared memory segment for for column data buffer, due to error 48.

Tools & Utilities
Enthusiast

Failed to obtain shared memory segment for for column data buffer, due to error 48.

I'm using Teradata Tools and Utilities 15, TPT and the ODBC operator to move data from SQL Server to Teradata.  Every once in a while I get this error and I don't know why.  If anyone has any experience with this error is would be appreciated.

Services|ODBCOperator: TPT17187: Failed to obtain shared memory segment for for column data buffer, due to error 48.

Services|ODBCOperator: TPT17174: Error 0 allocating memory for row size buffer

Services|ODBCOperator: disconnecting sessions

1 REPLY
Teradata Employee

Re: Failed to obtain shared memory segment for for column data buffer, due to error 48.

Please provide the exact version number of TPT (including the patch version).

If you are running 15.00.00.00 then I would first suggest that you upgrade to the latest patch level of TPT 15.

Next, are you using the ODBC drivers for Progress DataDirect?

We only certify with those drivers.

When you say "once in a while", how often?

Does the type (size of data) of job seem to be consistent with the failure?

How many instances of the ODBC operator are you specifying?

What are your settings for shared memory usage and availability?

-- SteveF