Notifications
Announcements
No record found.
Hi,
I was trying to fetch data for the document type "GL_Open_Trans" using eConnect16.0 but it throws ambiguous column name . Since it is a production issue kindly help me in resolving this.
Thanks and Regards
Venkatesan
i am assuming that this was working before, and no changes were made to the environment?
Thank you for your response Arch Stanton, For other document type like Customer, Vendor it is working fine. I am getting this error for GL_Open_Trans and some other tables. Below is my request xml.
<?xml version="1.0"?><eConnect xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:xsi="">www.w3.org/.../XMLSchema-instance"> <RQeConnectOutType> <eConnectProcessInfo xsi:nil="true" /> <taRequesterTrxDisabler_Items xsi:nil="true" /> <eConnectOut> <DOCTYPE>GL_Open_Trans</DOCTYPE> <OUTPUTTYPE>2</OUTPUTTYPE> <FORLIST>1</FORLIST> <ACTION>1</ACTION> </eConnectOut> </RQeConnectOutType></eConnect>
And what is the error message exactly?
Do you have any custom post or pre procedures, any triggers on the related tables?
Thank you for your response Galina. Ambiguous column name 'DEX_ROW_ID' this is the error we got. And we didn't done any changes both db and app side. We just installed the GP2016 and created a sample company and tried to extract data from that using eConnect.
Well, ambiguous column name, as a SQL error means that you are using queries somewhere that reference more than one table with that name, and DEX_ROW_ID would be present in pretty much all tables in GP databases.
Thank you Galina, But we didn't used any queries. We just make use of the GetEntity call of eConnect to get the data.
I would think that to get the data there are some SELECT queries being run on the database, not by you, but by eConnect stored procedures, how else would you get them? At this point it looks to me that may be there is some issue with that, wouldn't be the first time. If this is important I would open a case with MS. But I would also look at other ways of getting the data you need.
Have you tried to not use eConnect to retrieve the GL data? I have never used eConnect to retrieve data only to write. Just build a query against the GL20000 table.
Yes Galina, This could be an open issue in eConnect. Now i have decided to go with writing SQL queries to the table to get the data by using SQL connection as suggested by Richard.
Thanks for the suggestions Richard. For now I have decided to go with SQL queries against the GL20000 table to get the required data. It is worrying that microsoft doesn't have any proper documentation for their SDK.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
