Hi,
we are facing critical issue in our live environment that when we are selecting any on-hand form and selecting any product lookup in production module and many other places we getting below error :-
Stack trace: Field 'ItemId' in table 'InventSum' has not been explicitly selected.
Stack trace
(C)\Classes\WHSInventReserveQty\inventSum - line 3
(C)\Classes\WHSInventReserveQty\availTotal - line 15
(C)\Classes\InventAvailabilitySnapshot\initFromAvailability - line 5
(C)\Classes\InventAvailabilitySnapshot\newFromAvailability - line 24
(C)\Classes\InventAvailabilityByUnit\pack - line 6
(C)\Classes\InventAvailabilityProvider\findPackedOnServer - line 14
(C)\Classes\InventAvailabilityProvider\find - line 31
(C)\Classes\InventAvailabilityProvider\findBySumDim - line 29
(C)\Classes\InventAvailabilityFormCache\updateCachedValuesSum - line 22
(C)\Classes\InventAvailabilityFormCache\availabilityFromDimJoinedWithSum - line 29
(C)\Forms\InventBatchIdLookup\Data Sources\InventDim\Methods\availPhysical - line 3
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\availReservation - line 12
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\availReservation - line 12
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\availOrdered - line 12
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\availOrdered - line 12
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\availPhysical - line 12
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace
(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\availPhysical - line 12
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\pdsTotalAvailable - line 5
Error Message (02:46:05 pm) InventAvailabilitySnapshot object not initialized.
Stack trace(C)\Forms\InventOnHandItemPart\Data Sources\InventSum\Methods\pdsTotalAvailable - line 5
It looks like cache issue and we did following things but didn't solve our issue any suggestion would be more appreciated.
Below are the steps which we have followed.
1. Restarting AOS
2. Clearing usage data
3. Flushing cache using SysFlush classes
4. Full compile ,CIL,Sync also done successfully but still facing same issue.
Regards,
Kishore
