POST
|
We have a problem which might be similar to your problem. We have the same error in some dashboards in the widgets which are using arcade expression as data source. The error "data source error" just shows up in Chrome, not in the Edge browser (everything is fine there), but it doesn't matter if a user is viewer, creator or admin or if the application is public or not. And the error wasn't there some weeks ago. Chrome Version 114.0.5735.91 32-Bit and Edge 113.0.1774.35 64-Bit. Both browser show in the console of the developer tools a lot of warnings: [esri.core.workers] Version mismatch detected between ArcGIS API for JavaScript and assets: API version: 4.20 [Date: 20211015, Revision: 92e806ee] Assets version: 4.20 [Date: 20220916, Revision: 4a1b176c] And the Chrome browser has the error: init.js:108 [esri.layers.FeatureLayer] #load() Failed to load layer (title: '', id: '188e18561e4-layer-9') error: l {name: 'ReferenceError', details: {…}, message: 'WebAssembly is not defined'} [[Prototype]]: Object ... Regards Christoph Römer
... View more
06-21-2023
11:45 PM
|
0
|
0
|
390
|
IDEA
|
this function is necessary for co-working! also for portal for arcgis!
... View more
04-23-2021
04:18 AM
|
0
|
0
|
1135
|
IDEA
|
i was surprised that it is not possible to overwrite hosted feature layers and all attempts to change group or user role authorizations failed. it doesn't support co-working in projects.
... View more
04-23-2021
04:05 AM
|
0
|
0
|
1144
|
POST
|
I don't see the connection between your link and the problem of filtering related tables?
... View more
03-23-2021
12:18 AM
|
0
|
0
|
1701
|
POST
|
i know this solution, but if you have 1:n relations and also more than one related table this should not the the aimed solution. there need to be a solution for related tables with non coordinate data and filter options all over the layers and tables. Without that the concept/realization in agol/portal of related tables doesn't make much sense to me.
... View more
12-22-2020
07:49 AM
|
1
|
0
|
849
|
POST
|
I wrote some weeks ago some code in python to implement my task. The GUI isn't fancy (OnEnter doesn't work, ...), but it works for our purpose. So if someone wants to use it... One interesting thing about this: we moved two weeks ago from ArcGIS Enterprise 10.7.1 to 10.8.1 and since that time more services are listed with no datasource/tables? Did something changed in the Service Folder Structure on ArcGIS Server? from arcgis.gis import GIS
import arcgis.gis.admin
import json
import pandas
import pandastable
from pandastable import Table, TableModel
from IPython.display import display
from tkinter import *
class Window():
def __init__(self, master):
master.title("DataSources to Portal Featureservices")
master.geometry("1600x876")
master.configure(background='#F0F0F0', pady=8, padx=8)
source_gis = None
self.anmeldung_label = Label(master, justify=LEFT, text="Portal Login (maybe not necessary):")
self.user_label = Label(master, justify=LEFT, text="Username:")
self.user_tbox = Entry(master, width=30)
self.pw_label = Label(master, justify=LEFT, text="Password:")
self.pw_tbox = Entry(master, show='*', width=30)
self.empty_label = Label(master, justify=LEFT, text=" ")
self.empty_label2 = Label(master, justify=LEFT, text=" ")
self.empty_label3 = Label(master, justify=LEFT, text=" ")
self.empty_label4 = Label(master, justify=LEFT, text=" ")
self.empty_label5 = Label(master, justify=LEFT, text=" ")
self.tabname_label = Label(master, text="Search")
rbwert = IntVar()
self.dienstname_rb = Radiobutton(master, value=1, variable=rbwert, text="Servicename")
self.tabname_rb = Radiobutton(master, value=2, variable=rbwert, text="Table")
self.tabname_tbox = Entry(master, width=30)
self.tableframe = Frame(master, width=1506, height=640, pady=4, padx=4, borderwidth=2, relief="groove")
self.table = pt = Table(self.tableframe, width=1506, height=640, rows=1, cols=3, editable=False, enable_menus=False)
emptylist = []
emptylist.append(['', '', ''])
col = ['FEATURESERVICE NAME', 'DATASOURCE', 'TABLES']
result = pandas.DataFrame(emptylist, columns=col)
pt.updateModel(TableModel(result))
pt.autoResizeColumns()
pt.show()
rbwert.set(2)
self.list_button = Button(master, text="List Tables", command=lambda: self.bt_list_tables(
self.user_tbox.get(), self.pw_tbox.get(), self.tabname_tbox.get(), rbwert.get()))
self.exit_button = Button(master, text="Close", command=fenster.quit)
self.anmeldung_label.grid(row=1, sticky=W, pady=2)
self.user_label.grid(row=2, sticky=W, pady=2)
self.user_tbox.grid(row=2, column=1, sticky=W, pady=2, padx=2)
self.pw_label.grid(row=3, sticky=W, pady=2)
self.pw_tbox.grid(row=3, column=1, sticky=W, pady=2, padx=2)
self.empty_label.grid(row=4, column=1, sticky=W, pady=2, padx=2)
self.tabname_label.grid(row=6, sticky=W, pady=6, padx=2)
self.dienstname_rb.grid(row=6, pady=6, padx=2)
self.tabname_rb.grid(row=6, sticky=E, pady=6, padx=2)
self.tabname_tbox.grid(row=6, column=1, sticky=W, pady=6, padx=2)
self.list_button.grid(row=6, column=2, sticky=W, pady=6, padx=2)
self.empty_label2.grid(row=6, column=3, sticky=W, pady=6, padx=2)
self.empty_label3.grid(row=6, column=4, sticky=W, pady=6, padx=2)
self.empty_label4.grid(row=6, column=5, sticky=W, pady=6, padx=2)
self.empty_label4.grid(row=6, column=6, sticky=W, pady=6, padx=2)
self.tableframe.grid(row=8, columnspan=7)
self.table.grid()
self.table.resizeColumn(0, 300)
self.table.resizeColumn(1, 745)
self.table.resizeColumn(2, 460)
self.table.redraw()
self.exit_button.grid(row=9, column=6, sticky=E, pady=8, padx=12)
def login(self, username, pw):
source_gis = GIS('PORTALNAME/WEBADAPTER', username, pw, verify_cert=False)
source_gis.users.me
display(source_gis)
return source_gis
def color_red(self, val):
color = '#DC143C' if val == "!!! NO DATENSOURCE !!!" or val == "!!! NO TABLES !!!" else 'black'
return 'color: %s' % color
def bt_list_tables(self, username, pw, searchstring, rbvar):
source_gis = self.login(username, pw)
columns = ['FEATURESERVICE NAME', 'DATASOURCE', 'TABLES']
resultlist = []
gis_servers = source_gis.admin.servers.list()
for server in gis_servers:
serviceManager = server.services
for folder in serviceManager.folders:
if folder in ('Geocoding', 'Routing', 'System', 'Utilities'):
continue
for service in server.services.list(folder):
#print(service.url + "/iteminfo/manifest/manifest.json")
json_string = service._service_manifest()
json_dict = json.loads(json_string)
if 'databases' in json_dict:
databases = json_dict['databases']
for database in databases:
databasename = ""
# DatabaseNames
if 'onPremiseConnectionString' in database:
databasename = database['onPremiseConnectionString']
if "SERVER=" in databasename:
dbnameshort = ""
entrylist = databasename.split(';')
for entry in entrylist:
if "INSTANCE=" in entry:
dbnameshort += entry.replace("INSTANCE=", "") + "\\"
if "DATABASE=" in entry:
dbnameshort += entry.replace("DATABASE=", "")
databasename = dbnameshort
else:
databasename = databasename.replace("DATABASE=", "")
# Tables:
if 'datasets' in database:
datasets = database['datasets']
for table in datasets:
# Search Tables with searchstring
if (rbvar == 2 and searchstring.upper() in table['onServerName'].upper()):
resultlist.append([service.properties.serviceName, databasename, table['onServerName']])
# Search Services
if (rbvar == 1 and searchstring.upper() in service.properties.serviceName.upper()):
resultlist.append([service.properties.serviceName, databasename, table['onServerName']])
# Search Services with a searchstring, but the service has no tables assigned
elif (rbvar == 1 and searchstring.upper() in service.properties.serviceName.upper()):
resultlist.append([service.properties.serviceName, databasename, "!!! NO TABLES ASSIGNED !!!"])
# No searchstring but the service has no tables assigned
elif (searchstring==""):
resultlist.append([service.properties.serviceName, databasename, "!!! NO TABLES ASSIGNED !!!"])
# No searchstring, but the service has no Database/-source
elif (rbvar == 1 and searchstring.upper() in service.properties.serviceName.upper()):
resultlist.append([service.properties.serviceName, "!!! NO DATABASE/-SOURCE !!!", "!!! NO TABLES ASSIGNED !!!"])
# No searchstring, but the service has no Database/-source
elif (searchstring==""):
resultlist.append([service.properties.serviceName, "!!! NO DATABASE/-SOURCE !!!", "!!! NO TABLES ASSIGNED !!!"])
result = None
if resultlist:
result = pandas.DataFrame(resultlist, columns=columns)
else:
templist = []
templist.append(['', '', ''])
result = pandas.DataFrame(templist, columns=columns)
(result
.style.applymap(self.color_red)
.hide_index()
.set_table_styles([dict(selector='th', props=[('text-align', 'left')])])
.set_properties(**{'text-align': 'left'}))
self.table.updateModel(TableModel(result))
self.table.redraw()
self.table.show()
fenster.config(cursor="")
if __name__ == '__main__':
fenster = Tk()
app=Window(fenster)
fenster.mainloop()
... View more
09-08-2020
12:38 AM
|
3
|
0
|
5180
|
IDEA
|
I would also appreciate this function. I would recommend building a tool to show dependencies and links between datasources <-> feature services <-> maps <-> all kinds of apps <-> widgets (using feature services) for portal admins.
... View more
08-03-2020
03:25 AM
|
1
|
0
|
574
|
IDEA
|
I would also appreciate this function. I would recommend building a tool to show dependencies and links between datasources <-> feature services <-> maps <-> all kinds of apps <-> widgets (using feature services) for portal admins.
... View more
08-03-2020
03:25 AM
|
1
|
0
|
571
|
POST
|
Thanks Derrick, for understanding more about the places to see relations between the objects. I hoped to find an easier way. Maybe somewhere out there already had this question and wrote a solution. I will check if i get the time to build that code or not. Regards Christoph
... View more
07-30-2020
11:37 PM
|
0
|
1
|
5180
|
POST
|
Thanks Derrick for your detailed solution, a script would be fine, but a manually way would also help me for the moment. My concrete problem is to extend a table in sql server with new columns and for this i want to stop all services to add the columns in pro and after that start the services again and configure the maps which are using the services. Because different users might have published services out of that table i hope to see which services are connected with a table. If i understand your solution right you explain the how to find the source to a service, so a solution from the other side. And i had to write code searching through all services to find the database table names in the manifest.json files and list these files? I have two problems in your explanation: 1. If the service is a published from a db-query layer in arcpro, the manifest.json shows under datasets not the tables used in the db-query but the alias-name of the db-query in the ArcPro-project 2. Listing the feature services in the portal admin i just can list the services published with the siteadmin/admin user etc. but i need to list the services from all users.? Regards Christoph @Esri developers: A tool to show dependencies and links between datasources <-> feature services <-> maps <-> all kinds of apps <-> widgets (using feature services) would be great for portal admins.
... View more
07-30-2020
06:23 AM
|
0
|
3
|
5180
|
POST
|
Hi, how can i list all services in ArcGIS Enterprise connected to a datasource table. We have a referenced standard geodatabase (SQL Server 2014) which is connected to a Portal for Arcgis. I want to check what services in Portal for ArcGIS (10.7.1) are referenced to a table in this database (full tables published or services out of joins in db query layers)? Regards Christoph
... View more
07-28-2020
06:59 AM
|
1
|
6
|
5360
|
POST
|
We also have the problem that just one of the layers in our App beside the base map are printed by the print widget in portal 10.7.1. Changing the printing options in the widget doesn't make a difference. We didn't see a difference between the three layers why one is working but not the others. The one is working is a point layer from a sql server geodatabase, the two layers which are not printed is a polygon layer from the same database and a published query feature layer all published from arcgis pro 2.4.1.
... View more
11-21-2019
05:23 AM
|
0
|
0
|
879
|
IDEA
|
This should be implemented ! Our users don't understand why it's not working. Also they don't understand the "show related record" function in the attribute table. Because the show function just has an impact on the attribut table and doesn't has an impact on the map like the filter function (defintion query).
... View more
11-12-2019
06:51 AM
|
1
|
0
|
2259
|
Title | Kudos | Posted |
---|---|---|
1 | 07-28-2020 06:59 AM | |
1 | 12-22-2020 07:49 AM | |
2 | 12-22-2020 07:42 AM | |
3 | 09-08-2020 12:38 AM | |
1 | 08-03-2020 03:25 AM |
Online Status |
Offline
|
Date Last Visited |
01-23-2024
09:32 AM
|