Troubleshooting
Problem
Customer is importing data from staging tables. Most of the time, it works OK. However, sometimes the import fails (for example if a different user is accessing the same form at the same time). The superuser can check if the staging tables import was successfully, by manually However, is there an automatic method (to be automatically notified) which would create an alert (to a user) if a staging tables import failed?
Symptom
Imagine a scenario where:
1. User triggers an import of data from staging tables
2. Afterwards, user opens the 'Log' menu
3. User clicks on 'External Data' and locates the relevant job:
- User notices that all the rows (that were read) were discarded
=> Clearly something went wrong with the import.
4. To understand why, user opens the log:
Inside the log, there are lots of entries relating to the cause of the problem, for example:
- 47 - The form containing the account is locked for update
===================================
Clearly there is some manual work involved in checking if a staging tables import ran OK (no errors).
- Is there an easier method to be automatically notified when a problem occurred in the import?
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21981426