Error while running the transformation

[meenaiyer]

Hi all..
I am running a simple transformation where i am just passing the value from one table to another.
but i am getting the error like
"Packet for query is too large (1523888 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable."

Can someone please help me in solving the above error. where will i find this "max_allowed_packet" variable??

Thanks

[sboden]

Guessing you're using MySQL... in the database? It's anyway not a setting native to PDI.

From the internet (by searching for your error):

[Solution]
1. Try to modify my.ini or my.cnf.
2. In [mysqld] section user can add
max_allowed_packet = 16777216
3. Save this file.
4. Restart mysql server.

Regards,
Sven