Avaya IPOCC upgrade, from 10.0.0 to 10.1.2: problem with Postgres-Upgrade

[Raff-Tech]

Hi, we need to upgrade IPOCC to 10.1.2.2 from 10.0.0, but we have an error updating the Postgres database from version 9.3 to 9.6 with PostgresUpgrader.exe.

The error in "PostgresUpgrader_XYZ.log":
installation of C:\IPOCC\Server\IP Office Contact Center\Setups\PostgreSQL x64.msi failed!; error=0

The error in "MSI-PostgreSQL x64-XXXXX.LOG":
MSI (s) (C0:68) [21:53:35:545]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIFBEE.tmp, Entrypoint: SqlQueriesExec
+++++ SqlQueriesExec +++++
try to start 'PostgreSQL 9.6' service

d:\bm\ipocc101\release\11100\src\setup\setup\postgresql\cpp\ServiceManager.h(76): Throw in function void __cdecl ServiceManager::Start(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
Dynamic exception type: class boost::exception_detail::clone_impl<struct ERR_General>
std::exception::what: Unknown exception
= PostgreSQL 9.6
= StartService()
= 1053, "Unknown error"
!!!!! SqlQueriesExec !!!!!

Can you help me?
Thanks in advance!

 

[janni78]

I haven't had any issues with this.

Do you select "Start as Administrator" when you start PostgresUpdater.exe and if so will that require you to enter credentials?

"Trying is the first step to failure..." - Homer

 

[Raff-Tech]

Yes, I've also tried to start PostgresUpdater.exe with "Start as Administrator".

However we have solved the problem by removing the two empty folders in C:\ProgramData\Avaya\PostgreSQL\:
\9.6\crashdumps

This problem happened to us 3 times, on 3 different servers, updating IPOCC to version 10.1.2.2.
It would have been useful to understand why the problem happens at the first run of PostgresUpgrader.exe, and why those two folders with the Rollback are not removed.
I remember that with previous versions the problem was not there.