Unbehandelte Ausnahme #7110FFD83C0136E0 vom Typ JTL.Database.SqlUpdater.UpdateException in
JTL.Database.SqlUpdater.UpdateException: 10:00:51 Fehler in der Version 1.7.14.0 beim Befehl:
==============================================DECLARE @BillOfMaterials pps.TYPE_spCalculateAvailableProductionStock;
INSERT INTO @BillOfMaterials (kBillOfMaterial) SELECT kBillOfMaterial FROM pps.tBillOfMaterial AS Bom WHERE Bom.nState = 1;
EXEC pps.spCalculateAvailableProductionStock @BillOfMaterials = @BillOfMaterials;==============================================
FEHLER:
Fehler aufgrund einer Division durch Null.
2025-03-29T22:00:51 DEBUG - Dauer: 52ms
2025-03-29T22:00:51 DEBUG - DECLARE @Identities TABLE (Id INT NOT NULL);
INSERT INTO [dbo].[tUpdateMigration] ([cVersion], [bHash], [cObjectname], [cError], [cSqlId]) OUTPUT INSERTED.[kUpdateMigration] AS [Id] INTO @Identities VALUES (@cVersion, @bHash, @cObjectname, @cError, @cSqlId);
SELECT [Id] FROM @Identities ORDER BY [Id];
@cVersion = '1.7.14.0'
@bHash = CONVERT(varbinary(max), '34-37-36-35-41-32-39-44-35-39-32-42-37-41-45-43-38-38-33-46-41-41-30-42-32-34-41-33-37-44-33-42', 2)
@cObjectname = 'CreateColumn_nAutoShowProcessParameterValuesInProduction_ON_[ResPl].[tWorkbenchResource]'
@cError = NULL
@cSqlId = '
WAWI-70770_TableWorkbenchResourceAddColumnAutoShowProcessParameterValuesInProduction_001'
2025-03-29T22:00:51 DEBUG - Dauer: 3ms, (bis zum Reader)
2025-03-29T22:00:51 DEBUG - Dauer: 3 ms, 1 Zeilen
2025-03-29T22:00:51 DEBUG - SELECT TOP(1)
[tUpdateMigration].[kUpdateMigration] AS [kUpdateMigration],
[tUpdateMigration].[cVersion] AS [cVersion],
[tUpdateMigration].[bHash] AS [bHash],
[tUpdateMigration].[cObjectname] AS [cObjectname],
[tUpdateMigration].[cError] AS [cError],
[tUpdateMigration].[cSqlId] AS [cSqlId]
FROM
[dbo].[tUpdateMigration]
WHERE
(([tUpdateMigration].[cSqlId] = 'WAWI-71142_PpsRefreshCalculatedStock_001'));
2025-03-29T22:00:51 DEBUG - Dauer: 1ms, (bis zum Reader)
2025-03-29T22:00:51 DEBUG - Dauer: 2 ms, 0 Zeilen
2025-03-29T22:00:51 DEBUG - DECLARE @BillOfMaterials pps.TYPE_spCalculateAvailableProductionStock;
INSERT INTO @BillOfMaterials (kBillOfMaterial) SELECT kBillOfMaterial FROM pps.tBillOfMaterial AS Bom WHERE Bom.nState = 1;
EXEC pps.spCalculateAvailableProductionStock @BillOfMaterials = @BillOfMaterials;
2025-03-29T22:00:51 WARN - Dauer: 204ms, Error: Fehler aufgrund einer Division durch Null.
2025-03-29T22:00:51 DEBUG - DECLARE @Identities TABLE (Id INT NOT NULL);
INSERT INTO [dbo].[tUpdateMigration] ([cVersion], [bHash], [cObjectname], [cError], [cSqlId]) OUTPUT INSERTED.[kUpdateMigration] AS [Id] INTO @Identities VALUES (@cVersion, @bHash, @cObjectname, @cError, @cSqlId);
SELECT [Id] FROM @Identities ORDER BY [Id];
@cVersion = '1.7.14.0'
@bHash = CONVERT(varbinary(max), '39-41-37-45-44-38-30-30-37-41-35-39-39-32-37-42-37-31-46-34-35-32-43-31-39-39-46-34-45-44-45-45', 2)
@cObjectname = 'PlainSql'
@cError = NULL
@cSqlId = 'WAWI-71142_PpsRefreshCalculatedStock_001'
2025-03-29T22:00:51 DEBUG - Dauer: 3ms, (bis zum Reader)
2025-03-29T22:00:51 DEBUG - Dauer: 4 ms, 1 Zeilen
2025-03-29T22:00:51 DEBUG - SELECT [recovery_model_desc] FROM [master].[sys].[databases] WHERE [name] = @name
@name = 'eazybusiness'
2025-03-29T22:00:51 DEBUG - Dauer: 0ms, Result: SIMPLE
2025-03-29T22:00:51 DEBUG - SELECT * FROM tUpdateLog WHERE kUpdateLog > @kUpdateLog
kUpdateLog = 2
2025-03-29T22:00:51 DEBUG - Dauer: 1ms, (bis zum Reader)
2025-03-29T22:00:51 DEBUG - Dauer: 4ms, 0 Zeilen
2025-03-29T22:01:06 DEBUG - SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
2025-03-29T22:01:06 DEBUG - Dauer: 1ms, Result: local
2025-03-29T22:01:34 DEBUG -
MERGE INTO
eazybusiness.dbo.tOptions AS myTarget
USING (VALUES (@Key, @Value)) AS mySource(cKey, cValue)
ON mySource.cKey = myTarget.cKey
WHEN NOT MATCHED BY TARGET THEN
INSERT (cKey, cValue) VALUES (mySource.cKey, mySource.cValue);
SELECT
cValue
FROM
eazybusiness.dbo.tOptions
WHERE
cKey = @Key;
@key = 'WawiSeed'
@value = '00502C5F741F872A'
2025-03-29T22:01:34 DEBUG - Dauer: 19ms, (bis zum Reader)
2025-03-29T22:01:35 DEBUG - Dauer: 25 ms, 1 Zeilen
2025-03-29T22:01:35 DEBUG -
MERGE INTO
eazybusiness.dbo.tOptions AS myTarget
USING (VALUES (@Key, @Value)) AS mySource(cKey, cValue)
ON mySource.cKey = myTarget.cKey
WHEN NOT MATCHED BY TARGET THEN
INSERT (cKey, cValue) VALUES (mySource.cKey, mySource.cValue);
SELECT
cValue
FROM
eazybusiness.dbo.tOptions
WHERE
cKey = @Key;
@key = 'AnonymousWawiSeed'
@value = '3FA8BE8C38B36F42'
2025-03-29T22:01:35 DEBUG - Dauer: 11ms, (bis zum Reader)
2025-03-29T22:01:35 DEBUG - Dauer: 11 ms, 1 Zeilen
Zeitstempel: 2025-03-29T22:01:35
Locale: German (Germany)
Locale: German (Germany)
Version: Der Wert wurde nicht erstellt.
Plattform: Wawi
WawiSeed: 9.2.67871.79601
Prozessname: JTL-Wawi
Physikalischer Speicher: 576225280 / Peak: 712720384
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:51,53125
CPU-Zeit (System): 0:00:05,890625
Page-Size (Sytem): 2444032 / Peak: 769224704
Page-Size: 608219136 / Peak: 769224704
Offene Handles: 2305
Database:
Build: 2502280943 82495ec11c0629664f4b3dda38b60bac08b63ce4
