DATA_UPDATE_LOG: - SKU/Package : Can not edit SKU Descr(L) and Pack Descr
Creation date: 19/05/2022 12:33
Updated: 19/05/2022 12:33
Question:
Answer:
Investigation:
Date : 18/05/22
Warehouse ID : ALL
We found an error "The input (New Value] is too long, please retype!" and "The input (Old Value] is too long, please retype!" when Editing SKU Descr(L) and Pack Descr.
SKU Descr(L)
Pack Descr.
And after more investigation, we found that the problem was caused by the settings DATA_UPDATE_LOG, the "Default Value" is set to Y/Yes.
When we change to N-NO, we can edit normally.
Debug log
Answer:
Investigation:
The column length for the table SYS_DATAUPDATE_DETAILS and SYS_DATAUPDATE_LOG differ from BAS_SKU.
Alter it to make it the same.
alter table SYS_DATAUPDATE_DETAILS modify newValue text null;
alter table SYS_DATAUPDATE_DETAILS modify oldValue text null;
alter table SYS_DATAUPDATE_LOG modify menu varchar(30) null;
alter table SYS_DATAUPDATE_LOG modify resultCode varchar(300) null;
DataImage58.png
DataImage71[1].png
DataImage71.png