Restart the QDS_service on a regular basis?

[datanibbler]

Hi,

I wonder if any of you have made the same experience as us?

In our company, we had the case - several times, every month or 2 months - that there was a problem with Qlikview, nothing was loaded, but we couldn't identify any obvious reason - then we restarted the QDS_service and all was well again.

If so, is there any chance QlikTech is going to provide a tool (just a batch or so) that could be used to do this?

Thanks a lot!

Best regards,

DataNibbler

[marcus_sommer]

You could use something like this as batch:

net stop qlikviewserver

timeout /T 15

net start qlikviewserver

net stop qlikviewwebserver

timeout /T 15

net start qlikviewwebserver

net stop QlikviewManagementService

timeout /T 10

net start QlikviewManagementService

net stop QlikViewDistributionService

timeout /T 10

net start QlikViewDistributionService

net stop QlikviewDirectoryServiceConnector

timeout /T 10

net start QlikviewDirectoryServiceConnector

echo "QV-Server-Dienste wurden neugestartet"

pause

or something as vbs:

REM wird als Task vom Windows-Aufgabenplaner alle x Minuten ausgelöst

REM Umsetzung per Schleifen-Durchlauf durch ein Array der Serverdienste

REM auskommentierter Bereich --> eventuell mal erweiterte Tasks mit Stop + Start wegen anderer Fehler oder hoher Speicherlast

REM -----------------------------------------------------------------------------------------------------------------------------

Dim oService, index, arrService, i, fso, File

set fso = CreateObject("Scripting.FileSystemObject") 'FileSystemObject erstellen

set File = fso.OpenTextFile("D:\Qlikview_Anwendungen\Retail\Log\CheckQlikViewServices.txt", 8, true)

On Error Resume Next

redim arrService(4)

arrService(0) = "QlikViewDistributionService"

arrService(1) = "QlikviewDirectoryServiceConnector"

arrService(2) = "QlikviewManagementService"

arrService(3) = "QlikviewServer"

arrService(4) = "QlikviewWebserver"

for i = 0 to ubound(arrService)

    set oService = GetObject("WinNT://" &  "OBKQLIKTECH/" & arrService(i) & ",service")

    if err.Number = 0 Then

REM               if oService.Status = 4 Then

REM                'oService.Stop

REM                File.Writeline now() & chr(9) &  arrService(i) & chr(9) & oService.Status & chr(9) & "angehalten"

REM               end if

               if oService.Status = 1 Then

                oService.Start

                File.Writeline now() & chr(9) &  arrService(i) & chr(9) & oService.Status & chr(9) & "gestartet"

               end if

    else

           File.Writeline now() & chr(9) &  arrService(i) & chr(9) & err.Number & ": " & err.Description & chr(9) & "Mail"

         'MsgBox "Fehler: " & Err.Number & vbCrLf & Err.Description, vbCritical, "Fehler"

    end if

next

File.Close

REM -----------------------------------------------------------------------------------------------------------------------------

- Marcus

[datanibbler]

Hi Marcus,

many thanks! That was much more precise than I was hoping for.

The issue, however, is not so much knowing how to do it - I cannot do it myself for I cannot access the server.

I would still like to know, however, if any of you has been having the same issues and if it's something in the QlikView_Server or just us ...

[jerrysvensson]

Which version are you running?

[marcus_sommer]

I make it in two different ways. Once as windows-task which runs with the admin-account and once as a runas-batch:

runas /user:domain\adminuser /savegred "D:\YourPath\QV_Dienste_neu_starten.cmd"

- Marcus