Troubleshooting
Problem
An issue similar to the following scenario might be experienced: the Maximo WOGEN table has more than 172 million records generated by 1pm on one Work Order record.
Symptom
Comments in the code say things like "wogen is a scratch pad" and "RUNDATE can be used to delete old runs that didn't get deleted when they should have."
This implies it can be truncated to clear debris when the crontask is not running.
The LONGDESCRIPTION table might also grow in size.
There are 27443757 records in WOGEN table.
Since the Description field for each record in WOGEN table is also stored in the LONGDESCRIPTION table, the WOGEN also has 27443757 records corresponding to WOGEN records
The SQL query below returns 27443757 records.
select COUNT (*) from LONGDESCRIPTION where LONGDESCRIPTION.ldownertable = 'WOGEN'
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Work Order Gen Appl","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation 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:
18 September 2025
UID
swg21636637