search

Esri / geoportal-server

Geoportal Server is a standards-based, open source product that enables discovery and use of geospatial resources including data and services.
https://gptogc.esri.com/geoportal
Apache License 2.0
244 stars 149 forks source link

Moving to SQL server 2012 #243

Open olivernm opened 7 years ago

olivernm commented 7 years ago

Our current geoportal (1.2.0) is running using SS 2008r2. We recently stood up a new db server running SS 2012 and migrated the geoportal db over. i would like the geoportal application to use this new server and db. To that end, I modified the geoportal.xml to reflect the new server name,, restricted access to the old db, and restarted the apache tomcat service.

Searching for data works, but when viewing 'details', i cannot view any information. It cannot perform the action.

Are there any other parameters that need to be changed to point to the new db server ?

Thanks !

mhogeweg commented 7 years ago

have you checked the logs? I suspect an issue in the connection to SQL Server and there are a few common issues: https://github.com/Esri/geoportal-server/wiki/Database-problems

olivernm commented 7 years ago

Thank you, I will scope the logs as well as the link. I inherited this system, so I am trying to figure it out.

From: Marten [mailto:notifications@github.com] Sent: Tuesday, September 06, 2016 6:02 PM To: Esri/geoportal-server Cc: Mohar, Oliver; Author Subject: Re: [Esri/geoportal-server] Moving to SQL server 2012 (#243)

have you checked the logs? I suspect an issue in the connection to SQL Server and there are a few common issues: https://github.com/Esri/geoportal-server/wiki/Database-problems

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Esri/geoportal-server/issues/243#issuecomment-245110071, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AVBAxnuqc7j-s5_x42fHtweME3rQ1vljks5qneLTgaJpZM4J2QgS.

olivernm commented 7 years ago

Marten, you were absolutely right, there was a communication issue between the web server and the db server. The new db server was moved outside the firewall and given a new port. Opening the firewall and changing the geoportal.xml resolved this.

The only issue I am having as of now is that I receive the following on SOME of the data sets, (many others work) when I click on the ‘Details’ button:

[cid:image001.png@01D21B09.18BB4F30] geoportal

geoportal

When they stood up the new db server, they migrated the geoportal db. I have not updated that from the old db server recently. I tried synchronizing, that did not help. Do some of the tables in the geoportal db need to be brought over from the old db or should I restore the old db onto the new db server to ‘refresh’ it ?

Thanks !

From: Marten [mailto:notifications@github.com] Sent: Tuesday, September 06, 2016 6:02 PM To: Esri/geoportal-server Cc: Mohar, Oliver; Author Subject: Re: [Esri/geoportal-server] Moving to SQL server 2012 (#243)

have you checked the logs? I suspect an issue in the connection to SQL Server and there are a few common issues: https://github.com/Esri/geoportal-server/wiki/Database-problems

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Esri/geoportal-server/issues/243#issuecomment-245110071, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AVBAxnuqc7j-s5_x42fHtweME3rQ1vljks5qneLTgaJpZM4J2QgS.