Skip to Content
0
Former Member
Jun 29, 2009 at 03:49 PM

Error message when updating Sales Orders

86 Views

Hi Experts

Following an issue over the weekend when I was forced to perform a hard reset we are now experiencing error message when trying to update some sales orders.

This entry already exists in the following tables " ADO1 (ODBC - 2035) [Message 131 - 183]

it is not happening on all orders - i think only ones which were on the system prior to the reset.

We also use webtools and the B1SyncService seems to be causing the SAP B1 system to become unusable - following each attempt to sync there is an error in the event log:

Event Type: Error

Event Source: B1SynchService

Event Category: None

Event ID: 0

Date: 29/06/2009

Time: 13:42:38

User: N/A

Computer: SQL01

Description:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

at netpoint.api.data.DataFunctions.ExecuteScalar(String SQL, String connectionstring)

at NetPoint.SynchSBO.SBOObjects.SBOUtility.SetCompany(Company TheCompany, SecurityTicket securityTicket)

at NetPoint.SynchSBO.Synch.SetCompany()

at NetPoint.SynchSBO.Synch..ctor(SecurityTicket ticket)

at NetPoint.SynchSBO.Synch..ctor(SecurityTicket ticket, Int32 pricinginterval)

at NetPoint.SynchService.NPSynchService.Synch(String profile, Mutex mutex)

at NetPoint.SynchService.NPSynchService.Main(String[] args)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

For now I have had to stop the SyncService to prevent B1 from becoming unusable (users are unable to start any AR module), but even after I have stopped the syncservice I still have the error when updating sales orders.

Regards

Jon