Neu UPDATE Fehler von 1.5.36.2 auf 1.5.51.1

andreasscharf

Mitglied
22. November 2021
1
0
Hallo JTL Team und Forenmitglieder.
ich versuche gerade bei mir ein UPDATE von JTL Wawi 1.5.36.2 auf Version 1.5.51.1 zu installieren sobald ich die Datenbank aktualisieren möchte bekomme folgenden Fehler

1637587717354.png

Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: 02:20:37 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 hat zu einem Überlauf geführt. 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: dbo.spReservierungAktualisieren


2021-11-22T14:20:34 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-11-22T14:20:34 DEBUG - Dauer: 7ms
2021-11-22T14:20:34 DEBUG - UPDATE [dbo].[tVersion] SET [cVersion] = '1.5.47.0';
2021-11-22T14:20:34 DEBUG - Dauer: 7ms, AffectedRows: 1
2021-11-22T14:20:34 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-11-22T14:20:36 DEBUG - Dauer: 1705ms, AffectedRows: 57213
2021-11-22T14:20:36 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-11-22T14:20:36 DEBUG - Dauer: 15ms, AffectedRows: 2
2021-11-22T14:20:36 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-11-22T14:20:36 DEBUG - Dauer: 115ms, AffectedRows: 526
2021-11-22T14:20:36 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-11-22T14:20:36 DEBUG - Dauer: 41ms, AffectedRows: 1
2021-11-22T14:20:36 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-11-22T14:20:36 DEBUG - Dauer: 60ms, AffectedRows: 0
2021-11-22T14:20:36 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-11-22T14:20:36 DEBUG - Dauer: 14ms, AffectedRows: 1
2021-11-22T14:20:36 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-11-22T14:20:36 DEBUG - Dauer: 4ms, AffectedRows: 0
2021-11-22T14:20:36 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-11-22T14:20:37 DEBUG - Dauer: 460ms, AffectedRows: 26260
2021-11-22T14:20:37 DEBUG - SELECT * FROM tUpdateLog WHERE kUpdateLog > @kUpdateLog
kUpdateLog = 2
2021-11-22T14:20:37 DEBUG - Dauer: 0ms, (bis zum Reader)
2021-11-22T14:20:37 DEBUG - Dauer: 1ms, 0 Zeilen
2021-11-22T14:20:37 DEBUG - SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
2021-11-22T14:20:37 DEBUG - Dauer: 0ms, Result: local
Zeitstempel: 2021-11-22T14:21:52
Locale: German (Germany)
Locale: German (Germany)
Version: 1.5.51.1
Plattform: Wawi
WawiSeed: 5.1.13267.214301
Prozessname: JTL-Wawi
Physikalischer Speicher: 544821248 / Peak: 662855680
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:01:55,046875
CPU-Zeit (System): 0:00:10,796875
Page-Size (Sytem): 1953744 / Peak: 631566336
Page-Size: 482398208 / Peak: 631566336
Offene Handles: 1331
Database:
Build: 2111111225 df62843e8c13f04731af3522ab489d5256fb6c2c
 
