Feature not supported: global temporary table must be empty to drop

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";