Unable to offline upgrade couchbase server community edition 4.5 to 6 -- '1 node pending' showing for all the buckets in CB Community 6.0v v

During a couchbase server offline upgrade form 4.5 community version, I am unable to run the 5.x installer on top of 4.5. I tried with all the 5.x installers and following are the logs of msi for 5.x installers:
SI © (C0:68) [11:07:09:956]: Note: 1: 1708
MSI © (C0:68) [11:07:09:956]: Note: 1: 2205 2: 3: Error
MSI © (C0:68) [11:07:09:956]: Note: 1: 2228 2: 3: Error 4: SELECT Message FROM Error WHERE Error = 1708
MSI © (C0:68) [11:07:09:956]: Note: 1: 2205 2: 3: Error
MSI © (C0:68) [11:07:09:956]: Note: 1: 2228 2: 3: Error 4: SELECT Message FROM Error WHERE Error = 1709
MSI © (C0:68) [11:07:09:956]: Product: Couchbase Server – Installation failed.

MSI © (C0:68) [11:07:09:957]: Windows Installer installed the product. Product Name: Couchbase Server. Product Version: 5.0.1.5003. Product Language: 1033. Manufacturer: Couchbase Inc… Installation success or error status: 1603.

MSI © (C0:68) [11:07:09:959]: Grabbed execution mutex.
MSI © (C0:68) [11:07:09:959]: Cleaning up uninstalled install packages, if any exist
MSI © (C0:68) [11:07:09:961]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8/4/2020 11:07:09 ===

Now,
To upgrade, I have upgraded couchbase server community version from 4.5 to 6 directly using the offline upgrade method. It is showing “1 node pending” for all the buckets on the console.
Also, is upgrading 4.5 ->5 -> 6.0 equivalent to 4.5 -> 6.0 community version?