Re: Fatal error starting PgAdmin 4

Hi Sumedh

Can you please specify the exact version of PostgreSQL 12 that you have
installed? For example 12.x.x
The "pgadmin4.db" file can be found in the "%AppData%\Roaming\pgadmin"
folder.

On Tue, May 18, 2021 at 12:01 PM Balapure, Sumedh <
Sumedh(dot)Balapure(at)contractor(dot)tranetechnologies(dot)com> wrote:

> 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> 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.
>
>
>
> 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 *
>

--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*