How can I troubleshoot and diagnose the report formatter in IFS Cloud? I have Report Designer jobs stuck in Waiting status.
Troubleshooting Report Formatter in IFS Cloud
Userlevel 7
+18
Userlevel 7
+15
Hi,
As this is 22R1, there reporting solution is broken in to 3 parts. Check the logs of ifsapp-reporting, ifsapp-reporting-ren and ifsapp-reporting-cr (if these are crystal reports). The logs should ideally give you any information about the issue you are having.
You can also check the Report Application Messages. Check the statues of the message and if they are in error state. If they are in error state check the message and it should give an indication of the issue.
Another thing you can check is the report task templates. Check the queues the task templates are running on and check in the report queues if these relevant queues are there. If they are, then check if the queue is stopped or not. If the queue is not there, you will have to create that queue.
If you find the issue to be a missing queue, please let me know as I’m investigating in to a issue like that and I would need some more information from you.
Regards,
Userlevel 5
+11
Hi
You can try below steps
-
Make sure that all queue used in report templates are there and started. Here the faulty report templets like BATCH2 and some others report templets were removed and only the DEFAULT report template and report queue was kept.
-
Remove all jobs from PRINT_JOB_TAB and PRINT_QUEUE_TAB
-
Remove all rows from REPORT_APPLICATION_MESSAGE_TAB
-
Remove all rows from REPORT_BATCH_PR_QUEUE_TAB
-
Restarted the ifsapp-reporting and ifsapp-reporting-ren containers
-
Order a report and see if it works as expected. Printed the “Component Information” report to NO_PRINTOUT logical printer. All worked fine.
-
Added the BATCH2 queue and created a new report templates and configured that to use the BATCH2 queue. Added a Logical Printer and then printed the “Component Information” report to that Logical Printer. The job errored out saying “Not mapped to a Print Agent” which is the expected behavior as Print Agents were not configured in the environment. It should work after the Print Agents are properly setup and started.
/Shanaka
Hi
i would start off by checking the logs in “ifsapp-reporting” pod. it’s quite likely that you would find a more meaningful error that leads to something there.
Cheers
Userlevel 7
+18
Pod ifsapp-reporting-XXXXXXXXXX-XXXXX is reporting "Readiness probe failed: HTTP probe failed with statuscode: 504". Do you have any idea what that might mean?
Userlevel 7
+18
The logs for the ifsapp-reporting container look like this:
WTRN0049W: An attempt by the transaction manager to call rollback on a transactional resource has resulted in an XAER_RMFAIL error. The resource was com.ibm.tx.jta.impl.JTAXAResourceImpl
This looks like IBM WebSphere.
https://www.ibm.com/docs/en/was-nd/9.0.5?topic=messages-wtrn
WTRN0049W: An attempt by the transaction manager to call rollback on a transactional resource has resulted in an XAER_RMFAIL error. The resource was {0}
| Explanation | The rollback call on a transactional resource did not succeed because the resource manager was unavailable. The rollback call will be retried at regular intervals. |
| Action | Ensure that the resource manager is available. |
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.