Ähnliche Themen
Titel Forum Antworten Datum
Neu Fehler bei Update von 1.5.55.8 auf jede weitere Version bis einschließlich 1.8.11.0 Gelöste Themen in diesem Bereich 3
Neu Fehler beim Update von Exportformat Google Shopping JTL-Shop - Fehler und Bugs 1
Neu Fehler beim Update von JTL-WAWI 1.8.8.2 auf 1.8.9.1 JTL-Wawi - Fehler und Bugs 6
Neu JTL-Shop 5.3.0 RC3 Fehler nach Update Portlet Banner, fehlendes Produkt JTL-Shop - Fehler und Bugs 0
Was bedeutet dieser Fehler? - Jtlwa wai update to 1.8.11 JTL-Wawi 1.8 2
Neu Update 5.1.2 auf 5.2.4 Struktur-Migration Fehler in 320 Tabellen, PHP 8.2.14 Gelöste Themen in diesem Bereich 3
Neu Wawi Update Fehler JTL-Wawi - Fehler und Bugs 0
Neu Update des JTL shops aus der Wawi funktioniert nicht Allgemeine Fragen zu JTL-Shop 1
Neu Greyhound JTL-Connector funktioniert nach Update auf 1.8.12 nicht mehr richtig Technische Fragen zu den JTL-Connectoren 0
Neu Kuriosum - Shop 5.1.5 mit Datenbank 5.2.4 Mischbetrieb nach fehlgeschlagenem Update Installation / Updates von JTL-Shop 8
Neu Weiße Seite nach Update Shop 5.1.5. auf 5.2.4 Installation / Updates von JTL-Shop 24
Neu fehlermeldung update 1.5 > 1.7 Installation von JTL-Wawi 1
Neu Erledigt - Plugin PayPal Checkout, Update auf 1.4.0, Komplettabsturz Plugins für JTL-Shop 1
Neu Keine SEO URLs bei Kinderartikeln nach Update Allgemeine Fragen zu JTL-Shop 3
Neu Update von 5.1.5 auf 5.2.4 Installation / Updates von JTL-Shop 1
Neu Update von Wawi 17.15.4. auf 18.12.0 geht nicht, weil Primary voll ist JTL-Wawi - Fehler und Bugs 4
Störung nach Update JTL-Wawi 1.8 2
JTL Wawi Update 1.7.15.5 - Worker hat keinen Zugriff auf DB JTL-Wawi 1.7 6
Manuelle Workflowliste nach Update durcheinandergewürfelt JTL-Wawi 1.8 0
Neu Nach Update von 1.5 auf 1.8 Versand in die Schweiz nicht mehr möglich JTL-ShippingLabels - Fehler und Bugs 2
Neu Links der Startseite funktionieren nach Update mobil nicht Installation / Updates von JTL-Shop 1
Wawi 1.8.11.2 startet nicht mehr nach Win 11 Update vom 14.02. ??? JTL-Wawi 1.8 3
Wawi startet nach UPDATE auf 1.8.11.0 nicht mehr JTL-Wawi 1.8 2
Neu Update MS SQL 2014 auf MS SQL 2022 User helfen Usern - Fragen zu JTL-Wawi 0
Update von JTL-Shop 4.06 auf JTL-Shop 5.1.1 geht nicht Upgrade JTL-Shop4 auf JTL-Shop5 4
Neu Nach Update auf 1.8 sind alle stornierten Verkäufe als bezahlt markiert JTL-Wawi - Fehler und Bugs 5
Bug: Fail to update Product Data. There are missing Attributes Titel, Bild, FSK-Einstufung kaufland.de - Anbindung (SCX) 2
Nur noch sporadischer Versand per Mail von Rechnungen, Lieferscheinen und Mahnungen nach Update auf Version 1.8. JTL-Wawi 1.8 0
Neu Nach Update auf 1.8.11 - teilweise kein "Amazon - Neue Produkteseite erstellen" möglich Amazon-Lister - Fehler und Bugs 1
Nach Update auf 1.8. sind die Bilderpfade alle gleich JTL-Wawi 1.8 0
Skonto fehlt nach Update JTL-Wawi 1.8 0
Neu Kein Update vom Sendungsstatus JTL-Track&Trace - Ideen, Lob und Kritik 1
Neu SQL Server Express 2017 auf 2022 Update Installation von JTL-Wawi 10
Nach Update von 1.5.55 auf 1.8.10 alle Cross-Selling Produkte verschwunden JTL-Wawi 1.8 0
Update auf 1.7.15.4 JTL-Wawi 1.7 7
Neu Problem beim Update von 5.0.0 auf 5.2.4 (Integrity constraint violation: 1062 Duplicate entry 'COUNTRY_VIEW' for key 'PRIMARY'") Installation / Updates von JTL-Shop 3
Sequenz enthält kein übereinstimmendes Element - nach Update von 1.5.55 auf 1.6.48 - Artikel lassen sich nicht mehr öffnen nach Speichern JTL-Wawi 1.6 6
Neu Keine Übertragung der Preise mehr seit Connector Update von 1.41.2 auf 1.42.0 WooCommerce-Connector 9
Neu Update auf Connector 2.2.5.3 stürzt mich ins Chaos Shopware-Connector 4
Update auf 1.8.9.1 nicht möglich JTL-Wawi 1.8 0
Wawi Update von 1.5.55.6 auf 1.8.10.0 JTL-Wawi 1.8 62
Windows (10) update verhindert Zugriff auf Datenbank JTL-Wawi 1.6 3
Update von 1.5.55.8 auf 1.7.15.4 nicht möglich JTL-Wawi 1.7 4
Verwiesen an Support Datenbankwiederherstellung nach Update der JTL-POS auf 1.0.9.3 funktioniert nicht (Gerät Sunmi T2) JTL-POS - Fehler und Bugs 1
Neu Artikel können nicht geöffnet werden (Geisterartikel) update: Problem gelöst User helfen Usern - Fragen zu JTL-Wawi 0
Nach letzte Update 1.8.9.1 kein zugriff auf Mediadateien? JTL-Wawi 1.8 2
Fehler beim Rendering der Attribute bei SCX Abgleich kaufland.de - Anbindung (SCX) 1
Neu Smarty-Fehler im Logfile JTL-Shop - Fehler und Bugs 1
Neu Fehler beim Zahlungsabgleich - Zahlungsmodul - Wawi 1.5.55.6 JTL-Wawi - Fehler und Bugs 13
Neu Fehler: Sonderpreis falsch formatiert, wird nicht importiert; obwohl importiert genau wie exportiert User helfen Usern - Fragen zu JTL-Wawi 0

Ähnliche Themen