Hello everyone.
I know, many, many posts exist with the same error message, but I wasn't able to find one that matches my situation.
If I query the database with a 'standard' data-input tool (table & column names hard coded), it works beautifully.
However, the problem arises when I use a formula tool to create a query more dynamically (table & column name) and parse it into a dynamic input tool (replace string).
When I test the generated query directly in the database, it works.
When I test the hard coded query in data-input, it works.
Checking with other threads, we verified the server memory (44GB of ram) and the query string that is generated is cut down to a bare 512 bytes.
When my co-worker runs the same data-input (static version), he gets the same error...
Any suggestions?
Solved! Go to Solution.
The error was triggered by table names in the (dynamic) query and the database.