Malachi 8/10/2011 3:00:45 PM

Procedure or function 'taCreateVendorAddress' expects parameter '@I_vVENDORID', which was not supplied

Hi there, I have code to create a PM transaction thru eConnect 2010 and I'm getting the error above. PLEASE HELP!!!! Here is the xml: ...

 

    <PMTRANSACTIONTYPE>
        <ECONNECTPROCESSINFO xsi:nil="true">
        <TAREQUESTERTRXDISABLER_ITEMS xsi:nil="true">
        <TAUPDATECREATEVENDORRCD>
            <VENDORID>ZZ_002165161 </VENDORID>
            <VENDNAME>JOE SMITH</VENDNAME>
            <VENDSTTS>3</VENDSTTS>
            <VNDCLSID>CUSTREFUND</VNDCLSID>
            <VADDCDPR>CISMA76500</VADDCDPR>
            <ADDRESS1>1111 MAIN DRIVE APT 104</ADDRESS1>
            <CITY>MYCITY</CITY>
            <STATE>AK</STATE>
            <ZIPCODE>99999</ZIPCODE>
            <VADCDTRO>CISMA76500</VADCDTRO>
            <USEVENDORCLASS>1</USEVENDORCLASS>
        </TAUPDATECREATEVENDORRCD>
        <TACREATEVENDORADDRESS_ITEMS>
            <TACREATEVENDORADDRESS xsi:nil="true">
            <TACREATEVENDORADDRESS>
                <VENDORID>ZZ_002165161 </VENDORID>
                <ADRSCODE>CISMA76500</ADRSCODE>
                <ADDRESS1>1111 MAIN DRIVE APT 104</ADDRESS1>
                <CITY>MICTY</CITY>
                <STATE>AK</STATE>
                <ZIPCODE>99999</ZIPCODE>
            </TACREATEVENDORADDRESS>
            <TACREATEVENDORADDRESS>
                <VENDORID>ZZ_002165161 </VENDORID>
                <ADRSCODE>CISSA76501</ADRSCODE>
                <ADDRESS1>2222 ALOHA PLACE APT H</ADDRESS1>
                <ADDRESS2>000650030 </ADDRESS2>
                <ADDRESS3>181.50</ADDRESS3>
                <CITY>RICHES </CITY>
                <STATE>AK</STATE>
                <ZIPCODE>99999 </ZIPCODE>
            </TACREATEVENDORADDRESS>
        </TACREATEVENDORADDRESS_ITEMS>
        <TAPMTRANSACTIONTAXINSERT_ITEMS xsi:nil="true">
        <TAPMDISTRIBUTION_ITEMS>
            <TAPMDISTRIBUTION xsi:nil="true">
        </TAPMDISTRIBUTION_ITEMS>
        <TAANALYTICSDISTRIBUTION_ITEMS xsi:nil="true">
        <TAPMTRANSACTIONINSERT>
            <BACHNUMB>CIS20110810</BACHNUMB>
            <VCHNUMWK>CISVCH42414</VCHNUMWK>
            <VENDORID>ZZ_002165161 </VENDORID>
            <DOCNUMBR>000650030_42414</DOCNUMBR>
            <DOCTYPE>1</DOCTYPE>
            <DOCAMNT>181.5</DOCAMNT>
            <DOCDATE>8/10/2011</DOCDATE>
            <PRCHAMNT>181.5</PRCHAMNT>
            <CHRGAMNT>181.5</CHRGAMNT>
            <TRXDSCRN>002165161_000650030</TRXDSCRN>
        </TAPMTRANSACTIONINSERT>
        <TAMDAUPDATE_ITEMS xsi:nil="true">
    </PMTRANSACTIONTYPE>
</ECONNECT>

here is the error message: Dynamics GP Accounts Payable Exception: System.ServiceModel.CommunicationException: There was an error writing to the pipe: The pipe is being closed. (232, 0xe8). ---> System.IO.IOException: The write operation failed, see inner exception. ---> System.ServiceModel.CommunicationException: There was an error writing to the pipe: The pipe is being closed. (232, 0xe8). ---> System.IO.PipeException: There was an error writing to the pipe: The pipe is being closed. (232, 0xe8). at System.ServiceModel.Channels.PipeConnection.StartSyncWrite(Byte[] buffer, Int32 offset, Int32 size, Object& holder) at System.ServiceModel.Channels.PipeConnection.WriteHelper(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout, Object& holder) --- End of inner exception stack trace --- at System.ServiceModel.Channels.PipeConnection.WriteHelper(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout, Object& holder) at System.ServiceModel.Channels.PipeConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout) at System.ServiceModel.Channels.BufferedConnection.WriteNow(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout, BufferManager bufferManager) at System.ServiceModel.Channels.BufferedConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout) at System.ServiceModel.Channels.ConnectionStream.Write(Byte[] buffer, Int32 offset, Int32 count) at System.Net.Security.NegotiateStream.StartWriting(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.NegotiateStream.ProcessWrite(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest) --- End of inner exception stack trace --- at System.Net.Security.NegotiateStream.ProcessWrite(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.NegotiateStream.Write(Byte[] buffer, Int32 offset, Int32 count) at System.ServiceModel.Channels.StreamConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout) --- End of inner exception stack trace --- Server stack trace: at System.ServiceModel.Channels.StreamConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout) at System.ServiceModel.Channels.StreamConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout, BufferManager bufferManager) at System.ServiceModel.Channels.FramingDuplexSessionChannel.OnSend(Message message, TimeSpan timeout) at System.ServiceModel.Channels.OutputChannel.Send(Message message, TimeSpan timeout) at System.ServiceModel.Dispatcher.DuplexChannelBinder.Request(Message message, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) 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.IServiceInterface.CreateTransactionEntity(String connectionString, String xml) at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String ConnectionString, String sXML) at CISDynamicsGP.CISInfinity.CISeConnect.AddAPItem(APTransaction CISTrx, APVendor CISVendor). Dynamics GP Accounts Payable Exception: System.Data.SqlClient.SqlException: Procedure or function 'taCreateVendorAddress' expects parameter '@I_vVENDORID', which was not supplied. at Microsoft.Dynamics.GP.eConnect.ServiceProxy.HandleSqlException(FaultException`1 ex) at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String ConnectionString, String sXML) at CISDynamicsGP.CISInfinity.CISeConnect.AddAPItem(APTransaction CISTrx, APVendor CISVendor). Thanks!

Version: All
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3