Highlighted
Absent Member.. Absent Member..
Absent Member..
1082 views

PPM8.0 Workflow import error

Hi everybody,

I have a problem with the import of a workflow from an environment to another, I have attached the log of the failed import, thereafter the error.

Errors:
Cannot save row to the database for entity

Workflow, table KNTA_NOTIFICATIONS, primary key 31021. Message from database: ORA-00001: unique constraint (TTK_PPM.SYS_C008454) violated ORA-06512: at "TTK_PPM.KNTA_NOTIFICATIONS_TRIG", line 11 ORA-04088: error during execution of trigger 'TTK_PPM.KNTA_NOTIFICATIONS_TRIG' {KNTA_NOTIFICATIONS_TH-300} (KNTA-10641)

Message name: MIG_CANNOT_SAVE_ROW

PPM 8.0x in order to migrate notifications linked to a workflow create them with the use of a function contained into KNTA_NOTIFICATIONS_TH that makes sulla vista KNTA_NOTIFICATIONS, che fa scattare il trigger KNTA_NOTIFICATIONS_TRIG, that update KNTA_NOTIFICATIONS_NLS, making the violation of the constraint.

Checking in homologation (environment of destination of the migration) the constraint SYS_C008454 is the one linked with the primary key of the column notification_id belonging to the table KNTA_NOTIFICATIONS_NLS. It seems that PPM tried to insert two rows with the same notification_id.

Any idea?
Thank you in advance,
- Simone

0 Likes
10 Replies
Highlighted
Absent Member.
Absent Member.

I ran into the same issue before. Check to see if the descriptions on the notifications at a workflow step are the same. The have to be different.
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Thank you very much, I will try to change all the descriptions 🙂

I will you update about this if the workaround does its job!

Regards,
- Simone
0 Likes
Highlighted
Absent Member.
Absent Member.

why not rename and migrate?
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi Kerimkilic, what do you mean for rename? If you're talking about the workflow's name I can't do it because it would affect the actual configuration of the system.


Regards,
- Simone
0 Likes
Highlighted
Commander
Commander

Hi Guyes, 

 

I have same issue during migration of our workflow, but I didn't add any new notification to the steps and there aren't descriptions on existing notifications. 

Can you write more details about your workaround? 

 

Best regards,

Islam

 

0 Likes
Highlighted
Absent Member.
Absent Member.

Hello everybody

Could anyone explain how to solve this problem?

BR, Alex
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi,

 

we had the very same issue. Unfortunately, we never figured out the cause, but we found a workaround:

- delete the recently added/changed notifications;

- save the workflow;

- re-apply the added/changed notifications.

 

You should be able to find the problematic notification using the ID returned by the error(31021 in your case).

 

Let us know if this helps.

 

Cheers

alex


--remember to kudos people who helped solve your problem
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Simone, 

 

Renaming the Workflow either in the Source or Destination environment still works better provided you have your Source Environment (Assume - QA or DEV) is refreshed with Destination (PROD) frequently. 

 

Idea is to have the latest entity in QA or DEV similar to that of PROD before we make any changes to it. Once the changes are done, we can either import it directly as it is OR rename it so as to avoid any errors as one you have mentioned!

 


Regards,

Mallikarjun.S

 

Warm Regards,
Mallikarjun.S
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Mallik,

 

I don't advise on renaming the source or target or workflows, since this will generate a new ID in the database. This action will have a huge impact on any reporting which is based on entities IDs.

 

cheers

alex


--remember to kudos people who helped solve your problem
0 Likes
Highlighted
Absent Member.
Absent Member.

Hi,

 

I ran into the same problem today and solved it by deleting the notification in the target instance of PPM. Then I started the import of WORKFLOW_xxxxx_xx.zip again and this time the workflow including the notification in question was imported successfully.

 

You can find the notification by running

 

select * from knta_notifications_nls where notification_id = 31021

 

With the PARENT_TEXT and SUBJECT columns you should be able to identify the notification in question.

 

Good luck,

Torsten

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.