PreSQL Error with Output Tool for SQL Server DB

kherty

I have created a workflow that runs and executes a presql statement on a SQL Server database.  I have another user who's DB connections are configured exactly the same as my Designer installation, however, when they try and execute the same workflow, they get an "invalid object" error?   I have attached a word .doc which has screenshots of both of our DB connection settings and the flow executing properly on my machine and the error the other user receives. Can anybody help us edit this Designer workflow so it can be used by both of us? Thanks!

Presql Error.docx

mceleavey

Hi @kherty ,

have you tried praying to the SQL gods?

Failing that, it may be that for the other user it's not resolving the full table name, because of reasons (known only to the SQL gods). Get the other person to connect to that source using the input tool, go to the table picker, select the table and add it. Then go to the SQL tab and see what the name of the table is in that sql select script. This will give you the name of the table from their connection.

At least will see where the problem lies.

M.