Caching Service Error

I am running the Community Edition as we evaluate the product.  When I try hitting the computers tab, I get an error:

Web Portal Error
The required service 'Caching Service' cannot be contacted.  The information in list of computer will not be accurate.


Error Log
6/15/2017 1:51:43 PM -> Using settings from 'C:\InetPub\ConfigMgrPortal\Configuration.xml'
6/15/2017 1:51:46 PM -> Error: Error in 'HostingService.OnStart'
6/15/2017 1:51:46 PM -> Error message: Cannot open database "ConfigMgrPortal" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.
6/15/2017 1:51:46 PM -> Stack Trace:    at ConfigMgrPortal.Core.DAL.SQLHelper.ExecuteDataset(String cmdText)
   at ConfigMgrPortal.Core.DAL.SQLHelper.ExecuteDataTable(String cmdText)
   at ConfigMgrPortal.Core.DAL.HostingService.GetHostingServices(String sql)
   at ConfigMgrPortal.Core.DAL.HostingService.GetFromServicename(String newServiceName)
   at ConfigMgrPortal.HostingSvc.HostingService.StartUp()


Best Answer

Answers

  • F_ChristiansenF_Christiansen Cireson Dev Advanced IT Monkey ✭✭✭
    Correct what Davis is suggesting - and way easiest. But if you want to keep using LocalSystem for your service, you can set up permissions for NT AUTHORITY\SYSTEM on the databases.
    Refer to the installation guide starting on page 20 and just use NT AUTHORITY\SYSTEM and the computer account instead of the AD user.

    You can download the installation guide from here if you don't already have it:
    https://ciresonreleases.blob.core.windows.net/cmp/Cireson Portal for Configuration Manager Install Guide v1.0.pdf

    Best regards
    Flemming Appelon Christiansen
  • John_AubreyJohn_Aubrey Customer IT Monkey ✭
    What Dave recommended worked. Thanks!


  • NicklasHalmeNicklasHalme Member IT Monkey ✭
    I have the same error and I'm running the service with domain account. The account has the rights to connect to the CMP and ConfigMgr databases. The error that is in hostingService.log is:

    Error: Error in 'HostingService.RegistrerInWindowsServiceDatabase'
    Error message: Object reference not set to an instance of an object.
    Stack Trace:    at ConfigMgrPortal.HostingSvc.HostingService.RegistrerWindowsServiceDatabase()

    Any ideas?

  • F_ChristiansenF_Christiansen Cireson Dev Advanced IT Monkey ✭✭✭
    Hi Nicklas,

    Yes, I sounds like you will need the update to the latest version as we should have fixed this bug.
    Please download the latest from http://softwaredownloads.cireson.com/

    Let me know how that work. If you are already on that version, let me know too :-)

    Best regards
    Flemming Appelon Christiansen
  • NicklasHalmeNicklasHalme Member IT Monkey ✭
    Did not have the latest. Downloaded. I will report the result once I get it installed.

    Thanks!
  • NicklasHalmeNicklasHalme Member IT Monkey ✭
    Updated to 2.1, but still have the problem:

    Error: Error in 'HostingService.RegistrerInWindowsServiceDatabase'
    Error message: Object reference not set to an instance of an object.
    Stack Trace:    at ConfigMgrPortal.HostingSvc.HostingService.RegistrerWindowsServiceDatabase()
  • F_ChristiansenF_Christiansen Cireson Dev Advanced IT Monkey ✭✭✭
    Please send me the entire content of the log.
  • NicklasHalmeNicklasHalme Member IT Monkey ✭
    29.8.2017 17.00.44 -> -----------------------------------Hosting Service info-----------------------------------
    29.8.2017 17.00.44 ->
    29.8.2017 17.00.44 -> Name: Hosting Service
    29.8.2017 17.00.44 -> Version: 2.1.0.0
    29.8.2017 17.00.44 -> Server: CM01
    29.8.2017 17.00.44 -> System: Microsoft Windows Server 2016 Standard - 64-bit - 10.0.14393
    29.8.2017 17.00.44 ->
    29.8.2017 17.00.44 -> ------------------------------------------------------------
    29.8.2017 17.00.44 ->
    29.8.2017 17.00.44 ->
    29.8.2017 17.00.44 -> Using settings from 'C:\InetPub\ConfigMgrPortal\Configuration.xml'
    29.8.2017 17.00.44 -> Connecting to database. Getting setting from configuration.xml.
    29.8.2017 17.00.44 -> Server: CM01, Database: ConfigMgrPortal, Windows
    29.8.2017 17.00.44 -> Error: Error in 'HostingService.RegistrerInWindowsServiceDatabase'
    29.8.2017 17.00.44 -> Error message: Object reference not set to an instance of an object.
    29.8.2017 17.00.44 -> Stack Trace:    at ConfigMgrPortal.HostingSvc.HostingService.RegistrerWindowsServiceDatabase()
  • NicklasHalmeNicklasHalme Member IT Monkey ✭
    Any ideas how to solve this issue?
  • Davis_MathaiDavis_Mathai Member Adept IT Monkey ✭✭
    Hi Nicklas,
    It looks like there may be an issue with the Cireson ConfigMgr Portal Hosting Service.  Could you uninstall the service from Add Remove programs and then re-install from the Manual Install > Cireson ConfigMgr Portal Service Installer folder in your downloaded media please?
    Thanks,
  • NicklasHalmeNicklasHalme Member IT Monkey ✭
    Hi Davis, I did uninstall it and re-run the Cireson ConfigMgr Portal Service x64.msi. Here is what the log:

    7.9.2017 22.16.50 -> -----------------------------------Hosting Service info-----------------------------------
    7.9.2017 22.16.50 ->
    7.9.2017 22.16.50 -> Name: Hosting Service
    7.9.2017 22.16.50 -> Version: 2.1.0.0
    7.9.2017 22.16.50 -> Server: CM01
    7.9.2017 22.16.50 -> System: Microsoft Windows Server 2016 Standard - 64-bit - 10.0.14393
    7.9.2017 22.16.50 ->
    7.9.2017 22.16.50 -> ------------------------------------------------------------
    7.9.2017 22.16.50 ->
    7.9.2017 22.16.50 ->
    7.9.2017 22.16.50 -> Using settings from 'C:\Inetpub\ConfigMgr Portal\Configuration.xml'
    7.9.2017 22.16.50 -> Error: Error in 'HostingService.OnStart'
    7.9.2017 22.16.50 -> Error message: The ConnectionString property has not been initialized.
    7.9.2017 22.16.50 -> Stack Trace:    at ConfigMgrPortal.Core.DAL.SQLHelper.ExecuteDataset(String cmdText)
       at ConfigMgrPortal.Core.DAL.SQLHelper.ExecuteDataTable(String cmdText)
       at ConfigMgrPortal.Core.DAL.HostingService.GetHostingServices(String sql)
       at ConfigMgrPortal.Core.DAL.HostingService.GetFromServicename(String newServiceName)
       at ConfigMgrPortal.HostingSvc.HostingService.StartUp()

  • F_ChristiansenF_Christiansen Cireson Dev Advanced IT Monkey ✭✭✭
    Hi Nicklas,

    I would like to take a closer look at your environment to help you out, I will be sending you a message.

    Best regards
    Flemming Appelon Christiansen
  • Davis_MathaiDavis_Mathai Member Adept IT Monkey ✭✭
    Hi Nicklas,

    Just checking to see if this was resolved?

    Thanks,
    Davis

  • Nicklas_HalmeNicklas_Halme Member IT Monkey ✭
    Hi Davis,

    Yes, this has been fixed in the latest release. There was issue with the date/time format used in Finnish region, but Flemming was able to solve it. Thanks!
Sign In or Register to comment.