Linux环境， postgresql 9.5 拓展sde错误.
Server env:
os: ubuntu server 16.04.6 64bit
postgresql: 9.5.5
arcgis server: 10.5
Client env:
os: windows server 2016 Datacenter
arcgis: 10.5
* 在服务器端编译安装完 postgresql以后，需要拓展 sde 来存放数据以及发布数据到 server的 arcgis server中.
* 按照官网的操作说明 http://desktop.arcgis.com/zh-c ... x.htm
中的操作， 全部检验过， 都没有问题. 变量， 权限.
* postgresql 9.5.5的拓展库文件的 md5 值
0ff80cced26f76847286bd6d45629a84 libst_raster_pg.so
66f41c5445075e36e6e75c4a7fecd3c4 PGSQLEngine.so
427e994cfc547a5ede92ca2eafb5da9d st_geometry.so
* 在 Client 机器中，连接 server机器的postgresql， 并创建 企业级数据库，创建时报错
报错日志如下.
------------------
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist
LINE 1: select count(*) from sde.sde_layers
^
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist
LINE 1: select count(keyword) from sde.sde_dbtune
^
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:11:39 2019] ST_GEOMETRY support being installed...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_coordinate_systems" does not exist
LINE 1: select count(*) from sde.sde_coordinate_systems
^
[Mon Jun 03 16:11:39 2019] COORDINATE_SYSTEMS table being created...
[Mon Jun 03 16:11:39 2019] COORDINATE_SYSTEMS table created...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "public.sde_spatial_references" does not exist
LINE 1: select count(object_flags) from public.sde_spatial_reference...
^
[Mon Jun 03 16:11:39 2019] SPATIAL_REFERENCES table being created...
[Mon Jun 03 16:11:39 2019] SPATIAL_REFERENCES table created...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_geometry_columns" does not exist
LINE 1: select count(*) from sde.sde_geometry_columns
^
[Mon Jun 03 16:11:39 2019] GEOMETRY_COLUMNS table being created...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P07
SDE DBMS Error: -62 ERROR: relation "sde_geometry_columns" already exists
[Mon Jun 03 16:11:39 2019] GEOMETRY_COLUMNS table created...
[Mon Jun 03 16:11:39 2019] ST_GEOMETRY support installed...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:12:18 2019] VERSION table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist
LINE 1: select count(minz) from sde.sde_layers
^
[Mon Jun 03 16:12:18 2019] LAYERS table being created...
[Mon Jun 03 16:12:18 2019] LAYERS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_metadata" does not exist
LINE 1: select count(object_database) from sde.sde_metadata
^
[Mon Jun 03 16:12:18 2019] METADATA table being created...
[Mon Jun 03 16:12:18 2019] METADATA table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_raster_columns" does not exist
LINE 1: select count(1) from sde.sde_raster_columns
^
[Mon Jun 03 16:12:18 2019] RASTER_COLUMNS table being created...
[Mon Jun 03 16:12:18 2019] RASTER_COLUMNS table created...
[Mon Jun 03 16:12:18 2019] TABLE_REGISTRY table being created...
[Mon Jun 03 16:12:18 2019] TABLE_REGISTRY table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_states" does not exist
LINE 1: select count(lineage_name) from sde.sde_states
^
[Mon Jun 03 16:12:18 2019] STATES table being created...
[Mon Jun 03 16:12:18 2019] STATES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_versions" does not exist
LINE 1: select count(*) from sde.sde_versions
^
[Mon Jun 03 16:12:18 2019] VERSIONS table being created...
[Mon Jun 03 16:12:18 2019] VERSIONS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_mvtables_modified" does not exist
LINE 1: select count(*) from sde.sde_mvtables_modified
^
[Mon Jun 03 16:12:18 2019] MVTABLES_MODIFIED table being created...
[Mon Jun 03 16:12:18 2019] MVTABLES_MODIFIED table created...
[Mon Jun 03 16:12:18 2019] STATE_LINEAGES table being created...
[Mon Jun 03 16:12:18 2019] STATE_LINEAGES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_locators" does not exist
LINE 1: select count(*) from sde.sde_locators
^
[Mon Jun 03 16:12:18 2019] LOCATORS table being created...
[Mon Jun 03 16:12:18 2019] LOCATORS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_xml_index_tags" does not exist
LINE 1: select count(tag_name) from sde.sde_xml_index_tags
^
[Mon Jun 03 16:12:18 2019] XML tables being created...
[Mon Jun 03 16:12:18 2019] Warning: Error querying tsearch2 system table schema. You will
need to grant select access to public to pg_ts_cfg,pg_ts_cfgmap
pg_ts_dict,pg_ts_parser for xml functionality
[Mon Jun 03 16:12:18 2019] XML tables created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_column_registry" does not exist
LINE 1: select count(*) from sde.sde_column_registry
^
[Mon Jun 03 16:12:18 2019] COLUMN_REGISTRY table being created...
[Mon Jun 03 16:12:18 2019] COLUMN_REGISTRY table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_archives" does not exist
LINE 1: select count(*) from sde.sde_archives
^
[Mon Jun 03 16:12:18 2019] ARCHIVES table being created...
[Mon Jun 03 16:12:18 2019] ARCHIVES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layer_stats" does not exist
LINE 1: select count(version_id) from sde.sde_layer_stats
^
[Mon Jun 03 16:12:18 2019] LAYER_STATS table being created...
[Mon Jun 03 16:12:18 2019] LAYER_STATS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_branches" does not exist
LINE 1: select count(*) from sde.sde_branches
^
[Mon Jun 03 16:12:18 2019] BRANCHES table being created...
[Mon Jun 03 16:12:18 2019] BRANCHES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_branch_tables_modified" does not exist
LINE 1: select count(*) from sde.sde_branch_tables_modified
^
[Mon Jun 03 16:12:18 2019] BRANCH_TABLES_MODIFIED table being created...
[Mon Jun 03 16:12:18 2019] BRANCH_TABLES_MODIFIED table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_multibranch_tables" does not exist
LINE 1: select count(*) from sde.sde_multibranch_tables
^
[Mon Jun 03 16:12:18 2019] MULTIBRANCH_TABLES table being created...
[Mon Jun 03 16:12:18 2019] MULTIBRANCH_TABLES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_logfile_pool" does not exist
LINE 1: select count(*) from sde.sde_logfile_pool
^
[Mon Jun 03 16:12:18 2019] LOGFILE_POOL tables being created...
[Mon Jun 03 16:12:18 2019] LOGFILE_POOL tables created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist
LINE 1: select count(keyword) from sde.sde_dbtune
^
[Mon Jun 03 16:12:18 2019] DBTUNE table being created...
[Mon Jun 03 16:12:18 2019] DBTUNE table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:12:18 2019] SERVER_CONFIG tables being created...
[Mon Jun 03 16:12:18 2019] SERVER_CONFIG tables created...
[Mon Jun 03 16:12:18 2019] S_get_functions_release prepare error.
[Mon Jun 03 16:12:18 2019] DBMS stored procedures being created or updated...
[Mon Jun 03 16:12:19 2019] DBMS stored procedures created or updated...
[Mon Jun 03 16:12:19 2019]
Successfully installed ArcSde.
[Mon Jun 03 16:12:19 2019] Successfully created GDB_Tables_Last_Modified table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_Items table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ItemRelationships table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ItemTypes table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ItemRelationshipTypes table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ReplicaLog table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_Locks table...
[Mon Jun 03 16:12:21 2019] ERROR Creating Geodatabase tables
, Error = -512
,EXT_Error = -51
,EXT_ERROR1 = ERROR: unsupported XML feature
DETAIL: This functionality requires the server to be built with libxml support.
HINT: You need to rebuild PostgreSQL using --with-libxml. (test.sde.gdb_items)
,EXT_ERROR2 = SQLSTATE=0A000
,
os: ubuntu server 16.04.6 64bit
postgresql: 9.5.5
arcgis server: 10.5
Client env:
os: windows server 2016 Datacenter
arcgis: 10.5
* 在服务器端编译安装完 postgresql以后，需要拓展 sde 来存放数据以及发布数据到 server的 arcgis server中.
* 按照官网的操作说明 http://desktop.arcgis.com/zh-c ... x.htm
中的操作， 全部检验过， 都没有问题. 变量， 权限.
* postgresql 9.5.5的拓展库文件的 md5 值
0ff80cced26f76847286bd6d45629a84 libst_raster_pg.so
66f41c5445075e36e6e75c4a7fecd3c4 PGSQLEngine.so
427e994cfc547a5ede92ca2eafb5da9d st_geometry.so
* 在 Client 机器中，连接 server机器的postgresql， 并创建 企业级数据库，创建时报错
报错日志如下.
------------------
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist
LINE 1: select count(*) from sde.sde_layers
^
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist
LINE 1: select count(keyword) from sde.sde_dbtune
^
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:11:39 2019] ST_GEOMETRY support being installed...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_coordinate_systems" does not exist
LINE 1: select count(*) from sde.sde_coordinate_systems
^
[Mon Jun 03 16:11:39 2019] COORDINATE_SYSTEMS table being created...
[Mon Jun 03 16:11:39 2019] COORDINATE_SYSTEMS table created...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "public.sde_spatial_references" does not exist
LINE 1: select count(object_flags) from public.sde_spatial_reference...
^
[Mon Jun 03 16:11:39 2019] SPATIAL_REFERENCES table being created...
[Mon Jun 03 16:11:39 2019] SPATIAL_REFERENCES table created...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_geometry_columns" does not exist
LINE 1: select count(*) from sde.sde_geometry_columns
^
[Mon Jun 03 16:11:39 2019] GEOMETRY_COLUMNS table being created...
[Mon Jun 03 16:11:39 2019] ev.SQLstate = 42P07
SDE DBMS Error: -62 ERROR: relation "sde_geometry_columns" already exists
[Mon Jun 03 16:11:39 2019] GEOMETRY_COLUMNS table created...
[Mon Jun 03 16:11:39 2019] ST_GEOMETRY support installed...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:12:18 2019] VERSION table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist
LINE 1: select count(minz) from sde.sde_layers
^
[Mon Jun 03 16:12:18 2019] LAYERS table being created...
[Mon Jun 03 16:12:18 2019] LAYERS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_metadata" does not exist
LINE 1: select count(object_database) from sde.sde_metadata
^
[Mon Jun 03 16:12:18 2019] METADATA table being created...
[Mon Jun 03 16:12:18 2019] METADATA table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_raster_columns" does not exist
LINE 1: select count(1) from sde.sde_raster_columns
^
[Mon Jun 03 16:12:18 2019] RASTER_COLUMNS table being created...
[Mon Jun 03 16:12:18 2019] RASTER_COLUMNS table created...
[Mon Jun 03 16:12:18 2019] TABLE_REGISTRY table being created...
[Mon Jun 03 16:12:18 2019] TABLE_REGISTRY table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_states" does not exist
LINE 1: select count(lineage_name) from sde.sde_states
^
[Mon Jun 03 16:12:18 2019] STATES table being created...
[Mon Jun 03 16:12:18 2019] STATES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_versions" does not exist
LINE 1: select count(*) from sde.sde_versions
^
[Mon Jun 03 16:12:18 2019] VERSIONS table being created...
[Mon Jun 03 16:12:18 2019] VERSIONS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_mvtables_modified" does not exist
LINE 1: select count(*) from sde.sde_mvtables_modified
^
[Mon Jun 03 16:12:18 2019] MVTABLES_MODIFIED table being created...
[Mon Jun 03 16:12:18 2019] MVTABLES_MODIFIED table created...
[Mon Jun 03 16:12:18 2019] STATE_LINEAGES table being created...
[Mon Jun 03 16:12:18 2019] STATE_LINEAGES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_locators" does not exist
LINE 1: select count(*) from sde.sde_locators
^
[Mon Jun 03 16:12:18 2019] LOCATORS table being created...
[Mon Jun 03 16:12:18 2019] LOCATORS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_xml_index_tags" does not exist
LINE 1: select count(tag_name) from sde.sde_xml_index_tags
^
[Mon Jun 03 16:12:18 2019] XML tables being created...
[Mon Jun 03 16:12:18 2019] Warning: Error querying tsearch2 system table schema. You will
need to grant select access to public to pg_ts_cfg,pg_ts_cfgmap
pg_ts_dict,pg_ts_parser for xml functionality
[Mon Jun 03 16:12:18 2019] XML tables created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_column_registry" does not exist
LINE 1: select count(*) from sde.sde_column_registry
^
[Mon Jun 03 16:12:18 2019] COLUMN_REGISTRY table being created...
[Mon Jun 03 16:12:18 2019] COLUMN_REGISTRY table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_archives" does not exist
LINE 1: select count(*) from sde.sde_archives
^
[Mon Jun 03 16:12:18 2019] ARCHIVES table being created...
[Mon Jun 03 16:12:18 2019] ARCHIVES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layer_stats" does not exist
LINE 1: select count(version_id) from sde.sde_layer_stats
^
[Mon Jun 03 16:12:18 2019] LAYER_STATS table being created...
[Mon Jun 03 16:12:18 2019] LAYER_STATS table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_branches" does not exist
LINE 1: select count(*) from sde.sde_branches
^
[Mon Jun 03 16:12:18 2019] BRANCHES table being created...
[Mon Jun 03 16:12:18 2019] BRANCHES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_branch_tables_modified" does not exist
LINE 1: select count(*) from sde.sde_branch_tables_modified
^
[Mon Jun 03 16:12:18 2019] BRANCH_TABLES_MODIFIED table being created...
[Mon Jun 03 16:12:18 2019] BRANCH_TABLES_MODIFIED table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_multibranch_tables" does not exist
LINE 1: select count(*) from sde.sde_multibranch_tables
^
[Mon Jun 03 16:12:18 2019] MULTIBRANCH_TABLES table being created...
[Mon Jun 03 16:12:18 2019] MULTIBRANCH_TABLES table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_logfile_pool" does not exist
LINE 1: select count(*) from sde.sde_logfile_pool
^
[Mon Jun 03 16:12:18 2019] LOGFILE_POOL tables being created...
[Mon Jun 03 16:12:18 2019] LOGFILE_POOL tables created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist
LINE 1: select count(keyword) from sde.sde_dbtune
^
[Mon Jun 03 16:12:18 2019] DBTUNE table being created...
[Mon Jun 03 16:12:18 2019] DBTUNE table created...
[Mon Jun 03 16:12:18 2019] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from sde.sde_server_config
^
[Mon Jun 03 16:12:18 2019] SERVER_CONFIG tables being created...
[Mon Jun 03 16:12:18 2019] SERVER_CONFIG tables created...
[Mon Jun 03 16:12:18 2019] S_get_functions_release prepare error.
[Mon Jun 03 16:12:18 2019] DBMS stored procedures being created or updated...
[Mon Jun 03 16:12:19 2019] DBMS stored procedures created or updated...
[Mon Jun 03 16:12:19 2019]
Successfully installed ArcSde.
[Mon Jun 03 16:12:19 2019] Successfully created GDB_Tables_Last_Modified table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_Items table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ItemRelationships table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ItemTypes table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ItemRelationshipTypes table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_ReplicaLog table...
[Mon Jun 03 16:12:20 2019] Successfully created GDB_Locks table...
[Mon Jun 03 16:12:21 2019] ERROR Creating Geodatabase tables
, Error = -512
,EXT_Error = -51
,EXT_ERROR1 = ERROR: unsupported XML feature
DETAIL: This functionality requires the server to be built with libxml support.
HINT: You need to rebuild PostgreSQL using --with-libxml. (test.sde.gdb_items)
,EXT_ERROR2 = SQLSTATE=0A000
,
0 个回复