Hi,

First, sorry for my bad english...I hope you will understand my problem:

I have to transfer data between two databases every days:
When I create a bug in a project into BugZilla (MySQL), I want to create a new task in a project (the same as in bugzilla) in Compiere (Oracle).
For example, I have a developpement project, called projectX in BugZilla:

I create a new bug entry (which has a creation Date) into that project and then, I want to create a task (same name as the bug) for that bug into Compiere.
This task is linked to a phase(which has a start date and an end date), which is linked to a project.

When the phase exist and is start date is before the bug's creation Date, I want to linked the new task into that phase.
If the dates do not correspond, or if there is no phase linked to the project, I want to create a new phase whose start date is the same as the bug's creation date.

BugZilla: ProjectX -> "bug" (creation date)
Compiere: ProjectX -> Support phase (startDate <= creation date <= endate) -> "bug" task

I created two jobs:

1. The first one scan the phase table in compiere, and if he find a phase for the project (the same name as th bug's project), he compare the phase's start date and the bug's creation date. If no phase -> a phase is created.

Job - phase creation


1st Tmap


2nd Tmap (handle Duplicates entries)


2. The other job scan the phase's table and when he find a phase to bind with the new task (with a date comparaison's routine), he create the task.

Job - task creation


1st Tmap


2nd Tmap (handle Duplicates entries)


I created two tmap per job to handle duplicate entries in oracle (the unique constraint doesn't work).

My problem is with the second job (who insert tasks) : I have to restart it as many times as there are bugs:

If I create 3 bugs in Bugzilla (MySQL), I have to restart 3 times the second job to create the tasks.
The first job is fully functionnal.