DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

Edit 9/17/15 View the main article for this error here 

Sql procedure error codes returned: Error Number = 3389

Stored Procedure taPopRcptLineInsert Error

Description = The Serial/Lot Quantity in the POP10330 does not match the Quantity Shipped in the POP10500

with this document:

 

<POPReceivingsType>
<taPopRcptLotInsert_Items >
    <taPopRcptLotInsert>
        <POPRCTNM>0166729          </POPRCTNM>
        <ITEMNMBR>DAVIDSBRICK2~~</ITEMNMBR>
        <SERLTNUM>lot1</SERLTNUM>
        <SERLTQTY>525</SERLTQTY>
        <RCPTLNNM>0</RCPTLNNM>
    </taPopRcptLotInsert>
</taPopRcptLotInsert_Items>
  
<taPopRcptLineInsert_Items>
    <taPopRcptLineInsert>
        <POPTYPE>1</POPTYPE>
        <POPRCTNM>0166729          </POPRCTNM>
        <PONUMBER>49771</PONUMBER>
        <ITEMNMBR>DAVIDSBRICK2~~</ITEMNMBR>
        <VENDORID>TEST VENDOR    </VENDORID>
        <RCPTLNNM>0</RCPTLNNM>
        <VNDITNUM>DAVIDSBRICK2~~                 </VNDITNUM>
        <UOFM>Each     </UOFM>
        <AUTOCOST>1</AUTOCOST>
        <QTYSHPPD>525</QTYSHPPD>
    </taPopRcptLineInsert>
</taPopRcptLineInsert_Items>
  
 
<taPopRcptHdrInsert>
    <POPRCTNM>0166729          </POPRCTNM>
    <POPTYPE>1</POPTYPE>
    <receiptdate>12/4/2007</receiptdate>
    <ACTLSHIP>12/4/2007</ACTLSHIP>
    <BACHNUMB>Yard Receipt</BACHNUMB>
     <AUTOCOST>1</AUTOCOST>
    <VENDORID>TEST VENDOR    </VENDORID>
</taPopRcptHdrInsert>
</POPReceivingsType>
</eConnect>

 Hey all,

I've got an application that is using the eConnect .Net assemblies to create an SOP transaction (eConnect/GP version 9). When the application runs on the same machine as the Dynamics GP database, everything works just great. However, if the application runs on a different machine, then the call to eConnect_EntryPoint() fails with a SqlException: "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

Here's the kicker: if I just use the .Net data access libraries to establish the a connection remotely using the same connection string, everything works just fine.

I've made sure that DTC is running on both boxes, and that remote connections are allowed to the SQL server. I've also turned off the firewalls on both boxes to no avail.

Anyone seen this before? How can I get the remote eConnect connection to work?

Thanks in advance.

Peter


 

Hi all,

I am trying to open the Purchase Orders Lookup window and let the user select a PO, then write the selected value back into my winform. I can see the window opening but it does not stay open, so I cannot make a selection.

Any ideas ?

I am using VS Tools for GP 10.0

eConnect error: 

Line items contain qauntity types that are not allowed for the Order DOCID entered

or, spelled correctly:

Line items contain quantity types that are not allowed for the Order DOCID entered

 

 

Server was unable to process request. ---> Sql procedure error codes returned:

Error Number = 9343 Stored Procedure taPopRcptLineInsert Error Description = Item/vendor item/vendor combination is not available to receive from the PO Line
Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert VNDITNUM = DAVIDSBRICK2~~ VENDORID = TEST VENDOR

Edit 9/17/15 View the main article for this error here 

Error Number = 3799 Stored Procedure taPopRcptLineInsert Error Description = VENDORID does not match the Purchase Order
Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert PONUMBER = 49771 VENDORID = TEST VENDOR

Error Number = 4606 Stored Procedure taPopRcptLineInsert Error Description = UOFM can not be changed when receiving an Inventoried or Non-Inventoried Item against a PO Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert PONUMBER = 49771 UOFM = Each

Edit 9/17/15 View the main article for this error here 

Error Number = 2053 Stored Procedure taPopRcptLineInsert Error Description = Purchase Order Line Item does not exist
Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = 0167653 PONUMBER = 49771 ITEMNMBR = DAVIDSBRICK2~~
Related Error Code Parameters for Node : taPopRcptLineInsert PONUMBER = 49771

 

This error came to me when attempting a PO Receipt integration on a lotted item.

 It went away when I changed the LOCNCODE to the one on the PO, even though the other one was valid and worked in Dynamics.

Given the XML structure:

<employees>
<employee>
 <firstname>John</firstname>
 <lastname>Doe</lastname>
</employee>
<employee>
 <firstname>James</firstname>
 <lastname>Buck</lastname>
</employee>
<employees>

 

 

I sometimes need to loop (iterate) through the file and gather the first/last names

Here is a piece of code that will do that

 

I'm going to try putting

<%@ Page Language="vb" EnableViewStateMac="False"%>

In the page declaration at the top of the page, that seems to be the consensus when I searched on this error.

 

What is EnableViewStateMac?
Here is what MSDN documentation has to say about EnableViewStateMac:
 

EnableViewStateMac
Indicates that ASP.NET should run a machine authentication check (MAC) on the page's view state when the page is posted back from the client. true if view state should be MAC checked; otherwise, false. The default is false.

Note   A view state MAC is an encrypted version the hidden variable that a page's view state is persisted to when sent to the browser. When you set this attribute to true, the encrypted view state is checked to verify that it has not been tampered with on the client.

 More info here.