POST
|
For reference purpose to whom so ever looks at this post in future to find a solution: We logged a BUG by reaching out to ESRI: BUG-000169197 : Unable to view related records when configuring the pop-up in Scene Viewer. Workaround Publish the data as a web scene from ArcGIS Pro. Open the published web scene in ArcGIS Pro> add the related table to pop up and save. Hope it helps!
... View more
Sunday
|
0
|
0
|
12
|
POST
|
Hello @EricErtl , Yes, that would be my understanding to this as each service machine handles licenses individually. For reference see section "Data requirements" (highlighted section) on the documentation. You will notice it specifically says "each machine". Hope it helps!
... View more
2 weeks ago
|
0
|
0
|
44
|
POST
|
Hello @NevraÇorapsız, Adding to what @jcarlson, the main question I would also like to understand, is "WHY". It would be good to know why that concern to access the data actually rises. Perhaps, we can look into the workflow you are trying to accomplish by this and maybe improve on that.So there is no need for accessing the datastore. Hope it helps!
... View more
2 weeks ago
|
0
|
0
|
80
|
POST
|
Hello @TamerAssaf , A good way to isolate this would be to perform following steps: Add the service to Map viewer and try to perform the edit operation If that succeeds, the issue may be in configuration of Web App Builder. If that fails then the issue is for sure is with the Feature service If this turns out to be an issue with Web App Builder, it would be great of you can share the details requested by @ShaneONeill_144 in above comment If this is a feature service issues, we can try following to isolate the cause: Switch the ArcGIS Server logging level to "DEBUG" and perform the edit operation again, this will allow the ArcGIS Server to record detailed messages. It would be great if you can share that. Try to edit the data by connecting to the Database (SQL/Oracle/Any other) from a desktop client (ArcGIS preferably) and check if you are able to edit. If that succeeds, the issue may be in configuration of service in ArcGIS Server If that fails then the issue is for sure on the data level and you would need to check all those configuration Another, goo this to figure out would be that "has this started happening recently, if so, we there any changes made to configuration of the Dataset or ArcGIS Server service? It would also help if you can share the version details of ArcGIS, Type of Databases, Version of database and configuration of all of the above. This will allow us to understand the environment better. Hope it helps!
... View more
2 weeks ago
|
1
|
0
|
47
|
POST
|
Hello @BenClark , A good place to start to fix this would be add windows firewall exceptions for the following exes and ports : Adding an exception : https://youtu.be/2AcqibSJ8ng?si=etakPzh0vcmh9p93&t=47 Programs: %ProgramFiles%\ArcGIS\Server\framework\etc\service\bin\ArcGISServer.exe %ProgramFiles%\ArcGIS\Server\framework\runtime\ArcGIS\bin\ArcSOC.exe %ProgramFiles%\ArcGIS\Server\framework\runtime\jre\bin\rmid.exe %ProgramFiles%\ArcGIS\Server\framework\runtime\jre\bin\javaw.exe Ports : https://enterprise.arcgis.com/en/server/latest/install/windows/ports-used-by-arcgis-server.htm Directories: \arcgisserver\directories\arcgiscache\ \arcgisserver\directories\arcgisjobs\ \arcgisserver\directories\arcgisoutput\ \arcgisserver\directories\arcgissystem \ \arcgisserver\config-store\ A documentation which helps me a lot in these scenarios is "ArcGIS Antivirus Guidance " (It's a bit old but the logic remains the same) Hope it helps!
... View more
2 weeks ago
|
1
|
0
|
137
|
POST
|
Hello @NaveedAhmed2 , Thanks for sharing these. I agree with @CodyPatterson that there is nothing suspicious which is visible in these screenshot. However, I would also request if you can share a copy of the ArcGIS Data Store logs perhaps something may show up there. In regards to bat script can be created to run the changedatastoremode. I think you can schedule that to run at machine start up after reboot. So it will run every time you restart the Server. kindly find a sample below: Save the file with a .bat extension, for example, set_datastore_readwrite.bat. @echo off cd "<ArcGIS Datastore installation directory>\tools" managedb changedatastoremode --mode readwrite --store relational Place this batch file in the Windows Startup folder or use Task Scheduler to run it at startup. Hope it helps!
... View more
2 weeks ago
|
1
|
0
|
84
|
POST
|
Hello @NaveedAhmed2 , In addition to what @CodyPatterson has mentioned. It would be great if you can check ArcGIS DataStore logs and if they show anything in regards to this. A documentation which can help with that : Access log files Additionally, we can also try to utilize some DataStore command line utilities to help us dig deeper, if you can share the screenshot of the following, that would help in understanding the issue: describedatastore Check for and install software patches and updates Hope it helps!
... View more
2 weeks ago
|
1
|
1
|
102
|
POST
|
Hello @gisarchitect @RedaAli While I may not be able to address all of your concerns, I will do my best to answer as many as I can. Kindly find the details below (Hope it doesn't end up being a boring response 😁😞 Connection Pooling and Management: How does ArcGIS Server handle database connections in this scenario? Does it use connection pooling to manage and reuse connections efficiently? ArcGIS Server uses connection pooling to manage and reuse database connections efficiently. Connection pooling minimizes the overhead of opening and closing database connections by keeping a pool of active connections that can be reused by different service instances. Even if the ArcGIS Server is not utilizing the database, it will still have a "sleeping connection" to the database. You can validate this by querying the "sys.dm_exec_sessions" table in SQL Server with "s.login_name = 'RegisteredwithArcGISServer' AND s.status IN ('running', 'sleeping')". If 20 users are accessing the feature service simultaneously, does this result in 20 individual connections to SQL Server, or are connections pooled and shared across instances? When 20 users access the feature service simultaneously, ArcGIS Server will not necessarily create 20 individual connections to SQL Server. Instead, it uses a pool of connections that are shared across service instances. The exact number of connections depends on the configuration of the service and the demand placed on the server, which controls the connections created by ArcGIS Server. Service Instance Configuration: Given that the feature service has a maximum of 20 instances, does this configuration imply that up to 20 connections could be established with the SQL Server, assuming high load? Yes, up to 20 connections could potentially be established with SQL Server. This assumes that each instance requires a separate connection and that all instances are actively serving requests. However, if a connection completes a request and is free, it will be reused instead of creating a new connection. What best practices can be followed to configure the minimum and maximum number of service instances to optimize connection usage? This depends on several variables, with the major factor being "how fast the service can address the request from the client." The faster it addresses the request, the sooner that instance will be free to answer new requests. If the instance is reused, so is the DB connection (no new connection needed). These are controlled by a few properties on the service, including: Maximum time a client can use a service Maximum time a client will wait to get a service Maximum time an idle instance can be kept running Recycling Documents that would help in extensively understanding these capabilities include: Tune and configure services Configure service instance settings Anticipate and accommodate users Additionally, what helps me a lot is "monitoring and adjustment," i.e., regularly monitoring the usage of service instances and adjusting the configuration as needed. Tools like ArcGIS Monitor can help track service performance and database connection usage. Registered connection files in ArcGIS Server When multiple geodatabases are registered from the same SQL Server instance, does this count as multiple users even if they are connected using the same SQL Server user account? This depends on the architecture you want to apply. Database Authentication: Essentially, ArcGIS Server will use the account you used to register the database connection, so all connections to SQL will show that account. In this case, you can create a separate account in SQL Server specifically for ArcGIS Server and use that for all connections (not recommended if you want editor tracking). Operating System Authentication: In this case, use a domain account/local account with the same username and password on both the SQL and ArcGIS Server machines for the ArcGIS Server service. Add it as a login to the SQL Server instance and map it to a user you create in the database. ArcGIS Server will use this account to connect to the database. This would fall under the licensing process you are referring to. From what I could understand from different blogs, When multiple geodatabases are registered from the same SQL Server instance, each connection to the SQL Server counts as a separate user or device from a licensing perspective, even if they are connected using the same SQL Server user account. This is because SQL Server Client Access Licenses (CALs) are based on the number of distinct connections, not just the user account used for those connections. I can say that I am no expert in SQL Server Licensing. Hence, I did some research on this and read a lot of blogs and in these cases YouTube videos help me a lot. I will try to summarize what I could understand briefly Licensing Obligations: Multiple Users or Devices: Each connection to the SQL Server, whether coming from different geodatabases or multiple instances of the same geodatabase, counts towards your SQL Server CALs. Thus, you need to license based on the number of unique connections rather than the single user account. Connection Pool Consideration: The connections in the pool represent the number of distinct sessions or instances that interact with SQL Server. Licensing should account for these connections as each connection could potentially be a different user or device. Licensing Based on Connection Pool: SQL Server CALs: We need to consider and keep in mind to license SQL Server based on the total number of connections expected in the connection pool, not just the user account used to establish those connections. Each connection pool entry is treated as a distinct user or device for licensing purposes. Key Points (From various sources) Multiple Geodatabases: If you have multiple geodatabases registered from the same SQL Server instance, each connection from these geodatabases counts as a separate user or device. Single User Account: Licensing could not be based solely on the single SQL Server user account but rather on the number of concurrent connections in the connection pool. Compliance: We can ensure compliance by licensing the maximum number of concurrent connections to SQL Server, reflecting the actual usage and number of connections that may be active at any given time. Ensuring Compliance with SQL Server Standard Edition Licensing Constraints Furthermore, again from reading different blogs and this time some YouTube Videos as well, SQL Server Standard Edition has licensing constraints based on the number of connections, here are some strategies and configurations to help ensure compliance and avoid exceeding these limits: Strategies to Manage and Limit Concurrent Connections Optimize Connection Pooling: Connection Timeout Settings: Configure shorter idle timeouts for connections to ensure that unused connections are promptly closed. This helps in keeping the number of active connections within the limits. Max Pool Size: Set the maximum pool size for database connections to a value that complies with your SQL Server licensing. This can be configured in the database connection string used by ArcGIS Server. Configure Service Instances: Minimum and Maximum Instances: Set appropriate minimum and maximum instances for your ArcGIS Server services. By limiting the maximum number of instances, you can control the number of concurrent connections to SQL Server. Instance Recycling: Configure service instance recycling to periodically release and refresh instances, helping to manage the connection pool more effectively. Monitor and Adjust: Monitoring Tools: Use tools like ArcGIS Monitor and SQL Server Management Studio to track the number of active connections, monitor usage patterns, and identify peak usage times. Alerts and Notifications: Set up alerts to notify you when the number of active connections approaches the licensing limit, allowing you to take preemptive action. Implement Efficient Query Practices: Optimize Queries: Ensure that your queries are optimized to reduce the load on SQL Server, thus potentially reducing the number of connections required. Batch Processing: Where possible, use batch processing to handle multiple requests within a single connection. Load Balancing: Distribute Load: If feasible, distribute the load across multiple SQL Server instances. This can help in spreading out the connections and avoiding overloading a single instance. User and Connection Management: Dedicated Accounts: Create dedicated SQL Server accounts for different services or applications to better track and manage connections. User Session Management: Implement policies to manage user sessions, such as limiting the duration of sessions or enforcing logouts after a period of inactivity. Configuration Examples Example of Connection String with Max Pool Size: Sample query: Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Max Pool Size=50;Connection Timeout=30; Setup Service Instance Configuration in ArcGIS Server in association accordingly Example of Monitoring Setup: ArcGIS Monitor: Set up to track active connections, instance usage, and performance metrics. SQL Server Management Studio: As mentioned before you can monitor “sys.dm_exec_sessions” table and monitor that for “s.session_id = c.session_id” (could be more detailed as well). Hopefully this doesn't cause more confusion. I understand that the response is a bit long but I tried to keep it as short as possible and not miss out on any key points. Hope it helps!
... View more
2 weeks ago
|
1
|
1
|
97
|
POST
|
Hello @CW-GIS , It would be great if you can share details from the logs generated by WebGISDr process (usually created where you store the properties file). It will help us in understanding at which step this is failing/which steps take such long time. Additionally, an easy way to isolate this problem is to switch Portal logging level to "DEBUG" and run "exportsite" operation from Portal Admin endpoint by following the steps in below document : https://developers.arcgis.com/rest/enterprise-administration/portal/export-site/#file-store-request-parameters While this is running check Portal logs with "DEBUG" for more detailed error message which will help in understanding (If possible share that here) Note : Remember to switch the logging back to way it was otherwise it can consume a lot of storage on the machine The reason that this will help isolate is because it is what "WeebGISDr" essentially does in case of Portal for ArcGIS. If you can share these, we can probably look for the root cause of this. Hope this helps!
... View more
2 weeks ago
|
0
|
0
|
102
|
POST
|
Hi Community, I am trying to achieve this new capability which ESRI released which allows to show "Related Records" on Web Scene by using Hosted Scene layers. However, the data on the related records shows blank. Version : ArcGIS Enterprise 11.3 Workflow: Publish Hosted Scene Layers Add the Scene layer to Web Scene/Local Web Scene Enable display "related record Display" on Pup-ups by following the below documentation: Configure pop-ups in a scene—Portal for ArcGIS | Documentation for ArcGIS Enterprise Select the feature and it will show the presence of related records. However, when you click on that it will not shows data from that related table. Add the associated feature service to Web Map and enable display of related record. It will show all the data. Can anyone share some thoughts or have experienced such issue before?
... View more
4 weeks ago
|
0
|
1
|
122
|
POST
|
Hello @AkhilRajT , Apologies for delay in response got occupied with some stuff. I tested with creating a custom script as per ESRI documentation and it works for me as expected. This leads me to believe that there is something with the script or template you are utilizing. Is it possible for you to share the script and a sample copy of the template you are utilizing, I can test with that on my end. Additionally, I am sure it's not but I wanted to confirm that neither the print service nor Application is publicly shared? Hopefully you can share the details. Stay Safe! -Archit
... View more
05-29-2024
09:46 PM
|
0
|
0
|
355
|
POST
|
Hello @AkhilRajT , Thanks for clarifying that. It would be very helpful in narrowing down the cause. I would run the same test in one of my 11.2 environment today and will try to gather more information on this. Will share more details soon on this. In the meantime can you confirm the the print tool you have created on 11.2, was it able to print the Sample server 6 service which I shared above. I would like to if that is working or failing? -Archit
... View more
05-12-2024
10:10 PM
|
0
|
3
|
501
|
POST
|
Hello @AkhilRajT , That clarifies it a bit. It seems to me that the layer which is in the map could be causing a problem. In order to further understand can you try the following: https://************/server/rest/services/dev/GIS_Plot/FeatureServer/0 Is this service secured? Is this service coming from Hosted Server? Can you try to create a WebMap with the following service and try to Print https://sampleserver6.arcgisonline.com/arcgis/rest/services/DamageAssessment/FeatureServer Can you try the same Print Service in Web App Builder (Make sure you create the Web Map in Map viewer Classic which would be used in Web App Builder) Are you able to open the REST API of the service you are trying to print on ArcGIS Server Machine (Launch the browser with ArcGIS Server service account) We are trying to understand if the workflow requires print service which can Print secured service (with embedding ags file) These workflows should allow us to understand the behavior better and come up with a defined solution. Hope it helps! -Archit
... View more
05-08-2024
05:24 AM
|
0
|
5
|
557
|
POST
|
Hello @AkhilRajT , Can you share "Info" level logs for the Geoprocessing service. To set the logging level for the Geoprocessing Service specifically, follow the below document: Enabling info-level geoprocessing messages : Troubleshooting geoprocessing REST services—ArcGIS Server | Documentation for ArcGIS Enterprise Once, you enable this run the tool again in Experience Builder Application and in another Tab Navigate to "ArcGIS Server Manager" > Site > Jobs > Under Service select the GP service and query. This will show you the Job ID generated for the latest run of the tool. Once you open that, it will show you details of the JOB run. If you can share that it would shed some more light on what is actually failing in the process. Hope it helps! -Archit
... View more
05-02-2024
05:17 AM
|
0
|
7
|
675
|
POST
|
Hello @SciotoCoJT , You can take a different approach, let me try to describe that below: Move the cache to a shared location and allow ArcGIS Server Service account Full privileges on this folder. You can follow the steps as per below document depending on you cache type https://enterprise.arcgis.com/en/server/latest/publish-services/windows/copying-caches.htm Add a Cache Directory to ArcGIS Server (as the Image would be very large, would not recommend keeping them on same machine as ArcGIS server) but following the link below: https://enterprise.arcgis.com/en/server/latest/administer/windows/adding-a-server-directory-in-manager.htm Publish the Image service to ArcGIS Server, while publishing Navigate to configuration Tab > Select edit option on Imagery Under Layer Drawing Section > Dynamically from Data (this is default but make sure to check) Publish the Service After the service publishes, access the server manager and access the caching tab for the new service From here, change the caching to "using tiles from a cache" and specify the cache directory path to the copied folder from previously Save and Restart the Service. Things to really make sure as Cached Service would not allow any deviations: Publish a new using the same naming convention as the previous Image service & cache folder. For example, if the Service is called Test_Image_Service and the cache folder is Test_Image_Service, make sure you use the same name when publishing a new service. Keeping the name same for the copied folder and the service is crucial. Once this workflow is done, You can add these services as an Item to Portal for ArcGIS or if they are federated (not sure as you didn't reply to @A_Wyn_Jones's query) the items will visible by default. Do let me know if you encounter issue in this workflow. Hope it helps! -Archit
... View more
04-28-2024
11:38 PM
|
0
|
1
|
445
|
Title | Kudos | Posted |
---|---|---|
1 | 2 weeks ago | |
1 | 2 weeks ago | |
1 | 2 weeks ago | |
1 | 2 weeks ago | |
1 | 2 weeks ago |