Unable to Deploy the workflow from Studio

Unable to Deploy the workflow from Studio

book

Article ID: KB0077770

calendar_today

Updated On:

Products Versions
TIBCO MDM ALL

Description

When we deploy the workflow in the enterprises folder, we may get below error and unable to deploy the same.

SQL-8202: Failed while executing SQL statement. SQL state 23000. Database specific error code (if any) was 1. Database error message (if any) was: java.sql.BatchUpdateException: ORA-00001: unique constraint (XXXXX.XPKPROCESSDETAIL2) violated.

Issue/Introduction

While Deploying the workflow you may get the unique constraint error.

Environment

ALL

Resolution

Below are possible reasons for the mentioned exception.

1) With same name workflow already exists in the enterprise folder.So,We need to give unique name to the deploying workflow file.
2) There may be some duplicate parameters present in any one of the activities.we need to avoid the duplicate parameters present in the workflow activities.

Additional Information

01596591
Powered by Wolken Software