Inaktiv JTL Shipping / JTL 1.1.4.7

[DanielH.]

Hallo, habe folgendes Problem, wenn ich beim JTL Shipping die DPD Cloud einrichten möchte zeigt er mir jedesmal beim Speichen ein Fehler.

Ungültiger Spaltenname 'CRetourenEKP'

Fehlerprotokoll:

Unbehandelte Ausnahme #6C5DBE6695DA2599 vom Typ System.Data.SqlClient.SqlException in Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Spaltenname 'cRetourenEkp'.
   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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   bei jtlDatabase.DB.DBxz7foSdf[T](SqlConnection , Func`1 func)
   bei jtlDatabase.DB.executeNonQuery(SqlCommand oSqlCommand)
   bei jtlDatabase.jtlObjectRepository.Update(jtlObject item)
   bei jtlDatabase.jtlObject.updateInDB()
   bei jtlDatabase.jtlObject.Save()
   bei jtlCore.Forms.Einstellungen.VersandZahlung.JTLShipping.ShipperManagement.ViewModel.ShipperAccountManagementFormViewModel.Save()
   bei jtlCore.Forms.Einstellungen.VersandZahlung.JTLShipping.ShipperManagement.ShipperAccountManagementController.ShowDialog(IShipperAccountRepository shipperAccountRepository, ICompanySelector companySelector, ICountryRepository countryRepository)
   bei JTLwawi.CJTLwawi.JTL_Shipping_Benutzerkontenverwaltung(String SRV, String DBN, String DBU, String DBP, Int32 kBenutzer)
ClientConnectionId:344d8ef2-e020-44bd-8f52-d62359d469e1
Fehlernummer (Error Number):207,Status (State):1,Klasse (Class):16
SQL-Fehlerinformationen: [JTL\JTL .Net SqlClient Data Provider] Fehler #207 (Klasse 16) in Zeile 1: Ungültiger Spaltenname 'cRetourenEkp'. 
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 11.00.6020
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 207
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
CommandText = UPDATE [tShipperAccount] SET cSalutation=@cSalutation, cTitle=@cTitle, cCompany=@cCompany, cCompanyAdd=@cCompanyAdd, cFirstname=@cFirstname, cLastname=@cLastname, cStreetname=@cStreetname, cStreetnumber=@cStreetnumber, cAddressadd=@cAddressadd, cMobil=@cMobil, cMail=@cMail, cZipCode=@cZipCode, cCity=@cCity, cCountry=@cCountry, cCountryIso=@cCountryIso, cPhone=@cPhone, cBankAccountOwner=@cBankAccountOwner, cBankName=@cBankName, cBic=@cBic, cIban=@cIban, cRetourenEkp=@cRetourenEkp WHERE 1=1 AND kShipperAccount=@kShipperAccount;
Parameter @cSalutation =
Parameter @cTitle =
Parameter @cCompany =
Parameter @cCompanyAdd =
Parameter @cFirstname =
Parameter @cLastname =
Parameter @cStreetname =
Parameter @cStreetnumber =
Parameter @cAddressadd =
Parameter @cMobil =
Parameter @cMail =
Parameter @cZipCode =
Parameter @cCity =
Parameter @cCountry =
Parameter @cCountryIso =
Parameter @cPhone =
Parameter @cBankAccountOwner =
Parameter @cBankName =
Parameter @cBic =
Parameter @cIban =
Parameter @cRetourenEkp =
Parameter @kShipperAccount = 7
LineNr = 1
Codefragment = UPDATE [tShipperAccount] SET cSalutation=@cSalutation, cTitle=@cTitle, cCompany=@cCompany, cCompanyAdd=@cCompanyAdd, cFirstname=@cFirstname, cLastname=@cLastname, cStreetname=@cStreetname, cStreetnumber=@cStreetnumber, cAddressadd=@cAddressadd, cMobil=@cMobil, cMail=@cMail, cZipCode=@cZipCode, cCity=@cCity, cCountry=@cCountry, cCountryIso=@cCountryIso, cPhone=@cPhone, cBankAccountOwner=@cBankAccountOwner, cBankName=@cBankName, cBic=@cBic, cIban=@cIban, cRetourenEkp=@cRetourenEkp WHERE 1=1 AND kShipperAccount=@kShipperAccount;
Connection-String = DataSource=JTL\JTL, InitialCatalog=Mandant_1, UserID=sa

Schon mal vielen dank im voraus
LG
Daniel

 

[DanielH.]

Teil 2 der Fehler meldung

2016-10-19T22:49:35 DEBUG - [SQL] SELECT * FROM [pf_user]
2016-10-19T22:49:35 DEBUG - [SQL] Dauer: 95ms
2016-10-19T22:50:24 DEBUG - [SQL] UPDATE [tversandart] SET cAuftragsText=@cAuftragsText, cDruckText=@cDruckText, cZahlungsInfo=@cZahlungsInfo, cTrackingIDRegex=@cTrackingIDRegex, nEtikettenDrucken=@nEtikettenDrucken, nEtikettenStartRueckfrage=@nEtikettenStartRueckfrage WHERE 1=1 AND kVersandArt=@kVersandArt;
      @cAuftragsText = '',
      @cDruckText = '',
      @cZahlungsInfo = '',
      @cTrackingIDRegex = '',
      @nEtikettenDrucken = 1,
      @nEtikettenStartRueckfrage = 1,
      @kVersandArt = 33
2016-10-19T22:50:24 DEBUG - [SQL] Dauer: 112ms
2016-10-19T22:50:24 DEBUG - [TableTable] Invalidate: [tversandart]
2016-10-19T22:50:24 DEBUG - [SQL] SELECT COUNT(*) FROM
                                                (
                                                SELECT TOP 100 PERCENT tVersandart.kVersandArt, tVersandart.cAktiv, tversandart.cName, tversandart.fPrice, tversandart.cZahlungsInfo, tVersandart.nPrioritaet, tVersandart.nVerwiegePflicht, tVersandart.nVersandMailSenden, tVersandart.cAmazonCarrierCode, tVersandart.cEbayCarrierCode, tVersandart.nVersandSchnittstelle, tVersanddatenExportVorlage.cName as ExportVorlageName, tVersanddatenImportVorlage.cName as ImportVorlageName, tVersandart.cTrackingUrlTemplate, tVersandart.nTrackingIDEingabePflicht,tVersandart.cAktiv as color1
FROM tVersandart
LEFT JOIN tVersandartSprache ON tVersandart.kVersandArt = tVersandartSprache.kVersandArt
LEFT JOIN tVersanddatenExportVorlage ON tVersanddatenExportVorlage.kVersanddatenExportVorlage = tversandart.kVersanddatenExportVorlage
LEFT JOIN tVersanddatenImportVorlage ON tVersanddatenImportVorlage.kVersanddatenImportVorlage = tversandart.kVersanddatenImportVorlage
WHERE (tVersandart.cAktiv='Y') AND (tVersandart.nEigeneVersandart = 1)
GROUP BY tVersandart.kVersandArt, tVersandart.cAktiv, tversandart.cName, tversandart.fPrice, tversandart.cZahlungsInfo, tVersandart.cAktiv, tVersandart.nPrioritaet, tVersandart.nVerwiegePflicht, tVersandart.nVersandMailSenden, tVersandart.cAmazonCarrierCode, tVersandart.cEbayCarrierCode, tVersandart.nVersandSchnittstelle, tVersanddatenExportVorlage.cName, tVersanddatenImportVorlage.cName, tVersandart.cTrackingUrlTemplate, tVersandart.nTrackingIDEingabePflicht

                                                )
                                                countTable
2016-10-19T22:50:24 DEBUG - [SQL] Dauer: 157ms
2016-10-19T22:50:24 DEBUG - [SQL] WITH OuterResult AS
(
    SELECT TOP 100 PERCENT tVersandart.kVersandArt, tVersandart.cAktiv, tversandart.cName, tversandart.fPrice, tversandart.cZahlungsInfo, tVersandart.nPrioritaet, tVersandart.nVerwiegePflicht, tVersandart.nVersandMailSenden, tVersandart.cAmazonCarrierCode, tVersandart.cEbayCarrierCode, tVersandart.nVersandSchnittstelle, tVersanddatenExportVorlage.cName as ExportVorlageName, tVersanddatenImportVorlage.cName as ImportVorlageName, tVersandart.cTrackingUrlTemplate, tVersandart.nTrackingIDEingabePflicht,tVersandart.cAktiv as color1
FROM tVersandart
LEFT JOIN tVersandartSprache ON tVersandart.kVersandArt = tVersandartSprache.kVersandArt
LEFT JOIN tVersanddatenExportVorlage ON tVersanddatenExportVorlage.kVersanddatenExportVorlage = tversandart.kVersanddatenExportVorlage
LEFT JOIN tVersanddatenImportVorlage ON tVersanddatenImportVorlage.kVersanddatenImportVorlage = tversandart.kVersanddatenImportVorlage
WHERE (tVersandart.cAktiv='Y') AND (tVersandart.nEigeneVersandart = 1)
GROUP BY tVersandart.kVersandArt, tVersandart.cAktiv, tversandart.cName, tversandart.fPrice, tversandart.cZahlungsInfo, tVersandart.cAktiv, tVersandart.nPrioritaet, tVersandart.nVerwiegePflicht, tVersandart.nVersandMailSenden, tVersandart.cAmazonCarrierCode, tVersandart.cEbayCarrierCode, tVersandart.nVersandSchnittstelle, tVersanddatenExportVorlage.cName, tVersanddatenImportVorlage.cName, tVersandart.cTrackingUrlTemplate, tVersandart.nTrackingIDEingabePflicht

),
  Result2 AS
(
    SELECT  *, row_number() OVER (ORDER BY cName ASC) AS rownum FROM OuterResult
)
  SELECT * FROM Result2 WHERE rownum >= 0 AND rownum <= ( 0 + 120 )
2016-10-19T22:50:25 DEBUG - [SQL] Dauer: 112ms
2016-10-19T22:50:47 DEBUG - [SQL] SELECT * FROM [tShipperAccount]
2016-10-19T22:50:47 DEBUG - [SQL] Dauer: 165ms
2016-10-19T22:51:20 DEBUG - [SQL] SELECT * FROM tVersandschnittstellenkonfiguration where cKey = 'ShipperAccount' AND cValue =@kShipperAccount
      @kShipperAccount = 12
2016-10-19T22:51:20 DEBUG - [SQL] Dauer: 86ms
2016-10-19T22:51:42 DEBUG - [SQL] UPDATE [tShipperAccount] SET cSalutation=@cSalutation, cTitle=@cTitle, cCompany=@cCompany, cCompanyAdd=@cCompanyAdd, cFirstname=@cFirstname, cLastname=@cLastname, cStreetname=@cStreetname, cStreetnumber=@cStreetnumber, cAddressadd=@cAddressadd, cMobil=@cMobil, cMail=@cMail, cZipCode=@cZipCode, cCity=@cCity, cCountry=@cCountry, cCountryIso=@cCountryIso, cPhone=@cPhone, cBankAccountOwner=@cBankAccountOwner, cBankName=@cBankName, cBic=@cBic, cIban=@cIban, cRetourenEkp=@cRetourenEkp WHERE 1=1 AND kShipperAccount=@kShipperAccount;
      @cSalutation = '',
      @cTitle = '',
      @cCompany = '',
      @cCompanyAdd = '',
      @cFirstname = '',
      @cLastname = '',
      @cStreetname = '',
      @cStreetnumber = '',
      @cAddressadd = '',
      @cMobil = '',
      @cMail = '',
      @cZipCode = '',
      @cCity = '',
      @cCountry = '',
      @cCountryIso = '',
      @cPhone = '',
      @cBankAccountOwner = '',
      @cBankName = '',
      @cBic = '',
      @cIban = '',
      @cRetourenEkp = '',
      @kShipperAccount = 7
2016-10-19T22:51:42 DEBUG - [SQL] Dauer: 137ms
2016-10-19T22:52:00 DEBUG - [TableTable] Eintrag TableCache.tversion entfernt - Expired
2016-10-19T22:52:00 DEBUG - [TableTable] Eintrag TableCache.tbenutzer entfernt - Expired
2016-10-19T22:52:00 DEBUG - [TableTable] Eintrag TableCache.tOptions entfernt - Expired
2016-10-19T22:52:16 DEBUG - [SQL] EXEC Auslieferung.spPicklistenAufraeumen
      
2016-10-19T22:52:16 DEBUG - [SQL] Dauer: 159ms
2016-10-19T22:52:20 DEBUG - [TableTable] Eintrag TableCache.teinstellungen entfernt - Expired
2016-10-19T22:52:40 DEBUG - [TableTable] Eintrag TableCache.tSpracheUsed entfernt - Expired
2016-10-19T22:52:40 DEBUG - [TableTable] Eintrag TableCache.ebay_xx_sites entfernt - Expired
2016-10-19T22:52:40 DEBUG - [TableTable] Eintrag TableCache.tKundenGruppe entfernt - Expired
2016-10-19T22:54:00 DEBUG - [TableTable] Eintrag TableCache.tfirma entfernt - Expired
Zeitstempel: 2016-10-19T22:55:04
Locale: German (Germany)
Locale: German (Germany)
Version: 1.1.4.7
Plattform: Wawi
Versionshash: 41DA7F5F
Prozessname: System.Diagnostics.Process (JTL-wawi)
Physikalischer Speicher: 264966144 / Peak: 667717632
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:31,296875
CPU-Zeit (System): 0:00:14,109375
Page-Size (Sytem): 1526192 / Peak: 638705664
Page-Size: 184020992 / Peak: 638705664
Offene Handles: 1330

 

[DanielH.]

OK Problem war schon bekannt, siehe https://forum.jtl-software.de/threads/fehlermeldung-ungueltiger-spaltenname-cretourenekp.93669/
kann geschlossen werden
Danke