Hallo nochmals...
da es scheinbar ein zu allgemeines Problem ist, und niemand eine Idee hat, poste ich mal den kompletten Fehlerlog. Ich würde sehr gerne 1.6... testen, nur eben nicht auf dem "normalen" System. Kann mir Jemand sagen, ob es sich um einen Datenbankfehler handelt (und wie ich den evtl lösen könnte) oder ob mein Laptop doch evtl nicht geeignet ist? (Lenovo Yoga 370, 8GB Arbeitsspeicher, Win 10)?
Ich würde mich sehr freuen, wenn Jemand einen Hinweis geben könnte und bedanke mich schon mal..
Lutz
Unbehandelte Ausnahme #959190594F6282F vom Typ System.Exception in
System.Exception: 03:17:24 Fehler in der Version 1.6.0.0 beim Befehl:
==============================================IF(EXISTS(SELECT * FROM TableDiff
WHERE cTableName = 'tBild'
AND (cHasTableDiff = 1
OR cHasColumnDiff = 1)
))
BEGIN
DECLARE @TableExists BIT = 0;
DECLARE @sql NVARCHAR(MAX) = '1';
IF COL_LENGTH('dbo.tBild', 'idBild') IS NOT NULL
BEGIN
SELECT @TableExists = CASE WHEN tables.name IS NOT NULL THEN 1 ELSE 0 END
FROM sys.tables
WHERE tables.name = 'tBild';
IF(@TableExists = 1)
BEGIN
WHILE(@sql IS NOT NULL)
BEGIN
SELECT @sql = 'ALTER TABLE ' + Result.SchemaName + '.' + Result.RealTableName + ' DROP CONSTRAINT [' + Result.name + '];'
FROM(
SELECT foreign_keys.name, tables.name AS TableName, schemas.name AS SchemaName, 1 AS OrderId, RealTable.name AS RealTableName
FROM sys.foreign_keys
JOIN sys.tables ON foreign_keys.referenced_object_id = tables.object_id
JOIN sys.tables AS RealTable ON foreign_keys.parent_object_id = RealTable.object_id
JOIN sys.schemas ON schemas.schema_id = RealTable.schema_id
UNION
SELECT check_constraints.name, tables.name AS TableName, schemas.name AS SchemaName, 2 AS OrderId, tables.name AS RealTableName
FROM sys.check_constraints
JOIN sys.tables ON tables.object_id = check_constraints.parent_object_id
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
UNION
SELECT default_constraints.name, tables.name AS TableName, schemas.name AS SchemaName, 2 AS OrderId, tables.name AS RealTableName
FROM sys.default_constraints
JOIN sys.tables ON tables.object_id = default_constraints.parent_object_id
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
UNION
SELECT key_constraints.name, tables.name AS TableName, schemas.name AS SchemaName, 2 AS OrderId, tables.name AS RealTableName
FROM sys.key_constraints
JOIN sys.tables ON tables.object_id = key_constraints.parent_object_id
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
WHERE key_constraints.name NOT LIKE 'UQ__tBild__%'
) AS Result
WHERE Result.TableName = 'tBild'
ORDER BY OrderId DESC;
IF(@sql <> '1')
BEGIN
EXEC sp_executesql @sql;
SET @sql = '1';
END
ELSE
BEGIN
SET @sql = NULL;
END
END
EXEC sp_rename 'dbo.tBild', 'tBild_temp';
-- Add Missing Columns
IF(COL_LENGTH('dbo.tBild_temp', 'kBild') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [kBild] [INT] NOT NULL IDENTITY(1, 1);
END
IF(COL_LENGTH('dbo.tBild_temp', 'cQuelle') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [cQuelle] [NVARCHAR] (500) NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'bBild') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [bBild] [VARBINARY(MAX)] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'nDateigroesse') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nDateigroesse] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nBreite') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nBreite] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nHoehe') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nHoehe] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'cHash') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [cHash] [NVARCHAR] (510) NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'cChecksum') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [cChecksum] [NVARCHAR] (510) NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'bVorschauBild') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [bVorschauBild] [VARBINARY(MAX)] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'nVorschauDateigroesse') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nVorschauDateigroesse] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nVorschauBreite') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nVorschauBreite] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nVorschauHoehe') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nVorschauHoehe] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'dErstellt') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [dErstellt] [DATETIME] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'dAenderung') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [dAenderung] [DATETIME] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'idBild') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [idBild] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE DEFAULT NEWID();
END
IF(COL_LENGTH('dbo.tBild_temp', 'bRowversion') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [bRowversion] [TIMESTAMP] NOT NULL;
END
END
CREATE TABLE [dbo].[tBild]
(
[kBild][int] IDENTITY(1, 1) NOT NULL,
[cQuelle][varchar](500) NOT NULL,
[bBild] VARBINARY(MAX) FILESTREAM NOT NULL,
[nDateigroesse][int] NOT NULL,
[nBreite][int] NOT NULL,
[nHoehe][int] NOT NULL,
[cHash][varchar](255) NOT NULL,
[cChecksum][varchar](255) NOT NULL,
[bVorschauBild] VARBINARY(MAX) FILESTREAM NOT NULL,
[nVorschauDateigroesse][int] NOT NULL,
[nVorschauBreite][int] NOT NULL,
[nVorschauHoehe][int] NOT NULL,
[dErstellt][datetime] NOT NULL,
[dAenderung][datetime] NOT NULL,
[idBild] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE DEFAULT NEWID(),
[bRowversion] [timestamp] NOT NULL,
CONSTRAINT PK_tBild PRIMARY KEY CLUSTERED([kBild] ASC)
) filestream_on fsgroup
SET IDENTITY_INSERT dbo.tBild ON;
IF(@TableExists = 1)
BEGIN
INSERT INTO dbo.tBild
(
kBild,
cQuelle,
bBild,
nDateigroesse,
nBreite,
nHoehe,
cHash,
cChecksum,
bVorschauBild,
nVorschauDateigroesse,
nVorschauBreite,
nVorschauHoehe,
dErstellt,
dAenderung,
idBild
)
SELECT
kBild,
LEFT(ISNULL(cQuelle, '') , 500),
ISNULL(bBild, 0) ,
ISNULL(nDateigroesse, '0') ,
ISNULL(nBreite, '0') ,
ISNULL(nHoehe, '0') ,
LEFT(ISNULL(cHash, '') , 510),
LEFT(ISNULL(cChecksum, '') , 510),
ISNULL(bVorschauBild, 0) ,
ISNULL(nVorschauDateigroesse, '0') ,
ISNULL(nVorschauBreite, '0') ,
ISNULL(nVorschauHoehe, '0') ,
ISNULL(dErstellt, '0') ,
ISNULL(dAenderung, '0'),
idBild
FROM dbo.tBild_temp;
DROP TABLE dbo.tBild_temp;
END
END
ELSE
BEGIN
SELECT @TableExists = CASE WHEN tables.name IS NOT NULL THEN 1 ELSE 0 END
FROM sys.tables
WHERE tables.name = 'tBild';
IF(@TableExists = 1)
BEGIN
WHILE(@sql IS NOT NULL)
BEGIN
SELECT @sql = 'ALTER TABLE ' + Result.SchemaName + '.' + Result.RealTableName + ' DROP CONSTRAINT [' + Result.name + '];'
FROM(
SELECT foreign_keys.name, tables.name AS TableName, schemas.name AS SchemaName, 1 AS OrderId, RealTable.name AS RealTableName
FROM sys.foreign_keys
JOIN sys.tables ON foreign_keys.referenced_object_id = tables.object_id
JOIN sys.tables AS RealTable ON foreign_keys.parent_object_id = RealTable.object_id
JOIN sys.schemas ON schemas.schema_id = RealTable.schema_id
UNION
SELECT check_constraints.name, tables.name AS TableName, schemas.name AS SchemaName, 2 AS OrderId, tables.name AS RealTableName
FROM sys.check_constraints
JOIN sys.tables ON tables.object_id = check_constraints.parent_object_id
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
UNION
SELECT default_constraints.name, tables.name AS TableName, schemas.name AS SchemaName, 2 AS OrderId, tables.name AS RealTableName
FROM sys.default_constraints
JOIN sys.tables ON tables.object_id = default_constraints.parent_object_id
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
UNION
SELECT key_constraints.name, tables.name AS TableName, schemas.name AS SchemaName, 2 AS OrderId, tables.name AS RealTableName
FROM sys.key_constraints
JOIN sys.tables ON tables.object_id = key_constraints.parent_object_id
JOIN sys.schemas ON schemas.schema_id = tables.schema_id
) AS Result
WHERE Result.TableName = 'tBild'
ORDER BY OrderId DESC;
IF(@sql <> '1')
BEGIN
EXEC sp_executesql @sql;
SET @sql = '1';
END
ELSE
BEGIN
SET @sql = NULL;
END
END
EXEC sp_rename 'dbo.tBild', 'tBild_temp';
-- Add Missing Columns
IF(COL_LENGTH('dbo.tBild_temp', 'kBild') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [kBild] [INT] NOT NULL IDENTITY(1, 1);
END
IF(COL_LENGTH('dbo.tBild_temp', 'cQuelle') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [cQuelle] [NVARCHAR] (4000) NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'bBild') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [bBild] [IMAGE] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'nDateigroesse') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nDateigroesse] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nBreite') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nBreite] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nHoehe') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nHoehe] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'cHash') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [cHash] [NVARCHAR] (510) NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'cChecksum') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [cChecksum] [NVARCHAR] (510) NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'bVorschauBild') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [bVorschauBild] [IMAGE] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'nVorschauDateigroesse') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nVorschauDateigroesse] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nVorschauBreite') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nVorschauBreite] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'nVorschauHoehe') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [nVorschauHoehe] [INT] NOT NULL DEFAULT (0);
END
IF(COL_LENGTH('dbo.tBild_temp', 'dErstellt') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [dErstellt] [DATETIME] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'dAenderung') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [dAenderung] [DATETIME] NOT NULL DEFAULT('');
END
IF(COL_LENGTH('dbo.tBild_temp', 'bRowversion') IS NULL)
BEGIN
ALTER TABLE dbo.tBild_temp ADD [bRowversion] [TIMESTAMP] NOT NULL;
END
END
CREATE TABLE [dbo].[tBild]
(
[kBild] [INT] NOT NULL IDENTITY(1, 1),
[cQuelle] [NVARCHAR] (2000) NOT NULL,
[bBild] [IMAGE] NOT NULL,
[nDateigroesse] [INT] NOT NULL,
[nBreite] [INT] NOT NULL,
[nHoehe] [INT] NOT NULL,
[cHash] [NVARCHAR] (255) NOT NULL,
[cChecksum] [NVARCHAR] (255) NOT NULL,
[bVorschauBild] [IMAGE] NOT NULL,
[nVorschauDateigroesse] [INT] NOT NULL,
[nVorschauBreite] [INT] NOT NULL,
[nVorschauHoehe] [INT] NOT NULL,
[dErstellt] [DATETIME] NOT NULL,
[dAenderung] [DATETIME] NOT NULL,
[bRowversion] [TIMESTAMP] NOT NULL,
CONSTRAINT PK_dbo_tBild PRIMARY KEY( kBild),
);
CREATE NONCLUSTERED INDEX IX_tBild_cHash ON dbo.tBild( cHash);
SET IDENTITY_INSERT dbo.tBild ON;
IF(@TableExists = 1)
BEGIN
INSERT INTO dbo.tBild
(
kBild,
cQuelle,
bBild,
nDateigroesse,
nBreite,
nHoehe,
cHash,
cChecksum,
bVorschauBild,
nVorschauDateigroesse,
nVorschauBreite,
nVorschauHoehe,
dErstellt,
dAenderung
)
SELECT
kBild,
LEFT(ISNULL(cQuelle, '') , 4000),
ISNULL(bBild, '0') ,
ISNULL(nDateigroesse, '0') ,
ISNULL(nBreite, '0') ,
ISNULL(nHoehe, '0') ,
LEFT(ISNULL(cHash, '') , 510),
LEFT(ISNULL(cChecksum, '') , 510),
ISNULL(bVorschauBild, '0') ,
ISNULL(nVorschauDateigroesse, '0') ,
ISNULL(nVorschauBreite, '0') ,
ISNULL(nVorschauHoehe, '0') ,
ISNULL(dErstellt, '0') ,
ISNULL(dAenderung, '0')
FROM dbo.tBild_temp;
DROP TABLE dbo.tBild_temp;
END
END
END==============================================
FEHLER:
Speicherplatz für das "dbo.tBild".'PK_dbo_tBild'-Objekt in der JTL_SIM_eazybusiness-Datenbank konnte nicht belegt werden, da die Dateigruppe "PRIMARY" voll ist. Speicherplatz kann durch Löschen nicht benötigter Dateien, Löschen von Objekten in der Dateigruppe, Hinzufügen von Dateien zur Dateigruppe oder Festlegen der automatischen Vergrößerung für vorhandene Dateien in der Dateigruppe gewonnen werden.
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.tXMLImportvorlage
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.tFirmaAufbewahrungsfrist
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.ebay_coposeigenschaft
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.pf_amazon_apa_usersettings
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.ebay_user
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.Rechnung.tRechnungPositionEckdaten
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.tBild
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.tWarenLagerPlatz
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.Artikel.tArtikelVerkaufskanalFeldWert
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.tStueckliste
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.tRechnungBackup
2021-11-08T15:17:24 DEBUG - [TableCache] Invalidate: JTL_SIM_eazybusiness.dbo.ameise_exporttyp
2021-11-08T15:17:24 DEBUG - SELECT * FROM [tOptions]
2021-11-08T15:17:24 DEBUG - Dauer: 1ms, (bis zum Reader)
2021-11-08T15:17:24 DEBUG - Dauer: 1ms, 73 Zeilen
2021-11-08T15:17:30 DEBUG - Neue Verbindungsparameter: Data Source=TP-YOGA370LUTZ\JTLWAWI;Initial Catalog=eazybusiness;Integrated Security=False;Persist Security Info=True;User ID=sa;Password=;MultipleActiveResultSets=True;Connect Timeout=5;Application Name="1 - Administrator
JTL-Wawi C#";Current Language=German
2021-11-08T15:17:30 DEBUG - [TableCache] Invalidate: Full
Cache
2021-11-08T15:17:30 DEBUG - [TableTable] Eintrag TableCache.tOptions entfernt - Removed
2021-11-08T15:17:30 DEBUG - SELECT * FROM [tOptions]
2021-11-08T15:17:30 DEBUG - Dauer: 1ms, (bis zum Reader)
2021-11-08T15:17:30 DEBUG - Dauer: 2ms, 73 Zeilen
2021-11-08T15:17:30 DEBUG - SELECT (CASE WHEN SERVERPROPERTY('MACHINENAME') = HOST_NAME() THEN 'local' ELSE 'remote' END) AS instance
2021-11-08T15:17:30 DEBUG - Dauer: 0ms, Result: local
2021-11-08T15:17:31 DEBUG -
USE [master];
ALTER DATABASE JTL_SIM_eazybusiness SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE JTL_SIM_eazybusiness;
2021-11-08T15:17:34 DEBUG - Dauer: 3168ms
Zeitstempel: 2021-11-08T15:18:01
Locale: German (Germany)
Locale: German (Germany)
Version: 1.6.31.2
Plattform: Wawi
WawiSeed: 2.1.02021.9601
Prozessname: JTL-Wawi
Physikalischer Speicher: 569573376 / Peak: 658464768
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:54,484375
CPU-Zeit (System): 0:00:10,6875
Page-Size (Sytem): 2249264 / Peak: 751038464
Page-Size: 636448768 / Peak: 751038464
Offene Handles: 1635
Database:
Build: 2110191414 7e3e2d561de2af3c69287f28a7b39ec2de07b093