Custom Workflow Manager tables

MikeJohnson2 — Thu, 07 Feb 2013 17:47:04 GMT

Greetings,

A custom Workflow Manager application (DLL) was developed in C# using version 10.0 (ESRI software) and Oracle 11g database.

Additionally there are some custom tables that were created/loaded with values using SQL.

The following error message is received during the WFM client startup. "DBMS table not found [ORA00942] table or view does not exist <custom table name> stateid=38560"

1. Do the custom tables need to be registered with the geodatabase?

2. Can the custom tables be created/loaded with SQL files or do they have to be created with an ESRI tool?

3. Any suggestion as to the cause of the error?

Thanks,

Mike

Re: Custom Workflow Manager tables

Jean-GabrielHasbani — Fri, 08 Feb 2013 17:04:50 GMT

1. Do the custom tables need to be registered with the geodatabase?

Not too sure what you mean by custom tables. If you talk about extended properties, then yes,but this is not your problem here.

2. Can the custom tables be created/loaded with SQL files or do they have to be created with an ESRI tool?

SQL is fine, then use ArcCatalog to register

3. Any suggestion as to the cause of the error?

grant SELECT/UPDATE/INSERT/DELETE on your tables to WMX user!!!

topic Custom Workflow Manager tables in ArcGIS Workflow Manager Questions

Custom Workflow Manager tables

Re: Custom Workflow Manager tables