nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Portal Change Content Directory Error

ryanuthoff

I am in the process of migrating Portal to a new machine. I am following ESRI's documentation to migrate to a new machine, but I am having issues when changing the content directory on the new machine from the shared network location to the local drive of the new machine. This is the error I am receiving in the Portal Administrator Directory after providing the new file path:

com.esri.arcgis.portal.admin.core.PortalException: java.lang.Exception: Rollback: SQLException in put, Batch entry 0 UPDATE cp_container SET parent_container_name=NULL, etag='1551904251440' WHERE container_name='/' was aborted: ERROR: cannot execute UPDATE in a read-only transaction Call getNextException to see other errors in the batch.

Any thoughts on what this could be?

Najděte více příspěvků označených jako

Accepted answers

JonathanQuinn

Any operation that involves writing to the database, (which happens during joinSite), will fail. Do you have a recovery.conf within the db directory on the machine? If so, try to rename it to recover.conf_bck or something, or move it out of the directory entirely, and restart Portal.

All comments

DanielCota1

Hi Ryan Uthoff‌

On the surface, it sounds like this error is alluding to the fact that the underlying database that Portal runs off of is in a read-only mode. As implied, no SQL commands can be done to modify that content directory location. That being said, I did want to ask if this was the documentation you were following:

Changing the portal content directory—Portal for ArcGIS (10.6) | ArcGIS Enterprise

If so, the part that I wanted to emphasize was granting full control permissions to the service account that is running Portal for ArcGIS for the new directory location -- Step 3.

Was this done?

-Daniel

ryanuthoff

Hello,

Thank you for your response. I did verify the content directory (both the middle step of the file share location and the final destination of the content directory) have full permissions to the folder. I'm logging into Windows as the same account as the Portal service account is running as, and it has full administrative privileges. I also verified the entire arcgisportal folder has full permissions as well.

I do have a case open with ESRI Technical Support, and the person I am working with watched me follow the migration procedures step by step and he couldn't find anything unusual or anything I'm doing wrong.

JonathanQuinn

Did you remove the primary/original machine? It sounds like the database on the remaining machine, or new primary, isn't set to read/write, but read-only which is the expected state of the database on the standby.

ryanuthoff

If you are referring to step 4 under "Migrate a machine running Portal for ArcGIS" in this article where I unregister the primary/old machine with the new machine, then yes I have done that.

Migrate to new machines—Portal for ArcGIS (10.6) | ArcGIS Enterprise

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.