Neu UPDATE Fehler von 1.5.36.2 auf 1.5.51.1

andreasscharf

Neues 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 Update von 5.0 auf 5.1.5 fehlgeschlagen, Fehler bei Datenbankaktualisierung Installation / Updates von JTL-Shop 1
Neu Fehler nach Update von 4.06.18 nach 4.06.20 JTL-Wawi - Fehler und Bugs 2
Neu Update von 5.1.2 -> 5.1.3 Fehler Dateistruktur Installation / Updates von JTL-Shop 0
Neu Update von 5.1.2 auf 5.1.3 SQL Fehler Installation / Updates von JTL-Shop 9
Nach Update Fehler bei eBay-Abgleich JTL-Wawi 1.6 4
Fehler Retourenlabel nach Update auf 16.42.0 Fehler JTL-Wawi 1.6 2
Neu Update 5.1.1 --> 5.1.4: Fehler im Bestellvorgang "unknown tag 'getCountry'" (inc_billing_address_form.tpl) (NOVA) Installation / Updates von JTL-Shop 1
Neu JTL Shop Update 5.1.3 - Datenbank Fehler: 1062 Duplicate entry 'COUNTRY_VIEW' for key 'PRIMARY' Installation / Updates von JTL-Shop 6
Fehler bei Update: "SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined" Upgrade JTL-Shop4 auf JTL-Shop5 1
Neu Variablen funktionieren nach Update nicht mehr JTL-Shop - Fehler und Bugs 0
Kategorie Bilder werden nach Update von JTl-Shop 4 auf JTL-Shop 5 nicht angezeigt Upgrade JTL-Shop4 auf JTL-Shop5 2
Neu Access Violation nach Update auf 1.6.42.2 JTL-WMS / JTL-Packtisch+ - Fehler und Bugs 0
Neu Datenbankfehler nach Update auf 5.1.5 Installation / Updates von JTL-Shop 2
Neu Bestellvorschläge funktioniert nach Update auf 1.6.42.2 nicht mehr JTL-Wawi - Fehler und Bugs 4
Neu DB Update hängt 5.1.2 zu 5.1.5 Einrichtung JTL-Shop5 1
Neu Boxen füllen - Druckt jetzt Auftrag und keine Rechnung Nach Update 1.6 Arbeitsabläufe in JTL-Wawi 0
Amazon Rechnungen VCS Probleme nach dem Update auf der 1.6 JTL-Wawi 1.6 3
Neu Nach update auf Shop 5 lädt Bestellabschlussseite nicht mehr Installation / Updates von JTL-Shop 4
Neu Problem bei Artikelimport nach Update auf JTL-WAWI 1.6 User helfen Usern - Fragen zu JTL-Wawi 0
Neu Export von Rechnungen - Auftragswährung Feld leer seit Update JTL-Ameise - Fehler und Bugs 7
Nach Update Fehlermeldung beim einstellen von Kinderartikeln. kaufland.de - Anbindung (SCX) 1
Neu Update auf Shop 5.1.5 Installation / Updates von JTL-Shop 2
Neu Probleme bei Update und Deinstallation der Wawi auf Win10P JTL-Wawi - Fehler und Bugs 4
Neu Weiße Seite nach Update auf 5.1.5 Installation / Updates von JTL-Shop 1
Neu Lizenz/Update-Prüfung Shop Admin 5.15 lädt dauerhaft JTL-Shop - Fehler und Bugs 0
Update von 1.5.55.4 auf 1.6.41.2 nicht möglich JTL-Wawi 1.6 7
Neu Nach Update funktioniert Shopware Connector nicht mehr. Auch Fehlermeldung nach Bestellung für Kunden Shopware-Connector 5
Neu Update Wawi von 1.5.55.2 aud 1.6.41.2 Installation von JTL-Wawi 2
Update bei JTL Shop Hosting Upgrade JTL-Shop4 auf JTL-Shop5 3
Neu Nach Update: Meldung Steuerklassen ohne Steuerschlüssel OSS User helfen Usern - Fragen zu JTL-Wawi 0
Neu JTL WAWI Update mit WoodmartCore JTL-Wawi - Fehler und Bugs 0
Neu Update auf aktuelle Version - keine Plusbuchung nur mit Scanner mehr möglich JTL-WMS / JTL-Packtisch+ - Fehler und Bugs 0
Update von Version 1.5.31.0 auf 1.6.41.2 ungültiger Spaltenname JTL-Wawi 1.6 3
In Bearbeitung FCC Update schlägt fehl JTL-POS - Fehler und Bugs 24
Neu Update Wawi 1.5... auf 1.6.41.2 Installation von JTL-Wawi 3
SQL-Abfrage funktioniert seit Update nicht mehr JTL-Wawi 1.6 9
Neu Darstellungsprobleme nach Update auf 5.1.4 JTL-Shop - Fehler und Bugs 2
Seit Update sind Artikel reserviert und können nicht im Packtisch versandt werden JTL-Wawi 1.6 2
Verwiesen an Support Update auf 1.6 FOREIGN KEY-Einschränkung Absturz Servicedesk (Beta) 2
Neu Lizenzproblem bei eigenem Nova Child nach Update auf 5.1.4 JTL-Shop - Fehler und Bugs 0
Neu Update 5.0 auf 5.1.4 Datenbank update funktioniert nicht Installation / Updates von JTL-Shop 3
Beantwortet nach Update von 1.55.5.2 zu 1.6.40.0 kein Scannen des "#Verpacken" mehr möglich JTL-WMS / JTL-Packtisch+ - Fehler und Bugs 2
Neu Nach Shop Update (5.1.4) funzt die Theme Kompilierung nicht mehr. JTL-Shop - Fehler und Bugs 3
Neu 1.6 Update UmsatzsteuerID nicht mehr auf den Belegen User helfen Usern - Fragen zu JTL-Wawi 3
Seit Update auf Wawi 16 werden uns keine Variationen im Shop mehr angezeigt!!!! JTL-Wawi 1.6 22
Gelöst linke Seitenliste in Artikelübersicht verschwunden, einstellen nach Update JTL-Shop - Fehler und Bugs 1
Neu Generelle Update Reihenfolge Leitfaden erwünscht Installation / Updates von JTL-Shop 5
Beantwortet Update unter Windows Server 2012 R2 Installation von JTL-Wawi 5
Neu Nach Update auf 5.1.4: Modifizierte Datei Installation / Updates von JTL-Shop 6
Nach Update Shop4 auf Shop5 keine Neukunden Anmeldung möglich Upgrade JTL-Shop4 auf JTL-Shop5 1

Ähnliche Themen