Error On Topics Tab: SQL Where Clause caused an error and was removed com.oracle.hsgbu.empirica.jdbc.DatabaseException: System Error
(Doc ID 2256346.1)
Last updated on FEBRUARY 05, 2020
Applies to:Oracle Health Sciences Empirica Topics Cloud Services - Version 22.214.171.124 and later
Information in this document applies to any platform.
Customer is currently on Signal version 7.3.
The proposed solution applies to version 126.96.36.199.178.
Steps to reproduce your problem:
navigate to Topics tab
click 'Select Rows'
click 'Select All'
click 'Topics by Action Due Date'
choose 'Overdue' or Closed'
Click 'View Report'
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