RQM Scorecard Report Widget Error
Hi,
Kindly help in resolving this issue we encountered in a report widget in Quality Management where in the report widget is producing an error halfway through the display. Below is the error.
The following items have errors:
TextData (id = 3729):
+ Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: ORA-01795: maximum number of expressions in a list is 1000
ReportDesign (id = 1):
+ There are errors evaluating script "// Test to see if we are at the end of the results we need to create
// If so, we return false and the fetch() method will not get called again
if (typeof root == "undefined" || root == null || i >= root.ewiToDefect.length )
return false
// Set our column fields for this row of data to be added to the dataset result
// The available row columns for this dataset are defined as the 'output columns' on the dataset.
row["EWI_ITEMID"] = root.ewiToDefect[i].ewi
row["WORKITEM_ITEMID"] = root.ewiToDefect[i].defect
row["WORKITEM_BLOCKING"]= root.ewiToDefect[i].blocking
// lookup the associated defect and assign field values to this dataset results columns
// All the column values of the defect are defined in dataset 'Remote - Workitems'
var defect = root.defects[root.ewiToDefect[i].defect]
row["WORKITEM_NAME"] = defect["WORKITEM_NAME"]
row["WORKITEM_ID"] = defect["REFERENCE_ID"]
row["WORKITEM_URL"] = defect["WORKITEM_URL"]
row["WORKITEM_STATE"] = defect["WORKITEM_STATEID.WORKITEMSTATE_NAME"]
row["WORKITEM_RESOLVER"] = defect["WORKITEM_RESOLVER.CONTRIBUTOR_USERID"]
row["WORKITEM_PRIORITY"] = defect["WORKITEM_PRIORITY.WORKITEMPRIORITY_NAME"]
row["WORKITEM_SEVERITY"] = defect["WORKITEM_SEVERITY.WORKITEMSEVERITY_NAME"]
row["WORKITEM_DATE_CREATED"] = defect["WORKITEM_DATE_CREATED_COLUMN"]
row["WORKITEM_DATE_RESOLVED"] = defect["WORKITEM_DATE_RESOLVED_COLUMN"]
// Override default text value in the DW with appropriate translated text
if ( row["WORKITEM_RESOLVER"] == "Info not available" ) {
row["WORKITEM_RESOLVER"] = nls.getString("legend.unassigned");
}
// The DW has default dates of 1969 instead of null. This is to work around the problem.
// If the DW has 1969, then the workitem has not been resolved and we don't want to show a date.
if ( row["WORKITEM_DATE_RESOLVED"] != null && row["WORKITEM_DATE_RESOLVED"].getTime() == 0 ) {
row["WORKITEM_DATE_RESOLVED"] = null ;
}
// increment to get the next row of data when we are called again
i++
// return true to indicate that we should continue processing results for this dataset
return true":
{1}.
+ Data Set script method "Fetch" returned null; expected a Boolean value.
When investigated in the logs, the following errors are encountered.
Kindly help in resolving this issue we encountered in a report widget in Quality Management where in the report widget is producing an error halfway through the display. Below is the error.
The following items have errors:
TextData (id = 3729):
+ Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: ORA-01795: maximum number of expressions in a list is 1000
ReportDesign (id = 1):
+ There are errors evaluating script "// Test to see if we are at the end of the results we need to create
// If so, we return false and the fetch() method will not get called again
if (typeof root == "undefined" || root == null || i >= root.ewiToDefect.length )
return false
// Set our column fields for this row of data to be added to the dataset result
// The available row columns for this dataset are defined as the 'output columns' on the dataset.
row["EWI_ITEMID"] = root.ewiToDefect[i].ewi
row["WORKITEM_ITEMID"] = root.ewiToDefect[i].defect
row["WORKITEM_BLOCKING"]= root.ewiToDefect[i].blocking
// lookup the associated defect and assign field values to this dataset results columns
// All the column values of the defect are defined in dataset 'Remote - Workitems'
var defect = root.defects[root.ewiToDefect[i].defect]
row["WORKITEM_NAME"] = defect["WORKITEM_NAME"]
row["WORKITEM_ID"] = defect["REFERENCE_ID"]
row["WORKITEM_URL"] = defect["WORKITEM_URL"]
row["WORKITEM_STATE"] = defect["WORKITEM_STATEID.WORKITEMSTATE_NAME"]
row["WORKITEM_RESOLVER"] = defect["WORKITEM_RESOLVER.CONTRIBUTOR_USERID"]
row["WORKITEM_PRIORITY"] = defect["WORKITEM_PRIORITY.WORKITEMPRIORITY_NAME"]
row["WORKITEM_SEVERITY"] = defect["WORKITEM_SEVERITY.WORKITEMSEVERITY_NAME"]
row["WORKITEM_DATE_CREATED"] = defect["WORKITEM_DATE_CREATED_COLUMN"]
row["WORKITEM_DATE_RESOLVED"] = defect["WORKITEM_DATE_RESOLVED_COLUMN"]
// Override default text value in the DW with appropriate translated text
if ( row["WORKITEM_RESOLVER"] == "Info not available" ) {
row["WORKITEM_RESOLVER"] = nls.getString("legend.unassigned");
}
// The DW has default dates of 1969 instead of null. This is to work around the problem.
// If the DW has 1969, then the workitem has not been resolved and we don't want to show a date.
if ( row["WORKITEM_DATE_RESOLVED"] != null && row["WORKITEM_DATE_RESOLVED"].getTime() == 0 ) {
row["WORKITEM_DATE_RESOLVED"] = null ;
}
// increment to get the next row of data when we are called again
i++
// return true to indicate that we should continue processing results for this dataset
return true":
{1}.
+ Data Set script method "Fetch" returned null; expected a Boolean value.
When investigated in the logs, the following errors are encountered.