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'

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