topic Re: Use statistics On Databases in Talend Studio

Use statistics On Databases

Anonymous — Sat, 16 Nov 2024 03:34:07 GMT

Hi all...

Attempt to log into the DB using the 'Use statistics' function.

If only 'On Files' is checked, it will work.

But I want to put the log contents in the DB.

So created a table called ODS_LOGS...

CREATE TABLE ODS_LOGS
(
START_TIME     TIMESTAMP    ,
VAL1           VARCHAR2(20) ,
VAL2           VARCHAR2(20) ,
VAL3           VARCHAR2(20) ,
CNT1           NUMBER       ,
PROJECT_NM1    VARCHAR2(20) ,
JOB_NM1        VARCHAR2(20) ,
VAL4           VARCHAR2(20) ,
VERSION1       NUMBER(2,1) ,
VAL5           VARCHAR2(20) ,
VAL6           VARCHAR2(20) ,
VAL7           VARCHAR2(20) ,
VAL8           VARCHAR2(20) ,
END_TIME       TIMESTAMP    ,
VAL9           VARCHAR2(20) ,
VAL10          VARCHAR2(20) ,
VAL11          VARCHAR2(20) ,
CNT2           NUMBER       ,
PROJECT_NM2    VARCHAR2(20) ,
JOB_NM2        VARCHAR2(20) ,
VAL12          VARCHAR2(20) ,
VERSION2       NUMBER(2,1) ,
VAL13          VARCHAR2(20) ,
VAL14          VARCHAR2(20) ,
STATUS         VARCHAR2(20) ,
SUCC_YN        VARCHAR2(20) ,
CNT3           NUMBER
)
;

also, create Generic schema...

And..changed option stats_logs...

But.. i got this error...

What should I do?

I'd appreciate your reply.

Re: Use statistics On Databases

Anonymous — Thu, 16 Jan 2020 06:55:32 GMT

Hi
The DB table should have the same schema as tStatCatcher component, this component has pre-defined schema.

Regards
Shong

Re: Use statistics On Databases

Anonymous — Thu, 16 Jan 2020 07:16:28 GMT

CREATE TABLE O_JOB_LOG
(
moment            TIMESTAMP     ,
pid               VARCHAR2(20) ,
father_pid        VARCHAR2(20) ,
root_pid          VARCHAR2(20) ,
system_pid        NUMBER(8)     ,
project           VARCHAR2(50) ,
job               VARCHAR2(255) ,
job_repository_id VARCHAR2(255) ,
job_version       VARCHAR2(255) ,
context           VARCHAR2(50) ,
origin            VARCHAR2(255) ,
message_type      VARCHAR2(255) ,
message           VARCHAR2(255) ,
duration          NUMBER(8)
)

THANKS YOU!!