topic Re: Project Package to Enterprise Database unsaved password in ArcGIS Pro Questions

Project Package to Enterprise Database unsaved password

JimmyBowden — Thu, 02 Jan 2020 21:48:30 GMT

Using ArcGIS Pro 2.4.3. I'm attempting to create a project package that is connected to an enterprise database (Oracle or postgres). The aprx was created with no user/password saved, so that credentials have to be entered each time the aprx is opened. When I attempt to publish this project I am prompted for a Database connection username and password as expected. When I enter a username and password and hit Ok, a new Database dialog comes up (this continues every time I hit ok. If I cancel a message saying "Failed to connect to the specified server." Then the Share Project Package fails.

I checked the logs on our postgres server and it doesn't seem to even try to connect. On a co workers machine the Database connection dialog doesn't come up but the process fails.

Error message: ERROR 001707: Data cannot be opened: SDE(SERVER=development;INSTANCE=sde:oracle11g:development;DBCLIENT=oracle;DB_CONNECTION_PROPERTIES=development;PROJECT_INSTANCE=sde;VERSION=SDE.DEFAULT;AUTHENTICATION_MODE=DBMS)

Should we be able to create a project package without storing a username and password? arcgispro 2.4 project package

Re: Project Package to Enterprise Database unsaved password

JimmyBowden — Tue, 14 Jan 2020 17:56:10 GMT

Created a support case for this and it was a known issue. Expected to be fixed in 2.5.

Re: Project Package to Enterprise Database unsaved password

AndrewHargreaves1 — Thu, 23 Apr 2020 16:19:42 GMT

I'm using Pro 2.5 but experiencing something similar. Here's my setup:

Pro Doc accessing Feature Services through a AGO group
Feature Services are simply items within AGO, referring to ArcGIS Server services
These services have a password, which is embedded when registering the URL in AGO

It all works in Pro, but when attempting the package the Project I get:

ERROR 001707: Data cannot be opened:

I assume this is perhaps due to what you mention, that the password to access to services isn't being passed to Pro during the packaging process? JIMMY BOWDEN‌ do you have the case number in order to track progress?

Thanks

Re: Project Package to Enterprise Database unsaved password

AndrewHargreaves1 — Mon, 13 Jul 2020 21:28:06 GMT

Now at 2.5.2 and still no fix.

Re: Project Package to Enterprise Database unsaved password

DevinWelty1 — Thu, 08 Oct 2020 18:43:36 GMT

Does anyone have a solution to this? I really need to package up the maps and data for this project to share. The data is on AGOL....

Thanks

Re: Project Package to Enterprise Database unsaved password

GlenColgate1 — Thu, 07 Apr 2022 17:58:11 GMT

Now at 2.9.2 and this still appears to be an issue.

Only work around that I have been able to come up with is:

Setup map with data connection where user/password is saved.
Run Package Project to success
Deselect the Save User/Password in the database connection
Run Package Project again

If the Package Project is run first with the database connection where user/password is NOT saved no subsequent packages will be successful. Only if the first attempt at Project Package is run with saved credentials will the second run without saved credentials work. I have only tried this with a sde connection file saved in the project folders.

Seems to work for me. Hope this helps others.