Latest Contributions by JustinClowes

‎11-01-2018

Hi Cody, overnight the datastore seems to have sorted itself out and now appears valid in ArcGIS Server Manager. I'm still testing to see if everything is working but I'd like to establish what might have happened. ArcGIS Server (also the Hosting Server) and the Relational DataStore are both on the same machine. Is this causing problems? Would it be a resource issue? thanks

‎10-31-2018

thanks Jake, my licence has not changed but I ran updatelicense anyway and I get the message "Update license failed for managed geodatabase 'db_71scs'". I can't understand how the DataStore appears valid in the admin page (see below) but cannot be validated in ArcGIS Server Manager or Portal. Any ideas? { "datastore.release": "10.5.0.6491", "datastore.name": "ds_ztnjb5og", "datastore.replmethod": "ASYNC", "datastore.isConfigured": "true", "machines": [{ "machine.overallhealth": "Healthy", "datastore.release": "10.5.0.6491", "datastore.release.configstore": "1.2", "platform": "Windows", "machine.isReachable": "true", "hostip": "10.144.8.184", "name": "GBMNC0-APP025.EUROPE.JACOBS.COM", "role": "PRIMARY", "dbport": 9876, "healthcheck.enable": "true", "status": "Started", "adminurl": "https://MYSERVER:2443/arcgis/datastoreadmin/", "db.isactive": "true", "db.isAccepting": "true", "db.isInRecovery": "false", "db.ActiveReplMethod": "NONE", "db.isManagedUserConnValid": "true", "datastore.release.pg": "9.3.12", "datastore.release.sde": "105000", "datastore.release.geometry": "1.12.1", "datastore.release.geometrylib": "1.12.1", "db.isSiteConnValid": "true" }], "datastore.release.configstore": "1.2", "datastore.release.geometry": "1.12.1", "datastore.release.geometrylib": "1.12.1", "datastore.release.sde": "105000", "datastore.release.pg": "9.3.12", "datastore.status": "Started", "datastore.isActiveHA": "false", "datastore.overallhealth": "Healthy", "datastore.lastfailover": -1, "datastore.lastbackup": 1540981652086, "datastore.isRegistered": "true", "datastore.hasValidServerConnection": "true", "datastore.validServerMachinesList": [{ "machineName": "MYSERVER", "adminURL": "https://MYSERVER:6443/arcgis/admin" }], "owningSystemUrl": "https://mydomain/arcgis" }

‎10-31-2018

Suddenly we are having trouble with our Relational Datastore on ArcGIS Enterprise 10.5.. If you validate the Hosting server in Portal you receive "failed to validate the server managed database". If you validate the Relational DataStore in ArcGIS Server it fails. If you go to validate the DataStore in arcgis/admin then it all seems to be valid and ready for requests. If we restart the servers (ArcGIS and Portal) then the issue is temporarily resolved - the DataStore and Hosting server are valid. You can successfully publish hosted layers. After a while it goes wrong again. Looking in the ArcGIS Server Manager logs we can see messages such as : Service containing process crashed for 'MyService.MapServer'. Please see if an error report was generated in 'C:\arcgisserver\logs\SERVERNAME\errorreports'. To send an error report to Esri, compose an e-mail to ArcGISErrorReport@esri.com and attach the error report file. Any ideas? Could it be a hosted layer in the DataStore which is causing the problem? Any help would be great.

‎06-24-2014

I'm using the ArcGIS Server JS API to store a new feature using ApplyEdits. The feature is created sucessfully. One of the feature attributes is a datetime field. The field value is defined like this: dt = new Date(2014, 6, 24, 10, 32); fieldvalue = dt.valueOf(); The time of 10:32 goes into the database as 1402997520000 (the primitive value) In the SQL Server database the time reads 10:32 When I retrieve the datetime value using the JS API the primitive value is 1402997519999, which displays as : 10:31.5999 Where am I going wrong?

‎02-09-2014

Thanks, that works perfectly with SQL Server too. Problem solved.

‎02-07-2014

thanks, yes I'm trying to write to a datetime field (in SQL Server) and I need to include both the date and the time. I need to write a specific date + time, not the current date

‎02-06-2014

I'm trying to create a new feature using featureLayer.applyEdits. I pass in the geometry and attributes and this is saved to the database correctly. When I try and save a datetime attribute I get the error : "Error saving new find : Unable to complete operation". Does anyone know what format the datetime needs to be in? I am using ArcGIS Server v10 with SQL Server 2008. Thanks. See my code below: var datetime = dojo.date.locale.parse("07/02/2014 13:54", { datePattern:"dd/MM/yyyy", timePattern:"HH:mm" } ); var attr = { "DATE_TIME_J" : datetime }; var ng = new esri.Graphic(Point, null, attr, null); featureLayer.applyEdits([ng], null, null, ........

Online Status	Offline
Date Last Visited	‎11-30-2022 07:55 PM

My Ideas

Latest Contributions by JustinClowes

Re: ArcGIS Portal : Federated server - "failed to validate the server managed database"

Re: ArcGIS Portal : Federated server - "failed to validate the server managed database"

ArcGIS Portal : Federated server - "failed to validate the server managed database"

problems retrieving correct datetime value from SDE/SQL Server

Re: problems saving datetime to SDE via applyedits

Re: problems saving datetime to SDE via applyedits

problems saving datetime to SDE via applyedits

ArcGIS Portal : Federated server - "failed to vali...