topic Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release in Management & Governance

Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

Anonymous — Mon, 11 Dec 2017 09:59:23 GMT

Hello,

I make an Upgrade from QLIK Sense September 2017 release (qliksenseserver 11.14.3) to November 2017 release. The Upgrade works without error, but after upgrade I get no connection to my QLIK Sense server. The services are started. OS is Windows 2012R2.

I found some hints in the forum for my error messages about a bad MACHINE.CONFIG, but the MACHINE.CONFIG is clean.

I try the update twice with and without Patch 1of November 2017 release. Same result.

Any ideas what’s going wrong? September 2017 release was running perfect.

System_Proxy:

When contacting https://localhost:4242/ No connection could be made because the target machine actively refused it 127.0.0.1:4242↵↓Unable to connect to the remote server at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult

Could not contact local repository to retrieve local server node configuration No connection could be made because the target machine actively refused it 127.0.0.1:4242↵↓Unable to connect to the remote server at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult

Server_Proxy:

Command=Open connection;Result=-2146233079;ResultText=Error: Unable to connect to the remote server 0 0 0 INTERNAL sa_proxy 0 Not available Proxy Not available Not available Open connection -2146233079 Web exception when contacting service uri https://localhost:4242/ Command=Configure proxy;Result=-2146233079;ResultText=Error: Unable to connect to the remote server 0 0 0 INTERNAL sa_proxy 0 Not available Proxy Not available Not available Configure proxy -2146233079 Could not contact local repository to retrieve proxy service settings

System_Repository:

Fatal exception Aktualisieren oder Löschen in Tabelle »CompositeEvents« verletzt Fremdschlüssel-Constraint »FK_CompositeEventTimeConstraints_CompositeEvents_ID« von Tabelle »CompositeEventTimeConstraints«↵↓Failed to execute query: 'DELETE FROM "CompositeEvents" WHERE "Deleted" = true'. Exception: Aktualisieren oder Löschen in Tabelle »CompositeEvents« verletzt Fremdschlüssel-Constraint »FK_CompositeEventTimeConstraints_CompositeEvents_ID« von Tabelle »CompositeEventTimeConstraints«

Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

Anonymous — Mon, 08 Jan 2018 22:28:04 GMT

Hi Dirk,

Could you manage to sort this error? I am getting the same after I restored the repository to November release.

Many Thanks

Mohamad

Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

Anonymous — Tue, 09 Jan 2018 07:09:15 GMT

No, unfortunately no solution. I'm still working on the September release and I'm waiting for the next release and I hope this will work.

Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

EmmaC — Mon, 22 Jan 2018 09:55:38 GMT

I had the same problem! I got this tip from qlik support:

http://help.qlik.com/en-US/sense/November2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Troubleshooting-soft-deletes-not-removed.htm

It worked!!!

Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

awhitfield — Mon, 22 Jan 2018 10:01:38 GMT

Hi Dirk,

Have you applied any Qlik patches to you September release? If so, you should uninstall these first.

Programs and Features > View Installed updates > uninstall any Sense Updates.

Then attempt you upgrade again.

Best Regards

Andy

Check this out from the TechSpert session last week: STT - Keeping Your Qlik Sense Installation Current

Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

Anonymous — Mon, 22 Jan 2018 10:55:51 GMT

This link helped to sovlve the troubles.

Many Thanks

Failed to remove soft deleted records ‒ Qlik Sense

Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

gorthiqlik — Thu, 01 Feb 2018 00:28:03 GMT

Qlik Sense November 2017 Patch 2 Resolved the issue with the soft deleted records issue.

Soft deleted records cause upgrade failures Jira issue ID: HLP-1135 Description: When upgrading Qlik Sense to November 2017 or later, the installation fails and you get an error message stating that the removal of soft deleted records failed. The database command time out has been set to 30 minutes. If failure does occur, see documentation for further instructions: http://help.qlik.com/enUS/sense/November2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Trouble shooting-soft-deletes-not-removed.htm

We encountered this issue when upgraded from 3.2 SR4 to November 2017 release,But resolved automatically after applying the November 2017 Patch 2 release.

Re: Troubles after upgrade QLIK Sense September 2017 release to November 2017 release

tcarolus — Tue, 19 Feb 2019 11:57:57 GMT

Made my day, Thank you!