Cachebuilder Not Updating Database (dbo.CI$User Empty)

Shauna_Willmore

Our team is attempting to install the Analyst Portal and are having trouble getting the ServiceManagement Database to update resulting in "LOGINACCESSDENIED" when attempting to sign into the portal (forms authentication). The install completed with no errors or warnings.

The CacheBuilder log reports the following:

2017-03-01 07:54:32,487, INFO  [MAIN]:  ============== STARTING CACHEBUILDER VERSION 7.3.2012.1 ==============
2017-03-01 07:54:32,597, INFO  [MAIN]:  Running as 64 bit process: True
2017-03-01 07:54:32,622, INFO  [MAIN]:  Connecting to server: DEVSCSMMS1
2017-03-01 07:54:34,483, INFO  [   8]:  Connected to management group: DEV_SM as SCSMCacheBuilder
2017-03-01 07:54:34,551, DEBUG [   8]:  Database instance created 57605583
2017-03-01 07:54:34,573, INFO  [   8]:  Building work item parent -> child relationships lookup table
2017-03-01 07:55:43,967, INFO  [MAIN]:  ============== STARTING CACHEBUILDER VERSION 7.3.2012.1 ==============
2017-03-01 07:55:44,060, INFO  [MAIN]:  Running as 64 bit process: True
2017-03-01 07:55:44,089, INFO  [MAIN]:  Connecting to server: DEVSCSMMS1
2017-03-01 07:55:45,588, INFO  [   3]:  Connected to management group: RVHDEV_SM as SCSMCacheBuilder
2017-03-01 07:55:45,614, DEBUG [   3]:  Database instance created 13362614
2017-03-01 07:55:45,645, INFO  [   3]:  Building work item parent -> child relationships lookup table
2017-03-01 07:56:56,878, INFO  [MAIN]:  ============== STARTING CACHEBUILDER VERSION 7.3.2012.1 ==============
2017-03-01 07:56:56,979, INFO  [MAIN]:  Running as 64 bit process: True
2017-03-01 07:56:57,001, INFO  [MAIN]:  Connecting to server: DEVSCSMMS1
2017-03-01 07:56:59,010, INFO  [   4]:  Connected to management group: DEV_SM as SCSMCacheBuilder
2017-03-01 07:56:59,048, DEBUG [   4]:  Database instance created 47670324
2017-03-01 07:56:59,059, INFO  [   4]:  Building work item parent -> child relationships lookup table

Any ideas?

Morten_Meisler

But it looks like you are refering to the Data warehouse databases? Database=DWDataMart, that should be Database=ServiceManager and then the correct SQL servername for where this is located.

Morten_Meisler

I have seen this error before, in my case it was that the SQL server name in the config file was in a wrong format.

Check the config file: \inetpub\CiresonPortal\bin\Cireson.CacheBuilder.WindowsService.exe.config

 <add name="ServiceManagementDatabase" connectionString="Server=localhost;Database=ServiceManagement;Trusted_Connection=True;" />

    <add name="ServiceManagerDatabase" connectionString="Server=localhost;Database=ServiceManager;Trusted_Connection=True;" />

    <add name="EntityModels" connectionString="data source=localhost;initial catalog=ServiceManagement;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />

(my test environment has sql installed locally). In my case the "Server=" <sqlserver> was missing. it just had connectionString="<sqlserver>..". 

The cachebuilder service starts for a second and then shutsdown (and tries to restart again and again). There is a unhandled exception error in the Application log in Event Viewer, but no indication of what/where the error is.

Shauna_Willmore

Morten_Meisler said:

I have seen this error before, in my case it was that the SQL server name in the config file was in a wrong format.

Check the config file: \inetpub\CiresonPortal\bin\Cireson.CacheBuilder.WindowsService.exe.config

 <add name="ServiceManagementDatabase" connectionString="Server=localhost;Database=ServiceManagement;Trusted_Connection=True;" />

    <add name="ServiceManagerDatabase" connectionString="Server=localhost;Database=ServiceManager;Trusted_Connection=True;" />

    <add name="EntityModels" connectionString="data source=localhost;initial catalog=ServiceManagement;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />

(my test environment has sql installed locally). In my case the "Server=" <sqlserver> was missing. it just had connectionString="<sqlserver>..". 

The cachebuilder service starts for a second and then shutsdown (and tries to restart again and again). There is a unhandled exception error in the Application log in Event Viewer, but no indication of what/where the error is.

I believe it looks correct!

<connectionStrings>
    <add name="ServiceManagementDatabase" connectionString="Server=DEVSCSMDW;Database=ServiceManagement;Trusted_Connection=True;" />
    <add name="ServiceManagerDatabase" connectionString="Server=DEVSCSMDW;Database=DWDataMart;Trusted_Connection=True;" />
    <add name="EntityModels" connectionString="data source=DEVSCSMDW;initial catalog=ServiceManagement;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
  </connectionStrings>

Here is the event log entry:

Faulting application name: Cireson.CacheBuilder.WindowsService.exe, version: 7.3.2012.1, time stamp: 0x5892cca0 Faulting module name: KERNELBASE.dll, version: 6.3.9600.17415, time stamp: 0x54505737 Exception code: 0xe0434352 Fault offset: 0x0000000000008b9c Faulting process id: 0x20e8 Faulting application start time: 0x01d29291b20ccd96 Faulting application path: C:\InetPub\CiresonPortal\bin\Cireson.CacheBuilder.WindowsService.exe Faulting module path: C:\Windows\system32\KERNELBASE.dll Report Id: f7986f15-fe84-11e6-80d1-005056be763b Faulting package full name: Faulting package-relative application ID:

Morten_Meisler

But it looks like you are refering to the Data warehouse databases? Database=DWDataMart, that should be Database=ServiceManager and then the correct SQL servername for where this is located.