10.6升10.9后托管要素图层发布失败

Portal上传发布托管要素图层失败。
ArcMap发布托管要素服务失败。
ArcMap发布普通的地图服务成功。
server的PublishingToolsEx日志报错

<Msg time='2023-02-28T16:27:16,70' type='SEVERE' code='-2147216086' target='System/PublishingToolsEx.GPServer' methodName='SimpleDataConverter::ConvertFeatureClass' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>CreateFeatureClass failed. DBMS table not found [SHP_ChinaProvince]</Msg>
<Msg time='2023-02-28T16:27:16,71' type='WARNING' code='102014' target='System/PublishingToolsEx.GPServer' methodName='GeoDBDataTransfer::Transfer' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>Failed to copy dataset SHP_ChinaProvince. Dataset: SHP_ChinaProvince.</Msg>
<Msg time='2023-02-28T16:27:16,71' type='WARNING' code='102017' target='System/PublishingToolsEx.GPServer' methodName='GeoDBDataTransfer::Transfer' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>Attempting copy again with a new suggested name. Dataset: SHP_ChinaProvince.</Msg>
<Msg time='2023-02-28T16:27:16,77' type='WARNING' code='102016' target='System/PublishingToolsEx.GPServer' methodName='GeoDBDataTransfer::Transfer' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>Failure wasn't due to name conflict. Bailing out. Dataset: SHP_ChinaProvince.</Msg>
<Msg time='2023-02-28T16:27:16,78' type='SEVERE' code='23836' target='System/PublishingToolsEx.GPServer' methodName='SDMapServicePublisher.ProcessDatabases.CopyDataToManagedEgdb' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>Data extraction to managed egdb failed.</Msg>
<Msg time='2023-02-28T16:27:16,78' type='SEVERE' code='23836' target='System/PublishingToolsEx.GPServer' methodName='SDMapServicePublisher.ProcessDatabases.CopyDataToManagedEgdb' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>
Attribute column not found [ERROR:  column "oid" does not exist
LINE 1: SELECT oid,base_id, num_ids FROM sde.i5 WHERE id_type = 2 OR...
               ^
QUERY:  SELECT oid,base_id, num_ids FROM sde.i5 WHERE id_type = 2 ORDER BY num_ids DESC FOR UPDATE 
CONTEXT:  PL/pgSQL function i5_get_ids(integer,integer) line 43 at FOR over EXECUTE statement::SQLSTATE=42703]
DBMS table not found [SHP_ChinaProvince]</Msg>
<Msg time='2023-02-28T16:27:16,79' type='SEVERE' code='23836' target='System/PublishingToolsEx.GPServer' methodName='SDMapServicePublisher::DoAfterSDExtraction' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>ProcessDatabases failed.</Msg>
<Msg time='2023-02-28T16:27:16,79' type='SEVERE' code='23858' target='System/PublishingToolsEx.GPServer' methodName='SDPublisher::CreateService2' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>DoAfterSDExtraction failed.</Msg>
<Msg time='2023-02-28T16:27:16,105' type='SEVERE' code='23836' target='System/PublishingToolsEx.GPServer' methodName='SDPublisher::Publish' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>CreateServiceWrapper failed.</Msg>
<Msg time='2023-02-28T16:27:16,105' type='SEVERE' code='23836' target='System/PublishingToolsEx.GPServer' methodName='pubSD.execute' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>Failed to create the service.: 
Attribute column not found [ERROR:  column "oid" does not exist
LINE 1: SELECT oid,base_id, num_ids FROM sde.i5 WHERE id_type = 2 OR...
               ^
QUERY:  SELECT oid,base_id, num_ids FROM sde.i5 WHERE id_type = 2 ORDER BY num_ids DESC FOR UPDATE 
CONTEXT:  PL/pgSQL function i5_get_ids(integer,integer) line 43 at FOR over EXECUTE statement::SQLSTATE=42703]
DBMS table not found [SHP_ChinaProvince]</Msg>
<Msg time='2023-02-28T16:27:16,608' type='SEVERE' code='23836' target='System/PublishingToolsEx.GPServer' methodName='PublishPortalService.Execute' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>ERROR 001369: Failed to create the service. Failed to execute (PublishServiceDefinition). </Msg>
<Msg time='2023-02-28T16:27:17,315' type='SEVERE' code='20010' target='System/PublishingToolsEx.GPServer' methodName='GPServerSync.CheckMessages' machine='SERVER.CAUPDCLOUD.COM' process='21500' thread='426' user='0123456789ABCDEF::arcgischeck'  requestId='ba79d4a9-f168-4f74-a68b-2f0ba9a69a8b'>Error executing tool. PublishPortalService Job ID: jf0956394afb84e37a0cb1f4bd62c0027 : ERROR 001369: Failed to create the service. Failed to execute (PublishServiceDefinition). 
ERROR 001369: Failed to create the service. Failed to execute (PublishServiceDefinition). 
Failed to execute (Publish Portal Service).</Msg>
 
已邀请:

许丹石

赞同来自:

要素入库时创建要素类,调用存储过程i5_get_ids() 里面去寻找sde.i5的oid字段。而只有10.6等早期版本i5表里才会有oid字段。10.9版本的SDE当中的i5表里没有oid字段。所以创建要素失败。
 查看DataStore里面的pg里面的地理数据库版本。
SELECT description AS "Geodatabase release" FROM sde.sde_version;
发现依然是10.6版本。应恢复快照,重新升级DataStore。升级前保证DataStore数据目录的剩余空间大于当前占用的二倍空间以上。例如当前已占用40GB,建议剩余空闲空间80GB以上。总大小应在120GB以上。
 
如果老环境丢失,也没有快照备份。可以尝试使用桌面的Upgrade geodatabase。
 

要回复问题请先登录注册