Re: Fatal error starting PgAdmin 4

Hi Akshay,
It's a fresh installation. I am using it for the first time.

I cannot find file pgadmin4.db

Regards,

Sumedh R. Balapure,

Cell: +91-7770063134

________________________________
From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
Sent: Tuesday, May 18, 2021 9:26 AM
To: Balapure, Sumedh <Sumedh(dot)Balapure(at)contractor(dot)tranetechnologies(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Fatal error starting PgAdmin 4

Alert: This is an external email.

Hi Sumedh

You can do the following to get rid of the error:

* Take the backup of the 'pgadmin4.db' file and then delete it.
* Restart the pgAdmin4

Have you upgraded your existing pgAdmin setup or it's a fresh installation?

On Mon, May 17, 2021 at 9:31 PM Balapure, Sumedh <Sumedh(dot)Balapure(at)contractor(dot)tranetechnologies(dot)com<mailto:Sumedh(dot)Balapure(at)contractor(dot)tranetechnologies(dot)com>> wrote:
Hi Team,
I have installed PostgreSQL 12 and while starting PgAdmin 4 I am getting Fatal error. Below is screenshot of error and details. Please help asap.

[cid:7c5885e6-c3e1-4cc3-b1d6-9df36144d50b]

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\Sumedh\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\Sumedh\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_5952_XBAUMQEIPHMCHBHF
- CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: SUMEDH-PC
- ComSpec: C:\WINDOWS\system32\cmd.exe
- C_EM64T_REDIST11: C:\Program Files (x86)\Common Files\Intel\Shared Files\cpp\
- DriverData: C:\Windows\System32\Drivers\DriverData
- FP_NO_HOST_CHECK: NO
- HOMEDRIVE: C:
- HOMEPATH: \Users\Sumedh
- LOCALAPPDATA: C:\Users\Sumedh\AppData\Local
- LOGONSERVER: \\SUMEDH-PC
- NUMBER_OF_PROCESSORS: 4
- OneDrive: C:\Users\Sumedh\OneDrive
- OneDriveConsumer: C:\Users\Sumedh\OneDrive
- OS: Windows_NT
- Path: C:\Program Files (x86)\Common Files\Intel\Shared Files\cpp\bin\Intel64;C:\ProgramData\Oracle\Java\javapath;C:\orant\bin;C:\oracle\product\10.2.0\client_1\bin;c:\Program Files (x86)\Intel\iCLS Client\;c:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\orant\jdk\bin;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\PostgreSQL\12\bin;C:\Users\Sumedh\AppData\Local\Microsoft\WindowsApps
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 9dfe100a-97fe-41d8-b556-865e213bed55
- PGADMIN_INT_PORT: 50584
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 69 Stepping 1, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 4501
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
- PUBLIC: C:\Users\Public
- SynaProgDir: Synaptics\SynTP
- SystemDrive: C:
- SystemRoot: C:\WINDOWS
- TEMP: C:\Users\Sumedh\AppData\Local\Temp
- TMP: C:\Users\Sumedh\AppData\Local\Temp
- USERDOMAIN: Sumedh-PC
- USERDOMAIN_ROAMINGPROFILE: Sumedh-PC
- USERNAME: Sumedh
- USERPROFILE: C:\Users\Sumedh
- windir: C:\WINDOWS
- windows_tracing_flags: 3
- windows_tracing_logfile: C:\BVTBin\Tests\installpackage\csilogfile.log
--------------------------------------------------------

Traceback (most recent call last):
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line 98, in <module>
app = create_app()
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py", line 347, in create_app
if not os.path.exists(SQLITE_PATH) or get_version() == -1:
File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\setup\db_version.py", line 19, in get_version
return version.value
AttributeError: 'NoneType' object has no attribute 'value'

Regards,

Sumedh R. Balapure,

Cell: +91-7770063134

--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres<https://urldefense.com/v3/__http://edbpostgres.com__;!!LkoGuYl8_g!hfFNhHTM44kT4XtNdjyzqkWEZWDTWa7nCqLDBt8SOCG-nEKOEdgqE2gtlk5V6KKF5m915uLgFnGigbdNPZX9$>
Mobile: +91 976-788-8246