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