Home Analyst Portal

SSP not works after install - Cache builder is unable to start

Martin_StrbavyMartin_Strbavy Member IT Monkey ✭
Hi guys,
I have issue with portal. Install process is finishing with status "Success with Warinings!" and reporting warning "Unable to initialize platform".

Platform Cache service is working but Cireson Cache builder is still failing. In Builder log I can see: 
2018-10-25 15:14:31,221, INFO  [MAIN]:  ============== STARTING CACHEBUILDER VERSION 8.9.4.0 ==============
2018-10-25 15:14:31,252, INFO  [MAIN]:  Running as 64 bit process: True
2018-10-25 15:14:31,252, INFO  [MAIN]:  Connecting to server: localhost
2018-10-25 15:14:31,627, INFO  [   4]:  Connected to management group: SCSM16_Deploy as Dev\Buildersvc
2018-10-25 15:14:31,627, DEBUG [   4]:  Database instance created 51550511 
2018-10-25 15:14:31,643, INFO  [   4]:  Building work item parent -> child relationships lookup table
2018-10-25 15:14:45,987, INFO  [MAIN]:  ============== STARTING CACHEBUILDER VERSION 8.9.4.0 ==============
2018-10-25 15:14:46,018, INFO  [MAIN]:  Running as 64 bit process: True
2018-10-25 15:14:46,018, INFO  [MAIN]:  Connecting to server: localhost

In Application event log are two errors:
1. Source: Application error
Event ID: 1000
Details:
Faulting application name: Cireson.CacheBuilder.WindowsService.exe, version: 8.9.4.0, time stamp: 0x5bbbceed
Faulting module name: KERNELBASE.dll, version: 10.0.14393.2457, time stamp: 0x5b7e2adb
Exception code: 0xe0434352
Fault offset: 0x0000000000033c58
Faulting process id: 0x148c
Faulting application start time: 0x01d46c64de325292
Faulting application path: C:\InetPub\CiresonPortal\bin\Cireson.CacheBuilder.WindowsService.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report Id: 72227e39-a11c-4d0d-ba65-193dcded0f7f
Faulting package full name: 
Faulting package-relative application ID:  

2. Source: .NET Runtime
Event ID: 1026
Details:
Application: Cireson.CacheBuilder.WindowsService.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Data.SqlClient.SqlException
   at System.Data.SqlClient.SqlConnection.OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1<System.Action>)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(System.Data.SqlClient.TdsParserStateObject, Boolean, Boolean)
   at System.Data.SqlClient.TdsParser.TryRun(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject, Boolean ByRef)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean ByRef)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean, Boolean ByRef)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Cireson.CacheBuilder.Service.Util.ServiceManagerUtil+<Read>d__5`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at System.Linq.Enumerable+WhereEnumerableIterator`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at Cireson.CacheBuilder.Service.Util.ParentChildUtil.LoadParentChildRelationships()
   at Cireson.CacheBuilder.Service.Bindings+<>c.<Load>b__0_6(Cireson.CacheBuilder.Service.Util.ParentChildUtil)
   at Ninject.Infrastructure.Language.ExtensionsForIEnumerableOfT.Map[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>, System.Action`1<System.__Canon>)
   at Ninject.Infrastructure.Language.ExtensionsForIEnumerableOfT.Map[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>, System.Action`1<System.__Canon>)
   at Ninject.Activation.Pipeline.Activate(Ninject.Activation.IContext, Ninject.Activation.InstanceReference)
   at Ninject.Activation.Context.ResolveInternal(System.Object)
   at Ninject.Activation.Context.Resolve()
   at System.Linq.Enumerable+WhereSelectEnumerableIterator`2[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at System.Linq.Enumerable.SingleOrDefault[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>)
   at System.Linq.Enumerable+WhereSelectArrayIterator`2[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at System.Linq.Buffer`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.Collections.Generic.IEnumerable`1<System.__Canon>)
   at System.Linq.Enumerable.ToArray[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>)
   at Ninject.Activation.Providers.StandardProvider.Create(Ninject.Activation.IContext)
   at Ninject.Activation.Context.ResolveInternal(System.Object)
   at Ninject.Activation.Context.Resolve()
   at System.Linq.Enumerable+WhereSelectEnumerableIterator`2[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at System.Linq.Enumerable.SingleOrDefault[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>)
   at System.Linq.Enumerable+WhereSelectArrayIterator`2[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at System.Linq.Buffer`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.Collections.Generic.IEnumerable`1<System.__Canon>)
   at System.Linq.Enumerable.ToArray[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>)
   at Ninject.Activation.Providers.StandardProvider.Create(Ninject.Activation.IContext)
   at Ninject.Activation.Context.ResolveInternal(System.Object)
   at Ninject.Activation.Context.Resolve()
   at System.Linq.Enumerable+WhereSelectEnumerableIterator`2[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at System.Linq.Enumerable+<CastIterator>d__97`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
   at System.Linq.Enumerable.Single[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>)
   at Cireson.CacheBuilder.Service.CacheEngine.KeyGroupsAreValid()
   at Cireson.CacheBuilder.Service.CacheEngine+<BuildAllAsync>d__14.MoveNext()
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(System.Threading.Tasks.Task)
   at Cireson.CacheBuilder.Service.CacheEngine+<<Start>b__12_0>d.MoveNext()
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()

Thanks for any help
Martin

Best Answer

  • Martin_StrbavyMartin_Strbavy IT Monkey ✭
    Accepted Answer
    Ok. I found the issue. Server has configured Time/Date formats to Norwegian and Service was failing with Unable to convert variables error. I found this when I was running service manually from Inetpub.

    Maybe this will help someone in a future..

    Maybe would be nice to get at least some nice error :)

    Regards
    Martin

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    Hi Martin,
    Is the service account running your cachebuilder service able to read the ServiceManager database?  
  • Martin_StrbavyMartin_Strbavy Member IT Monkey ✭
    Hi,
    yes service account has DBowner for ServiceManager and ServiceManagement DB. 

    I forgot to mention, Web server is running on Windows Server 2016 and SQL is SQL 2016 SP2. But what I know both should be supported, but maybe I missed something?

    Thanks
    Martin
  • Martin_StrbavyMartin_Strbavy Member IT Monkey ✭
    Accepted Answer
    Ok. I found the issue. Server has configured Time/Date formats to Norwegian and Service was failing with Unable to convert variables error. I found this when I was running service manually from Inetpub.

    Maybe this will help someone in a future..

    Maybe would be nice to get at least some nice error :)

    Regards
    Martin
  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    Hey @Martin_Strbavy - I appreciate the feedback on your fix here!  Running cachebuilder manually is a great idea as a troubleshooting step!
Sign In or Register to comment.