Skip to main content
Kofax

MarkView All Components - MarkView 6.5 Installer fails with the following error message ''install' in project 'accounts-payable' Data Seed Task Failed: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows'

  1. Last updated
  2. Save as PDF
4792
Article # 304274 - Page views: 71

Summary

4792

Applies To

  • ERP System: All
  • MarkView Version: 6.5

Behavior

  • When executing the MarkView 6.5 Installer, the following error message is raised: 
    com.markview.installer.InstallerType Error while running installer
com.markview.installer.InstallerException: Encountered problem while trying to execute InstallInstructions: Failure executing target
'install' in project 'accounts-payable' Data Seed Task Failed: java.sql.SQLException: ORA-01422: exact fetch returns more than
requested number of rows
ORA-06512: at "XXMV.SF_RULE_INSTANCE_UTIL", line 193
ORA-06512: at "XXMV.SF_RULE_INSTANCE_UTIL", line 1252
ORA-06512: at "XXMV.SF_RULE_INSTANCE_UTIL", line 1344
ORA-06512: at "XXMV.SF_SEED_UTIL", line 630
ORA-06512: at line 1

Known Causes

  • Duplicated sequence numbers for the workflow queue rules and workflow rules

Resolution

  • To verify if there is duplicate sequence number for the workflow queue rules and workflow rules, execute the followig SQL statement. 
    select *
from sf_rule_instance ri1
where workflow_queue_id is not null
and workflow_id is not null
and exists (select 1
from sf_rule_instance ri2
where ri2.workflow_queue_id = ri1.workflow_queue_id
and ri2.rule_instance_id != ri1.rule_instance_id
and ri2.rule_sequence = ri1.rule_sequence)

    If a record is returned, this is an indication there are duplicate sequence numbers for the workflowqueue rules and workflow rules.
  • To resovle the issue the following update statement should be executed: 
    update sf_rule_instance ri1 set ri1.rule_sequence = ri1.rule_sequence + 100
where workflow_queue_id is not null
and workflow_id is not null and exists (select 1
from sf_rule_instance ri2
where ri2.workflow_queue_id = ri1.workflow_queue_id and ri2.rule_instance_id != ri1.rule_instance_id
and ri2.rule_sequence = ri1.rule_sequence);
commit;
  • Once the statements above have completed successfully, please confirm that sequence numbers have been updated by executing following sql statement. If no rows are returned from the following SQL statement this will indicate there are no remaining duplicate sequence numbers. 
    select *
from sf_rule_instance ri1
where workflow_queue_id is not null and workflow_id is not null
and exists (select 1
from sf_rule_instance ri2
where ri2.workflow_queue_id = ri1.workflow_queue_id
and ri2.rule_instance_id != ri1.rule_instance_id
and ri2.rule_sequence = ri1.rule_sequence)

Keywords: accounts payable,01422