Skip to main content
Kofax

MarkView Viewer Express - Receiving 'ORA-01722: invalid number' error messages when viewing certain images.

Summary

4187

Applies To

  • ERP System: All
  • MarkView Version: 5.10.x, 6.x

Behavior

When viewing certain images in the MarkView Express Viewer end users are encountering an 'ORA-01722: invalid number' error message and are unable to view the image.

Known Causes

This error can appear when trying to view certain images in the MarkView Express Viewer and can arise from a query with a join condition that compares a varchar column with a number column.

Resolution

  • If you do encounter an issue viewing certain images in the Express Viewer you should run the following update statements and commit the changes:

update mvt_web_display_where_clause wc
set wc.where_clause_text = 'dtl.file_name = to_char(mvd.document_id)'
where wc.where_clause_text = 'dtl.file_name = mvd.document_id';

update mvt_web_display_where_clause wc
set wc.where_clause_text = 'dtl.file_name = to_char(mvd.document_id (+))'
where wc.where_clause_text = 'dtl.file_name = mvd.document_id (+)';

update mvt_web_display_where_clause wc
set wc.where_clause_text = 'to_char(pv.vendor_id) = fad.pk1_value'
where wc.where_clause_text = 'pv.vendor_id = fad.pk1_value';

  • Update mvt_web_display_where_clause wc set wc.where_clause_text = 'to_char(pha.po_header_id) = fad.pk1_value' where wc.This error can appear when trying to view certain images in the MarkView Express Viewer and can arise from a query with a join condition that compares a varchar column with a number column.

where_clause_text = 'pha.po_header_id = fad.pk1_value';

update mvt_web_display_show_field sf
set sf.base_table_name = 'mvd',
sf.base_table_column = 'document_id'

where sf.display_name = 'Document ID'
and sf.base_table_name = 'dtl'
and sf.base_table_column = 'file_name';

commit;

  • If the above update statement does not resolve the particular issue that you are experiencing please run the 'TestGetAllDetailDataRecords.sql' script attached to this answer, open up a new Support Web Incident, and upload the resulting 'TestGetAllDetailDataRecords.txt' file to the incident for review by Kofax Technical Support.

Note: For MarkView 6.X, please use the attached TestGetAllDetailDataRecords6X.sql script instead.

  • After making the changes detailed above, you may see performance deterioration when viewing documents in the MarkView Express Viewer. To address any performance issue related to these changes, a function-based index on to_char(document_id) will need to be created. Such an index can be created using a statement similar to the following (Note: You will need to replace the parameter values with ones appropriate to your environment).

create index MV_DOC_DOCUMENT_ID_CHAR on MV_DOCUMENT (TO_CHAR(DOCUMENT_ID))
tablespace MVX pctfree 10
initrans 2
maxtrans 255 storage
(initial 128K minextents 1
maxextents unlimited);

  • Kofax recommends that all system changes be applied in the customer's test environment and tested thoroughly before being migrated to a production environment.

Keywords: 24621