Error SQLPrepare with no explation

[mohinder_singh]

Hi All

We are trying to run a workflow which reads data from difference sources like Oracle, Ms Access and YXMD files. However, it always error Error SQLPrepare with no explanation. If I try to break and run individual sections alone, it works fine. No error explanation is big problem for us. See attached image.

Note: Workflow start with reading various access dbs and after few mins(20 mins), it starts querying Oracle db and throws error.

Appreciate any help from team!

Thanks

Mohinder

[DataNath]

Hey @mohinder_singh, if you try placing a space between your select <table>.* and FROM, does that help? Spotted this post where linebreaks aren't always recognised: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/SQL-error-that-I-only-get-in-A...

[mohinder_singh]

Hi @DataNath , Tried everything but of no use. I am frustrated now. I don't see any reason for this