Caching Service Error

John_Aubrey

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()

Davis_Mathai

Hi,
It looks like you are using the local system account to run the caching service (ConfigMgr portal hosting service).  Could you change it to your application pool account (domain account) which should have the rights to connect to the CMP and ConfigMgr databases.
Hope that helps.

Davis

Davis_Mathai

Hi,
It looks like you are using the local system account to run the caching service (ConfigMgr portal hosting service).  Could you change it to your application pool account (domain account) which should have the rights to connect to the CMP and ConfigMgr databases.
Hope that helps.

Davis

F_Christiansen

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_Aubrey

What Dave recommended worked. Thanks!

NicklasHalme

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_Christiansen

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

NicklasHalme

Did not have the latest. Downloaded. I will report the result once I get it installed.

Thanks!

NicklasHalme

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_Christiansen

Please send me the entire content of the log.

NicklasHalme

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()

NicklasHalme

Any ideas how to solve this issue?

Davis_Mathai

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,

NicklasHalme

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_Christiansen

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_Mathai

Hi Nicklas,

Just checking to see if this was resolved?

Thanks,
Davis

Nicklas_Halme

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!