Custom Workflow Manager tables

2863
1
02-07-2013 09:47 AM
MikeJohnson2
New Contributor
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
0 Kudos
1 Reply
Jean-GabrielHasbani
New Contributor II
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!!!
0 Kudos