2 Replies Latest reply on Sep 8, 2019 3:59 PM by brend26

    A database error occurred: ODBC error: () - Shutting down VMware VirtualCenter

    jasmeetsinghsuri Novice

      We have a vCenter that is pointing to an external Database. All of a sudden all vCenter services stopped. vCenter is installed on a Windows 2012 server.


      VPXD logs:


      --> [backtrace begin] product: VMware VirtualCenter, version: 6.5.0, build: build-9451637, tag: vpxd, cpu: x86_64, os: windows, buildType: release
      --> backtrace[00] vmacore.dll[0x001F436A]
      --> backtrace[01] vmacore.dll[0x000684C0]
      --> backtrace[02] vmacore.dll[0x0006A93E]
      --> backtrace[03] vmacore.dll[0x000324F9]
      --> backtrace[04] vpxd.exe[0x0073C3E4]
      --> backtrace[05] vpxd.exe[0x00239FC2]
      --> backtrace[06] vpxd.exe[0x0023AB5D]
      --> backtrace[07] vpxd.exe[0x00486547]
      --> backtrace[08] vpxd.exe[0x00486D97]
      --> backtrace[09] vpxd.exe[0x01195E53]
      --> backtrace[10] KERNEL32.DLL[0x000013D2]
      --> backtrace[11] ntdll.dll[0x000154F4]
      --> [backtrace end]
      2019-09-01T13:31:24.716+05:30 info vpxd[38768] [Originator@6876 sub=vpxdVdb] Registry Item DB 5 value is ''
      2019-09-01T13:31:24.716+05:30 info vpxd[38768] [Originator@6876 sub=vpxdVdb] Setting VDB delay statements queue size to 10000 transactions for 10 GB RAM dedicated to vpxd.
      2019-09-01T13:31:24.716+05:30 info vpxd[38768] [Originator@6876 sub=vpxdVdb] [VpxdVdb::SetDBType] Logging in to DSN: vCenterDB with username SERVICE\adminvDB
      2019-09-01T13:31:24.800+05:30 error vpxd[38768] [Originator@6876 sub=Default] A database error occurred: ODBC error: () -
      2019-09-01T13:31:24.802+05:30 warning vpxd[38768] [Originator@6876 sub=Main] Database not initialized. Nothing to unlock
      2019-09-01T13:31:24.802+05:30 info vpxd[38768] [Originator@6876 sub=Default] Forcing shutdown of VMware VirtualCenter now



      Application logs from vCenter server


      EVENT 1000: A database error occurred: ODBC error: () -

      EVENT 1000: Failed to intialize VMware VirtualCenter. Shutting down

      EVENT 1000: A database error occurred: ODBC error: () -

      EVENT 1000: Log directory: C:\ProgramData\VMware\vCenterServer\logs\vmware-vpx.

      EVENT 1000: Starting VMware VirtualCenter 6.5.0 build-9451637

      EVENT 1000: Shutting down VMware VirtualCenter

      EVENT 1000: Initiating VMware VirtualCenter shutdown

      EVENT 103: svchost (26032) Instance: The database engine stopped the instance (0).

      EVENT 327: svchost (26032) Instance: The database engine detached a database (1, C:\ProgramData\Microsoft\Windows\AppRepository\PackageRepository.edb). (Time=0 seconds)



      Looking for an expert advice that what could have caused the services to stopped.




      Jasmeet Singh