POST
|
Hi Vince Thanks for you help. I've changed my way to import the data and I've used Import XML Workspace Document after I've exported. The import process failed with this error message "Field is not editable" in the ArcCatalog and ERROR out of memory in the PostgreSQL log file. Patch finder output **********************ArcSDE install summary:********************** ArcSDE 10.1 PostgreSQL (64-bit) Install Location: /arcsde/base/arcgis/sdeexe101 *********ArcGIS Server install summary:******** ArcGIS 10.1 for Server Install Location: /arcsde/base/arcgis/server Service Pack / Patch / Hot Fix Found: SP-ID: ArcGIS 10.1 SP1 for Server Date Installed: 05/15/13 04:53:04 ArcGIS 10.1 for Desktop ArcGIS 10.1 SP1 for Desktop ArcGIS VBA Compatibility 10.1 ArcGIS 10.1 Data Interoperability for Desktop ******************************************************************* Log file ..... pg_foreign_server_name_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_conversion_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_user_mapping_user_server_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_conversion_name_nsp_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_authid_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_auth_members_member_role_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_tablespace_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_database_datname_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_auth_members_role_member_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_database_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_authid_rolname_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used MdSmgr: 8192 total in 1 blocks; 2944 free (4 chunks); 5248 used LOCALLOCK hash: 24576 total in 2 blocks; 9808 free (4 chunks); 14768 used Timezones: 83472 total in 2 blocks; 3744 free (0 chunks); 79728 used ErrorContext: 8192 total in 1 blocks; 8160 free (0 chunks); 32 used ERROR: out of memory DETAIL: Failed on request of size 232. CONTEXT: SQL statement "UPDATE corp.sde.sde_layers SET minx = new_minx, miny = new_miny, maxx = new_maxx, maxy = new_maxy, minz = new_minz, maxz = new_maxz, minm = new_minm, maxm = new_maxm WHERE layer_id = i_layer_id" PL/pgSQL function "sde_layer_def_envelope_update" line 7 at SQL statement STATEMENT: SELECT corp.sde.SDE_layer_def_envelope_update ( $1, $2, $3, $4, $5, $6, $7, $8, $9) TopMemoryContext: 221792 total in 28 blocks; 25808 free (142 chunks); 195984 used TopTransactionContext: 8192 total in 1 blocks; 6448 free (0 chunks); 1744 used CurTransactionContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used PL/pgSQL function context: 24576 total in 2 blocks; 2776 free (2 chunks); 21800 used PL/pgSQL function context: 24576 total in 2 blocks; 11856 free (2 chunks); 12720 used PL/pgSQL function context: 24576 total in 2 blocks; 15824 free (2 chunks); 8752 used PL/pgSQL function context: 24576 total in 2 blocks; 8680 free (2 chunks); 15896 used PL/pgSQL function context: 57344 total in 3 blocks; 16536 free (1 chunks); 40808 used PL/pgSQL function context: 24576 total in 2 blocks; 17176 free (2 chunks); 7400 used PL/pgSQL function context: 24576 total in 2 blocks; 17336 free (3 chunks); 7240 used PL/pgSQL function context: 57344 total in 3 blocks; 32528 free (2 chunks); 24816 used PL/pgSQL function context: 57344 total in 3 blocks; 30552 free (1 chunks); 26792 used RI compare cache: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used RI query cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 used PL/pgSQL function context: 24576 total in 2 blocks; 9480 free (2 chunks); 15096 used .....
... View more
06-03-2013
05:06 PM
|
0
|
0
|
1076
|
POST
|
Thank for that, Is this the correct steps? create enterprise Geodatabase enable enterprise Geodatabase create roles create database users create schemas Could you please provide the link for the documentation. Thanks
... View more
05-08-2013
04:17 PM
|
0
|
0
|
303
|
POST
|
Hi everyone. where is the install option in ArcSDE 10.1. It was exist in ArcSDE 10, but not exist in ArcSDE 10.1 I've used this command line to install it on ArcSDE 10. ./sdesetup -o install -d POSTGRESQL -D corpdb -u sde -p sde -l /u01/sde/authorization.ecp How to do the same for ArcSDE 10.1 ArcSDE 10.1 Setup Setup Administration Utility ----------------------------------------------------- Usage for ./sdesetup: -? -h -o delete -d {ORACLE10G|ORACLE11G} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-i <master_geodatabase_service>[:<user_schema>]] [-N] -o list -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>] [-s <datasource>] [-i <master_geodatabase_service>[:<user_schema>]] [-q] -o update_key -d {ORACLE10G|ORACLE11G|SQLSERVER| DB2|DB2ZOS|INFORMIX|POSTGRESQL} -l <key> [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-H <sde_directory>] [-D <database>] [-s <datasource>] [-N] [-i <master_geodatabase_service>[:<user_schema>]] [-q] -o install_st_raster -d {ORACLE10G|ORACLE11G|SQLSERVER|POSTGRESQL} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>] [-s <datasource>] [-N] [-l <key>] [-q] ============================================== ============================================== ArcSDE 10.0 Setup Setup Administration Utility ----------------------------------------------------- Usage for sdesetup: -? -h -o install -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>] [-s <datasource>] [-N] [-i {<master_geodatabase_service>[:<user_schema>] | :sde} ] [-l <key>] [-q] -o upgrade -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>] [-s <datasource>] [-N] [-i <master_geodatabase_service>[:<user_schema>]] [-l <key>] [-q] -o delete -d {ORACLE10G|ORACLE11G} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-i <master_geodatabase_service>[:<user_schema>]] [-N] -o list -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>] [-s <datasource>] [-i <master_geodatabase_service>[:<user_schema>]] [-q] -o update_key -d {ORACLE10G|ORACLE11G|SQLSERVER| DB2|DB2ZOS|INFORMIX|POSTGRESQL} -l <key> [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-H <sde_directory>] [-D <database>] [-s <datasource>] [-N] [-i <master_geodatabase_service>[:<user_schema>]] [-q] -o install_st_raster -d {ORACLE10G|ORACLE11G|SQLSERVER|POSTGRESQL} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>] [-s <datasource>] [-N] [-l <key>] [-q] -o prerequisite_check -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL} [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>] [-s <datasource>] [-N] [-q] Thanks
... View more
05-07-2013
09:45 PM
|
0
|
4
|
737
|
POST
|
Thank you Kasia Yes you are right, I have to make the default storage is PG_GEOMETRY in dbtune. Thanks a lot.
... View more
03-10-2011
02:14 PM
|
0
|
0
|
311
|
POST
|
How to populate Empty public.geometry_columns in ArcSDE 10. I�??ve used ArcCatalog �??ArcInfo (10) to import feature class to geodatabase (multiple) from one database to another. But I find out that the public.geometry_columns is empty. From Database: select version(); version ---------------------------------------------------------------------------------------------------- PostgreSQL 8.3.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10) ArcSDE 9.3 PostGIS 1.4.2 To Database select version(); version ------------------------------------------------------------------------------------------------------- PostgreSQL 8.4.5 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit ArcSDE 10 PostGIS 1.4.2 So how to populate public.geometry_columns. Thanks
... View more
03-06-2011
02:46 PM
|
0
|
3
|
991
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|