All Forums Database
MohanMuchivolu 1 post Joined 02/15
25 Jul 2016
TPT Script Error While executing

Hi,
I am getting below TPT error while reading from MQ 
MQ_READER[1]: TPT19434 pmOpen failed. General failure (34): 'Teradata Websphere MQ AMOD/PIDMMain(!ERROR!).  --ERROR: Ignoring unnecessary pathname specification at open'
MQ_READER[1]: TPT19304 Fatal error opening file.
MQ_READER[1]: TPT19015 TPT Exit code set to 12.
STREAM_OPERATOR: TPT1508 RDBMS error 3802:Database 'PROD_CURRENT_LIB' does not exists
STREAM_OPERATOR: The job will use its internal data-related erro codes
 
Please find the code also
 
DEFINE JOB MQ_LOAD
DESCRIPTION 'Load a Teradata table using MQSeries'
(
DEFINE SCHEMA MQ_SCHEMA
(
MESSAGEPAYLOAD CHAR(117)
);
 
DEFINE OPERATOR MQ_READER
TYPE DATACONNECTOR PRODUCER
SCHEMA MQ_SCHEMA
ATTRIBUTES
(
VARCHAR PrivateLogName = 'dataconnector_log',
VARCHAR FileName = 'c:/1.txt',
VARCHAR Format = 'unformatted',
VARCHAR IndicatorMode = 'N',
VARCHAR OpenMode = 'Read',
VARCHAR AccessModuleName = 'libmqs.so',
VARCHAR AccessModuleInitStr = '-qnm NOTIFICATION -qmgr AA -TRCL 4 MQTRACE -CKFILE CKFILE'
);
 
DEFINE OPERATOR STREAM_OPERATOR
TYPE STREAM
SCHEMA *
ATTRIBUTES
(
VARCHAR PrivateLogName = 'stream_log',
VARCHAR TdpId = ,
VARCHAR UserName =,
VARCHAR UserPassword = ,
VARCHAR LogTable = 'DEV1_DB.tst_LOG',
VARCHAR ErrorTable = 'DEV1_DB.tst_ET'
);
APPLY
('INSERT INTO DEV1_DB.MQ_DATA_tst VALUES(:MESSAGEPAYLOAD);')
TO OPERATOR (STREAM_OPERATOR[2])
 
SELECT * FROM OPERATOR (MQ_READER[2]);
 
Please advise any changes i need to make to the script
 
Thanks
Mohan

You must sign in to leave a comment.