TPT NPAM reading named pipe ,not ending. Please help urg!!

Tools & Utilities
Teradata Employee

TPT NPAM reading named pipe ,not ending. Please help urg!!

Hello, please need help urgently with this problem!!

I have a TPT update reading from a named pipe using np_axsmod

the first tests were made manually, that is we had a file, then created a pipe and sent the data trough the pipe, and the tpt update reads the data ok.

Now we are testing with the data produced by the customer from cobol in flat file format, and the np_axsmod opens the pipe, starts reading but never ends.  The tpt update stays in the aquisition phase until we have to kill the process.

This is the File_Reader definition

    DEFINE OPERATOR FILE_READER

    DESCRIPTION 'TERADATA PARALLEL TRANSPORTER DATA CONNECTOR OPERATOR'

    TYPE DATACONNECTOR PRODUCER

    SCHEMA DIAN_SCHEMA

    ATTRIBUTES

       (

        VARCHAR DirectoryPath   = @DATADIR,

        VARCHAR FileName        = @Proceso ||'.'||@HOY,

        VARCHAR TrimTrailingBlanks = 'Y',

        VARCHAR TrimLeadingBlanks = 'Y',

        VARCHAR MultipleReaders = 'N',

        VARCHAR IndicatorMode   = 'N',

        VARCHAR OpenMode        = 'Read',

        VARCHAR AccessModuleName = 'np_axsmod.so',

        VARCHAR AccessModuleInitStr = 'll=6 nfb=n',

        VARCHAR Format          = 'Delimited',

        VARCHAR TextDelimiter   = '^',

        VARCHAR TraceLevel = 'All'

       );

The trace for the np_axsmod:

Thu Aug 20 09:14:55 2015 12815 TRACE 72 Log Initialize: ProcessName=executor, UtilityID=Unknown Client, FileName=/tmp/namedpipes.log, Log_Level=6

Thu Aug 20 09:14:55 2015 12815 DEBUG 9999 New Log Level = 6

Thu Aug 20 09:14:55 2015 12815 DEBUG 9999 Full Blocks = 0

Thu Aug 20 09:14:55 2015 12815 TRACE 9999 Request Received: pmiPIDMOptID (9)

Thu Aug 20 09:14:55 2015 12815 TRACE 9999 Request Received: pmiPIDMOptPutA_A (13)

Thu Aug 20 09:14:55 2015 12815 ERROR 9999 Attribute name: 'TBR_OP_HANDLE' unknown

Thu Aug 20 09:14:55 2015 12815 TRACE 9999 Request Received: pmiPIDMOptPutA_A (13)

Thu Aug 20 09:14:55 2015 12815 TRACE 9999 Request Received: pmiPIDMOptOpen (2)

Thu Aug 20 09:14:55 2015 12815 TRACE 9999 Opened pipe "/desarrollo/datacobol/DIAN.20150820".

Thu Aug 20 09:15:14 2015 12815 TRACE 9999 Request Received: pmiPIDMOptRead (4)

As you can see the npam opens the pipe and starts reading but it never ends.

FILE_READER Instance 1 directing private log report to 'dtacop-mrodriguezdes-12815-1'.

FILE_READER: TPT19008 DataConnector Producer operator Instances: 1

UPDATE_OPERATOR: connecting sessions

FILE_READER: TPT19003 ECI operator ID: FILE_READER-12815

FILE_READER: TPT19222 Operator instance 1 processing file '/desarrollo/datacobol/DIAN.20150820'.

UPDATE_OPERATOR: preparing target table(s)

UPDATE_OPERATOR: entering DML Phase

UPDATE_OPERATOR: entering Acquisition Phase

...

1 REPLY
Teradata Employee

Re: TPT NPAM reading named pipe ,not ending. Please help urg!!

Is the data coming through the pipe in the proper format?

If so, then the pipe will remain open until there is an end-of-file type of condition on the pipe.

Without that, the named pipe access module cannot detect that there is no more data.

-- SteveF