Hallo,
ich bekomme beim Artikelupload mit dem JTL Connector zu Shopware immer eine Fehlermeldung angezeigt, welche den Upload stoppt.
Betrifft einen Artikel - wo irgendwo ein Fehler drin sein muss. Er war schon einmal im Shop vorhanden aber jetzt kommt immer diese Meldung. Ich habe ihn im Shop gelöscht und im JTL auf Shop inaktiv und dann wieder aktiv gesetzt - leider kommt weiterhin der für mich nicht nachvollziehbare Fehler.
Ich hoffe es kann mir jemand sagen, was hier stört. So komme ich leider nicht weiter
Viele Grüße
Nicole
Fehlermeldung:
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [ee6a2078-3b85-41cf-94a4-4d35f0b26093] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in : Artikel-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [ee6a2078-3b85-41cf-94a4-4d35f0b26093] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Response: {"jtlrpc":"2.0","id":"047397f19dbf4f49b0bccb870b7b8a2e","result":null,"error":{"code":520,"message":"Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung f\u00fcr Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [b2deca08-8175-4605-9b96-14bbfaf99140] The Shopware 6 Admin API responded with an error: \nCode = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:110"},"warnings":[]}
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [ee6a2078-3b85-41cf-94a4-4d35f0b26093] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Response: {"jtlrpc":"2.0","id":"987c1e21013f4089abc1b97975bd7b49","result":null,"error":{"code":520,"message":"Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung f\u00fcr Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error: \nCode = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:110"},"warnings":[]}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.Ij7MUQrbbQv(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.spCMUxfAaj0(String , Object , Boolean , NetworkCredential , Boolean )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.Ij7MUQrbbQv(String , Object , Boolean , NetworkCredential )
2025-03-26T15:24:21 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:21 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness. Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:21 DEBUG - Dauer: 0ms
2025-03-26T15:24:31 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:24:31 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:24:31 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:31 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:31 DEBUG - Dauer: 0ms
2025-03-26T15:24:39 DEBUG - SELECT tbestellung.kBestellung,
tbestellung.cBestellNr AS 'Auftrags Nr.',
CASE
WHEN tbestellung.dBezahlt is null THEN
convert(varchar,tbestellung.dErstellt,104)
ELSE
convert(varchar,tbestellung.dBezahlt,104)
END AS 'Datum',
CASE
WHEN tbestellung.dBezahlt is null THEN
convert(varchar,tbestellung.dErstellt,102)
ELSE
convert(varchar,tbestellung.dBezahlt,102)
END AS 'Datum_Sort'
,dbo.tFarbe.nFarbcode as RowColor ,dbo.tAdresse.cVorname as Vorname, dbo.tAdresse.cName as Name ,dbo.tAdresse.cFirma as Firma ,CASE WHEN (DATEDIFF(dd,tBestellung.dErstellt,GETDATE()) - tBestellung.nZahlungsziel < 0)
THEN
'0'
ELSE
DATEDIFF(dd,tBestellung.dErstellt,GETDATE()) - tBestellung.nZahlungsziel
END
AS 'Verzug (Tage)' ,XX.Betrag AS 'Betrag (Netto)' FROM DEPRECATED.vBestellung AS tBestellung
LEFT JOIN dbo.tFarbe ON tBestellung.kColor = dbo.tFarbe.kFarbe LEFT JOIN dbo.tkunde ON tBestellung.tKunde_kKunde = dbo.tkunde.kKunde
JOIN dbo.tAdresse ON tAdresse.kKunde = tKunde.kKunde AND tAdresse.nTyp = 1 AND tAdresse.nStandard = 1
LEFT JOIN dbo.tFirma ON tBestellung.kFirma = dbo.tFirma.kFirma LEFT JOIN (SELECT tBestellung_kBestellung, CAST(ROUND(SUM((nAnzahl*fVKNetto*(100-fRabatt)/100.0)*(100+fMwSt)/100), 2) AS DECIMAL(10,2)) AS Betrag
FROM DEPRECATED.vBestellpos AS tBestellpos
GROUP BY tBestellung_kBestellung) as XX ON XX.tBestellung_kBestellung = tBestellung.kBestellung WHERE (tBestellung.kColor = @farbe) AND (tbestellung.cType = 'B')
@farbe = 0
2025-03-26T15:24:39 DEBUG - Dauer: 2ms
2025-03-26T15:24:41 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:24:41 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:24:41 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:41 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:41 DEBUG - Dauer: 0ms
2025-03-26T15:24:51 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:24:51 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:24:51 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:51 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:51 DEBUG - Dauer: 0ms
2025-03-26T15:25:01 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:25:01 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:25:01 DEBUG - Dauer: 1 ms, 1 Zeilen
2025-03-26T15:25:01 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:25:01 DEBUG - Dauer: 0ms
Zeitstempel: 2025-03-26T15:25:03
Locale: German (Germany)
Locale: German (Germany)
Version: Der Wert wurde nicht erstellt.
Plattform: Wawi
WawiSeed: 4.1.92341.05901
Prozessname: JTL-SharpWawi
Physikalischer Speicher: 1636429824 / Peak: 1735487488
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:08:33,875
CPU-Zeit (System): 0:01:31,78125
Page-Size (Sytem): 2544744 / Peak: 1484914688
Page-Size: 1387745280 / Peak: 1484914688
Offene Handles: 4339
Database:
Build: 2501141642 e5cc441f02dd9fa1258ac4ec744f69c707e91553
ich bekomme beim Artikelupload mit dem JTL Connector zu Shopware immer eine Fehlermeldung angezeigt, welche den Upload stoppt.
Betrifft einen Artikel - wo irgendwo ein Fehler drin sein muss. Er war schon einmal im Shop vorhanden aber jetzt kommt immer diese Meldung. Ich habe ihn im Shop gelöscht und im JTL auf Shop inaktiv und dann wieder aktiv gesetzt - leider kommt weiterhin der für mich nicht nachvollziehbare Fehler.
Ich hoffe es kann mir jemand sagen, was hier stört. So komme ich leider nicht weiter
Viele Grüße
Nicole
Fehlermeldung:
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: Exception: Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [ee6a2078-3b85-41cf-94a4-4d35f0b26093] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in : Artikel-Senden-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [ee6a2078-3b85-41cf-94a4-4d35f0b26093] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Response: {"jtlrpc":"2.0","id":"047397f19dbf4f49b0bccb870b7b8a2e","result":null,"error":{"code":520,"message":"Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung f\u00fcr Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [b2deca08-8175-4605-9b96-14bbfaf99140] The Shopware 6 Admin API responded with an error: \nCode = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:110"},"warnings":[]}
Exception bei product.push: Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung für Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [ee6a2078-3b85-41cf-94a4-4d35f0b26093] The Shopware 6 Admin API responded with an error:
Code = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)
Response: {"jtlrpc":"2.0","id":"987c1e21013f4089abc1b97975bd7b49","result":null,"error":{"code":520,"message":"Controller = Product | Action = push | JTL-Wawi PK = 2118 | SKU = 202301-G | Name = Halterung f\u00fcr Rauchverschluss am Schlauchtragekorb (Gurt-Halterung) | [45146e7e-ec5a-4e18-a578-f5ac1e9c1a20] The Shopware 6 Admin API responded with an error: \nCode = 1452 | Detail = An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`c10105newlive`.`product`, CONSTRAINT `product_ibfk_1` FOREIGN KEY (`product_manufacturer_id`, `product_manufacturer_version_id`) REFERENCES `product_manufacturer` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CASCADE)","data":"Jtl\\Shopware6\\Client\\Exception\\ClientException (Code: 520) in ...\/ClientException.php:110"},"warnings":[]}
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.Ij7MUQrbbQv(String , Object , Boolean , NetworkCredential )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.spCMUxfAaj0(String , Object , Boolean , NetworkCredential , Boolean )
bei jtlCore.ControllerClasses.Connector.Abgleich.Connector.Ij7MUQrbbQv(String , Object , Boolean , NetworkCredential )
2025-03-26T15:24:21 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:21 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness. Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:21 DEBUG - Dauer: 0ms
2025-03-26T15:24:31 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:24:31 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:24:31 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:31 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:31 DEBUG - Dauer: 0ms
2025-03-26T15:24:39 DEBUG - SELECT tbestellung.kBestellung,
tbestellung.cBestellNr AS 'Auftrags Nr.',
CASE
WHEN tbestellung.dBezahlt is null THEN
convert(varchar,tbestellung.dErstellt,104)
ELSE
convert(varchar,tbestellung.dBezahlt,104)
END AS 'Datum',
CASE
WHEN tbestellung.dBezahlt is null THEN
convert(varchar,tbestellung.dErstellt,102)
ELSE
convert(varchar,tbestellung.dBezahlt,102)
END AS 'Datum_Sort'
,dbo.tFarbe.nFarbcode as RowColor ,dbo.tAdresse.cVorname as Vorname, dbo.tAdresse.cName as Name ,dbo.tAdresse.cFirma as Firma ,CASE WHEN (DATEDIFF(dd,tBestellung.dErstellt,GETDATE()) - tBestellung.nZahlungsziel < 0)
THEN
'0'
ELSE
DATEDIFF(dd,tBestellung.dErstellt,GETDATE()) - tBestellung.nZahlungsziel
END
AS 'Verzug (Tage)' ,XX.Betrag AS 'Betrag (Netto)' FROM DEPRECATED.vBestellung AS tBestellung
LEFT JOIN dbo.tFarbe ON tBestellung.kColor = dbo.tFarbe.kFarbe LEFT JOIN dbo.tkunde ON tBestellung.tKunde_kKunde = dbo.tkunde.kKunde
JOIN dbo.tAdresse ON tAdresse.kKunde = tKunde.kKunde AND tAdresse.nTyp = 1 AND tAdresse.nStandard = 1
LEFT JOIN dbo.tFirma ON tBestellung.kFirma = dbo.tFirma.kFirma LEFT JOIN (SELECT tBestellung_kBestellung, CAST(ROUND(SUM((nAnzahl*fVKNetto*(100-fRabatt)/100.0)*(100+fMwSt)/100), 2) AS DECIMAL(10,2)) AS Betrag
FROM DEPRECATED.vBestellpos AS tBestellpos
GROUP BY tBestellung_kBestellung) as XX ON XX.tBestellung_kBestellung = tBestellung.kBestellung WHERE (tBestellung.kColor = @farbe) AND (tbestellung.cType = 'B')
@farbe = 0
2025-03-26T15:24:39 DEBUG - Dauer: 2ms
2025-03-26T15:24:41 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:24:41 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:24:41 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:41 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:41 DEBUG - Dauer: 0ms
2025-03-26T15:24:51 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:24:51 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:24:51 DEBUG - Dauer: 0 ms, 1 Zeilen
2025-03-26T15:24:51 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:24:51 DEBUG - Dauer: 0ms
2025-03-26T15:25:01 DEBUG - SELECT TOP(2)
[eazybusiness].[dbo].[tUniqueSession].[kSession] AS [kSession],
[eazybusiness].[dbo].[tUniqueSession].[cContext] AS [cContext],
[eazybusiness].[dbo].[tUniqueSession].[dLastCallback] AS [dLastCallback],
[eazybusiness].[dbo].[tUniqueSession].[cInfo] AS [cInfo],
[eazybusiness].[dbo].[tUniqueSession].[cRechnername] AS [cRechnername]
FROM
[eazybusiness].[dbo].[tUniqueSession]
WHERE
(([eazybusiness].[dbo].[tUniqueSession].[cContext] = 'Worker 2.0'));
2025-03-26T15:25:01 DEBUG - Dauer: 0ms, (bis zum Reader)
2025-03-26T15:25:01 DEBUG - Dauer: 1 ms, 1 Zeilen
2025-03-26T15:25:01 DEBUG -
SELECT
CAST(tStatus.nAbgleichstyp AS varchar(10)) AS nAbgleichstyp,
CAST(tStatus.kMandant AS varchar(10)) AS kMandant,
CAST(tStatus.kZiel AS varchar(10)) AS kZiel,
CAST(tStatus.nStatus AS varchar(10)) AS nStatus
FROM eazybusiness.Worker.tStatus
WHERE tStatus.nAbgleichstyp NOT IN (13);
2025-03-26T15:25:01 DEBUG - Dauer: 0ms
Zeitstempel: 2025-03-26T15:25:03
Locale: German (Germany)
Locale: German (Germany)
Version: Der Wert wurde nicht erstellt.
Plattform: Wawi
WawiSeed: 4.1.92341.05901
Prozessname: JTL-SharpWawi
Physikalischer Speicher: 1636429824 / Peak: 1735487488
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:08:33,875
CPU-Zeit (System): 0:01:31,78125
Page-Size (Sytem): 2544744 / Peak: 1484914688
Page-Size: 1387745280 / Peak: 1484914688
Offene Handles: 4339
Database:
Build: 2501141642 e5cc441f02dd9fa1258ac4ec744f69c707e91553