Guess Schema throws error for Big SQL Query

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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