Differences
This shows you the differences between two versions of the page.
— |
control_error_-_could_not_load_record [2019/01/27 11:28] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== | ||
+ | |||
+ | |||
+ | |||
+ | ===== Error Message ===== | ||
+ | |||
+ | |||
+ | |||
+ | Could not load record | ||
+ | |||
+ | |||
+ | |||
+ | ===== Explanation of Error ===== | ||
+ | |||
+ | |||
+ | |||
+ | This is a generic error from Control indicating that a record it was expecting could not be found. | ||
+ | |||
+ | |||
+ | |||
+ | EXAMPLE OF ERROR MESSAGE : Could not Load Record | ||
+ | |||
+ | |||
+ | |||
+ | Table : TransDetail, | ||
+ | |||
+ | |||
+ | |||
+ | ID : (11724, 100, 10100) | ||
+ | |||
+ | |||
+ | |||
+ | In this example, something (perhaps an order or parent line item) was trying to load another line item from the TransDetail and TransDetailGraphic Tables but the ID (11724) was not in the database. | ||
+ | |||
+ | |||
+ | |||
+ | ===== Severity ===== | ||
+ | |||
+ | **Normal**. User is not down. | ||
+ | |||
+ | |||
+ | |||
+ | ===== Possible Root Cause(s) ===== | ||
+ | |||
+ | |||
+ | |||
+ | ===== Resolution ===== | ||
+ | |||
+ | |||
+ | |||
+ | Open up the Cyrious SSLIP and access the " | ||
+ | |||
+ | |||
+ | |||
+ | From here, select the "Store Data" database group from the drop-down menu along with the corresponding database. | ||
+ | |||
+ | |||
+ | |||
+ | Run an advanced SQL by clicking on the " | ||
+ | |||
+ | |||
+ | |||
+ | ===EXAMPLE=== | ||
+ | |||
+ | |||
+ | |||
+ | <code sql> | ||
+ | Select * from Transdetail | ||
+ | where ID = 11724 | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | <code sql> | ||
+ | Select * from Transdetailgraphic | ||
+ | where ID = 11724 | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | From here, choose the "view results option and if the record appears for the ID number from the query, then the table is fine. Otherwise, the record needs to be inserted. The ID, StoreID, and ClassTypeID numbers correspond to the three numbers in the error message. Save the changes and then try to reproduce the error. | ||
+ | |||
+ | |||
+ | |||
+ | ===== Version Information ===== | ||
+ | * Reported : __/__/20__ | ||
+ | * Version(s): | ||
+ | * Fixed in : | ||
+ | |||
+ | |||
+ | |||
+ | ===== Related Errors ===== | ||
+ | |||
+ | |||
+ | |||
+ | |||