Neu Update Version von 1.5.47.2 nach 1.5.48 (fehler)

[duftmania]

Hallo,

Fehler Log:
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: 12:35:54 Fehler in der Version 1.5.47.0 beim Befehl:
==============================================
DECLARE @Reservierung TYPE_spReservierungAktualisieren;
INSERT INTO @Reservierung ( kBestellPos )
SELECT tbestellpos.kBestellPos
FROM dbo.tbestellpos
JOIN dbo.tBestellung ON tBestellung.kBestellung = tbestellpos.tBestellung_kBestellung
WHERE tBestellung.nKomplettAusgeliefert = 0;

EXEC dbo.spReservierungAktualisieren @Positionen = @Reservierung;
==============================================
Message: Die datediff-Funktion führte zu einem Überlauf. Die Anzahl von datepart-Werten, die zwei Datums-/Uhrzeitinstanzen trennen, ist zu groß. Verwenden Sie eine datediff-Funktion mit einem weniger präzisen datepart-Wert.
LineNumber: 91
Procedure: spReservierungAktualisieren


2021-08-13T12:35:53 DEBUG - CREATE TRIGGER [dbo].[tgr_tKategorieShop_INSUP]
ON [dbo].[tKategorieShop]
AFTER INSERT, UPDATE
AS
SET NOCOUNT ON;
SET ANSI_NULLS, ANSI_NULL_DFLT_ON, ANSI_PADDING, CONCAT_NULL_YIELDS_NULL, XACT_ABORT ON;
BEGIN TRY
IF NOT EXISTS (SELECT 1 FROM Inserted) RETURN;
IF TRIGGER_NESTLEVEL(@@PROCID) > 1 RETURN;

IF (OBJECT_ID('tempdb..#tgrtKategorieShopInsup') IS NOT NULL)
BEGIN
DROP TABLE #tgrtKategorieShopInsup;
END

CREATE TABLE #tgrtKategorieShopInsup
(
kKategorie INT NOT NULL,
kShop INT NOT NULL,
nInetUpdateBlock BIT NOT NULL,
nInet BIT NOT NULL,
nInetY BIT NOT NULL,
nInserted BIT NOT NULL
);

INSERT INTO #tgrtKategorieShopInsup (kKategorie, kShop, nInetUpdateBlock, nInet, nInetY, nInserted)
SELECT
Inserted.kKategorie,
Inserted.kShop,
CASE WHEN EXISTS (SELECT Inserted.cInet EXCEPT SELECT Deleted.cInet)
AND Inserted.cInet = 'Y' THEN 1 ELSE 0 END AS nInetUpdateBlock,
CASE WHEN EXISTS (SELECT Inserted.cInet EXCEPT SELECT Deleted.cInet) THEN 1 ELSE 0 END AS nInet,
CASE WHEN Inserted.cInet = 'Y' THEN 1 ELSE 0 END AS nInetY,
CASE WHEN Deleted.kKategorie IS NULL THEN 1 ELSE 0 END AS nInserted
FROM Inserted
FULL OUTER JOIN Deleted ON Deleted.kKategorie = Inserted.kKategorie
AND Deleted.kShop = Inserted.kShop;

IF (UPDATE(cInet))
BEGIN
IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInetUpdateBlock = 1)
BEGIN
UPDATE dbo.tKategoriebildPlattform
SET tKategoriebildPlattform.nInet = 1
FROM dbo.tKategoriebildPlattform
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kKategorie = tKategoriebildPlattform.kKategorie
AND #tgrtKategorieShopInsup.kShop = tKategoriebildPlattform.kShop
WHERE tKategoriebildPlattform.nInet = 0
AND #tgrtKategorieShopInsup.nInetUpdateBlock = 1;
END

IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInet = 1)
BEGIN
UPDATE dbo.tKategorieShop
SET dbo.tKategorieShop.nInBearbeitung = 0
FROM dbo.tKategorieShop
JOIN #tgrtKategorieShopInsup ON dbo.tKategorieShop.kKategorie = #tgrtKategorieShopInsup.kKategorie
AND dbo.tKategorieShop.kShop = #tgrtKategorieShopInsup.kShop
AND #tgrtKategorieShopInsup.nInet = 1;
END

IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInetY = 1)
BEGIN
UPDATE dbo.tArtikelShop
SET tArtikelShop.nAktion = tArtikelShop.nAktion | 1,
tArtikelShop.cInet = 'Y',
tArtikelShop.nInBearbeitung = 0
FROM dbo.tArtikelShop
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kShop = tArtikelShop.kShop
JOIN dbo.tkategorieartikel ON tkategorieartikel.kArtikel = tArtikelShop.kArtikel
AND tkategorieartikel.kKategorie = #tgrtKategorieShopInsup.kKategorie
WHERE #tgrtKategorieShopInsup.nInetY = 1
AND #tgrtKategorieShopInsup.nInserted = 1
AND (tArtikelShop.cInet = 'N'
OR tArtikelShop.nAktion IN (0,2,4,6,8)
OR tArtikelShop.nInBearbeitung = 1);

UPDATE Sync.tEntityTracking
SET tEntityTracking.dLastModified = GETDATE()
FROM Sync.tEntityTracking
JOIN dbo.tkategorieartikel ON tkategorieartikel.kArtikel = tEntityTracking.kEntityId
AND tEntityTracking.nEntityType = 1
AND tEntityTracking.nSyncType = 4
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kKategorie = tkategorieartikel.kKategorie
WHERE #tgrtKategorieShopInsup.nInetY = 1;
END
END

