AMC LOG Table

Anonymous — Wed, 14 Mar 2018 10:28:25 GMT

Hi Team

i am using AMC log table Creation I have created my log table as per below schema

CREATE TABLE `amclogdata` (
`moment` datetime DEFAULT NULL,
`pid` varchar(20) DEFAULT NULL,
`root_pid` varchar(20) DEFAULT NULL,
`father_pid` varchar(20) DEFAULT NULL,
`project` varchar(50) DEFAULT NULL,
`job` varchar(255) DEFAULT NULL,
`context` varchar(50) DEFAULT NULL,
`priority` int(3) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`origin` varchar(255) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`code` int(3) DEFAULT NULL
);

But the message is too large so that record is not inserting into the table and i am getting db truncation issue how to solve this.PLease suggest.

Thanks

Deepthi

Re: AMC LOG Table

Anonymous — Thu, 15 Mar 2018 09:16:31 GMT

Have you tried rebuilding your log table with the message column resized to something a bit larger? Also, are you sizing in chars or bytes? Are the characters you are using multi byte?

topic Re: AMC LOG Table in Talend Studio

AMC LOG Table

Re: AMC LOG Table