Hallo zusammen erhalte folgenden Fehler beim Update der DB, musste bisschen kürzen die INSERT INSERT [dbo].[pf_amazon_group] sind alle fehlerhaft
Code:
Unbehandelte Ausnahme #73788303BAE06D51 vom Typ System.Data.SqlClient.SqlException in Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
System.Data.SqlClient.SqlException (0x80131904): Fehler beim Konvertieren des varchar-Datentyps in numeric.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei jtlDatabase.DB.DvWq8fgxCQ[T](SqlConnection , Func`1 func)
bei jtlDatabase.DB.executeLongRunningCommandSQL(String cSqlCommand)
bei jtlCore.Classes.Update.SqlUpdater.<>c__DisplayClass2.<UpdateToVersion>b__0()
bei jtlCore.Classes.Update.SqlUpdater.IZF5gb9c9oVFg8y588.OFczHHLpbh(Action , Int32 , String )
bei jtlCore.Classes.Update.SqlUpdater.ALszZ3gvHW(IList`1 sqlCommands, String , TaskProgress )
ClientConnectionId:dbd08d43-6577-47ac-958e-b736211a2d7f
Fehlernummer (Error Number):8114,Status (State):5,Klasse (Class):16
SQL-Fehlerinformationen: [WAWISERVER-PC\JTLWAWI .Net SqlClient Data Provider] Fehler #8114 (Klasse 16) in Zeile 1: Fehler beim Konvertieren des varchar-Datentyps in numeric.
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 11.00.6020
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 8114
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
CommandText = INSERT INTO tShipperAccount ( nVersanddienstleister,nAddressSourceType,cEkp,cInternationalEkp,cBankname,cBankaccountOwner,ciban,cbic,ccodFee,cDisplayName,cPassword,cUserName)
select
nVersanddienstleister,
0 AS nAddressSourceType,
ekp.cValue AS cEkp,
ekp.cValue AS cInternationalEkp,
bankname.cValue AS cBankName,
bankaccount.cvalue AS cBankAccountOwner,
iban.cValue AS cIban,
bic.cValue AS cBic,
codfee.cValue AS cCodFee,
CASE WHEN nVersanddienstleister = 0 THEN 'DHL Versenden'
WHEN nVersanddienstleister = 1 THEN 'DHL Express'
WHEN nVersanddienstleister = 2 THEN 'DPD'
WHEN nVersanddienstleister = 3 THEN 'Hermes'
ELSE 'eFiliale'
END
+ CASE WHEN COUNT(nVersanddienstleister) OVER (PARTITION BY nVersanddienstleister) > 1 THEN ' #' + CONVERT(varchar(50), CASE WHEN COUNT(nVersanddienstleister) OVER (PARTITION BY nVersanddienstleister) > 1 THEN ROW_NUMBER() OVER (ORDER BY nVersanddienstleister) ELSE 0 END) ELSE '' END
as cDisplayName,
passwort.cValue as cPassword,
Nutzer.cValue AS cUserName
from tVersandart
LEFT JOIN tVersandschnittstellenKonfiguration passwort ON passwort.kVersandArt = tVersandart.kVersandArt AND passwort.cKey = 'Password'
LEFT JOIN tVersandschnittstellenKonfiguration Nutzer ON Nutzer.kVersandArt = tVersandart.kVersandArt AND Nutzer.cKey = 'User'
LEFT JOIN tVersandschnittstellenKonfiguration ekp ON ekp.kVersandArt = tVersandart.kVersandArt AND ekp.cKey = 'Abrechnungsnummer'
LEFT JOIN tVersandschnittstellenKonfiguration bankname ON bankname.kVersandArt = tVersandart.kVersandArt AND bankname.cKey = 'BankName'
LEFT JOIN tVersandschnittstellenKonfiguration bankaccount ON bankaccount.kVersandArt = tVersandart.kVersandArt AND bankaccount.cKey = 'BankAccountOwner'
LEFT JOIN tVersandschnittstellenKonfiguration iban ON iban.kVersandArt = tVersandart.kVersandArt AND iban.cKey = 'Iban'
LEFT JOIN tVersandschnittstellenKonfiguration bic ON bic.kVersandArt = tVersandart.kVersandArt AND bic.cKey = 'Bic'
LEFT JOIN tVersandschnittstellenKonfiguration codfee ON codfee.kVersandArt = tVersandart.kVersandArt AND codfee.cKey = 'CodFee'
WHERE tVersandart.nVersandSchnittstelle = 2
AND passwort.cValue IS NOT NULL
AND Nutzer.cValue IS NOT NULL
GROUP BY nVersanddienstleister,ekp.cValue,bankname.cValue,bankaccount.cvalue,iban.cValue,bic.cValue,codfee.cValue,passwort.cValue,Nutzer.cValue;
LineNr = 1
Codefragment = INSERT INTO tShipperAccount ( nVersanddienstleister,nAddressSourceType,cEkp,cInternationalEkp,cBankname,cBankaccountOwner,ciban,cbic,ccodFee,cDisplayName,cPassword,cUserName)
Connection-String = DataSource=WAWISERVER-PC\JTLWAWI, InitialCatalog=eazybusiness, UserID=sa
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 0ms
2016-01-19T09:55:51 DEBUG - [SQL] UPDATE ameise_importtypfeld SET cDBTyp = 'real' WHERE kImportTypFeld = 359
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 1ms
2016-01-19T09:55:51 DEBUG - [SQL] UPDATE ameise_importtypeinstellung SET cName = 'Vk Brutto Preise bis 10 € glätten zu' WHERE kImportTypEinstellung = 21
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 26ms
2016-01-19T09:55:51 DEBUG - [SQL] UPDATE ameise_importtypeinstellung SET cName = 'Vk Brutto Preise zwischen 10-100 € glätten zu' WHERE kImportTypEinstellung = 22
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 0ms
2016-01-19T09:55:51 DEBUG - [SQL] UPDATE ameise_importtypeinstellung SET cName = 'Vk Brutto Preise zwischen 100-1000 € glätten zu' WHERE kImportTypEinstellung = 23
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 0ms
2016-01-19T09:55:51 DEBUG - [SQL] UPDATE ameise_importtypeinstellung SET cName = 'Vk Brutto Preise zwischen 1000-10000 € glätten zu' WHERE kImportTypEinstellung = 24
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 0ms
2016-01-19T09:55:51 DEBUG - [SQL] TRUNCATE TABLE [pf_amazon_group]
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 11ms
2016-01-19T09:55:51 DEBUG - [SQL] SET IDENTITY_INSERT [dbo].[pf_amazon_group] ON
INSERT [dbo].[pf_amazon_group] ([kGroup], [cName], [kPlattform], [nAktiv]) VALUES (1, N'Autoteile', 51, 1)
INSERT [dbo].[pf_amazon_group] ([kGroup], [cName], [kPlattform], [nAktiv]) VALUES (2, N'Autozubehör', 51, 1)
SET IDENTITY_INSERT [dbo].[pf_amazon_group] OFF
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 121ms
2016-01-19T09:55:51 DEBUG - [SQL] UPDATE ameise_importtypfeld SET cName = 'Menge pro VPE' WHERE kImportTypFeld = 545
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 2ms
2016-01-19T09:55:51 DEBUG - [SQL] INSERT INTO ameise_importtypfeld values(776,5,'Verpackungseinheit zurücksetzen','tliefartikel','hlpVerpackungseinheitZurücksetzen','char',1,0,'','bool',40195);
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 0ms
2016-01-19T09:55:51 DEBUG - [SQL] UPDATE ebay_item SET cRelistID='' WHERE Type='G' OR Type='V';
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 30ms
2016-01-19T09:55:51 DEBUG - [SQL] DECLARE @xArtikelReserviert_pn XML;
SET @xArtikelReserviert_pn = (
SELECT kArtikel FROM dbo.tlagerbestand
WHERE fZulauf < 0
FOR XML PATH('Artikel'), TYPE
);
EXEC dbo.spUpdateLagerbestand @xArtikelReserviert_pn;
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 34ms
2016-01-19T09:55:51 DEBUG - [SQL] ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyWarehouse INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyUnsellable INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyReserved INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyTotal INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyInboundWorking INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyInboundShipped INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyReceiving INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN nQtyReceiving INT NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN fVolume DECIMAL(28, 15) NULL;
ALTER TABLE dbo.pf_amazon_angebot_fba ALTER COLUMN cFNSKU VARCHAR(50) NULL;
2016-01-19T09:55:51 DEBUG - [SQL] Dauer: 24ms
Zeitstempel: 2016-01-19T09:56:01
Locale: German (Germany)
Locale: German (Germany)
Version: 1.0.8.0
Plattform: Wawi
Versionshash: F3689073
Prozessname: System.Diagnostics.Process (JTL-wawi)
Physikalischer Speicher: 155160576 / Peak: 286912512
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:07,1448458
CPU-Zeit (System): 0:00:01,092007
Page-Size (Sytem): 943688 / Peak: 235307008
Page-Size: 102805504 / Peak: 235307008
Offene Handles: 760
