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'
4792
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