Error message in sldppcoll.log when using Oracle database and SP Portal 4.10
search cancel

Error message in sldppcoll.log when using Oracle database and SP Portal 4.10

book

Article ID: 86952

calendar_today

Updated On:

Products

CA Automic Sysload

Issue/Introduction

Affects Release version(s): 5

Error Message :
In the sldppcoll.log:
###########################
sldf_scope.php [572] Error : oci8 error: [1795: ORA-01795: le nombre maximum d'expressions autorisé dans une liste est de 1000] in EXECUTE("SELECT DISTINCT sld_internalmetric_entity_id, sld_internalmetric_entity_name FROM sld_internalmetric_entity WHERE sld_internalmetric_entity_id IN (1681,1682,1683,1684... 

PHP Notice: Undefined index: vm in C:\Program Files (x86)\Sysload\spportal\webroot\scriptspp\reportsdef\sldk_tfullview\sldk_tfullview_vsphere_dat.php on line 1351
########################### 

Patch level detected:Sysload Portal 4.10
Product Version: Sysload 5.7.0

Description :An error message regarding an Oracle query wrongly formulated appears in the sldppcoll.log file (more than 1000 elements in the IN)

Environment

OS: Windows

Cause

Cause type:
Defect
Root Cause: N/A

Resolution

Update to the fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component: Portal
Version: Sysload 5.7.0

Additional Information

Workaround :
N/A