Gelöst Fehler: Zeichenfolgen- oder Binärdaten würden abgeschnitten.

[saschadd]

Hallo,

beim abholen der Kundendaten erhalte ich folgende Fehlermeldung:

Fehler:
Kunden-Empfangen-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Zeichenfolgen- oder Binärdaten würden abgeschnitten.
Die Anweisung wurde beendet.
   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)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, 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 JTL.Database.DbCommandExtensions.ExecuteNonQuery(IDbCommand command)
   bei JTL.Database.DbConnectionExtensions.<>c__DisplayClass1.<ExecuteNonQuery>b__0(IDbConnection con)
   bei JTL.Database.DbConnectionExtensions.<>c__DisplayClass9`1.<Execute>b__7()
   bei JTL.Database.DbConnectionExtensions.HandleError[T](IDbConnection connection, Func`1 action)
   bei JTL.Database.DbConnectionExtensions.Execute[T](IDbConnection connection, Func`2 func)
   bei JTL.Database.DbConnectionExtensions.ExecuteNonQuery(IDbConnection connection, IDbCommand command)
   bei JTL.Database.Commands.Entities.KeylessCreateCommand.Execute(IDbConnection connection, IDbTransaction transaction)
   bei JTL.Database.Commands.Entities.DbCreateCommandTransaction.<>c__DisplayClass1.<Execute>b__0(IDbCreateCommand command)
   bei System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
   bei System.Linq.Enumerable.Sum(IEnumerable`1 source)
   bei System.Linq.Enumerable.Sum[TSource](IEnumerable`1 source, Func`2 selector)
   bei JTL.Database.Commands.Entities.DbCreateCommandTransaction.Execute(IDbConnection connection, IDbTransaction transaction)
   bei jtlDatabase.jtlObjectRepositoryBase.wZZI4Vo5XqV(IEnumerable`1 items, Type )
   bei jtlDatabase.jtlObjectRepositoryBase.XqcI4ZB5Vvr(IGrouping`2 group)
   bei System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   bei System.Linq.Enumerable.Sum(IEnumerable`1 source)
   bei System.Linq.Enumerable.Sum[TSource](IEnumerable`1 source, Func`2 selector)
   bei jtlDatabase.jtlObjectRepositoryBase.Create(IEnumerable`1 items)
   bei jtlDatabase.jtlObject.insertInDB()
   bei jtlDatabase.jtlObject.Save()
   bei jtlDatabase.classes.ConnectorClasses.CustomerSaver.Save(List`1 customers)
   bei jtlDatabase.classes.ConnectorClasses.Saver.Save(IEnumerable`1 items, jtlShop shop, List`1& exceptions)
   bei jtlCore.ControllerClasses.Connector.Abgleich.Funktionen.ConnectorPuller.Pull[TEntity](Int64 quantity)



Warnungen:
Der Shop hat nicht alle Kunden gesendet.Abgleich darf nicht weiterlaufen.Abgleich darf nicht weiterlaufen.

Log-Datei des Servers

[2017-03-15 08:32:06] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 12): Undefined index: customers_status_min_order [] []
[2017-03-15 08:32:06] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 22): Undefined index: customers_status_max_order [] []
[2017-03-15 08:32:06] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 12): Undefined index: customers_status_min_order [] []
[2017-03-15 08:32:06] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 22): Undefined index: customers_status_max_order [] []
[2017-03-15 08:32:06] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 12): Undefined index: customers_status_min_order [] []
[2017-03-15 08:32:06] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 22): Undefined index: customers_status_max_order [] []
[2017-03-15 08:32:10] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 12): Undefined index: customers_status_min_order [] []
[2017-03-15 08:32:10] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 22): Undefined index: customers_status_max_order [] []
[2017-03-15 08:32:10] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 12): Undefined index: customers_status_min_order [] []
[2017-03-15 08:32:10] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 22): Undefined index: customers_status_max_order [] []
[2017-03-15 08:32:10] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 12): Undefined index: customers_status_min_order [] []
[2017-03-15 08:32:10] global.NOTICE: (E_NOTICE) File (phar:///var/www/jtlconnector/index.php/src/jtl/Connector/Gambio/Mapper/CustomerGroupAttr.php, 22): Undefined index: customers_status_max_order [] []

 

[saschadd]

Abgleich-Log der JTL-Wawi

JTL-Wawi: StartForm()
JTL-Wawi: MainWindow != null
Endpoint version: 2.2
Wawi-Version: 1.2.0.2
JTL-Wawi: Sync start
JTL-Wawi: Licence is valid
JTL-Wawi: InitCall OK
JTL-Wawi: Initialize model getters...
>>> Category.statistic: {
  "method": "Category.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "4fd0f9620c014823b88922fb4677b52d"
}
<<< Category.statistic: {"result":{"available":0,"controllerName":"category"},"error":null,"jtlrpc":"2.0","id":"4fd0f9620c014823b88922fb4677b52d"}
(98,0642 milliseconds)
<<< Product.statistic: {"result":{"available":0,"controllerName":"product"},"error":null,"jtlrpc":"2.0","id":"7712b17365ea437c8c8db6bec0a2a744"}
(1356,3668 milliseconds)
>>> CrossSelling.statistic: {
  "method": "CrossSelling.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "b470f91eea704a7baa7adf7fc61849c8"
}
<<< CrossSelling.statistic: {"result":{"available":0,"controllerName":"crossSelling"},"error":null,"jtlrpc":"2.0","id":"b470f91eea704a7baa7adf7fc61849c8"}
(106,1843 milliseconds)
<<< Customer.statistic: {"result":{"available":7151,"controllerName":"customer"},"error":null,"jtlrpc":"2.0","id":"d3a1df6378cd4c688e5bb23828c395f3"}
(137,8018 milliseconds)
<<< CustomerOrder.statistic: {"result":{"available":16684,"controllerName":"customerOrder"},"error":null,"jtlrpc":"2.0","id":"2ff2f3fc1c444a57b67c8ccf01f66f47"}
(702,4252 milliseconds)
>>> Image.statistic: {
  "method": "Image.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "266ef14c103440b3aa72312db4be8f5b"
}
<<< Image.statistic: {"result":{"available":4776,"controllerName":"image"},"error":null,"jtlrpc":"2.0","id":"266ef14c103440b3aa72312db4be8f5b"}
(112,3193 milliseconds)
>>> Manufacturer.statistic: {
  "method": "Manufacturer.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "0c0747ee34af428c9278ef4bfbfbc9cd"
}
<<< Manufacturer.statistic: {"result":{"available":0,"controllerName":"manufacturer"},"error":null,"jtlrpc":"2.0","id":"0c0747ee34af428c9278ef4bfbfbc9cd"}
(89,5 milliseconds)
JTL-Wawi: ModelGetters OK
>>> global_data.pull: {
  "method": "global_data.pull",
  "params": {
    "limit": 50,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "bd6cd187b53a44ef9826e738e6f594d1"
}
<<< global_data.pull: {"result":[{"configGroups":[],"configItems":[],"crossSellingGroups":[],"currencies":[{"id":["1",0],"delimiterCent":",","delimiterThousand":".","factor":1,"hasCurrencySignBeforeValue":false,"isDefault":true,"iso":"EUR","name":"EUR","nameHtml":""},{"id":["2",0],"delimiterCent":".","delimiterThousand":",","factor":1.55792999,"hasCurrencySignBeforeValue":false,"isDefault":false,"iso":"USD","name":"Dollar","nameHtml":""},{"id":["3",0],"delimiterCent":",","delimiterThousand":".","factor":1.62945998,"hasCurrencySignBeforeValue":false,"isDefault":false,"iso":"CHF","name":"Schweizer Franken","nameHtml":""}],"customerGroups":[{"id":["1",0],"applyNetPrice":false,"discount":0,"isDefault":false,"attributes":[],"i18ns":[{"customerGroupId":["1",0],"languageISO":"eng","name":"Guest"},{"customerGroupId":["1",0],"languageISO":"ger","name":"Gast"}]},{"id":["2",0],"applyNetPrice":false,"discount":0,"isDefault":true,"attributes":[],"i18ns":[{"customerGroupId":["2",0],"languageISO":"eng","name":"Endkunde"},{"customerGroupId":["2",0],"languageISO":"ger","name":"Endkunde"}]},{"id":["3",0],"applyNetPrice":true,"discount":0,"isDefault":false,"attributes":[],"i18ns":[{"customerGroupId":["3",0],"languageISO":"eng","name":"Merchant"},{"customerGroupId":["3",0],"languageISO":"ger","name":"H\u00e4ndler"}]}],"languages":[{"id":["1",0],"isDefault":false,"languageISO":"eng","nameEnglish":"English","nameGerman":"English"},{"id":["2",0],"isDefault":true,"languageISO":"ger","nameEnglish":"Deutsch","nameGerman":"Deutsch"}],"measurementUnits":[],"productTypes":[],"shippingClasses":[],"shippingMethods":[{"id":["freeamount",0],"name":"Versandkostenfrei"},{"id":["dp",0],"name":"Deutsche Post"},{"id":["table",0],"name":"Versandkosten nach Preis\/Gewicht"},{"id":["dpd",0],"name":"DPD"},{"id":["selfpickup",0],"name":"Selbstabholung"}],"taxRates":[{"id":["",0],"rate":0},{"id":["",0],"rate":7},{"id":["",0],"rate":19}],"units":[{"id":["1",0],"i18ns":[{"unitId":["1",0],"languageISO":"ger","name":"St\u00fcck"}]},{"id":["2",0],"i18ns":[{"unitId":["2",0],"languageISO":"ger","name":"Satz"}]},{"id":["3",0],"i18ns":[{"unitId":["3",0],"languageISO":"ger","name":"Set"}]},{"id":["4",0],"i18ns":[{"unitId":["4",0],"languageISO":"ger","name":"0 "}]}],"warehouses":[]}],"error":null,"jtlrpc":"2.0","id":"bd6cd187b53a44ef9826e738e6f594d1"}
(98,5088 milliseconds)
>>> Customer.statistic: {
  "method": "Customer.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "a7c6df2d837c4ee4adb6baaff71229b2"
}
<<< Customer.statistic: {"result":{"available":7151,"controllerName":"customer"},"error":null,"jtlrpc":"2.0","id":"a7c6df2d837c4ee4adb6baaff71229b2"}
(93,7176 milliseconds)
>>> customer.pull: {
  "method": "customer.pull",
  "params": {
    "limit": 50,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "331a614b4a324186b20aa3e752c5e6b4"
}
<<< customer.pull: {"result":[ entfernt wegen kundendaten, wenn nötig gern per pm],"error":null,"jtlrpc":"2.0","id":"331a614b4a324186b20aa3e752c5e6b4"}
(148,0458 milliseconds)
JTL-Wawi: End sync
Kunden-Empfangen-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der JTL-Wawi notwendig sind!
Zeichenfolgen- oder Binärdaten würden abgeschnitten.
Die Anweisung wurde beendet.
   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)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, 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 JTL.Database.DbCommandExtensions.ExecuteNonQuery(IDbCommand command)
   bei JTL.Database.DbConnectionExtensions.<>c__DisplayClass1.<ExecuteNonQuery>b__0(IDbConnection con)
   bei JTL.Database.DbConnectionExtensions.<>c__DisplayClass9`1.<Execute>b__7()
   bei JTL.Database.DbConnectionExtensions.HandleError[T](IDbConnection connection, Func`1 action)
   bei JTL.Database.DbConnectionExtensions.Execute[T](IDbConnection connection, Func`2 func)
   bei JTL.Database.DbConnectionExtensions.ExecuteNonQuery(IDbConnection connection, IDbCommand command)
   bei JTL.Database.Commands.Entities.KeylessCreateCommand.Execute(IDbConnection connection, IDbTransaction transaction)
   bei JTL.Database.Commands.Entities.DbCreateCommandTransaction.<>c__DisplayClass1.<Execute>b__0(IDbCreateCommand command)
   bei System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
   bei System.Linq.Enumerable.Sum(IEnumerable`1 source)
   bei System.Linq.Enumerable.Sum[TSource](IEnumerable`1 source, Func`2 selector)
   bei JTL.Database.Commands.Entities.DbCreateCommandTransaction.Execute(IDbConnection connection, IDbTransaction transaction)
   bei jtlDatabase.jtlObjectRepositoryBase.wZZI4Vo5XqV(IEnumerable`1 items, Type )
   bei jtlDatabase.jtlObjectRepositoryBase.XqcI4ZB5Vvr(IGrouping`2 group)
   bei System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   bei System.Linq.Enumerable.Sum(IEnumerable`1 source)
   bei System.Linq.Enumerable.Sum[TSource](IEnumerable`1 source, Func`2 selector)
   bei jtlDatabase.jtlObjectRepositoryBase.Create(IEnumerable`1 items)
   bei jtlDatabase.jtlObject.insertInDB()
   bei jtlDatabase.jtlObject.Save()
   bei jtlDatabase.classes.ConnectorClasses.CustomerSaver.Save(List`1 customers)
   bei jtlDatabase.classes.ConnectorClasses.Saver.Save(IEnumerable`1 items, jtlShop shop, List`1& exceptions)
   bei jtlCore.ControllerClasses.Connector.Abgleich.Funktionen.ConnectorPuller.Pull[TEntity](Int64 quantity)

 

[itratosTeam]

Hallo Sascha,

prüfe mal Deine Kundendaten inkl. Bestellungen und Zahlungen ob dort Pflichtdaten fehlen.
Das kann vorkommen wenn z.B. Kundendaten in Bestellungen unvollständig sind und es sich um Pflichtdaten handelt die JTL Wawi fordert - das kann vorkommen wenn die Daten von externen Systemen importiert oder bei Testbestellungen mit dem Admin User dessen Daten evtl. unvollständig sind.

 

[saschadd]

Hallo Timo,

danke für die Info. Was sind Pflichtdaten für die Wawi? Gibt es da eine Liste die ich abarbeiten kann?

 

[saschadd]

Ich hab mal nach Unstimmigkeiten bei customers und orders geschaut.
Da sind einige Datumsangaben auf 1000-01-01 00:00:00 gesetzt, kann sowas zu Problemen führen?
Bei der Menge an Kunden und Bestellungen im Shop wäre eine Liste der Pflichtangaben die die Wawi braucht sehr hilfreich.