IF EXISTS (SELECT 1 FROM #tgrtKategorieShopInsup WHERE #tgrtKategorieShopInsup.nInserted = 1)
BEGIN
-- Connector
--
-- Bilder vollständig zu Webshop wenden, wenn Änderungen vorgenommen wurden
--
UPDATE dbo.tKategoriebildPlattform
SET tKategoriebildPlattform.nInet = 1
FROM dbo.tKategoriebildPlattform
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kKategorie = tKategoriebildPlattform.kKategorie
AND #tgrtKategorieShopInsup.kShop = tKategoriebildPlattform.kShop
WHERE tKategoriebildPlattform.nInet = 0
AND #tgrtKategorieShopInsup.nInserted = 1;

--
-- Evtl. bestehenden Löscheinträge in tQueue entfernen
--
DELETE dbo.tQueue
FROM dbo.tQueue
JOIN #tgrtKategorieShopInsup ON #tgrtKategorieShopInsup.kShop = tQueue.kShop
AND #tgrtKategorieShopInsup.kKategorie = tQueue.kWert
WHERE tQueue.cName = 'tkategorie'
AND tQueue.nAction = 2
AND #tgrtKategorieShopInsup.nInserted = 1;

--
-- POS
--
IF(OBJECT_ID('tempdb..#tgr_tKategorieShop_Sync') IS NOT NULL)
BEGIN
DROP TABLE #tgr_tKategorieShop_Sync;
END

CREATE TABLE #tgr_tKategorieShop_Sync
(
kKategorie INT,
kShop INT,
nSyncType TINYINT,
kEntityId INT,
);

INSERT INTO #tgr_tKategorieShop_Sync (kKategorie, kShop, nSyncType, kEntityId)
SELECT
#tgrtKategorieShopInsup.kKategorie,
#tgrtKategorieShopInsup.kShop,
tShop.nTyp,
tEntityPlatform.kEntityId
FROM #tgrtKategorieShopInsup
JOIN dbo.tShop ON tShop.kShop = #tgrtKategorieShopInsup.kShop
LEFT JOIN Sync.tEntityPlatform ON tEntityPlatform.kShop = #tgrtKategorieShopInsup.kShop
AND tEntityPlatform.kEntityId = #tgrtKategorieShopInsup.kKategorie
AND tEntityPlatform.nEntityType = 2
WHERE tShop.nTyp NOT IN (2, 3)
AND #tgrtKategorieShopInsup.nInserted = 1
GROUP BY #tgrtKategorieShopInsup.kKategorie,
#tgrtKategorieShopInsup.kShop,
tShop.nTyp,
tEntityPlatform.kEntityId;

IF EXISTS (SELECT 1 FROM #tgr_tKategorieShop_Sync WHERE #tgr_tKategorieShop_Sync.kEntityId IS NOT NULL)
BEGIN
UPDATE Sync.tEntityPlatform
SET tEntityPlatform.dActive = GETDATE(),
tEntityPlatform.dInactive = NULL
FROM Sync.tEntityPlatform
JOIN #tgr_tKategorieShop_Sync ON #tgr_tKategorieShop_Sync.kEntityId = tEntityPlatform.kEntityId
AND #tgr_tKategorieShop_Sync.kShop = tEntityPlatform.kShop
AND tEntityPlatform.nEntityType = 2;
END

IF EXISTS (SELECT 1 FROM #tgr_tKategorieShop_Sync WHERE #tgr_tKategorieShop_Sync.kEntityId IS NULL)
BEGIN
INSERT INTO Sync.tEntityPlatform (kEntityId, nEntityType, kShop, dActive, dInactive)
SELECT
#tgr_tKategorieShop_Sync.kKategorie AS kEntityId,
2 AS nEntityType,
#tgr_tKategorieShop_Sync.kShop AS kShop,
GETDATE() AS dActive,
NULL AS dInactive
FROM #tgr_tKategorieShop_Sync
WHERE #tgr_tKategorieShop_Sync.kEntityId IS NULL;
END

IF EXISTS (SELECT 1 FROM #tgr_tKategorieShop_Sync WHERE #tgr_tKategorieShop_Sync.kEntityId IS NULL)
BEGIN
INSERT INTO Sync.tEntityTracking (kEntityId, nEntityType, nSyncType, dCreated, dLastModified)
SELECT
#tgr_tKategorieShop_Sync.kKategorie AS kEntityId,
2 AS nEntityType,
#tgr_tKategorieShop_Sync.nSyncType,
GETDATE() AS dCreated,
GETDATE() AS dLastModified
FROM #tgr_tKategorieShop_Sync
LEFT JOIN Sync.tEntityTracking ON tEntityTracking.kEntityId = #tgr_tKategorieShop_Sync.kKategorie
AND tEntityTracking.nEntityType = 2
AND tEntityTracking.nSyncType = #tgr_tKategorieShop_Sync.nSyncType
WHERE tEntityTracking.kEntityId IS NULL
GROUP BY #tgr_tKategorieShop_Sync.kKategorie,
#tgr_tKategorieShop_Sync.nSyncType;
END
END
END TRY
BEGIN CATCH
BEGIN TRY
DECLARE @DeadlockRetries TINYINT = 0;
EXEC dbo.spErrorHandler @DeadlockRetries = @DeadlockRetries OUTPUT;
END TRY
BEGIN CATCH
IF ERROR_NUMBER() <> 266 THROW;
END CATCH;
THROW;
END CATCH
2021-08-13T12:35:53 DEBUG - Dauer: 11ms
2021-08-13T12:35:53 DEBUG - UPDATE [dbo].[tVersion] SET [cVersion] = '1.5.47.0';
2021-08-13T12:35:53 DEBUG - Dauer: 0ms, AffectedRows: 1
2021-08-13T12:35:53 DEBUG - DELETE FROM dbo.tUserlayout WHERE tUserlayout.cName = 'ServicedeskTicketListFilterSettingsLayoutKey';
-- Alle Bestände einmal neu berechnen
TRUNCATE TABLE dbo.tlagerbestandProLagerLagerartikel;
TRUNCATE TABLE dbo.tlagerbestand;

DECLARE @Lagerartikel AS TYPE_spUpdateLagerbestandProLager;
INSERT INTO @Lagerartikel ( kArtikel ,
kWarenlager )
SELECT tArtikel.kArtikel, tWarenLager.kWarenLager
FROM dbo.tArtikel
CROSS JOIN dbo.tWarenlager
WHERE tArtikel.kStueckliste = 0;

EXEC dbo.spUpdateLagerbestandProLager @Artikel = @Lagerartikel;

DECLARE @Artikel AS TYPE_spUpdateLagerbestand;
INSERT INTO @Artikel ( kArtikel )
SELECT tArtikel.kArtikel
FROM dbo.tArtikel;

EXEC dbo.spUpdateLagerbestand @Artikel = @Artikel;

-- tDbErrorlog bereinigen
TRUNCATE TABLE dbo.tDbErrorlog;

INSERT INTO dbo.tAttribut (cBeschreibung, nIstMehrsprachig, nIstFreifeld, nSortierung, nBezugstyp, nAusgabeweg, nIstStandard, kFeldTyp, cGruppeName, nReadOnly, nAktivFuerArtikelOhneWarengruppe)
VALUES ('Preisabfrage', 0, 0, 9, 0, 0, 0, 4, ' JTL-POS', 0, 1);

INSERT INTO dbo.tAttributSprache (kAttribut, kSprache, cName)
VALUES (SCOPE_IDENTITY(), 0, 'Preisabfrage');
2021-08-13T12:35:54 DEBUG - Dauer: 708ms, AffectedRows: 1854
2021-08-13T12:35:54 DEBUG - INSERT INTO dbo.tAttribut (cBeschreibung, nIstMehrsprachig, nIstFreifeld, nSortierung, nBezugstyp, nAusgabeweg, nIstStandard, kFeldTyp, cGruppeName, nReadOnly, nAktivFuerArtikelOhneWarengruppe)
VALUES ('Mengenabfrage', 0, 0, 28, 0, 0, 0, 4, 'JTL-POS', 0, 1);

INSERT INTO dbo.tAttributSprache (kAttribut, kSprache, cName)
VALUES (SCOPE_IDENTITY(), 0 , 'Mengenabfrage');
2021-08-13T12:35:54 DEBUG - Dauer: 5ms, AffectedRows: 2
2021-08-13T12:35:54 DEBUG - --START AMA Lister

SET IDENTITY_INSERT dbo.pf_amazon_group OFF

INSERT INTO dbo.pf_amazon_group
(cName, kPlattform, nAktiv)
SELECT DISTINCT
cName, kPlattform, nAktiv
FROM (
VALUES
('AutoAccessory_brakerotor', 51, 1),
('AutoAccessory_cargonet', 51, 1),
('AutoAccessory_cargostrap', 51, 1),
('AutoAccessory_engineairfilter', 51, 1),
('AutoAccessory_enginewaterpump', 51, 1),
('AutoAccessory_fuelfilter', 51, 1),
('AutoAccessory_fuelpump', 51, 1),
('AutoAccessory_jumpstarter', 51, 1),
('AutoAccessory_licenseplateattachment', 51, 1),
('AutoAccessory_lightmotorvehicle', 51, 1),
('AutoAccessory_oilfilter', 51, 1),
('AutoAccessory_sparkplug', 51, 1),
('AutoAccessory_steeringwheel', 51, 1),
('AutoAccessory_steeringwheelcover', 51, 1),
('AutoAccessory_tirevalvestemcap', 51, 1),
('AutoAccessory_towhitch', 51, 1),
('AutoAccessory_trailerhitchcover', 51, 1),
('AutoAccessory_transportrack', 51, 1),
('AutoAccessory_unmannedaerialvehicle', 51, 1),
('AutoAccessory_vehicleaccentlight', 51, 1),
('AutoAccessory_vehiclebrakepad', 51, 1),
('AutoAccessory_vehiclebumper', 51, 1),
('AutoAccessory_vehiclecover', 51, 1),
('AutoAccessory_vehiclehorn', 51, 1),
('AutoAccessory_vehicleinteriorshade', 51, 1),
('AutoAccessory_vehiclelightassembly', 51, 1),
('AutoAccessory_vehiclelightbulb', 51, 1),
('AutoAccessory_vehiclemat', 51, 1),
('AutoAccessory_vehiclemirror', 51, 1),
('AutoAccessory_vehiclerail', 51, 1),
('AutoAccessory_vehiclescantool', 51, 1),
('AutoAccessory_vehicleseatcover', 51, 1),
('AutoAccessory_vehiclewrap', 51, 1),
('AutoAccessory_wiperblade', 51, 1),
('Beauty_bodydeodorant', 51, 1),
('Beauty_conditioner', 51, 1),
('Beauty_cosmeticpowder', 51, 1),
('Beauty_eyebrowcolor', 51, 1),
('Beauty_eyelidcolor', 51, 1),
('Beauty_faceshapingmakeup', 51, 1),
('Beauty_falseeyelash', 51, 1),
('Beauty_falsenail', 51, 1),
('Beauty_hairband', 51, 1),
('Beauty_hairbrush', 51, 1),
('Beauty_haircleanerconditioner', 51, 1),
('Beauty_hairclip', 51, 1),
('Beauty_haircoloringagent', 51, 1),
('Beauty_haircomb', 51, 1),
('Beauty_hairextension', 51, 1),
('Beauty_hairremovalagent', 51, 1),
('Beauty_hairstylingagent', 51, 1),
('Beauty_hairtie', 51, 1),
('Beauty_lipbalm', 51, 1),
('Beauty_lipcolor', 51, 1),
('Beauty_manualshavingrazor', 51, 1),
('Beauty_mascara', 51, 1),
('Beauty_nailpolish', 51, 1),
('Beauty_personalfragrance', 51, 1),
('Beauty_razorbladecartridge', 51, 1),
('Beauty_selftanner', 51, 1),
('Beauty_shampoo', 51, 1),
('Beauty_skincleaningagent', 51, 1),
('Beauty_skincleaningwipe', 51, 1),
('Beauty_skinexfoliant', 51, 1),
('Beauty_skinfoundationconcealer', 51, 1),
('Beauty_skinmoisturizer', 51, 1),
('Beauty_skintreatmentmask', 51, 1),
('Beauty_sunscreen', 51, 1),
('Beauty_temporarytattoo', 51, 1),
('Beauty_topicalhairregrowthtreatment', 51, 1),
('Beauty_wig', 51, 1),
('Clothing_apparelbelt', 51, 1),
('Clothing_apparelgloves', 51, 1),
('Clothing_apron', 51, 1),
('Clothing_armsleeve', 51, 1),
('Clothing_backpack', 51, 1),
('Clothing_choli', 51, 1),
('Clothing_coat', 51, 1),
('Clothing_corset', 51, 1),
('Clothing_earmuff', 51, 1),
('Clothing_foodbib', 51, 1),
('Clothing_keychain', 51, 1),
('Clothing_kurta', 51, 1),
('Clothing_lehengacholiset', 51, 1),
('Clothing_leotard', 51, 1),
('Clothing_necktie', 51, 1),
('Clothing_nightgownnightshirt', 51, 1),
('Clothing_overalls', 51, 1),
('Clothing_pajamas', 51, 1),
('Clothing_protectiveglove', 51, 1),
('Clothing_robe', 51, 1),
('Clothing_safetyglasses', 51, 1),
('Clothing_salwarsuitset', 51, 1),
('Clothing_saree', 51, 1),
('Clothing_scarf', 51, 1),
('Clothing_shoelace', 51, 1),
('Clothing_socks', 51, 1),
('Clothing_suspender', 51, 1),
('Clothing_sweatshirt', 51, 1),
('Clothing_tights', 51, 1),
('Clothing_totebag', 51, 1),
('Clothing_tracksuit', 51, 1),
('Clothing_tunic', 51, 1),
('Clothing_undergarmentslip', 51, 1),
('Clothing_underpants', 51, 1),
('Clothing_vest', 51, 1),
('Clothing_waistcincher', 51, 1),
('Computers_computerchassis', 51, 1),
('Computers_flashdrive', 51, 1),
('Computers_graphictablet', 51, 1),
('Computers_inputmouse', 51, 1),
('Computers_inputpen', 51, 1),
('Computers_multiporthub', 51, 1),
('Computers_opticaldiscdrive', 51, 1),
('ConsumerElectronics_3dprinter', 51, 1),
('ConsumerElectronics_avreceiver', 51, 1),
('ConsumerElectronics_banner', 51, 1),
('ConsumerElectronics_blankbook', 51, 1),
('ConsumerElectronics_calendar', 51, 1),
('ConsumerElectronics_cellphoneholster', 51, 1),
('ConsumerElectronics_cellularphonecase', 51, 1),
('ConsumerElectronics_chargingadapter', 51, 1),
('ConsumerElectronics_DipSwitch', 51, 1),
('ConsumerElectronics_electronicadapter', 51, 1),
('ConsumerElectronics_electronicbookreader', 51, 1),
('ConsumerElectronics_electronicdevicedockingstation', 51, 1),
('ConsumerElectronics_electronicdeviceskin', 51, 1),
('ConsumerElectronics_flatscreendisplaymount', 51, 1),
('ConsumerElectronics_greetingcard', 51, 1),
('ConsumerElectronics_landlinephone', 51, 1),
('ConsumerElectronics_microphone', 51, 1),
('ConsumerElectronics_MotionActuatedSwitch', 51, 1),
('ConsumerElectronics_mousepad', 51, 1),
('ConsumerElectronics_networkinterfacecontrolleradapter', 51, 1),
('ConsumerElectronics_onboardcamera', 51, 1),
('ConsumerElectronics_planner', 51, 1),
('ConsumerElectronics_portableelectronicdevicestand', 51, 1),
('ConsumerElectronics_powerconverter', 51, 1),
('ConsumerElectronics_powercord', 51, 1),
('ConsumerElectronics_powerstrip', 51, 1),
('ConsumerElectronics_powersupply', 51, 1),
('ConsumerElectronics_screenprotector', 51, 1),
('ConsumerElectronics_signage', 51, 1),
('ConsumerElectronics_standalonestreamingmediaplayer', 51, 1),
('ConsumerElectronics_ToggleSwitch', 51, 1),
('ConsumerElectronics_turntable', 51, 1),
('ConsumerElectronics_vehiclesafetycamera', 51, 1),
('ConsumerElectronics_videodiscplayer', 51, 1),
('ConsumerElectronics_virtualrealityheadset', 51, 1),
('Eyewear_correctiveeyeglasses', 51, 1),
('Eyewear_eyeglassframe', 51, 1),
('Eyewear_sunglasses', 51, 1),
('FoodAndBeverages_bakingmix', 51, 1),
('FoodAndBeverages_bread', 51, 1),
('FoodAndBeverages_breakfastcereal', 51, 1),
('FoodAndBeverages_cake', 51, 1),
('FoodAndBeverages_candy', 51, 1),
('FoodAndBeverages_cereal', 51, 1),
('FoodAndBeverages_chewinggum', 51, 1),
('FoodAndBeverages_chocolatecandy', 51, 1),
('FoodAndBeverages_coffee', 51, 1),
('FoodAndBeverages_condiment', 51, 1),
('FoodAndBeverages_cookie', 51, 1),
('FoodAndBeverages_cracker', 51, 1),
('FoodAndBeverages_culinarysalt', 51, 1),
('FoodAndBeverages_dairybasedbutter', 51, 1),
('FoodAndBeverages_dairybasedcheese', 51, 1),
('FoodAndBeverages_dairybasedcream', 51, 1),
('FoodAndBeverages_dairybaseddrink', 51, 1),
('FoodAndBeverages_dairybasedicecream', 51, 1),
('FoodAndBeverages_drinkflavored', 51, 1),
('FoodAndBeverages_edibleoilanimal', 51, 1),
('FoodAndBeverages_edibleoilvegetable', 51, 1),
('FoodAndBeverages_fish', 51, 1),
('FoodAndBeverages_flavoreddrinkconcentrate', 51, 1),
('FoodAndBeverages_flour', 51, 1),
('FoodAndBeverages_fruit', 51, 1),
('FoodAndBeverages_fruitsnack', 51, 1),
('FoodAndBeverages_herb', 51, 1),
('FoodAndBeverages_honey', 51, 1),
('FoodAndBeverages_jerky', 51, 1),
('FoodAndBeverages_juiceandjuicedrink', 51, 1),
('FoodAndBeverages_leaveningagent', 51, 1),
('FoodAndBeverages_legume', 51, 1),
('FoodAndBeverages_mealreplacementbeverage', 51, 1),
('FoodAndBeverages_meat', 51, 1),
('FoodAndBeverages_milksubstitute', 51, 1),
('FoodAndBeverages_nondairycream', 51, 1),
('FoodAndBeverages_noodle', 51, 1),
('FoodAndBeverages_nutandseed', 51, 1),
('FoodAndBeverages_nutbutter', 51, 1),
('FoodAndBeverages_packagedsoupandstew', 51, 1),
('FoodAndBeverages_pastry', 51, 1),
('FoodAndBeverages_popcorn', 51, 1),
('FoodAndBeverages_poultry', 51, 1),
('FoodAndBeverages_pretzel', 51, 1),
('FoodAndBeverages_proteindrink', 51, 1),
('FoodAndBeverages_ricemix', 51, 1),
('FoodAndBeverages_saladdressing', 51, 1),
('FoodAndBeverages_sauce', 51, 1),
('FoodAndBeverages_seafood', 51, 1),
('FoodAndBeverages_shellfish', 51, 1),
('FoodAndBeverages_snackchipandcrisp', 51, 1),
('FoodAndBeverages_snackmix', 51, 1),
('FoodAndBeverages_sugar', 51, 1),
('FoodAndBeverages_sugarcandy', 51, 1),
('FoodAndBeverages_sugarsubstitute', 51, 1),
('FoodAndBeverages_tea', 51, 1),
('FoodAndBeverages_thickeningagent', 51, 1),
('FoodAndBeverages_vegetable', 51, 1),
('FoodAndBeverages_vinegar', 51, 1),
('FoodAndBeverages_water', 51, 1),
('FoodServiceAndJanSan_trashcan', 51, 1),
('Health_astringentsubstance', 51, 1),
('Health_bathwateradditive', 51, 1),
('Health_bloodpressuremonitor', 51, 1),
('Health_bodylubricant', 51, 1),
('Health_condom', 51, 1),
('Health_dentalfloss', 51, 1),
('Health_earplug', 51, 1),
('Health_electricshaver', 51, 1),
('Health_essentialoil', 51, 1),
('Health_firstaidkit', 51, 1),
('Health_hairdryer', 51, 1),
('Health_hairiron', 51, 1),
('Health_herbalsupplement', 51, 1),
('Health_incontinenceprotector', 51, 1),
('Health_insectrepellent', 51, 1),
('Health_kneepad', 51, 1),
('Health_massager', 51, 1),
('Health_massagestick', 51, 1),
('Health_medicalteststrip', 51, 1),
('Health_medication', 51, 1),
('Health_menstrualcup', 51, 1),
('Health_mineralsupplement', 51, 1),
('Health_mouthwash', 51, 1),
('Health_muscleroller', 51, 1),
('Health_nutritionalsupplement', 51, 1),
('Health_oralirrigator', 51, 1),
('Health_orthopedicbrace', 51, 1),
('Health_personalpilldispenser', 51, 1),
('Health_proteinsupplementpowder', 51, 1),
('Health_sanitarynapkin', 51, 1),
('Health_shoeinsert', 51, 1),
('Health_sleepmask', 51, 1),
('Health_toothbrush', 51, 1),
('Health_toothbrushhead', 51, 1),
('Health_toothcleaningagent', 51, 1),
('Health_toothwhitener', 51, 1),
('Health_vitamin', 51, 1),
('Health_wounddressing', 51, 1),
('Home_airmattress', 51, 1),
('Home_bedskirt', 51, 1),
('Home_bodypositioner', 51, 1),
('Home_bottlerack', 51, 1),
('Home_broom', 51, 1),
('Home_coffeemaker', 51, 1),
('Home_crib', 51, 1),
('Home_deepfryer', 51, 1),
('Home_electricwaterboiler', 51, 1),
('Home_fooddehydrator', 51, 1),
('Home_hammock', 51, 1),
('Home_incense', 51, 1),
('Home_mattresscover', 51, 1),
('Home_pillowcase', 51, 1),
('Home_portablestove', 51, 1),
('Home_pressurecooker', 51, 1),
('Home_roastingpan', 51, 1),
('Home_rubberstamp', 51, 1),
('Home_rugpad', 51, 1),
('Home_sculpture', 51, 1),
('Home_sewingmachine', 51, 1),
('Home_stoolseating', 51, 1),
('Home_timer', 51, 1),
('Home_toaster', 51, 1),
('Home_toiletpaperholder', 51, 1),
('Home_toothbrushholder', 51, 1),
('HomeImprovement_aircompressor', 51, 1),
('HomeImprovement_areadeodorizer', 51, 1),
('HomeImprovement_ashtray', 51, 1),
('HomeImprovement_barbecuegrill', 51, 1),
('HomeImprovement_basket', 51, 1),
('HomeImprovement_bathtub', 51, 1),
('HomeImprovement_blowtorch', 51, 1),
('HomeImprovement_bottle', 51, 1),
('HomeImprovement_caddy', 51, 1),
('HomeImprovement_chainsaw', 51, 1),
('HomeImprovement_cleaningagent', 51, 1),
('HomeImprovement_clothesrack', 51, 1),
('HomeImprovement_cosmeticbrush', 51, 1),
('HomeImprovement_dishwasherdetergent', 51, 1),
('HomeImprovement_door', 51, 1),
('HomeImprovement_doorstop', 51, 1),
('HomeImprovement_drill', 51, 1),
('HomeImprovement_electricitygenerator', 51, 1),
('HomeImprovement_fastenerdrivebit', 51, 1),
('HomeImprovement_faucet', 51, 1),
('HomeImprovement_foodstoragebag', 51, 1),
('HomeImprovement_gassmokefirealarm', 51, 1),
('HomeImprovement_hangingrod', 51, 1),
('HomeImprovement_hardwareclampvise', 51, 1),
('HomeImprovement_hardwarehandle', 51, 1),
('HomeImprovement_hardwarehinge', 51, 1),
('HomeImprovement_hardwaretubing', 51, 1),
('HomeImprovement_hosepipefitting', 51, 1),
('HomeImprovement_jar', 51, 1),
('HomeImprovement_jewelrystorage', 51, 1),
('HomeImprovement_lampshade', 51, 1),
('HomeImprovement_laundrydetergent', 51, 1),
('HomeImprovement_laundryhamper', 51, 1),
('HomeImprovement_lock', 51, 1),
('HomeImprovement_multitool', 51, 1),
('HomeImprovement_pliers', 51, 1),
('HomeImprovement_portabletoolbox', 51, 1),
('HomeImprovement_safe', 51, 1),
('HomeImprovement_sander', 51, 1),
('HomeImprovement_saw', 51, 1),
('HomeImprovement_scissors', 51, 1),
('HomeImprovement_screwdriver', 51, 1),
('HomeImprovement_screwgun', 51, 1),
('HomeImprovement_securitycamera', 51, 1),
('HomeImprovement_shippingbox', 51, 1),
('HomeImprovement_showerhead', 51, 1),
('HomeImprovement_sink', 51, 1),
('HomeImprovement_snackfoodbar', 51, 1),
('HomeImprovement_solderingiron', 51, 1),
('HomeImprovement_storagebag', 51, 1),
('HomeImprovement_storagebox', 51, 1),
('HomeImprovement_storagedrawer', 51, 1),
('HomeImprovement_storagehook', 51, 1),
('HomeImprovement_storagerack', 51, 1),
('HomeImprovement_tile', 51, 1),
('HomeImprovement_toilet', 51, 1),
('HomeImprovement_toiletseat', 51, 1),
('HomeImprovement_utilityknife', 51, 1),
('HomeImprovement_valve', 51, 1),
('HomeImprovement_wallpaper', 51, 1),
('HomeImprovement_Washer', 51, 1),
('HomeImprovement_washerdryercombination', 51, 1),
('HomeImprovement_wastebag', 51, 1),
('HomeImprovement_waterpump', 51, 1),
('HomeImprovement_wrench', 51, 1),
('Industrial_adhesivetapes', 51, 1),
('Industrial_agriculturalsupplies', 51, 1),
('Industrial_bondingadhesives', 51, 1),
('Industrial_drillbits', 51, 1),
('Industrial_electromechanicalgauge', 51, 1),
('Industrial_ElectronicCable', 51, 1),
('Industrial_ElectronicComponentFan', 51, 1),
('Industrial_ElectronicComponentTerminal', 51, 1),
('Industrial_electronicswitch', 51, 1),
('Industrial_ElectronicWire', 51, 1),
('Industrial_endmills', 51, 1),
('Industrial_fertilizer', 51, 1),
('Industrial_horsetackequipment', 51, 1),
('Industrial_irrigationequipment', 51, 1),
('Industrial_livestockhousing', 51, 1),
('Industrial_Relay', 51, 1),
('Industrial_sawblade', 51, 1),
('Industrial_TerminalBlock', 51, 1),
('Industrial_thermometer', 51, 1),
('Industrial_weatherstation', 51, 1),
('Industrial_weighscale', 51, 1),
('Jewelry_apparelpin', 51, 1),
('Jewelry_charm', 51, 1),
('Jewelry_earring', 51, 1),
('Jewelry_jewelryset', 51, 1),
('Jewelry_piercingjewelry', 51, 1),
('Jewelry_ring', 51, 1),
('Jewelry_watchband', 51, 1),
('Kitchen_bakingcup', 51, 1),
('Kitchen_bakingpan', 51, 1),
('Kitchen_bakingpaper', 51, 1),
('Kitchen_bottleopener', 51, 1),
('Kitchen_bottlestopper', 51, 1),
('Kitchen_canopener', 51, 1),
('Kitchen_Casseroles', 51, 1),
('Kitchen_cocktailshaker', 51, 1),
('Kitchen_coffeefilter', 51, 1),
('Kitchen_cookiecutter', 51, 1),
('Kitchen_cookingpot', 51, 1),
('Kitchen_corepitremover', 51, 1),
('Kitchen_cuttingboard', 51, 1),
('Kitchen_drinkingcup', 51, 1),
('Kitchen_drinkingstraw', 51, 1),
('Kitchen_DutchOvens', 51, 1),
('Kitchen_flatware', 51, 1),
('Kitchen_foodpreparationmold', 51, 1),
('Kitchen_foodshaker', 51, 1),
('Kitchen_foodslicer', 51, 1),
('Kitchen_garlicpress', 51, 1),
('Kitchen_icecubetray', 51, 1),
('Kitchen_kitchenknife', 51, 1),
('Kitchen_knife', 51, 1),
('Kitchen_knifeblockset', 51, 1),
('Kitchen_knifesharpener', 51, 1),
('Kitchen_mealholder', 51, 1),
('Kitchen_measuringcup', 51, 1),
('Kitchen_pastamaker', 51, 1),
('Kitchen_pipingtip', 51, 1),
('Kitchen_pitcher', 51, 1),
('Kitchen_potablewaterfilter', 51, 1),
('Kitchen_RiceCookers', 51, 1),
('Kitchen_rollingpin', 51, 1),
('Kitchen_seasoningmill', 51, 1),
('Kitchen_sheetpan', 51, 1),
('Kitchen_teainfuser', 51, 1),
('Kitchen_teapot', 51, 1),
('Kitchen_thermos', 51, 1),
('Kitchen_wheelcutter', 51, 1),
('LabSupplies_Flask', 51, 1),
('LabSupplies_waterpurificationunit', 51, 1),
('LargeAppliances_hvacairfilter', 51, 1),
('LargeAppliances_vacuumfilter', 51, 1),
('LawnAndGarden_compostbin', 51, 1),
('LawnAndGarden_firepit', 51, 1),
('LawnAndGarden_freestandingshelter', 51, 1),
('LawnAndGarden_lawnmower', 51, 1),
('LawnAndGarden_leafblower', 51, 1),
('LawnAndGarden_metaldetector', 51, 1),
('LawnAndGarden_outbuilding', 51, 1),
('LawnAndGarden_pestcontroldevice', 51, 1),
('LawnAndGarden_plantseed', 51, 1),
('LawnAndGarden_pressurewasher', 51, 1),
('LawnAndGarden_shovelspade', 51, 1),
('LawnAndGarden_snowblower', 51, 1),
('LawnAndGarden_stringtrimmer', 51, 1),
('LawnAndGarden_wildlifefeeder', 51, 1),
('Lighting_candle', 51, 1),
('Lighting_lamp', 51, 1),
('Lighting_lightbulb', 51, 1),
('Lighting_lightfixture', 51, 1),
('Lighting_stringlight', 51, 1),
('Luggage_cosmeticcase', 51, 1),
('Luggage_duffelbag', 51, 1),
('Luggage_suitcase', 51, 1),
('Luggage_waistpack', 51, 1),
('MotoApparel_powersportsridinghelmet', 51, 1),
('MusicalInstruments_musicalinstruments', 51, 1),
('Office_badgeholder', 51, 1),
('Office_cardstock', 51, 1),
('Office_craftbead', 51, 1),
('Office_decorativeribbontrim', 51, 1),
('Office_disposablenapkin', 51, 1),
('Office_envelope', 51, 1),
('Office_fabricappliquepatch', 51, 1),
('Office_facialtissue', 51, 1),
('Office_filefolder', 51, 1),
('Office_glitter', 51, 1),
('Office_inkjetprinterink', 51, 1),
('Office_label', 51, 1),
('Office_markingpen', 51, 1),
('Office_papertowel', 51, 1),
('Office_pinboard', 51, 1),
('Office_printcopypaper', 51, 1),
('Office_sculptingmaterial', 51, 1),
('Office_selfsticknote', 51, 1),
('Office_stapler', 51, 1),
('Office_storagebinder', 51, 1),
('Office_templatestencil', 51, 1),
('Office_thermoplasticfilament', 51, 1),
('Office_toiletpaper', 51, 1),
('Office_writingboard', 51, 1),
('Office_writingpaper', 51, 1),
('Office_yarn', 51, 1),
('PetSupplies_animalcage', 51, 1),
('PetSupplies_animalcollar', 51, 1),
('PetSupplies_animalharness', 51, 1),
('PetSupplies_animallitter', 51, 1),
('PetSupplies_leash', 51, 1),
('PetSupplies_litterbox', 51, 1),
('PetSupplies_petbedmat', 51, 1),
('PetSupplies_petfeeder', 51, 1),
('PetSupplies_petpestcontrol', 51, 1),
('PetSupplies_pettoy', 51, 1),
('PetSupplies_vivarium', 51, 1),
('Shoes_slipper', 51, 1),
('SoftwareVideoGames_videogameconsole', 51, 1),
('SoftwareVideoGames_videogamecontroller', 51, 1),
('Sports_abdominalexerciser', 51, 1),
('Sports_aimingscopesight', 51, 1),
('Sports_airgun', 51, 1),
('Sports_airpump', 51, 1),
('Sports_barbell', 51, 1),
('Sports_basketballhoop', 51, 1),
('Sports_bicycletrainer', 51, 1),
('Sports_biometricmonitor', 51, 1),
('Sports_boxingglove', 51, 1),
('Sports_cyclingtire', 51, 1),
('Sports_exerciseband', 51, 1),
('Sports_exercisemat', 51, 1),
('Sports_fishinghook', 51, 1),
('Sports_fishingline', 51, 1),
('Sports_fishingreel', 51, 1),
('Sports_fitnessbench', 51, 1),
('Sports_golfclubbag', 51, 1),
('Sports_gunholster', 51, 1),
('Sports_icechest', 51, 1),
('Sports_jumprope', 51, 1),
('Sports_kickscooter', 51, 1),
('Sports_messkit', 51, 1),
('Sports_punchingbag', 51, 1),
('Sports_recreationball', 51, 1),
('Sports_rollerskate', 51, 1),
('Sports_rowingmachine', 51, 1),
('Sports_skateboard', 51, 1),
('Sports_sleepingbag', 51, 1),
('Sports_sleepingmat', 51, 1),
('Sports_snowboardboot', 51, 1),
('Sports_snowshoe', 51, 1),
('Sports_sportactivityglove', 51, 1),
('Sports_sportbinding', 51, 1),
('Sports_sporthelmet', 51, 1),
('Sports_sportmitt', 51, 1),
('Sports_sportracket', 51, 1),
('Sports_sporttablegame', 51, 1),
('Sports_sportwetsuit', 51, 1),
('Sports_stationarybicycle', 51, 1),
('Sports_sweatband', 51, 1),
('Sports_tent', 51, 1),
('Sports_trampoline', 51, 1),
('Sports_treadmill', 51, 1),
('Sports_utilityholsterpouch', 51, 1),
('Sports_walkingstick', 51, 1),
('Sports_waterflotationdevice', 51, 1),
('TiresAndWheels_vehicletire', 51, 1)
) as NewGroups(cName, kPlattform, nAktiv)
WHERE NOT EXISTS (
SELECT 1
FROM dbo.pf_amazon_group
WHERE pf_amazon_group.cName = NewGroups.cName
AND pf_amazon_group.kPlattform = NewGroups.kPlattform
)
2021-08-13T12:35:54 DEBUG - Dauer: 269ms, AffectedRows: 526
2021-08-13T12:35:54 DEBUG - --END AMA Lister

MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 0
WHERE AttributSprache.cName = 'jtl_voucher')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-08-13T12:35:54 DEBUG - Dauer: 62ms, AffectedRows: 1
2021-08-13T12:35:54 DEBUG - MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 1
WHERE AttributSprache.cName = 'jtl_voucher')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-08-13T12:35:54 DEBUG - Dauer: 8ms, AffectedRows: 1
2021-08-13T12:35:54 DEBUG - MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 0
WHERE AttributSprache.cName = 'jtl_voucher_flex')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-08-13T12:35:54 DEBUG - Dauer: 6ms, AffectedRows: 1
2021-08-13T12:35:54 DEBUG - MERGE INTO dbo.tAttributShop AS Target
USING (SELECT AttributSprache.kAttribut, Shop.kShop
FROM dbo.tAttributSprache AS AttributSprache
JOIN dbo.tShop AS Shop ON Shop.nTyp = 1
WHERE AttributSprache.cName = 'jtl_voucher_flex')
AS Source ON (Target.kAttribut = Source.kAttribut AND Target.kShop = Source.kShop)
WHEN NOT MATCHED THEN
INSERT (kAttribut, kShop) VALUES (Source.kAttribut, Source.kShop);
2021-08-13T12:35:54 DEBUG - Dauer: 16ms, AffectedRows: 1
2021-08-13T12:35:54 DEBUG - DECLARE @Reservierung TYPE_spReservierungAktualisieren;
INSERT INTO @Reservierung ( kBestellPos )
SELECT tbestellpos.kBestellPos
FROM dbo.tbestellpos
JOIN dbo.tBestellung ON tBestellung.kBestellung = tbestellpos.tBestellung_kBestellung
WHERE tBestellung.nKomplettAusgeliefert = 0;

EXEC dbo.spReservierungAktualisieren @Positionen = @Reservierung;
2021-08-13T12:35:54 DEBUG - Dauer: 116ms, AffectedRows: 37
2021-08-13T12:35:54 DEBUG - SELECT * FROM tUpdateLog WHERE kUpdateLog > @kUpdateLog
kUpdateLog = 2
2021-08-13T12:35:54 DEBUG - Dauer: 1ms, (bis zum Reader)
2021-08-13T12:35:54 DEBUG - Dauer: 1ms, 0 Zeilen
2021-08-13T12:35:54 DEBUG - SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
2021-08-13T12:35:54 DEBUG - Dauer: 0ms, Result: local
Zeitstempel: 2021-08-13T12:36:02
Locale: German (Germany)
Locale: German (Germany)
Version: 1.5.47.2
Plattform: Wawi
WawiSeed: 0.7.70781.80001
Prozessname: JTL-Wawi
Physikalischer Speicher: 696610816 / Peak: 735256576
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:01:21,484375
CPU-Zeit (System): 0:00:20,59375
Page-Size (Sytem): 2570608 / Peak: 757432320
Page-Size: 693018624 / Peak: 757432320
Offene Handles: 2134
Database:
Build: 2107190928 6a264dcd904464037011d53065ca4af57a458888

 

[Arne Janson]

Moin @duftmania ich hatte dieses auch dieses exakt bei einem Kunden. Hierzu wurde ein Ticket aufgemacht: Ticket#2021080910000634 Antwort von JTL: "das ist aktuell ein bekannter Fehler. Hierfür ist bereits ein Vorgang in unserer Entwicklung in Bearbeitung um hier eine Lösung zu finden." Gerne kannst du, wenn du möchtest ein Ticket beim JTL Support aufmachen und auf "Ticket#2021080910000634" verweisen.

 

[Arne Janson]

Moin @duftmania von JTL gibt es wohl eine Lösung. Antort aus dem Ticket#2021080910000634 "ich hab hier einen manuelle Lösung für dieses Updateproblem. Meine Kollegen aus den Entwicklung werden hierfür einen Fix für eins der nächsten Updates bauen."

 

[Arne Janson]

Moin @duftmania Lösung beim Kunden war: Es gab einen Auftrag mit Datum 01.01.1900, das konnte die Wawi nicht verarbeiten. Datum auf 01.04.2015 gesetzt und dann hat das Update geklappt