Publishing Services 10.2 with data in various schemas

2657
2
01-07-2016 10:13 AM
KevinWatson
New Contributor

Our team is publishing a variety of services that use various schemas in our Oracle DB to source their data.

When we publish our sd files the schemas are being ignored and it seems that the tables are being looked for in the User schema/account.  Rather than the schema that the data is sourced from.  Here is the error:

In the first error (10:45:59) the tablename parameter does not indicate the schema (schema.tablename)....so it is not found in the User schema/account (in this case 'user').  When it can not find the table in the User schema/account it starts to look elsewhere in other schemas.

SEVERE Dec 23, 2015, 10:46:00 AM Failed to create the service.: FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] FDO error: -2147205085 [The terrain was not found.] Schema is out of date, Retry as owner or sdeadmin [LOADER_ARCHIVE.MUNIC_BND_UPPER_AND_DIST_FT][STATE_ID = 1016] Schema is out of date, Retry as owner or sdeadmin [LOADER_ARCHIVE.MUNIC_BND_UPPER_AND_DIST_FT][STATE_ID = 1016] System/PublishingTools.GPServer

SEVERE Dec 23, 2015, 10:46:00 AM Error executing tool.: ERROR 001487: Failed to update the published service with the server-side data location. Please see the server's log for more details. ERROR 001369: Failed to create the service. Failed to execute (Publish Service Definition). System/PublishingTools.GPServer

SEVERE Dec 23, 2015, 10:46:00 AM Failed processing the gis-resource in the service definition. System/PublishingTools.GPServer

SEVERE Dec 23, 2015, 10:45:59 AM Updating the server connection string for layer Upper Tier or District Municipality failed. Attempted connection string was ENCRYPTED_PASSWORD=00022e68447742304873786c71307339786b6849676d5064596e63774b57437668434175714e51346a56676e6e5a633d2a00;SERVER=sde;INSTANCE=sde:oracle$sde:oracle11g:ourdb;USER=user;VERSION=SDE.DEFAULT;AUTHENTICATION_MODE=DBMS. Table name is MUNIC_BND_UPPER_AND_DIST_FT. Please verify the data exists on the server.

We do have services where the User schema/account is the owner of the table and these publish just fine.

Can anyone suggest what the solution is here?  It is not feasible to be moving data.

0 Kudos
2 Replies
WoodsideSDIM
New Contributor

Did you get a solution to this issue ?

0 Kudos
BlakeTerhune
MVP Regular Contributor

Error: Schema is out of date, retry as owner or sdeadmin 

The owner of the data source must be the first user who opens the table in ArcCatalog, or open the table once the error has been encountered by any other users.

The process of opening the table by the data source owner, correctly updates ArcGIS's metadata about the table's columns; these are maintained in the ArcSDE table column_registry.

Add new columns to data sources by way of ArcCatalog to avoid this problem.

0 Kudos