|
POST
|
I would connect as the .SDE connection if using Python in Pro. I think this would provide you the easiest user experience. I am not sure what the difference is between the 2 are, but usually only make .sde connections to non-geodatabases in SQL Server. Just know that there are some limits to what can be done via ArcGIS client and .sde connections to non-geodatabases: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm
... View more
07-09-2024
07:27 AM
|
1
|
0
|
1690
|
|
POST
|
Are you trying to locate someone in Esri? Did you work with someone in Esri to create this? If so, who? I think we need some more information / context to help with this.
... View more
07-03-2024
12:39 PM
|
0
|
0
|
1328
|
|
POST
|
Roger, I am not sure how to report an issue outside of support.
... View more
07-01-2024
11:33 AM
|
1
|
0
|
3084
|
|
POST
|
This is where I recommend working with technical support on this. They have the mechanism to reproduce the issue and the process for logging potential issues. @MarlonAmaya any thoughts on getting this investigated?
... View more
07-01-2024
10:29 AM
|
1
|
2
|
3124
|
|
POST
|
Thanks for that update. We usually want the username / login name to match exactly for best outcomes and less issues.
... View more
07-01-2024
10:21 AM
|
0
|
0
|
3125
|
|
POST
|
Thanks for the update on your testing. I am not aware of any specific permission required between SQL / Windows logins. We usually do not recommend that Windows logins own data due to naming and when the person leaves. This is the first time I have come across this difference.
... View more
07-01-2024
09:23 AM
|
1
|
0
|
3136
|
|
POST
|
Not sure if there is a difference between the two...... I would highly recommend reaching out to technical support on this issue. Outside of the SQL vs Windows login, everything seems to be ok. I have also not seen that issue like this.
... View more
07-01-2024
05:30 AM
|
0
|
0
|
3431
|
|
POST
|
So, I ran a similar SQL for permissions and the difference I saw, was in the 'principal_type_desc' field. My data owner ("data") is a SQL_USER and not a WINDOWS_USER. SELECT
USER_NAME(dppriper.grantee_principal_id) AS [USERNAME],
dppri.type_desc AS principal_type_desc,
dppriper.class_desc,
OBJECT_NAME(dppriper.major_id) AS object_name,
dppriper.permission_name,
dppriper.state_desc AS permission_state_desc
FROM sys.database_permissions dppriper
INNER JOIN sys.database_principals dppri
ON dppriper.grantee_principal_id = dppri.principal_id
WHERE USER_NAME(dppriper.grantee_principal_id) = 'data' Can you please see if your login properties match something like this for the GISAdmin user?
... View more
07-01-2024
04:06 AM
|
0
|
0
|
3441
|
|
POST
|
When you try to delete the feature class. Are you logged in as "dataowner" or as your Windows user, just for clarification? Can you provide all the permissions that the dataowner has, including any fixed-server and db roles? What is the username / schema mapping, please provide screenshot.
... View more
06-28-2024
04:24 AM
|
1
|
2
|
3515
|
|
POST
|
I recommend reaching out to technical support for them to investigate the issue.
... View more
06-27-2024
04:07 AM
|
0
|
0
|
1202
|
|
POST
|
Ok, thanks for those items it does not appear to be resource related. I am wondering if the PostgreSQL DB is running out of available connections? I cannot find what I am looking for in order to check the # connections allowed.
... View more
06-26-2024
01:02 PM
|
0
|
0
|
10045
|
|
POST
|
How are you accessing the Postgres EGDB, via VPN or directly in your office? Does the timeout happen after a specific amount of time, like 15 or 30 minutes? Does it drop the connection when in the middle of interacting with data or after a period of "inactivity"? What are the resources on the Postgres VM reporting when the issue occurs? RAM / CPU utilization at that time?
... View more
06-26-2024
10:54 AM
|
0
|
4
|
10123
|
|
POST
|
I would look into using a Mosiac Dataset: https://doc.arcgis.com/en/imagery/workflows/resources/using-mosaic-datasets-to-manage-imagery.htm or https://pro.arcgis.com/en/pro-app/latest/help/data/imagery/mosaic-datasets.htm This can be used to manage all the images in a single location and allow for use in a model / script.
... View more
06-25-2024
06:14 AM
|
0
|
1
|
1331
|
|
POST
|
Thanks for that information and context. Here is what I am hearing, for clarity: Works: when using Pro client and the user 'test', no issues. Error: when using Python/SQLAlchemy script and the 'test' user credentials. Always works with DBO (database admin) credentials. I am not sure what would be causing the issue if it works in Pro, at the DB level. You may want to work with technical support on this. Seems like a Python side issue?
... View more
06-21-2024
08:53 AM
|
0
|
0
|
1735
|
|
POST
|
Are you sure that the PostgreSQL database has been enabled as a geodatabase? Is there an SDE schema present in the PostgreSQL database? A PG DB + PostGIS can accept simple feature classes / tables without the geodatabase functionality. Which is what I think that you are experiencing right now. Annotation is a geodatabase functionality and would require that component. Here is some documentation on what can be done with database and GIS: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm
... View more
06-18-2024
12:56 PM
|
0
|
0
|
1012
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 11 hours ago | |
| 1 | yesterday | |
| 2 | 2 weeks ago | |
| 1 | 2 weeks ago | |
| 2 | 07-01-2026 04:09 AM |
| Online Status |
Offline
|
| Date Last Visited |
15 hours ago
|