Problem Enable Geodatabase ArcGIS 10.1 SP1 + DB2 9.7 FP 4

2986
3
02-01-2013 03:22 AM
BrunoVogler
New Contributor II
Hi Guys

I have a problem with Enable Geodatabase.

We try "Enable Geodatabase" on ArcGIS 10.1 SP1 with DB2 9.7 Fix Pack 4.
Spatial Extender is enabled.
But we have this message:

******************************************************************
"Executing: EnableEnterpriseGeodatabase "Database Connections\Connection to db2.sde" "\\arcgis101\c$\Program Files\ESRI\License10.1\sysgen\keycodes.ecp"
Start Time: Wed Jan 09 13:56:24 2013
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
[Invalid parameter value passed to function]
Could not create  geodatabase tables and stored procedures.
Failed to execute (EnableEnterpriseGeodatabase).
Failed at Wed Jan 09 13:56:24 2013 (Elapsed Time: 0,00 seconds)"
******************************************************************

I try create a table directly on DB2 using sde user and has succesfully.

Keycode is valid.

Any idea of what is the problem?

Regards,
Andres
0 Kudos
3 Replies
MarcoBoeringa
MVP Regular Contributor
Have you verified you have all required privileges, especially those listed under the "Geodatabase administrator" section in the Help link below?:

User privileges for geodatabases in DB2
http://resources.arcgis.com/en/help/main/10.1/index.html#//00290000003m000000
0 Kudos
BojanBukovic
New Contributor
Hello,

have you managed to resolve the issue?
We are having the same issue now, triple checked the privileges and still no luck.

Thank you in advance!

Regards

Hi Guys

I have a problem with Enable Geodatabase.

We try "Enable Geodatabase" on ArcGIS 10.1 SP1 with DB2 9.7 Fix Pack 4.
Spatial Extender is enabled.
But we have this message:

******************************************************************
"Executing: EnableEnterpriseGeodatabase "Database Connections\Connection to db2.sde" "\\arcgis101\c$\Program Files\ESRI\License10.1\sysgen\keycodes.ecp"
Start Time: Wed Jan 09 13:56:24 2013
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
[Invalid parameter value passed to function]
Could not create  geodatabase tables and stored procedures.
Failed to execute (EnableEnterpriseGeodatabase).
Failed at Wed Jan 09 13:56:24 2013 (Elapsed Time: 0,00 seconds)"
******************************************************************

I try create a table directly on DB2 using sde user and has succesfully.

Keycode is valid.

Any idea of what is the problem?

Regards,
Andres
0 Kudos
BojanBukovic
New Contributor
Never mind, there is a note in the documentation that says "You cannot use a DSNless connection when enabling geodatabase functionality or upgrading a geodatabase."

Taking this into account fixed the problem.


Hello,

have you managed to resolve the issue?
We are having the same issue now, triple checked the privileges and still no luck.

Thank you in advance!

Regards
0 Kudos