Report Viewer - Unable to generate Module Productivity Report "Database logon failed" for Oracle Database

Issue

When customer with an Oracle 12c Database are unable to retrieve any standard Kofax Reports via Report Viewer.

Error message found in the ERR_YYMM.txt logs are similar to TFS 55533 which was for SQL Server (Fixed in KC 11.0.0.1):-

2021-09-28 16:34:22, 0x00000018, 0x00000000, 0x00000069, 0x80131500, 0x00000000, C:\Kofax\CaptureSS\ServLib\Bin, ReportViewer, PRIMARY:Sess 2, 11.0.646.0, ShowReportError at offset 157 in file:line:column <filename unknown>:0:0
, 0, Unable to generate System Status Report.CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon failed. ---> System.Runtime.InteropServices.COMException: Database logon failed.   at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.GetLastPageNumber(RequestContext pRequestContext)   at CrystalDecisions.ReportSource.EromReportSourceBase.GetLastPageNumber(ReportPageRequestContext reqContext)   --- End of inner exception stack trace ---   at Kofax.AscentCapture.ReportViewer.ReportViewerForm.ShowReport(), ,

Solution

This is a known TFS Bug 1102650 which was fixed in KC 11.0.0.2.

Add the following tag to ACConfig.xml to enable ReportViewer to use Ole DB Provider for Oracle
      instead of ODBC Provider:
      <ACConfig>
          ...
          <ReportViewer UseOleDbForOracle="1"/>
      </ACConfig>
 The default value of UseOleDbForOracle is "0".

Level of Complexity 

Easy

Applies to  

References

Add any references to other internal or external articles

​