QAID # 17748 Published
Question / Problem:
I received the following error message when configuring Kofax Database Export Connector with Sybase Adaptive Server Enterprise Database:
Kofax Capture Export Connector – Database Setup – Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue. Conversion from type ‘DBNull’ to type ‘String’ is not valid….
How can I resolve this issue?
Answer / Solution:
The issue is related to Kofax Database Export connector API (Application Programming Interface) changes made in Kofax Capture 10.
There are two solutions to the issue:
- Install Fix Pack 1 or later for Kofax Capture 10 Service Pack 2. This issue was reported in SPR 114763.
- The other option is to replace Kofax Capture Database Export files with the files from version 9.0:
- Obtain the
DBRel.DLLfile from a KC 9.0 machine with the latest patches and replace the same file in Kofax Capture 10.
- Configure the Release Script, edit the
AscRelSC.INFfile as follows:
[Scripts]section, add the following line:
KOFAX Capture Database v9
Create a new section and enter the associated parameters, as follows:
[KOFAX Capture Database v9]
- Save the INF file and add this Release Script into your Document Class. Configure as necessary.
- Obtain the
Keywords: Sybase, Export, SQL_NO_DATA_FOUND, Code 100, Validation, ODBC