topic Re: Guess Schema throws error for Big SQL Query in Talend Studio

Guess Schema throws error for Big SQL Query

Anonymous — Sat, 16 Nov 2024 04:18:40 GMT

Hi Team,

We are trying to Guess schema based on custom query but after long running it throws below error.

Please suggest how to handle it.

Error on Guess schema

Re: Guess Schema throws error for Big SQL Query

Anonymous — Thu, 24 Oct 2019 10:12:59 GMT

Hello,

From the error message, it seems to be memory error. Have you tried to increase the size of XMS and XMX in current job to see if it works?

Best regards

Sabrina

Re: Guess Schema throws error for Big SQL Query

Anonymous — Thu, 24 Oct 2019 10:14:45 GMT

Hello,

You can open the error log generated automatically by the Studio to see whether you have error stack trace there; if you do, we will appreciate it a lot if you can paste it here.

In your Studio, click Window to open the menu, then select Show View->General->Error Log. Once you see an error, double click it.

Best regards

Sabrina