DSM Reporter - Report Planed Failed

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

cmengine.exe or egc30n.exe is crashing on Enterprise server when executing a report using option "Direct Domain Reporting".

cmengine.exe/egc30n.exe are taking a lot of memory and crash when memory used reaches 1.8 GB

 

In Windows Event Viewer Application, events like these could be see :

Source : Application Error

Faulting application name: cmEngine.exe, version: 14.0.2000.255, time stamp: 0x59b25f3c
Faulting module name: KERNELBASE.dll, version: 10.0.14393.4770, time stamp: 0x618088d2
Exception code: 0xe06d7363
Fault offset: 0x000dc622

and/or

Source : EGC3.0 Exception Handler
An Exception Occurred:

Reason:
egc30n.exe caused an UNKNOWN_EXCEPTION in module <UNKNOWN> at 0023:74EDC622

Environment

Client Automation 14.5 CU1

Cause

To retrieve data from Domains, Enterprise is using bcp command. But due to a problem in SQL Connection string bcp command does not work and alternative method SELECT/INSERT are used.

If there are a lot of data to retrieve this could take a lot of memory and generate a crash.

In TRC_REPORTER_*.log we could see error like :

 

230322-14:36:10.2110021L|009856|00002ce0|REPORTER |Reporter | |000000|INFO | results merge for DM_PROD...
230322-14:36:10.2110502L|009856|00002ce0|REPORTER |Reporter | |000000|INFO | Result Copy - Copying rows from [SQLServer/DM_SQL1] mdb.R003CA1 to [SQLSERVER/EM_SQL1] mdb.R01066F (Clean Move)
230322-14:36:26.2561880L|009856|00002ce0|REPORTER |Reporter | |000000|WARNING| BulkCopyTable completed with warnings
230322-14:36:26.2562448L|009856|00002ce0|REPORTER |Reporter | |000000|WARNING| Result Copy - Bulk copy should be possible, but failed

 

Resolution

This issue is fixed in Client Automation 14.5 CU3.