AnsweredAssumed Answered

Publishing Services 10.2 with data in various schemas

Question asked by k2watson on Jan 7, 2016
Latest reply on Apr 25, 2017 by blake.terhune

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.

Outcomes