Defect/Issue list for OnBase due to Oracle related issues

[Alan_Vidmar]

Does anyone have a defect/issue list for each version of OnBase due to Oracle related issues? I know of two existing defects/issues in v17 due to bad SQL that is not Oracle compliant.

Issue #	895055
Summary	"ERROR [HY000] [Oracle][ODBC][Ora]ORA-00923: FROM keyword not found where expected" received when trying to use a Document Imaging Dashboard in Unity
Description of Issue	Error recieved when creating a Document Imaging Dashboard in Unity ERROR [HY000] [Oracle][ODBC][Ora]ORA-00923: FROM keyword not found where expected
System Type	OnBase
Module/Functionality	Reporting Dashboards - Unity | CSP

And another one we just discovered in v17:  DocPop search by DocID failing due to bad non-compliant SQL.  We'll get a Issue number for that shortly.

Please add any additional items to this thread that you may be aware of.

Thanks,

Alan

[Ariel_Koiman]

Hey Alan,

I see that your organization is already attached to this SCR--thought you'd like to know it's currently being worked on. The fix is still scheduled for release with v18.

Best,

Ariel
Developer II, Capture

[Alan_Vidmar]

Thanks for the response Ariel. We do look forward to having all of the Data Providers working in Reporting Dashboards. Two out of the six default Data Providers are broken right now due to non-compliant SQL.