Custom Workflow Manager tables

[MikeJohnson2]

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

[Jean-GabrielHasbani]

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!!!