Select to view content in your preferred language

Got error when registered a DB2 database

7882
11
04-18-2014 01:18 AM
by Anonymous User
Not applicable
Original User: lisa_qian

Our server is 64-bits windows 2008 R2 Enterprise. The DB2 installed was 64-bits which includes client with both 64 and 32 bits drivers. We installed ArcGIS server and ArcGIS Desktop 10.2.1. We have enabled geodatabase successfully. Then we were trying to register database using ArcCatalog or ArcGIS server. There is no problem in the database connection from ArcCatalog (using configured ODBC either from 32-bit or 64-bit ODBC configuration). But when we tried to use that connection sde file or input manually, we got error as below.
The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error[Unknown errorNo extended error.] DataValidator.GPServer

Could anybody help to identify the reason why this failed? Thanks!

[ATTACH=CONFIG]33190[/ATTACH]
[ATTACH=CONFIG]33191[/ATTACH]
[ATTACH=CONFIG]33192[/ATTACH]
0 Kudos
11 Replies
by Anonymous User
Not applicable
Original User: lisa_qian

More information: DB Directory list

[ATTACH=CONFIG]33212[/ATTACH]
0 Kudos
LisaQian
Emerging Contributor
Contacting ESRI Neeta, we finally got this problem resolved by adding the user arcgis to DB2USERS, DB2ADMNS and Administrators, and restarted the server. We focused on the user sde instead of arcgis before. That's the problem.
Thanks a lot for the information, Neeta!

[ATTACH=CONFIG]33363[/ATTACH]
0 Kudos