SAP FC and certificate of session x is invalid

Issue:

Your users may get a lot of different errors in SAP Financial Consolidation Client application (Finance.exe)

Failed%20to%20load%20one%20or%20more%20objects%20of%20type

Failed to load one or more objects of type

Error%20in%20the%20data%20engine

Error in the data engine

The%20certificate%20of%20session%20is%20invalid

The certificate of session is invalid

Environment:

SAP Financial Consolidation 10.1

Windows Terminal server for publishing SAP Financial Consolidation Client Application

SAP Financial Consolidation server is installed on a separate server

How to investigate:

The first of all, check SAP FC log files on the server <Installation_directory_SAP_FC>\Logs:

  • ctserver-<Date_and_time>-<PID>.log , it is a log of SAP FC instance of a data source

SAP%20FC%20instances%20of%20one%20data%20source

SAP FC instances of one data source

You will find the message like:

08-19-22 11:42:51 PID=5225832 THD=5215612 USR= MSG=0 WARN Apcom.Framework.SessionService.SessionService - Session {0604A7C5-CC6E-4682-B548-AC47D0169B31} has expired. 08-19-22 11:42:51 PID=5225832 THD=5215612 USR= MSG=0 INFO security.principal - Session ended by user 'UID=<user_name>' - SessionID={17F49484-E71A-4982-99ED-9F850A9F57C0} - Certificate={0604A7C5-CC6E-4682-B548-AC47D0169B31} 08-19-22 09:42:51 PID=5225832 THD=5215612 USR= MSG=0 INFO system.process - Killing processes dependent of session {0604A7C5-CC6E-4682-B548-AC47D0169B31} 08-19-22 09:42:51 PID=5225832 THD=5215612 USR= MSG=0 INFO system.process - SESS-PROC before : 4 ## [  - () ][ {0604A7C5-CC6E-4682-B548-AC47D0169B31} - (100942, ) ][ {918778F9-79FA-42AB-ADEC-3154A356E81C} - (100125, ) ][ {B2290CFF-B373-43FD-8E08-4A0122CBA905} - (2, ) ][ {FE90594D-B41F-47B9-A24F-DC1E8281914B} - (97840, ) ] 08-19-22 09:44:14 PID=5225832 THD=5034164 USR= MSG=10139 ERROR application - The certificate of session {0604A7C5-CC6E-4682-B548-AC47D0169B31} is invalid.

The second, check event viewer on Windows Terminal server where SAP Financial Consolidation Client Application works:

Event%20viewer%20and%20Finance.exe%20crashing%20error

Event viewer and Finance.exe crashing error

You will find the errors like:

Faulting application name: Finance.exe, version: 10.1.907.2078, time stamp: 0x5fdfd793
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc000041d
Fault offset: 0x00000004
Faulting process ID: 0x1978
Faulting application start time: 0x01d8b6c20423a0b9
Faulting application path: C:\Program Files (x86)\SAP\Financial Consolidation\Finance.exe
Faulting module path: unknown
Report ID: 776592d4-b32b-4a88-8f67-56f1efa4618b
Faulting package full name:
Faulting package-relative application ID:
Faulting application name: Finance.exe, version: 10.1.907.2078, time stamp: 0x5fdfd793
Faulting module name: ntdll.dll, version: 10.0.17763.2867, time stamp: 0xdff83dde
Exception code: 0xc000000d
Fault offset: 0x001012bf
Faulting process ID: 0xdd8
Faulting application start time: 0x01d8b6bb1a29d7a9
Faulting application path: C:\Program Files (x86)\SAP\Financial Consolidation\Finance.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report ID: 316214d9-60ec-4e57-bd72-4bc8e65db7f5
Faulting package full name:
Faulting package-relative application ID:
Faulting application name: Finance.exe, version: 10.1.907.2078, time stamp: 0x5fdfd793
Faulting module name: mfc120u.dll, version: 12.0.21005.1, time stamp: 0x524fabbd
Exception code: 0xc000041d
Fault offset: 0x0024e1e4
Faulting process ID: 0x4f98
Faulting application start time: 0x01d8b6b222d0d1e0
Faulting application path: C:\Program Files (x86)\SAP\Financial Consolidation\Finance.exe
Faulting module path: C:\Windows\SYSTEM32\mfc120u.dll
Report ID: e0d34288-71ca-42cf-8ce3-d45ec7349c7d
Faulting package full name:
Faulting package-relative application ID:

Root cause:

The root cause of the problem is an interrupted network connection between Windows Terminal server and SAP Financial Consolidation server.

Run continues ping command from SAP Financial Consolidation Server to Windows Terminal server to catch the network problem:

Ping.exe -t <IP> | ForEach {"{0} - {1}" -f (Get-Date),$_} , PowerShell command with

Useful links: