topic Re: I cannot display queries in workflow manager in ArcGIS Workflow Manager Questions

I cannot display queries in workflow manager

RodolfoMoreno1 — Mon, 30 Apr 2012 22:02:50 GMT

Hi All,
I created a job in workflow manager WM and I can see the ID, Name and all other attributes of my job. However when I want to see the query "all jobs" I get the following message:
This query is invalid. Verify your query definition or your query syntax (if using the SQL View) against your underlying database.
I thought that the predefined WM query "All Jobs" was wrong, so I created my own query in workflow manager administrator WMA to display all jobs. Next I came back to WM and try to see my query but I did not have success.
The same happens with the reports, it means that the reports did not show anything as if I had not created any job.
Then I search my job using "find jobs" button and put the job ID and I could see the job that has been created previosly.

I hope that someone can help me. Thans in advance.

Re: I cannot display queries in workflow manager

FraserHand — Mon, 07 May 2012 03:28:59 GMT

Hi There,
How have you set up your schema and what users are you using to connect to the wmx schema?
The issue may be that you need to fully qualify the SQL in the queries.

Have a read of this:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Imported_Job_Queries_Qualifying_Table_Names/003800000033000000/

Cheers,
Fraser

Re: I cannot display queries in workflow manager

RodolfoMoreno1 — Wed, 09 May 2012 19:52:37 GMT

The user who connects from workflow manager admnistrator WMAto the WM sde database has the SDE schema. With this same user I access to workflow manager. Obviuslythis user has been given the privilegies to view queries from the WMA. It is the stage where I cannot see the queries.
Thanks in advance.