Hi List
I've comes across an error when trying to access my triggers through pgAdmin 4
v3.0. Maybe you can point me in the right direction for a solution? Expanding
the tree down through database > schemas > schema > trigger functions > trigger
returns:
Advertising
Error retrieving the information - INTERNAL SERVER ERROR
Click for details
<click>
[cid:image001.png@01D3EDEC.BEB787C0]
Accessing functions, materialised views, sequences, tables and views works
fine. Everything works as expected in pgAdmin3 1.22.2.
The pgAdmin4.log has the following in it:
2018-05-17 14:28:06,539: ERROR pgadmin: Exception when checking for
update
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\__init__.py",
line 508, in index
response = urlreq.urlopen(url, data, 5)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 154, in
urlopen
return opener.open(url, data, timeout)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 429, in
open
response = self._open(req, data)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 447, in
_open
'_open', req)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 407, in
_call_chain
result = func(*args)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 1241, in
https_open
context=self._context)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 1198, in
do_open
raise URLError(err)
URLError: <urlopen error Tunnel connection failed: 407 Proxy Authentication
Required>
2018-05-17 14:28:45,897: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", line
254, in dispatch_request
return method(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py",
line 345, in wrap
return f(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py",
line 1053, in sql
) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: 'nspname'
2018-05-17 14:31:10,102: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", line
254, in dispatch_request
return method(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py",
line 345, in wrap
return f(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py",
line 1053, in sql
) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: 'nspname'
2018-05-17 14:33:43,618: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Program Files (x86)\pgAdmin
4\v3\venv\Lib\site-packages\flask\views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", line
254, in dispatch_request
return method(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py",
line 345, in wrap
return f(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py",
line 1053, in sql
) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: 'nspname'
pgAdmin4 Version
3.0
Copyright
Copyright 2013 - 2018, The pgAdmin Development Team
Python Version
2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC v.1500 32 bit (Intel)]
Flask Version
0.12.2
Application Mode
Desktop
Current User
pgadm...@pgadmin.org
Postgresql 9.6.9 64bit
PostGIS 2.4.4
Client Windows 7 64bit
Server Windows 2008 R2
Ross McDonald | GIS Data Coordinator | Angus Council, People, IT | Angus House,
Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT | t: 01307 476419
This message is strictly confidential. If you have received this in error,
please inform the sender and remove it from your system. If received in error
you may not copy, print, forward or use it or any attachment in any way. This
message is not capable of creating a legal contract or a binding representation
and does not represent the views of Angus Council. Emails may be monitored for
security and network management reasons. Messages containing inappropriate
content may be intercepted. Angus Council does not accept any liability for any
harm that may be caused to the recipient system or data on it by this message
or any attachment.
