I have an application that has more than 2000 File triggers jobs which are inserted using ESPmgr commands in automaticly way in it. All those commands are specify in a shell that this same application executes.
The file triggers jobs tree takes too long in create jobs in the application, almost 2 hours and if a see it in my application monitor the most of them are in PREDWAIT state, but if i check out the jobs states by BIRT report (using sql query) i could realize that almost every file triggers jobs are in COMPLETE state, because of the files are in the source, which is correct, but the Completion Pecentage shows 33%, when the real one should be almost 90% or more.
In the BIRT report i am filtering by job state of ESP_RTWOB table, i am not filtering by ESP_GENERIC_JOB.
Does anyone know why could be happening this?
Does anyone know how to fix this problem?
We have CA CAWA DE 11.3.3 Server and 11.3.2 Desktop Client versions
Thanks a lot for your help.
Regards.
Isaac