snake-bikes
Aktives Mitglied
Hallo
beim Update auf die neue Version erhalte ich immer nachfolgenden Fehler.
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: 06:50:05 Fehler in der Version 1.4.25.0 beim Befehl:
==============================================
-- Tabelle: ebay_usermessagequeue
IF EXISTS(
SELECT schemas.name + '.' + tables.name AS [Name],
CASE WHEN uses_ansi_nulls = 0 OR lock_escalation > 0 THEN 1 ELSE 0 END AS [Tabellenfehler],
CASE WHEN ColumnsTable.object_id IS NOT NULL THEN 1 ELSE 0 END AS [Spaltenfehler]
FROM sys.tables
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
LEFT JOIN (SELECT object_id
FROM sys.columns
JOIN sys.systypes ON systypes.xusertype = columns.user_type_id
WHERE columns.is_ansi_padded = 0
AND systypes.name IN ('CHAR', 'VARCHAR', 'BINARY', 'VARBINARY', 'NVARCHAR')
GROUP BY columns.object_id
) AS ColumnsTable ON ColumnsTable.object_id = tables.object_id
WHERE schemas.name = 'dbo' AND tables.name = 'ebay_usermessagequeue' AND (tables.uses_ansi_nulls = 0
OR tables.lock_escalation > 0
OR ColumnsTable.object_id IS NOT NULL)
)
BEGIN
IF OBJECT_ID('dbo.DF_ebay_usermessagequeue_nDel') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[ebay_usermessagequeue] DROP CONSTRAINT [DF_ebay_usermessagequeue_nDel];
END
IF OBJECT_ID('dbo.PK_ebay_usermessagequeue') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[ebay_usermessagequeue] DROP CONSTRAINT [PK_ebay_usermessagequeue];
END
EXEC sp_rename 'dbo.ebay_usermessagequeue', 'ebay_usermessagequeue_jtlbck';
CREATE TABLE [dbo].[ebay_usermessagequeue] (
kEbayDataUserOutputQueue INT NOT NULL,
cMessageType VARCHAR(255),
cMessage VARCHAR(MAX),
dErstellt VARCHAR(255),
nDel INT CONSTRAINT [DF_ebay_usermessagequeue_nDel] DEFAULT ((0)),
kEbayUser INT,
CONSTRAINT [PK_ebay_usermessagequeue] PRIMARY KEY CLUSTERED (kEbayDataUserOutputQueue ASC),
);
INSERT INTO [dbo].[ebay_usermessagequeue] (
[kEbayDataUserOutputQueue]
,[cMessageType]
,[cMessage]
,[dErstellt]
,[nDel]
,[kEbayUser]
)
SELECT
ISNULL([kEbayDataUserOutputQueue], 0)
,[cMessageType]
,[cMessage]
,[dErstellt]
,[nDel]
,[kEbayUser]
FROM
[dbo].[ebay_usermessagequeue_jtlbck];
DROP TABLE [dbo].[ebay_usermessagequeue_jtlbck];
END
==============================================
Message: Arithmetischer Überlauffehler beim Konvertieren von expression in den int-Datentyp.
LineNumber: 44
Procedure:
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftWertPict
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tFormularEMailVorlageAnhang
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tKategorieShop
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tArtikelEinkaufsliste
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.teigenschaft
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tUserControlSetting
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEinheit
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.teigenschaftwert
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tFormularAnhangDaten
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tArtikelSperre
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.ebay_planung
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tRueckhalteGrund
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tStampit
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftWertSprache
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tWaehrungISO
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tfirma
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tArtikelMerkmal
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftSprache
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tMerkmal
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftKombiWert
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEinheitSprache
2019-07-29T06:50:05 DEBUG - SELECT * FROM [tOptions]
2019-07-29T06:50:05 DEBUG - Dauer: 1 ms, 123 Zeilen
2019-07-29T06:51:02 DEBUG - SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
2019-07-29T06:51:02 DEBUG - Dauer: 0ms, Result: local
Zeitstempel: 2019-07-29T06:51:26
Locale: German (Germany)
Locale: German (Germany)
Version: 1.4.32.0
Plattform: Wawi
WawiSeed: 1.5.70782.53001
Versionshash: 81D687CD
Prozessname: JTL-Wawi
Physikalischer Speicher: 450781184 / Peak: 596602880
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:03:41,109375
CPU-Zeit (System): 0:00:17,953125
Page-Size (Sytem): 2069560 / Peak: 590716928
Page-Size: 383320064 / Peak: 590716928
Offene Handles: 1367
Database:
Build: 1907161758 8ab7bfabf43a63549bcfbf7e522fececab6467b9
beim Update auf die neue Version erhalte ich immer nachfolgenden Fehler.
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: 06:50:05 Fehler in der Version 1.4.25.0 beim Befehl:
==============================================
-- Tabelle: ebay_usermessagequeue
IF EXISTS(
SELECT schemas.name + '.' + tables.name AS [Name],
CASE WHEN uses_ansi_nulls = 0 OR lock_escalation > 0 THEN 1 ELSE 0 END AS [Tabellenfehler],
CASE WHEN ColumnsTable.object_id IS NOT NULL THEN 1 ELSE 0 END AS [Spaltenfehler]
FROM sys.tables
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
LEFT JOIN (SELECT object_id
FROM sys.columns
JOIN sys.systypes ON systypes.xusertype = columns.user_type_id
WHERE columns.is_ansi_padded = 0
AND systypes.name IN ('CHAR', 'VARCHAR', 'BINARY', 'VARBINARY', 'NVARCHAR')
GROUP BY columns.object_id
) AS ColumnsTable ON ColumnsTable.object_id = tables.object_id
WHERE schemas.name = 'dbo' AND tables.name = 'ebay_usermessagequeue' AND (tables.uses_ansi_nulls = 0
OR tables.lock_escalation > 0
OR ColumnsTable.object_id IS NOT NULL)
)
BEGIN
IF OBJECT_ID('dbo.DF_ebay_usermessagequeue_nDel') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[ebay_usermessagequeue] DROP CONSTRAINT [DF_ebay_usermessagequeue_nDel];
END
IF OBJECT_ID('dbo.PK_ebay_usermessagequeue') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[ebay_usermessagequeue] DROP CONSTRAINT [PK_ebay_usermessagequeue];
END
EXEC sp_rename 'dbo.ebay_usermessagequeue', 'ebay_usermessagequeue_jtlbck';
CREATE TABLE [dbo].[ebay_usermessagequeue] (
kEbayDataUserOutputQueue INT NOT NULL,
cMessageType VARCHAR(255),
cMessage VARCHAR(MAX),
dErstellt VARCHAR(255),
nDel INT CONSTRAINT [DF_ebay_usermessagequeue_nDel] DEFAULT ((0)),
kEbayUser INT,
CONSTRAINT [PK_ebay_usermessagequeue] PRIMARY KEY CLUSTERED (kEbayDataUserOutputQueue ASC),
);
INSERT INTO [dbo].[ebay_usermessagequeue] (
[kEbayDataUserOutputQueue]
,[cMessageType]
,[cMessage]
,[dErstellt]
,[nDel]
,[kEbayUser]
)
SELECT
ISNULL([kEbayDataUserOutputQueue], 0)
,[cMessageType]
,[cMessage]
,[dErstellt]
,[nDel]
,[kEbayUser]
FROM
[dbo].[ebay_usermessagequeue_jtlbck];
DROP TABLE [dbo].[ebay_usermessagequeue_jtlbck];
END
==============================================
Message: Arithmetischer Überlauffehler beim Konvertieren von expression in den int-Datentyp.
LineNumber: 44
Procedure:
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftWertPict
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tFormularEMailVorlageAnhang
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tKategorieShop
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tArtikelEinkaufsliste
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.teigenschaft
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tUserControlSetting
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEinheit
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.teigenschaftwert
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tFormularAnhangDaten
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tArtikelSperre
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.ebay_planung
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tRueckhalteGrund
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tStampit
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftWertSprache
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tWaehrungISO
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tfirma
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tArtikelMerkmal
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftSprache
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tMerkmal
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEigenschaftKombiWert
2019-07-29T06:50:05 DEBUG - [TableCache] Invalidate: eazybusiness.dbo.tEinheitSprache
2019-07-29T06:50:05 DEBUG - SELECT * FROM [tOptions]
2019-07-29T06:50:05 DEBUG - Dauer: 1 ms, 123 Zeilen
2019-07-29T06:51:02 DEBUG - SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
2019-07-29T06:51:02 DEBUG - Dauer: 0ms, Result: local
Zeitstempel: 2019-07-29T06:51:26
Locale: German (Germany)
Locale: German (Germany)
Version: 1.4.32.0
Plattform: Wawi
WawiSeed: 1.5.70782.53001
Versionshash: 81D687CD
Prozessname: JTL-Wawi
Physikalischer Speicher: 450781184 / Peak: 596602880
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:03:41,109375
CPU-Zeit (System): 0:00:17,953125
Page-Size (Sytem): 2069560 / Peak: 590716928
Page-Size: 383320064 / Peak: 590716928
Offene Handles: 1367
Database:
Build: 1907161758 8ab7bfabf43a63549bcfbf7e522fececab6467b9