SQL Timeouts / Environment Failures

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #786
    Lexx
    Member
    • Total Post: 1
    • Newbie

    Hello all, i’m new to the site but i hope to get some hints / solutions for the problems we are having with WDM

    Since an upgrade from Rapport 4.4 to WDM 4.5.1 it has
    worked fine for two weeks, when all of a sudden the program begun to display the following symptoms:

    – Wyse Devige Manager MMC:
    When viewing ‘update manager > scheduled tasks’ the error
    ‘Timeout Expired – SQL database’ appears.
    sometimes after trying 10 times we can view the scheduled tasks.

    – When it is possible to deploy an image (on a V90 for example)
    The client boots, connects to the wyse server, but then displays
    ‘Environment Failure’
    The IIS components seem to be working fine (http, ftp)

    – When running rptdiag.exe the tool gives an error at ‘Testing Database’
    ‘Currently validating: Rapport Web Service’
    ‘Connection To HServer failed’
    And a C++ error appears afterwards

    – On a sidenote, the IIS logs from the Wyse HTTP site is filled with:
    ‘VSQL02 192.168.10.2 80 PUT /hserver.dll &V01|&IMAC=00806454B029|CID=117||WFE=1|WF=0|OS=1|VI=1|AL=c:programüfilesrapport’
    Wich is a non-existing path.

    Detailed info:
    – Version of WDM is 4.5.1, running on an windows 2000 AS machine
    – SQL (2000?) desktop engine that the installer created itself.
    – The DB is around +/- 1 GB in size.
    – The installation is an upgrade from Rapport 4.4.
    – Following hotfixes were installed after these problems appeared:
    4051010007
    4051010107
    4051011507
    4051012707
    4051013407
    4051027707

    I’ve spend almost a day trying to fix these issues, but short of a re-install i’m out of options. I hope anyone can give me some advice!

    #10957
    Joe
    Member
    • Total Post: 96
    • Back Stage Pass
    • ★★★★

    – Wyse Devige Manager MMC:
    When viewing ‘update manager > scheduled tasks’ the error ‘Timeout Expired – SQL database’ appears. Sometimes after trying 10 times we can view the scheduled tasks.

    I’ve seen this issue when problems were occuring on the database server. It might be worth checking your database server to make sure it is operating properly.

    – When it is possible to deploy an image (on a V90 for example) The client boots, connects to the wyse server, but then displays ‘Environment Failure’
    The IIS components seem to be working fine (http, ftp)

    From my experience, this indicates you’re trying to push an image to a machine that the image isn’t compatible with. I don’t know if that is the only cause for this, or if it is even the correct answer.

    For example, I have quite a few v90 machiens in the field. Apparently the v90 is discontinued, and was replaced by the v90L. I wasn’t aware that my company had been purchasing them until they started calling me with this error. The image that I had created for the v90 didn’t work with the v90L.

    – When running rptdiag.exe the tool gives an error at ‘Testing Database’ ‘Currently validating: Rapport Web Service’ ‘Connection To HServer failed’ And a C++ error appears afterwards

    I’ve had problems with iis crashing, thus making connections to the HServer impossible. It’s possible that hserver isn’t available while you’re trying to test the database. Try giving the computer a restart to refresh all the services and make sure they’re up and running. I know that in some environments, rebooting the server is a no-no. In that case, you can try this script to restart the “core” WDM services.


    :Init
    @Echo Off
    Cls

    :Stop
    Echo
    Echo Stopping Core WDM Services
    Echo
    Echo ¦ World Wide Web Publishing Service
    Net Stop W3Svc
    Echo ¦ Microsoft FTP Services
    Net Stop MSFTPSVC
    Echo ¦ Rapport
    Net Stop RAPPORT4
    Echo
    Echo Core WDM Services Stopped
    Echo

    :Start
    Echo
    Echo Starting Core WDM Services
    Echo
    Echo ¦ World Wide Web Publishing Service
    Net Start W3Svc
    Echo ¦ Microsoft FTP Services
    Net Start MSFTPSVC
    Echo ¦ Rapport
    Net Start RAPPORT4
    Net Start HServerInit
    Echo
    Echo Core WDM Services Started
    Echo

    Just save the contents to a text file and rename it RestartWDM.cmd or whatever you want to all it. Then double click it.

    – On a sidenote, the IIS logs from the Wyse HTTP site is filled with:
    ‘VSQL02 192.168.10.2 80 PUT /hserver.dll &V01|&IMAC=00806454B029|CID=117||WFE=1|WF=0|OS=1|VI=1|AL=c:programüfilesrapport’
    Wich is a non-existing path.

    This looks to me like a transaction where the thin client is checking in with the WDM server. Is 192.168.10.2 a thin client? I’m pretty sure it is, because of the MAC address — I believe the 008064xxxxxx block belongs to Wyse.

    If I had to take a guess, and this is a complete guess, I bet AL is something like Agent Location, and shows the location on the thin client where the WDM/Rapport agent is installed. So look on your thin client for this directory, not your server.

    While I know I didn’t give any concrete fixes, hopefully I got you looking in the right direction.

    #10963
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    Hi Lexx,

    can you give us some more details about your WDM server? Version, hotfixes, server OS, language, SQL server version, language????

    Thanks
    ConfGen

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.