AMC LOG Table

Six Stars

AMC LOG Table

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

Sixteen Stars

Re: AMC LOG Table

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?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.