Error after database upgrade, Job Server Status error: "The underlying connection was closed: An unexpected error occurred on a receive."

Hi All,

This morning we had a DB upgrade from SQL Server 13.0.5893.48  to 14.0.3451.2. Running OneIM 7.1.3.

After restart the Develop system gave an error in the JobQueueInfo.net - Job Server Status - Job Server: The underlying connection was closed: An unexpected error occurred on a receive.

Anybody a clue?

Regards, Hans

Parents Reply Children
  • Hi, Hans, we're actually facing the same issue. Could you please explain how you did change this certificate? We're unable to know which cerficate the .net http listener currently uses. 

    Thanks!

  • Make sure you have a valid certificate installed in Windows (Job Server).

    There are 2 sides that need to be checked/set. You can choose to use SSL or not. For test purposes you can disable SSL to check if it is not another problem. 
    - Server side: running via service "One Identity Manager Service"
      The Identity Manager job service uses System.Net.HttpListener for the web interface on port 1880.
    - start: \Program Files\One Identity\One Identity Manager\JobServiceConfigurator.exe
      this will create/update "\Program Files\One Identity\One Identity Manager\JobServiceConfigurator.exe.config"
      path: Configuration > Use SSL: check!
      restart the service "One Identity Manager Service"

    - Client: JobQueueInfo.Net
      The client setup can be found in the Designer
    - Designer > Base Data
      Installation | Job Server
      New window appears: "Job Server editor", select your Job Servers
      Look below and select: One Identity Manager Service configuration > Configuration > Use SSL: check!
      Restart JobQueueInfo.Net

    Link the new Windows certificate with the IP port in netsh (Job Server)
    - show current settings
      netsh http show sslcert ipport=0.0.0.0:1880
      note: Application ID

    SSL Certificate bindings:
    -------------------------
    IP:port : 0.0.0.0:1880
    Certificate Hash : fc39077ea77a693534df63bb6c1711b1271570bc
    Application ID : {3b5779ae-209e-4749-9cf4-a58a45779392}
    Certificate Store Name : (null)
    Verify Client Certificate Revocation : Enabled
    Verify Revocation Using Cached Client Certificate Only : Disabled
    Usage Check : Enabled
    Revocation Freshness Time : 0
    URL Retrieval Timeout : 0
    Ctl Identifier : (null)
    Ctl Store Name : (null)
    DS Mapper Usage : Disabled
    Negotiate Client Certificate : Disabled

    - Delete the current SSL certificate bound to port 1880
    netsh http delete sslcert ipport=0.0.0.0:1880

    - Bind an SSL certificate to a port number
      netsh add sslcert
      - What 'appid' should I use with netsh.exe?
        stackoverflow.com/.../what-appid-should-i-use-with-netsh-exe
      - Find the GUIDs of SharePoint Web Application, Site Collection, Site, List, View and Columns
        www.sharepointdiary.com/.../find-guid-of-webapp-site-collection-web-list-view-column.html
      - You can generate a unique GUID in PowerShell: [Guid]::NewGuid().Guid
    netsh http add sslcert ipport=0.0.0.0:1880 certhash=b877aa44b6fbca7596ba27ef80a7c1f310dce939 appid={6ea5e68b-77b0-4589-851b-552aca0f9a3d}

    certhash = specify the thumbprint of the certificate (note: without spaces and delete the first character - check the thumbprint!
    appid = the old Application ID or generate a new one.

    Usefull links?
    - Easy Way To Retrieve Certificate Thumbprint Using PowerShell
      blog.rmilne.ca/.../
    - Installing and Configuring the One Identity Manager Service
      support.oneidentity.com/.../11