Home Analyst Portal

Error Platform Cache Service after installing new Portal version 9.0.3.2016

Margarete_JussenMargarete_Jussen Customer Adept IT Monkey ✭✭

After installing the new version we get the following message in Event log. Our view new config items which I set to visible in the Navigation pane is empty. Could anyone help please

Regards, Margret

- System
  - Provider
   [ Name]  Cireson Platform - Main
   - EventID 0
   [ Qualifiers]  0
    Level 2
    Task 0
    Keywords 0x80000000000000
   - TimeCreated
   [ SystemTime]  2019-03-08T10:06:41.350056100Z
    EventRecordID 81106
    Channel Application
    Computer AS-SCSMTEST33.klinikum.rwth-aachen.de
    Security
 - EventData
   Exception creating instance of BootstrapHandler PlatformCache.Data.LifecycleManagement.RecompileDynamicEdmIfNecessary

Best Answer

  • Margarete_JussenMargarete_Jussen Customer Adept IT Monkey ✭✭
    Answer ✓
    Raised an Incident at Cireson support Portal. We now use a Workaround and renamed the Service Manager database to ServiceManager (from ServiceManager33). We also changed the entry in registry. Now the config items are shown. 

Answers

  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    Hi @Margarete_Jussen

    Any SQL error logs? If not, can you paste the last item in the platform_cache log

    Geoff
  • Margarete_JussenMargarete_Jussen Customer Adept IT Monkey ✭✭
    Hello, no new SQL Errors. The following entries are in the file log.txt:

    UTC timestamp: 12.03.2019 07:27:57, Type Critical, Source: Cireson.Core.Services.RoleServices.ApplicationRoleProvider.ExecuteResetCache, Text: Building Authorization Cache.

    Is this the platform Cache log?
  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    The platform cache log is found at C:\ProgramData\Cireson.Platform.Host
  • Margarete_JussenMargarete_Jussen Customer Adept IT Monkey ✭✭
    Thanks, Here some error Messages, it seems that it does not work because our Service Manager Database name in test system is not Service Manager.
        at PlatformCache.Data.LifecycleManagement.RecompileDynamicEdmIfNecessary.OnExecute(IBootstrapStageManager manager) in D:\a\1\s\PlatformCache\PlatformCache.Data\LifecycleManagement\RecompileDynamicEdmIfNecessary.cs:line 20
       at Cireson.Platform.Runtime.Runtime.BootStrapStateManagement.BootstrapStageManager.ExecuteCurrentStageHandlers() in D:\a\1\s\Cireson.Platform.Runtime\Runtime\BootStrapStateManagement\BootstrapStageManager.cs:line 144
       at Cireson.Platform.Runtime.Runtime.PlatformRuntime.Start(IPlatformRuntimeConfig config) in D:\a\1\s\Cireson.Platform.Runtime\Runtime\PlatformRuntime.cs:line 125
    ---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): Database 'ServiceManager' does not exist. Make sure that the name is entered correctly.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader()
       at PlatformCache.Data.Models.RuntimeCache.CacheManagementRuntimeTemplateService.<RunQuery>d__26`1.MoveNext() in D:\a\1\s\PlatformCache\PlatformCache.Data\Models\RuntimeCache\CacheManagementRuntimeTemplateServicePartial.cs:line 472
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at PlatformCache.Data.Models.RuntimeCache.CacheManagementRuntimeTemplateService.GetCacheableTables(String connectionString, String databaseName) in D:\a\1\s\PlatformCache\PlatformCache.Data\Models\RuntimeCache\CacheManagementRuntimeTemplateServicePartial.cs:line 324
       at PlatformCache.Data.Models.RuntimeCache.CacheManagementRuntimeTemplateService.GetCacheManagementTables() in D:\a\1\s\PlatformCache\PlatformCache.Data\Models\RuntimeCache\CacheManagementRuntimeTemplateServicePartial.cs:line 113
       at PlatformCache.Data.Models.RuntimeCache.CacheManagementRuntimeTemplateService.GetLastCacheManagementTableChange() in D:\a\1\s\PlatformCache\PlatformCache.Data\Models\RuntimeCache\CacheManagementRuntimeTemplateServicePartial.cs:line 108
       at PlatformCache.Data.Models.RuntimeCache.CacheManagementRuntimeTemplateService.<IsModelStale>d__10.MoveNext() in D:\a\1\s\PlatformCache\PlatformCache.Data\Models\RuntimeCache\CacheManagementRuntimeTemplateServicePartial.cs:line 83
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at PlatformCache.Data.Services.Implementations.RuntimeCacheBuildService.<RecompileRequired>d__10.MoveNext() in D:\a\1\s\PlatformCache\PlatformCache.Data\Services\Implementations\RuntimeCacheBuildService.cs:line 58
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at PlatformCache.Data.Services.Implementations.RuntimeCacheBuildService.<RecompileRuntimeCacheIfRequired>d__11.MoveNext() in D:\a\1\s\PlatformCache\PlatformCache.Data\Services\Implementations\RuntimeCacheBuildService.cs:line 71
    ClientConnectionId:1bb88baa-8f17-4cb7-a235-d876cde0657b
    Error Number:911,State:1,Class:16<---
  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    I should read that database connection string from the cachebuilder config file found in

    \CiresonPortal\bin\Cireson.CacheBuilder.WindowsService.exe.config

    Can you check that please.

    Geoff
  • Margarete_JussenMargarete_Jussen Customer Adept IT Monkey ✭✭
      <connectionStrings>
        <add name="ServiceManagementDatabase" connectionString="Server=db-scsmtest;Database=ServiceManagement33;Trusted_Connection=True;" />
        <add name="ServiceManagerDatabase" connectionString="Server=db-scsmtest;Database=ServiceManager33;Trusted_Connection=True;" />
        <add name="EntityModels" connectionString="data source=db-scsmtest;initial catalog=ServiceManagement33;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />
      </connectionStrings>
  • Margarete_JussenMargarete_Jussen Customer Adept IT Monkey ✭✭
        <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
          <parameters>
            <parameter value="mssqllocaldb" />
          </parameters>
        </defaultConnectionFactory>
  • Margarete_JussenMargarete_Jussen Customer Adept IT Monkey ✭✭
    Answer ✓
    Raised an Incident at Cireson support Portal. We now use a Workaround and renamed the Service Manager database to ServiceManager (from ServiceManager33). We also changed the entry in registry. Now the config items are shown. 
  • Alexander_AxbergAlexander_Axberg Member Adept IT Monkey ✭✭

    Anyone knows if Cireson has a registered problem for fixing this bug? So that the platform can handle a Service Manager database with another name than default. Just upgraded to 9.6.0 but the issue is still there.

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭

    Hi @Alexander_Axberg

    This should have been resolved..

    I would probably log a support issue for this so we can take a look.

    Thanks,

    Shane

Sign In or Register to comment.