When generating a calendar in IFS Cloud 25R1, the background job never completed.
The problem occurred when the background job was executing the query:
SELECT * FROM res_base_shift_shift_exc_gen
WHERE generated_finish_time IS NULL;
This query triggered the Oracle error(also in PLSQL Developer):
"internal error code, arguments: [qcspCheckPcols.3], [], [], [], [], [], [], [], [], [], [], []"
We got the same error in all environments.
Since this is an internal Oracle error, it was not picked up as an exception by IFS. As a result, the background job appeared to be running.
After upgrading from 19.27.0.0.0 to 19.30.0.0.0, the issue was resolved. Probably Oracle had a problem with the design of the view res_base_shift_shift_exc_gen. The design “AND (rbsse.period = ris.shift_period OR ris.shift_period IS NULL)” looks a bit different in design and might be the “problem”(?)