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.