topic Re: errorMessage=Please specify correct schema for result of your query. in Talend Studio

errorMessage=Please specify correct schema for result of your query.

gnvkdramesh — Fri, 15 Nov 2024 22:33:29 GMT

Hi!

I have a stored procedure which is in Snowflake Datawarehouse. I am running the stored procedure from Talend job. In this process, I am getting the following error.

tDBRow_1 org.talend.daikon.exception.error.DefaultErrorCode@502a4156:{errorMessage=Please specify correct schema for result of your query.}

Please help me in resolving this issue.

Thanks,

Ramesh

Re: errorMessage=Please specify correct schema for result of your query.

Anonymous — Wed, 14 Sep 2022 02:51:41 GMT

Can you share some screenshots of job and the stored procedure that help us to analyze the errors?

Regards

Shong

Re: errorMessage=Please specify correct schema for result of your query.

gnvkdramesh — Wed, 14 Sep 2022 06:12:33 GMT

HI Shong!

Thanks for your response. Here is the screenshot of the job. I connected to Snowflake connection successful. I have only one activity here which should load the data. The SP executed successfully and loaded the data. But I see the errors here in the log.

Re: errorMessage=Please specify correct schema for result of your query.

Anonymous — Wed, 14 Sep 2022 08:23:20 GMT

I'm sorry, I have no idea about this error, I have tried to search this error on internet and Talend Sites, but I don't find any information about the error. I think I shall go to make some testing on my side, to see whether I can reproduce the error.

Regards

Shong