Timeline for ArcSDE PostgreSQL mixed environment error connecting to schemas
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 27, 2017 at 13:15 | comment | added | ziggy | so I actually came across another problem which I had a little while back gis.stackexchange.com/questions/250165/… . Essentially in this question I create a table in postgis and it wont properly display in arcgis but qgis it works fine. Feel free to comment on that posting if you have any indication on what that problem may be! | |
| Sep 27, 2017 at 11:25 | comment | added | pauldzy | Glad it worked. I am also glad there are not a new scenario I didn't know of that triggers this problem. SDE in all its manifestations is a passive metadata system. Its updated when Esri clients make a change. There is no active monitoring of the database to account for changes made outside the Esri stack. So when you do any changes via pgadmin to SDE registered resources you risk breaking the system. That being said I do make changes outside Esri all the time and I roll with the consequences. This particular one is more onerous than usual. | |
| Sep 26, 2017 at 16:13 | comment | added | ziggy | they all worked! thanks for the help I never would have figured this out on my own. I now recall I manually changed the keri_species table in pgadmin. so I am assuming that what the source of the problems? the sde.sde_table_registry did not register that table name change? | |
| Sep 26, 2017 at 15:52 | vote | accept | ziggy | ||
| Sep 26, 2017 at 15:45 | comment | added | ziggy | okay wow the left join query on the sde.sde_table_registry returned one row of an old table I renamed! I deleted that row (carefully) from the sde_table_registry and I was able to connect to one the schemas! im going to try it out for the other schemas as well | |
| Sep 25, 2017 at 21:55 | comment | added | pauldzy | Well if you checked against both sde.sde_layers and sde.sde_table_registry then I am just wrong about what your problem is. The next step is to do the same debugging that I did. When the database is quiet, have your user with the problem attempt to connect with ArcCatalog and thus trigger the error. Then inspect the postgresql log file for details on what happened. The error log should give you some indication of what table ArcCatalog cannot find. If it's not an issue with utterly missing resources then its probably permissions issues such as LR1234567 was driving towards. | |
| Sep 25, 2017 at 19:27 | comment | added | ziggy | query returns no rows for me | |
| Sep 25, 2017 at 19:21 | comment | added | ziggy | oh sorry its a view okay | |
| Sep 25, 2017 at 19:20 | comment | added | ziggy | what does pg_tables refer to? *also I have my DB all backed up and on a server, with the standard arcsde setup | |
| Sep 25, 2017 at 16:19 | comment | added | pauldzy | So I added the actual SQL to the answer. Again I am skirting your topic of db design as I believe the problem you are seeking immediate resolution to is unrelated to these db design issues. However I would just say that you ignore Vince Angelo at your peril. Vince is the last of the SDE old-timers at Esri and with any response from him you are essentially getting level 5 support for free. He has seen it all and his advice is always worth strong consideration. And note I've never stored data in the sde schema nor ever plan to. :) | |
| Sep 25, 2017 at 16:12 | history | edited | pauldzy | CC BY-SA 3.0 |
added 1090 characters in body
|
| Sep 25, 2017 at 12:30 | comment | added | ziggy | "orphaned references for resources which no longer exist in the database" what do you mean by this? user names and schemas I deleted along the way? I actually dont recall deleting any. I have definitely deleted and renamed many tables in the DB though | |
| Sep 25, 2017 at 12:28 | comment | added | ziggy | "no one stores their tables in the sde schema" the standard ArcSDE practice is to store all the tables in the sde schema (It seems backwards to me) | |
| Sep 24, 2017 at 22:51 | history | answered | pauldzy | CC BY-SA 3.0 |