My Oracle Support Banner

Error On Topics Tab: SQL Where Clause caused an error and was removed System Error (Doc ID 2256346.1)

Last updated on FEBRUARY 05, 2020

Applies to:

Oracle Health Sciences Empirica Topics Cloud Services - Version and later
Information in this document applies to any platform.


Customer is currently on Signal version 7.3.
The proposed solution applies to version

Steps to reproduce your problem:


navigate to Topics tab

click 'Select Rows'

click 'Select All'

Click 'Reports'

click 'Topics by Action Due Date'

choose 'Overdue' or Closed'

Click 'View Report'

Test results:

Selecting 999 items did not throw an error.
Selecting 1000 items did not throw an error.
Selecting 1001 items generated the error.

 Running topic reports: 'Topics by Action Due Date' or 'Topics by State' both fail with the following error message when selecting more than 1000 Topics:





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.