Dynamics Community Forum Thread Details

Econnect 10: Ambiguous column name 'Cash_Receipt!2!RMDTYPAL!element'.

I have a problem after upgrading to Great Plains 10.

When I try to retrieve data from the 'Cash_Receipt' table with OUTPUTTYPE = 2 (CompleteDocument).

an SqlException is thrown, the stack trace is:

System.Data.SqlClient.SqlException was caught

Message=Ambiguous column name 'Cash_Receipt!2!RMDTYPAL!element'.

Source=.Net SqlClient Data Provider

ErrorCode=-2146232060

Class=16

LineNumber=2

Number=209

Procedure=taRequesterCash_Receipt2

Server=ldn-gpdb

State=1

StackTrace:

Server stack trace:

at Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_Requester(String ConnectionString, ConnectionStringType ConnectionType, String sXML)

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.eConnectMethods.eConnect_Requester(String ConnectionString, ConnectionStringType ConnectionType, String sXML)

at EConnectClasses.eConnectProvider.Retrieve(String DOCTYPE, OutputType OUTPUTTYPE, String WHERE) in D:\Work\TFS\Telco Solutions\E-connect\E-connect Deployment-NBC\Business Tier\EConnectHandler\EConnectClasses\eConnectProvider.cs:line 155

InnerException:

I found a solution which states that I have to make the OUTPUTTYPE = 0 (List). and it really works with no exceptions but this way doesn't retrieve all data needed from the Cash_Receipt table it just returns econnect data

XML Retrieved from list:

<root>

<DOCTYPE>Cash_Receipt</DOCTYPE>

</eConnect>

<DOCTYPE>Cash_Receipt</DOCTYPE>

</eConnect>

</root>

Any help will be highly appreciated; thanks in advance.

The cause is the duplication of “RMDTYPAL” value of DOCTYPE “Cash_Receipt” in “INDEX1, DATA16” columns in “econnect_out_setup” table.

A safe approach is to create a new type with no columns duplication.

New doc type “Cash_Receipt_G” has been created, which is the exact copy from Cash_Receipt type except for “RMDTYPAL” in “DATA16” column (it was removed).

------------------SQL Script to Add New Type------------------------------------------------------------

INSERT [eConnect_Out_Setup]

(QUEUE_ENABLED

,DOCTYPE

,INSERT_ENABLED

,UPDATE_ENABLED

,DELETE_ENABLED

,TABLENAME

,ALIAS

,MAIN

,PARENTLEVEL

,ORDERBY

,INDEX1

,INDEX2

,INDEXCNT

,TRIGGER1

,TRIGGER2

,TRIGGERCNT

,DATACNT

,DATA1

,DATA2

,DATA3

,DATA4

,DATA5

,DATA6

,DATA7

,DATA8

,DATA9

,DATA10

,DATA11

,DATA12

,DATA13

,DATA14

,DATA15

,DATA16

,DATA17

,DATA18

,DATA19

,DATA20

,DATA21

,DATA22

,DATA23

,DATA24

,DATA25

,DATA26)

Select QUEUE_ENABLED

,'Cash_Receipt_G'