2 Replies Latest reply on Oct 15, 2007 7:52 PM by Carl Lewis

    Item Prices Not Synching In SynchManager For Web Tools/NetPoint eCommerce

    Michael Foss

      I've got ~23k items in SAP that need to be synched from SAP DB to the Web Tools DB.

      Here's an example error I get for one of the error messages I got (the example part number is "1013-ISO BRS&quot:

      <code>Failed Items 1013-ISO BRS 8/28/2007 5:59 PM Add
      Data is Null. This method or property cannot be called on Null values.
         at System.Data.SqlClient.SqlBuffer.get_String()
         at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
         at NetPoint.SynchSBO.SBOObjects.SBOItem.SynchPrice(String itemcode)
         at NetPoint.SynchSBO.SBOObjects.SBOItem.SBOToNetPoint(SBOQueueObject qData)
         at NetPoint.SynchSBO.SynchObjectBase.Synch()</code>

      The weird thing is, this is happening with every item I have to synch, and as a result of them all failing I need to resynch them the next time! The items do actually go, through, but they all throw this error. I have a feeling that it has to do with pricing, given that the <code>NetPoint.SynchSBO.SBOObjects.SBOItem.SynchPrice</code> function is in the middle of the call stack. However, all of the items have a valid base price and a pricelist.

      If anyone can help, I'd appreciate it!