Hi all, we have an issue with a few applications where on the 22nd May this year we had a major issue wit out CAWA DSeries system which was 11.3.1 and we ended up upgrading to 11.3.3 on the fly to fix the issue.
Since then we have been unable to use the wait for previous generation flag on a number of applications as they immediately go into an Applwait state. We suspected it was due to the applications from the 22nd May which are showing in the database as STATE = COMPLETE but with no END_DATE_TIME value (it's NULL). That seems to fit as other applications which have good entries on the 22nd May don't have the issue.
In an attempt to sort this without having to resort to a cold start we have been looking at our data. We founf that we had about 4 years worth of data on ESP_GENERIC_JOB and ESP_APPLICATION as we hadn't been running MOVEHISTORYDATA due to a bug in 11.3.1.
We have now run that and we have 120 days on live tables and another 280 days on history. This has moved the 22nd May onto history tables.
On Friday, I tested one of the problem applications that runs every hour and set the "wait for previous generation" flag on then uploaded the app, I then triggered it and it worked OK. The next scheduled run at 14:00 also worked OK but then from 15:00 they started coming back on in APPLWAIT atate again despite the fact that the previous two had completed ok.
I've since tested again this morning and it is still happening if I set the wait for previous generation flag back on.
I'd really like to get this sorted but a cold start is not feasible (there is never a time when nothing is running and this issue is not a showstopper so it's not justified)
I'd thought about deleting the lines where END_DATE_TIME is null from the history tables but not sure what effect this might have on the system.
Has anyone any ideas as to what we could do?