liveCache Database Anlyzer Error " -24900 too many files list

[pr_srinivas]

Hello

it is newly installed SCM System. Things were in place ,

Suddenly i am i seeing a new entry in ALERT MONITTOR when i am navigating thru LC10

Context : MaxDB Monitoring: LCA

Object Name : Database Analyzer

Short Name : Status Database Analyzer

Status : ACTIVE

Control Text : Not activated

With other some time stamps.

I quickly tried to see DB analyzer thry DBUI

in DBUI

Under Check --> When i click Database Analyzer

OS : AIX 5.3

liveCache Version : AIX 7.6.00 Build 022-123-119-055

I am getting the aError POP-UP as below

-24900 too many files list [file_getfirst ANALYZER]

On the Popup when i click - OK.

Database Analyzer State Window is available as below

Stopped

Error : Cannot execute SQL statement.

[MySQL MaxDB][LIBSQLOD SO][MaxDB] Communication link failure;-709 CONNECT: (database not running: no request pipe)

SELECT YEAR(NOW()),MONTH(NOW()),DAY(NOW()),HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()) FROM DUAL

Stopped = 2011-10-20 16:01:53

But in my LC10 , the live cache everything is green.

How to avoid this

Rgds

PR

-

---

Self - Reference

-

---

Referred Notes

#############################################

BC-DB-SDB936058FAQ: SAP MaxDB Runtime Environment

BC-DB-SDB1423935FAQ: SAP MaxDB Database Analyzer

BC-DB-SDB819641FAQ: SAP MaxDB Performance

BC-DB-SDB869267FAQ: SAP MaxDB log area

BC-DB-LCA1601477SAP liveCache 5.0 LCA Build 22

SV-BO--487972-Operating system parameterization of liveCache

BC-DB-LVC--719652-Setting initial parameters for liveCache 7.5, 7.6, 7.7

BC-DB-LVC--875662-Importing liveCache version 7.6

Attempted Trsnactions

#############################################

DB59 - MaxDB/liveCache System Overview

LC10 - liveCache Assistant

LCA03 - Standard liveCache Test

/SAPAPO/OM11 - liveCache Application Log

/SAPAPO/OM12 - Delete liveCache Application Log

/SAPAPO/OM13 - Analyze liveCache and LCA Builds

/SAPAPO/OM17 - Data Reconciliation

Attempted Programs

#############################################

/SAPAPO/OM_NON_LC_RELEVANT_CLT - Clients not relevent to liveCache

Attempted URL's

#############################################

https://wiki.sdn.sap.com/wiki/display/MaxDB/SAPMaxDBFAQ+Notes

http://help.sap.com/saphelp_nw70/helpdata/en/0b/1c5244486a994e8fc69d1894a11d93/content.htm

http://help.sap.com/saphelp_nw04/helpdata/EN/53/ae1e3e6217b40be10000000a114084/frameset.htm (Prvsh)

http://forums.sdn.sap.com/thread.jspa?threadID=598602 (/SAPAPO/OM_REORG_DAILY error )

[pr_srinivas]

HI....

We could clear the error,

By manually deleting the files from directory

/sapdb/data/wrk/LCA/analyzer

...I am now attempting, How this reorganization / dletion old logs can happen.

Rgds

PR

SV-BO--487972-Operating system parameterization of liveCache

BC-DB-LVC--719652-Setting initial parameters for liveCache 7.5, 7.6, 7.7

BC-DB-LVC--833216-IParameter values as of liveCache Versions 7.5, 7.6 and 7.7

BC-DB-LVC1111426Parameter check for liveCache/MaxDB instances