Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ...
Which version are you running?
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