SAP Knowledge Base Article - Preview

3218324 - Article synchronization issue - Unclosed quotation mark after the character string

Symptom

You're trying to synchronize articles/items from the SAP B1 to the CCO, however, the synchronization fails.

In the log files, the following error is raised:

  • WARN  com.sap.scco.ap.pos.i14y.util.AbstractDTOService - an exception came up while retrieving all MaterialDTO from ERP (BusinessOne)
    com.sap.scco.util.exception.XState: com.sap.scco.util.exception.XState: com.sap.scco.util.exception.XState: Unclosed quotation mark after the character string ' '.

Or,

  • WARN  com.sap.scco.ap.pos.i14y.util.AbstractDTOService - an exception came up while retrieving all MaterialDTO from ERP (BusinessOne)
    com.sap.scco.util.exception.XState: com.sap.scco.util.exception.XState: com.sap.scco.util.exception.XState: SAP DBTech JDBC: [257] (at 603): sql syntax error: unterminated quoted string literal: 


Read more...

Environment

  • SAP Customer Checkout
  • SAP Business One

Product

SAP Customer Checkout all versions

Keywords

synchronization, item, article, master data, CCO, B1, sync, sap.POS.FetchMaterialList
an exception came up while retrieving all MaterialDTO from ERP (BusinessOne), Unclosed quotation mark after the character string
sql syntax error: unterminated quoted string literal , KBA , IS-SE-CCO , Customer Checkout , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.