POST
|
Hi @essamadelali , Your observations was helpful for us. We made a little bit changes in creating the partition tables with the help of our DBA @MOHAMMEDKHAJAANSARI . Instead of creating tables one by one we created a function in which we pass the date ranges and the tables get created when a single query is fired. Other folks can utilize it if they using PosgreSQL. Function Code: DECLARE current_partition_date DATE := start_date; BEGIN -- Create the main table if it doesn't exist -- Loop to create partitions WHILE current_partition_date <= end_date LOOP -- Generate the partition name based on the current date -- You might want to use a specific naming convention for your partitions -- For example: 'partition_20240118' EXECUTE 'CREATE TABLE IF NOT EXISTS metrics_data_' || to_char(current_partition_date, 'YYYY_MM_DD') || ' PARTITION OF metrics_data FOR VALUES FROM (''' || current_partition_date || ''') TO (''' || current_partition_date + 1 || ''')'; -- Increment the current date for the next iteration current_partition_date := current_partition_date + 1; END LOOP; END; Query: SELECT public.create_partitioned_table_2d( '2024-01-01', '2024-12-31' ) Note: create create_partitioned_table_2d is the name of the function and the dates specified below are the start date and end date respectively(creates partition for a year).
... View more
02-06-2024
11:13 PM
|
1
|
0
|
212
|
POST
|
Hi @s1234678 You can refer this URL for backup and restore https://doc.arcgis.com/en/monitor/latest/administration/windows/back-up-and-restore-your-deployment.htm#:~:text=Copy%20the%20backup%20of%20the,to%20the%20configuration%20store%20directory. Regards, Rana
... View more
02-06-2024
10:05 PM
|
1
|
0
|
241
|
POST
|
@Thomas_Puthusserry Glad it worked. You're most welcome.
... View more
02-02-2024
03:58 AM
|
0
|
0
|
341
|
POST
|
Hi @Thomas_Puthusserry Unfortunately Portal 10.9.x does not support manual rebuild of indexes. Since the secondary portal was disconnected for a log time, the json files for portal contents might not have updated. You can try the below workaround and see if it works. (do take machine level backups before proceeding) Unregister the secondary portal ( which was disconnected) Run reindex form the Primary portal (only remaining node) On successful reindexing join the second site to portal Check the index status Run reindex if required Hope this helps.
... View more
02-01-2024
10:08 PM
|
0
|
2
|
355
|
POST
|
Hi @AndreaB_ It is not required to publish/overwrite the service again. During a publishing activity the publishing tool creates a MAP file and Service definition file in the in the arcgisinput directory. The service will continue to work even if the location (where you save the project) of the .aprx is not connected, as it has nothing to do with the file. You will face issues with the service if the published service has referenced data which is stored in the network drive. If you have such services, you shall have to repoint and register the path of the referenced data in a location that is accessible by ArcGIS Server and has sufficient privilege to the Server Service account. You can verify the path in installation directory of your ArcGIS Server. Hope this helps.
... View more
02-01-2024
09:44 PM
|
2
|
0
|
288
|
POST
|
@KThomasson Try running a full reindex from portaladmin. https://developers.arcgis.com/rest/enterprise-administration/portal/reindex.htm
... View more
01-29-2024
08:44 AM
|
0
|
0
|
158
|
POST
|
Hi @jez , This seems to issue related to directory permissions. Please verify if the service account is having adequate permission in the installation and content directories.
... View more
01-29-2024
07:46 AM
|
0
|
1
|
577
|
POST
|
Hi @jez , Could you please check the proxy settings under Internet Options on the system? If a proxy configuration is present, kindly follow these steps: Open Internet Explorer or any default browser on the system. Navigate to the "Internet Options" menu. Under the "Connections" tab, click on "LAN settings." Check if there is a proxy server configured. If so, please take note of the settings. Additionally, ensure that the following options are checked: "Bypass proxy server for local addresses" Add the following URLs to the proxy bypass list: [URL1] [URL2] localhost Regards, Rana
... View more
01-29-2024
04:51 AM
|
0
|
1
|
607
|
POST
|
Hi @AhmedFathy74 , Have you tried pushing the ArcGIS Module to the target machine. If not, please refer the below link. https://github.com/Esri/arcgis-powershell-dsc/wiki/Scripts-to-push-the-ArcGIS-Module Detailed steps: https://github.com/Esri/arcgis-powershell-dsc/wiki/Create-a-base-ArcGIS-Enterprise-deployment-on-one-machine Regards, Rana
... View more
01-29-2024
04:07 AM
|
0
|
0
|
349
|
IDEA
|
Description: Request: Enable users to add custom metrics or queries for databases, allowing for the creation of custom monitoring parameters. Example Use Case: For instance, a query such as SELECT tablespace_name, SUM(bytes)/(1024*1024*1024) AS total_free_space_gb FROM dba_Free_space GROUP BY tablespace_name; could be employed to display the available free space in different tablespaces. Rationale: Flexibility and Customization: Providing users with the ability to define and monitor custom metrics or queries is crucial for accommodating diverse database monitoring needs. This feature would empower administrators to tailor monitoring to the specific requirements of their databases. Enhanced Visibility: Custom queries, like the example mentioned, can offer insights into specific database aspects that might be critical for administrators, such as available free space in tablespaces. Improved Decision-Making: Custom metrics enable users to track and analyze database performance based on parameters that are most relevant to their organization, facilitating informed decision-making. Benefits: Tailored Monitoring: Organizations can define metrics that align with their unique database structures and requirements. Proactive Issue Identification: Administrators can set up custom queries to identify potential issues or trends specific to their databases. Comprehensive Database Management: This feature enhances the depth and scope of database monitoring, contributing to a more comprehensive and efficient database management solution.
... View more
01-29-2024
01:48 AM
|
4
|
1
|
271
|
IDEA
|
Implement hyperlinks on elements within the Analysis Dashboard, redirecting users to related insights. Rationale: By introducing hyperlinks, users can seamlessly navigate from one component to relevant insights, enhancing the overall user experience. This feature promotes a more intuitive and efficient workflow for administrators seeking detailed information about specific components.
... View more
01-29-2024
01:44 AM
|
5
|
2
|
275
|
IDEA
|
Extend the limit on the resource utilization graph from 10 systems to 50 systems. Additional Feature: Allow users to select and display the top/key 20 systems. Rationale: Organizations with larger deployments often find the current limit restrictive. Increasing the limit to 50 systems, with an option to select and display the top 20, would accommodate the needs of organizations with more extensive infrastructures.
... View more
01-29-2024
01:37 AM
|
2
|
1
|
178
|
IDEA
|
Add a dropdown list on the home page, enabling administrators to switch between analysis dashboards. Rationale: This enhancement provides administrators with the flexibility to quickly navigate between different analysis dashboards. It streamlines the user experience and improves overall efficiency in managing and monitoring various aspects of the system.
... View more
01-29-2024
01:34 AM
|
5
|
1
|
198
|
IDEA
|
Introduce a search bar in the component section under Monitoring. Rationale: This feature will significantly benefit administrators by allowing them to efficiently search for specific services, servers, or other components within the available monitoring options. It enhances usability, especially for users dealing with a large number of services.
... View more
01-29-2024
01:32 AM
|
0
|
2
|
249
|
POST
|
Hi @DerekLaw, Thank you for your response. The licenses are valid with configurations done as per configuration guide available on ESRI site. We were able to narrow down the issue, it was discovered that the matrics_data partition tables are not getting created. We created a table manually referring the below link and were able to capture the metrics data, but it still seems not all the data is not getting captured. https://community.esri.com/t5/arcgis-monitor-questions/partition-tables-not-created/td-p/1328147 Let us know how we can fix this issue. Regards, Rana
... View more
01-17-2024
10:12 PM
|
0
|
1
|
484
|
Title | Kudos | Posted |
---|---|---|
2 | 01-29-2024 01:37 AM | |
1 | 02-06-2024 10:05 PM | |
1 | 02-06-2024 11:13 PM | |
2 | 02-01-2024 09:44 PM | |
5 | 01-29-2024 01:44 AM |
Online Status |
Offline
|
Date Last Visited |
Wednesday
|