Error Running pre SQL on "No Table"

Team, My workflow uses in database tools to retrieve some information on customers. I'm connecting to Hadoop using knox credentials. At the end of the workflow, the job fails with following error message. Any idea what might be the issue?

Error: Write Data In-DB (11): Error running PreSQL on "NoTable": [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'.

Secondly, I'm not able to use 'data stream in' and 'data stream out'. I get the error message shown in the image.

Common Use Cases

Accepted answers

Alt_dp

The server details used to write the data are incorrect which is the cause of the issue.

All comments

Alt_dp

The server details used to write the data are incorrect which is the cause of the issue.

adhe1811

I am facing the " Write Data In-DB (11) Error running PreSQL on "NoTable": ORA-00923: FROM keyword not found where expected" error while trying to join two tables from Oracle data source.I am trying to use the left outer join and then Write Data In-DB tool to create the output table.I am also attaching my workflow here.Can someone please help me out with this urgently.

adobecampaign_in-db.yxmd

ntboen

I've used the same Connection/DSN to write other tables to Hadoop without this error. It seems to be throwing when I run a particular query, which the SELECT runs fine.

Ideas?

saiHareesh

HI @Alt_dp

My i know the process you did, i am facing the same issue and the connection is working for other workflows and would like to know where and how you managed to correct it.

Steps are appreciated!

Regards,
Sai Hareesh.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703