locked
eConnect 10 Headache RRS feed

 > 

  • Frage

  • Question
    Anmelden
    0
    Anmelden

    Hello,

    I am having a problem with eConnect and the DTC. I have a website that uses eConnect to post orders into GreatPlains but right now when I try to process the order I get the following error:

    Message

    Error in method GetNextSopNumber

    InnerException

    System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Dynamics.GP.eConnect.MiscRoutines.GetSopNumber.GetNextSopNumber(Int32 SOPTYPEKey, String DOCIDKey, String BackOfficeConnString)

    StackTrace

    Server stack trace: at Microsoft.Dynamics.GP.eConnect.MiscRoutines.GetSopNumber.GetNextSopNumber(Int32 SOPTYPEKey, String DOCIDKey, String BackOfficeConnString) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Dynamics.GP.eConnect.MiscRoutines.GetSopNumber.GetNextSopNumber(Int32 SOPTYPEKey, String DOCIDKey, String BackOfficeConnString) at InterstarMVC.MasterController.GenerateTransaction(Decimal TransportCost) at InterstarMVC.CartController.Checkout(Int16 CheckoutStep, Boolean ReturnPartial, FormCollection FormValues)

    Source

    Microsoft.Dynamics.GP.eConnect.MiscRoutines

     

    The Website is located on a Virtual Private Server outside our LAN where the GreatPlains server is located. I've tried using a VPN to connect the VPS/Web Server to our LAN because I read somewhere that in order to use eConnect both machines must be on the same LAN in the same domain. Is this correct?

    Any input would be greatly appreciated.

    Thank you.

    Mittwoch, 7. Juli 2010 15:58

Antworten