|
POST
|
I am working in an enterprise SDE database. I am working with a particular schema that contains tables, views and synonyms that have and have not been registered with the SDE and the Geodatabase. Ultimately, I am trying to retrieve domains that are being used in the schema, but I have ran into an issue along the way. The schema contains database synonyms. I have found that arcpy.ListTables will return the database synonym, but arcpy.ListFields will not recognize the database synonym. I would like to exclude the synonyms from my process, but arcpy.ListTables does not provide a utility to filter the return set by object type (info and dbase do not work in this case). Here is my specific example which I have abbreviated to highlight the issue. The MYSCHEMA.RESERVOIR object is a database synonym: tableList = arcpy.ListTables()
for table in tableList:
if "MYSCHEMA." in table:
if "RESERVOIR" in table:
print table
fieldList = arcpy.ListFields(table) ## code breaks here
print "made it here"
for field in fieldList:
print table
MYSCHEMA.RESERVOIR
Traceback (most recent call last):
File "<pyshell#71>", line 6, in <module>
fieldList = arcpy.ListFields(table)
File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\__init__.py", line 1119, in ListFields
return gp.listFields(dataset, wild_card, field_type)
File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing\_base.py", line 344, in listFields
self._gp.ListFields(*gp_fixargs(args, True)))
IOError: "MYSCHEMA.RESERVOIR" does not exist
So it appears that ListFields will not recognize a database synonym. Does anyone have any thoughts about how to filter out database synonyms before running arcpy.ListFields? I would prefer not to filter out the synonym objects by name, as these names could change and that would require someone to update the code. Thanks in advance. - Jake
... View more
07-30-2015
09:39 AM
|
0
|
2
|
3042
|
|
POST
|
This is question for ESRI staff. Is there any thought to expand the AGO Map Feature search functionality so that it works with number fields? Currently it only works with string fields that do not participate in a domain. See item 8 for details: Configure feature search—ArcGIS Online Help | ArcGIS Thanks, - Jake
... View more
04-20-2015
09:44 AM
|
0
|
0
|
3338
|
|
POST
|
I have been unable to make specific columns in BOTH the AGO map popup and the AGO edit form show in bold text For example, I want the following two columns (Phenol Stain Loss % and Safety Factor) in bold text in both the AGO map popup AND the AGO edit form The method that I am using to get the bold text in the edit form is to configure the map popup with <b> tags Configure AGO Map Popup AGO Map Edit Form looks good, but the map popup has the ugly <b> tags If I use the Custom Attribute Display (below) to customize the AGO map popup with bold text, this will override the AGO Map Edit Form text. In summary, I am unable to display specific columns with bold text in BOTH the AGO map popup and AGO edit form. I can do one or the other, but not both forms. Any suggestions? Thanks, - Jake
... View more
04-13-2015
08:03 AM
|
0
|
0
|
3755
|
|
POST
|
I should add that the logic that I am using will NOT allow a user to overwrite an existing value in the database with a NULL value, even if they wanted to. For my specific application, this is an acceptable consequence.
... View more
03-05-2015
07:34 AM
|
2
|
0
|
1435
|
|
POST
|
Hi Tobias, Thanks for your response. I have essentially used the logic that you provided above (IF :NEW.FIELD IS NULL AND :OLD.FIELD IS NOT NULL THEN SET :NEW.FIELD := :OLD.FIELD) in order to prevent the 'overwrite with nulls' issue. I guess my overall concern is that this is 'extra' logic that must be evaluated by the database simply because the form does not update with values that are currently in the database. I'm sure that there are technological obstacles that ESRI must overcome in order to tightly couple the web-form with the database. Hopefully this is something that is on their radar. Thanks for the confirmation that the approach that I am taking is similar to the work around that you have used. Thanks, - Jake
... View more
03-05-2015
07:13 AM
|
2
|
1
|
1435
|
|
POST
|
I will attempt to describe a simple example that illustrates the issue that I am experiencing. I have a line feature class with a database insert trigger that populates an ID column from a sequence. In AGO, when a user double clicks to finish creating a feature AND then proceeds to update another attribute using the AGO attribute form, the ID column will be overwritten with a null. Behind the scenes, the double click in AGO does the insert. The insert trigger fires in the database and the row gets the ID from the sequence (can see this in sql-plus). The issue is that the AGO attribute window does not get updated with the ID, so when the user updates a different attribute, and update takes place against the feature class and each row in the AGO attribute form that does not contain data (which includes the ID attribute) gets overwritten with a null (can see this in sql-plus). This issue does not exist in ArcMap. When a user double clicks to create a feature in ArcMap, the attribute window immediately refreshes to show the result (new ID) of the insert trigger. My current work around is to add additional UPDATE logic to the database trigger, but I am searching for a more elegant solution. Is there a way to get the AGO attribute window to refresh so that it will display the values that are currently in the database? Something similar to the disableClientCache (from silverlight) might be available in AGO or can be turned on from a feature service perspective? I searched GeoNet and did not find other posts concerning this issue. How have others gotten around this issue? Thanks - Jake
... View more
03-04-2015
03:21 PM
|
2
|
4
|
5118
|
|
POST
|
Hi Jill, I am publishing to our enterprise ArcServer (which is 10.3) and the data is being pulled from a 10.3 version of SDE. Though I think the AGO show related records functionality was working correctly for me before I upgraded to 10.3. I think the most important thing is that you have an established 'relationship class' in your geodatabase between your feature data and your related data. Publish both the feature and related table to your server. Consume them both in a a map, enable popups and when you click on a feature, you should get the show related records link. This is the workflow that worked for me.
... View more
02-17-2015
07:51 AM
|
0
|
0
|
1087
|
|
POST
|
This bug appears to be resolved. I have been able to view related data (with more that 30k records) in an AGO map. Thanks ESRI... - Jake
... View more
02-09-2015
07:56 AM
|
0
|
2
|
1087
|
|
POST
|
Also getting this error and not using Bing maps in the Ops Dashboard. I am unable to share my Operations Dashboard with EVERYONE.
... View more
11-26-2014
01:35 PM
|
0
|
0
|
759
|
|
POST
|
Yes Rebecca, My AGOL and support accounts are different usernames. I get an endless loop of logins in both IE and Chrome. I will try Firefox. Thanks for the feedback.
... View more
10-15-2014
03:36 PM
|
0
|
0
|
2692
|
|
POST
|
Thanks for the update. The link just takes me through an endless loop of ESRI Support login screens
... View more
10-15-2014
03:26 PM
|
2
|
2
|
2692
|
|
POST
|
Hello, I stopped by to check the status of this bug and the link (http://support.esri.com/en/bugs/nimbus/TklNMTA0MTU4) to bug NIM104158 no longer works. Can someone provide an update and new link for future updates? I tried searching for the bug on the support services site, but was unable to find any information. Thanks, - Jake
... View more
10-15-2014
02:15 PM
|
0
|
4
|
2692
|
|
POST
|
Thanks for the info Katie. I will continue to monitor the bug status...
... View more
09-22-2014
04:33 PM
|
0
|
0
|
2692
|
|
POST
|
Hello, I have a 1 to M relationship class between a feature class and table. I have published the feature class and related table to our organizations ArcServer and have created a web map using the map service. I have configured the popup and it will show counts of the related records. I have also added a chart of the related records in the popup. My issue is with the 'Show Relate Records' link in the popup. When clicking on the link, it shows the related table (with all rows, not just those related to the selected feature) in the split window below the map. Ideally I would like the related table to be automatically filtered to show only those related rows that are associated with the feature that has been selected for the popup. Is there anyway to link the map and the related table, so that selections in the map filter the related table? Thanks, - Jake
... View more
09-22-2014
08:20 AM
|
0
|
15
|
13116
|
|
POST
|
Hi Nat, I had the same issue when I tried to relate a table to a feature class in my my arcmap mxd and then publish as a service. When configuring the popups with related data, nothing would show. To fix the issue, I created a relationship class in SDE between my table and feature class (used ArcCatalog to do this). Then pulled both the table and the feature class into an ArcMap session (relationship class is already established, so no need to relate the table and feature class. I then published this as a service and was able to then get related content in my popups. Hope this helps.
... View more
09-22-2014
07:47 AM
|
0
|
1
|
790
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 05-03-2022 02:32 PM | |
| 2 | 07-15-2025 11:00 AM | |
| 1 | 05-07-2025 06:08 AM | |
| 1 | 01-13-2023 08:19 AM | |
| 1 | 10-11-2021 02:46 PM |
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|