Problem:  DBMS data fails to run in the background when using the 64-bit background geoprocessing option

相关信息
Article ID: 40675
Bug Id: N/A
Software:
ArcGIS for Desktop Advanced 10.1
ArcGIS for Desktop Standard 10.1
ArcGIS for Desktop Basic 10.1
Platforms:
Windows XP, Server 2003, Vista, Server 2008, Windows 7, Windows 8

问题描述
When using database management systems (DBMS) data with ArcGIS for Desktop 10.1 SP1's 64-bit Background Geoprocessing upgrade, processes fail with a variety of error messages. When run from the foreground, the same data works without issue.

For example, error messages could be:

• "error 000229 : Cannot Open <value>"
• "error 000622 : Failed to execute (<value>). Parameters are not valid."
• "error 000732 : <value>: Dataset <value> does not exist or is not supported."

原因
This is similar to problems registering a database from ArcGIS for Server 10.1. Some DBMS, such as Oracle, require the same client bit version as the processor that is used to manipulate the data.

For example, if only the 32-bit Oracle client was available after installing the 64-bit background geoprocessing upgrade, background geoprocessing using Oracle SDE data fails. Foreground geoprocessing would still work since it runs on the 32-bit processor which matches the currently available client on this machine.

Since ArcGIS Desktop is natively a 32-bit client, this also explains why the 32-bit client install allows for data to be processed in any Desktop version before the 10.1 SP1 64-bit Background Geoprocessing upgrade is installed.

Therefore, the machine must have both 32-bit and 64-bit clients installed if the 64-bit Background Geoprocessing Upgrade is installed on the machine.
已邀请:

易智瑞技术支持

赞同来自:

解决方案
To resolve the failures due to client communication issues, install the 64-bit client alongside the 32-bit version. Follow the instructions specific to the database used.


Setting up a connection to SQL Server Setting up a connection to Oracle Setting up a connection to PostgreSQL


其它相关参考
  1. Database Clients
  2. Background Geoprocessing (64-bit)
  3. Registering a database data store fails with 'Invalid database connection' or 'The data item is inaccessible'When registering a database data store in ArcGIS Server Manager, the following error occurs: "Invalid database connection" Attempting to register the same database data store in ArcGIS Desktop returns the error: "The data item is inacces...


创建及修改时间
Created: 11/20/2012

Last Modified: 7/12/2013
原文链接
http://support.esri.com/en/kno ... 40675

要回复问题请先登录注册