My Oracle Support Banner

E1: OMW: ENH: P98220 - Promote Task Before Task Relationship to Prevent JDB3400009 (Doc ID 2855346.1)

Last updated on MARCH 16, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Propose switching the order during a promotion - - the task before the task relationship.
That way if there is a key field conflict with the task, the task relationship is not successfully promoted and the following steps do not need to be taken.


Scenario:

A Task and a Task Relationship is added to a project in DV, and the project is advanced to PD environment via OMW (Object Management Workbench).
The following error is generated:   Error: General Error in method, Status Change

Cause:
The task ID (TASKNM; COM123456) already exists in F9000_CRP/PY (it did not start in DV before being promoted) . . . and TMTASKNM is a key field in F9000.

Solution:
Access P9000 in PY and attempt to delete Task ID = COM123456.
The message "This Task is in a Task Relationship and must be removed before it can be deleted." will be generated.

To resolve: Highlight the record, select Row > Where Used, and then delete the Task Relationship. Then the promotion works.

 

The jdedebug.log line numbers confirm the current sequence/order when promoting from TESTCTL to CRPCTL:

F9001 (Task Relationships) Insert statement:
Line 56927: WRK:Starting jdeCallObject INSERT INTO CRPCTL/F9001 VALUES (. . . . )

Then the F9000 (Task Master) records are addressed:
Line 57605: WRK:Starting jdeCallObject SELECT COUNT(*) FROM TESTCTL/F9000 WHERE ( TMTASKID = . . . )
Line 57610: WRK:Starting jdeCallObject SELECT COUNT(*) FROM CRPCTL/F9000 WHERE ( TMTASKID = . . . )
Line 57616: WRK:Starting jdeCallObject SELECT * FROM TESTCTL/F9000 WHERE ( TMTASKID = . . . )

F9000 Insert statement:
Line 57626: WRK:Starting jdeCallObject INSERT INTO CRPCTL/F9000 VALUES (. . . )

Followed by:
Line 57634: WRK:Starting jdeCallObject JDB9900401 - Failed to execute db request
Line 57635: WRK:Starting jdeCallObject JDB3400009 - Failed to perform Insert for F9000

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.