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

Document ID : KB000086952
Last Modified Date : 07/05/2018
Show Technical Document Details
Issue:
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