During upgrade you get an error message:
"PMX_SP_Create_TMP_Tables": line xx col xx (at pos xxx): feature not supported: global temporary table must be empty to drop.
This caused by one or more of the temp tables still having data.
- Please ensure that the database you are upgrading does not have any active connections.
- No add-on session, no mobile client session.
- No robot tool is running on the database, and also the Notification Listener is also stopped (if you use it)
- Please note this wiki article: Performing a Version Upgrade
Please run the below queries, it might be not all tables exists that is not a problem.
Please check the temp tables below. If there is a data in one of these tables then empty them, close the Suite Installer and start the database upgrade again.
SELECT * FROM "TMP_BatchToPickForAdHocPicking";
SELECT * FROM "TMP_FirstSequencesForItemForAdHocPicking";
SELECT * FROM "TMP_GetLocationTree";
SELECT * FROM "TMP_GOSOWSS_1";
SELECT * FROM "TMP_IntInt";
SELECT * FROM "TMP_IntStr";
SELECT * FROM "TMP_ItemBatchQuantityBBD";
SELECT * FROM "TMP_LocationSearch";
SELECT * FROM "TMP_LocationsForItemForAdHocPicking";
SELECT * FROM "TMP_LocationsForItemForAdHocPickingDetails";
SELECT * FROM "TMP_RecursiveBoM";
SELECT * FROM "TMP_SalesShippingReturnableItems";
SELECT * FROM "TMP_TN_GenericCodeName";
SELECT * FROM "TMP_TN_GetFreeStockInventoryBatch";
SELECT * FROM "TMP_TN_GetFreeStockInventoryDetail";
SELECT * FROM "TMP_TN_GetFreeStockInventoryItem";
SELECT * FROM "TMP_TN_GetFreeStockInventoryLUID";
SELECT * FROM "TMP_TN_GetFreeStockLockedBatch";
SELECT * FROM "TMP_TN_GetFreeStockLockedDetail";
SELECT * FROM "TMP_TN_GetFreeStockLockedItem";
SELECT * FROM "TMP_TN_GetFreeStockLockedLUID";
SELECT * FROM "TMP_TN_InventorySAPTable";
SELECT * FROM "TMP_TN_Packaging";
SELECT * FROM "TMP_TN_ProductsOnSSCC";
SELECT * FROM "TMP_WhsLocations";
SELECT * FROM "TMP_WhsLocationsSimple";
SELECT * FROM "TMP_GGIX";
SELECT * FROM "TMP_ICLTT_1";
SELECT * FROM "TMP_ICLTT_2";
SELECT * FROM "TMP_TN_1";
SELECT * FROM "TMP_TN_AddedLuids";
SELECT * FROM "TMP_TN_BatchNumbers1";
SELECT * FROM "TMP_TN_BatchNumbers2";
SELECT * FROM "TMP_TN_BestBeforeDates";
SELECT * FROM "TMP_TN_CharListTable";
SELECT * FROM "TMP_TN_CharListTableNoIndex";
SELECT * FROM "TMP_TN_CurrentLuids";
SELECT * FROM "TMP_TN_DestLuids";
SELECT * FROM "TMP_TN_DestQualityStatuses";
SELECT * FROM "TMP_TN_DestStorLocs";
SELECT * FROM "TMP_TN_DocumentLine";
SELECT * FROM "TMP_TN_DocumentLineRaw";
SELECT * FROM "TMP_TN_IgnoreLocking";
SELECT * FROM "TMP_TN_InventoryDetail";
SELECT * FROM "TMP_TN_ITL";
SELECT * FROM "TMP_TN_Luids";
SELECT * FROM "TMP_TN_LuidSerial";
SELECT * FROM "TMP_TN_MasterLuids";
SELECT * FROM "TMP_TN_QualityStatuses";
SELECT * FROM "TMP_TN_Quantities";
SELECT * FROM "TMP_TN_QuantitiesUom2";
SELECT * FROM "TMP_TN_QuantityPerLuid";
SELECT * FROM "TMP_TN_SDLines";
SELECT * FROM "TMP_TN_SSCCs";
SELECT * FROM "TMP_TN_StorLocs";
SELECT * FROM "TMP_TN_TempDetail";
Comments
0 comments
Please sign in to leave a comment.