TPT03022: Rule: Column Definition

Tools
nr1
Enthusiast

TPT03022: Rule: Column Definition

Getting below error :

 

Teradata Parallel Transporter Version 14.00.00.09
TPT_INFRA: Syntax error at or near line 6 of Job Script File 'test_load_ora.tpt':
TPT_INFRA: At "DATE" missing { PERIOD_ ANSIDATE_ BIGINT_ BLOB_ BYTE_ BYTEINT_ CHARACTER_ CHAR_ CHARACTERS_ CHARS_ CLOB_ DEC_ DECIMAL_ FLOAT_ GRAPHIC_ INT_ INTDATE_ INTEGER_ INTERVAL_ LONG_ NUMBER_ NUMERIC_ SMALLINT_ TIME_ TIMESTAMP_ VARBYTE_ VARCHAR_ VARDATE_ VARGRAPHIC_ } in Rule: Column Data Type
TPT_INFRA: Syntax error at or near line 6 of Job Script File 'test_load_ora.tpt':
TPT_INFRA: TPT03022: Rule: Column Definition
TPT_INFRA: Syntax error at or near line 7 of Job Script File 'test_load_ora.tpt':
TPT_INFRA: At "VARCHAR2" missing { PERIOD_ ANSIDATE_ BIGINT_ BLOB_ BYTE_ BYTEINT_ CHARACTER_ CHAR_ CHARACTERS_ CHARS_ CLOB_ DEC_ DECIMAL_ FLOAT_ GRAPHIC_ INT_ INTDATE_ INTEGER_ INTERVAL_ LONG_ NUMBER_ NUMERIC_ SMALLINT_ TIME_ TIMESTAMP_ VARBYTE_ VARCHAR_ VARDATE_ VARGRAPHIC_ } in Rule: Column Data Type
TPT_INFRA: Syntax error at or near line 7 of Job Script File 'test_load_ora.tpt':
TPT_INFRA: TPT03022: Rule: Column Definition
Compilation failed due to errors. Execution Plan was not generated.
Job script compilation failed.
Job terminated with status 8.

 

Initial Part of script :

 

DEFINE JOB SAMPLE_DB_LOAD
DESCRIPTION 'Load a Teradata table from a oracle'
(
DEFINE SCHEMA SCHEMA_acc_mon
(
INFORMATION_DATE DATE,
ACCOUNT_NUMBER VARCHAR2(16),
SOURCE_SYSTEM_ID VARCHAR2(2),
ACCOUNT_BALANCE NUMBER(22),
OPEN_DATE DATE,
ACCOUNT_STATUS_CODE NUMBER(22),
GL_SBU_CODE NUMBER(22),

3 REPLIES
Junior Contributor

Re: TPT03022: Rule: Column Definition

There's neither DATE nor VARCHAR2 in a SCHEMA definition.

There's ANSIDATE or INTDATE (or probably TIMESTAMP because it's an Oracle source) and VARCHAR.

 

See DEFINE SCHEMA

nr1
Enthusiast

Re: TPT03022: Rule: Column Definition

Thanks deiter for your Reply and information.

 

Can we use informatica odbc driveres for TPT odbc connection ?

 

Getting below error :

 

TPT_INFRA: TPT02192: Error: Cannot load shared library
dlopen error: libodbc.so: cannot open shared object file: No such file or directory
TPT_INFRA: TPT02109: Cannot open shared library libodbcop.so, status = Open Error

 

and informatica odbc libraries are :

 

./bin/libpmodbc.so
./bin/libpmneoviewodbc.so

 

Could you please advise on this ? or need to install odbc driveres for TPT ?