TPT_INFRA: TPT04111: Error: Line 13 of Job Script File 'tpt_stream.tpt':
Semantic error: schema 'Acc_Schema' is not defined.
This is my entire tpt stream script
DEFINE JOB Trickle_Load_New_Transactions_Into_Accounts
DESCRIPTION 'Add new transactions'
DEFINE SCHEMA Acc
DEFINE OPERATOR File_Reader
TYPE DATACONNECTOR PRODUCER
VARCHAR FileName= 'accounts_data.text',
VARCHAR Format = 'DELIMITED',
VARCHAR OpenMode = 'Read',
VARCHAR TextDelimiter = '|'
DEFINE OPERATOR Stream_Accounts
VARCHAR UserName= 'sysdba',
VARCHAR UserPassword= 'learning',
VARCHAR Tdpid= '192.168.126.128',
INTEGER MaxSessions= 8,
('INSERT INTO DS.Accounts (Account_Number,
VALUES (:Account_Number, :Street_Number);')
SERIALIZE ON (Account_Number)
TO OPERATOR (Stream_Accounts)
SELECT Account_Number,Street_Number FROM OPERATOR(File_Reader );
SCHEMA name given as Acc but you have mentioned in file reader operator schema as "SCHEMA Acc_Schema" in line 11 replace it with "SCHEMA Acc" it will work.
Hi , This is the issue because your Schema name in every operator should be same such as for connector operator, update operator, file reader operator etc, every operator should be named as same " SCHEMA Acc" and in your case the file reader operator has name asSCHEMA Acc_Schema