Document Type | Troubleshooting
Category | Monitoring/Inspection
Applicable Product Versions | 6FS07, 7FS02
Document Number | TMOTS022
Issue
While collecting statistics information through the basic job in the Tibero 7 (DB 7.0 FS02 Build 266408) environment, the following errors occurred.
- ERROR_PSM_ROWTYPE_MISMATCH(-15107): Row type mismatch
- ERROR_NUMBER_INVALID_ARGUMENT(-5073): Invalid NUMBER provided for the operation
Cause
When collecting statistics with the indexed column option, a temporary table is created to collect statistics only on columns with indexes applied.
During this process, columns without indexes are excluded in the middle, which can cause the column numbers between the temporary table and the original table to become misaligned.
If a histogram is generated while the column order is misaligned like this, the histogram is created on a different column than originally intended, causing a MISMATCH error during statistics collection.
Solutions
Applying patch 253667 or higher version FS02_253667p, which includes logic to ensure the column numbers in the temporary table match those in the original table when generating histograms, can resolve the issue.
CautionApply the patch through technical support provided by Tmax Tibero.
NoteYou can avoid the issue by changing the parameter to _opt_stat_collection_v2 = N;