Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
dan5460 11/3/2016 3:52:41 PM

eConnect Issue with Project Creation.

Hello,

I am having a hell of time trying to get projects inserted into GP 2015.  We have a VB script that uses the eConnect nodes to insert our projects into GP.  It has been working for 3 years until now.  I have no idea what and where the issue could be. 

The eConnect error is shown below. 

I bolded the error that confuses me because THERE is no where in the script and all the tables where 'ADMIN' would exist. 

I have debug the script and it fails at this point

e.CreateEntity(sConnectionString, scontractDocument)

I looked at the XML and I also do not see any 'ADMIN' in it.  I have included our XML below.

Any insight would help.  Thanks

-------------------------------------------------------------------

Event[0]:
  Log Name: eConnect
  Source: Microsoft.Dynamics.GP.eConnect
  Date: 2016-11-03T12:55:22.000
  Event ID: 0
  Task: N/A
  Level: Error
  Opcode: Info
  Keyword: Classic
  User: N/A
  User Name: N/A
  Computer: ACC-GP01.accretivesolutions.com
  Description:
Action:
Create

Current User Name:

Input parameters:

Exception type:
System.Data.SqlClient.SqlException

Exception message:
Conversion failed when converting the varchar value 'ADMIN                ' to data type int.

Stack Trace:
   at Microsoft.Dynamics.GP.eConnect.ServiceProxy.HandleSqlException(FaultException`1 ex)
   at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateEntity(String connectionString, String xml)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML)

------------------------------------------------------------------

XML

 

<eConnect>
    <PAContractsType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taPAContracts>
            <CUSTNMBR>FF40559     </CUSTNMBR>
            <PAcontid>FF94981</PAcontid>
            <PAcontname>ERA</PAcontname>
            <PACONTNUMBER>FF94981</PACONTNUMBER>
            <PAcontclassid>8010</PAcontclassid>
            <PAProjectType>1</PAProjectType>
            <PAAcctgMethod>1</PAAcctgMethod>
            <PAMCCURNCYID>Z-US$</PAMCCURNCYID>
            <PAContMgrID>080159</PAContMgrID>
            <PABusMgrID>080159</PABusMgrID>
            <ADRSCODE>C144032</ADRSCODE>
            <SLPRSNID> </SLPRSNID>
            <PABILLFORMAT>T&M MULTIWK SUMMARY</PABILLFORMAT>
            <PRBTADCD>C144032</PRBTADCD>
            <PATRKCHGORDS>1</PATRKCHGORDS>
            <PATRKCOBDGADDFLY>1</PATRKCOBDGADDFLY>
            <USRDEFND1>12/12/2016</USRDEFND1>
            <USRDEFND2>1/27/2017</USRDEFND2>
        </taPAContracts>
        <taPAContractBillingCycle_Items xsi:nil="true"/>
        <taPAAccountsSetup_Items xsi:nil="true"/>
        <taPAProjects_Items>
            <taPAProjects>
                <CUSTNMBR>FF40559     </CUSTNMBR>
                <PACONTNUMBER>FF94981</PACONTNUMBER>
                <PAprojid>FF94981</PAprojid>
                <PAprojname>ERA</PAprojname>
                <PAPROJNUMBER>FF94981</PAPROJNUMBER>
                <PAProjectType>1</PAProjectType>
                <PABBeginDate>12/12/2016</PABBeginDate>
                <PABEndDate>1/27/2017</PABEndDate>
                <PAprjclsid>8010</PAprjclsid>
                <PADepartment>08     </PADepartment>
                <PALabor_Rate_Table_ID>Finan94981</PALabor_Rate_Table_ID>
                <PALabor_RateTable_Type>1</PALabor_RateTable_Type>
                <PABILLFORMAT>T&M MULTIWK SUMMARY</PABILLFORMAT>
                <PA_RestrictCustomerList>0</PA_RestrictCustomerList>
                <PATRKCHGORDS>1</PATRKCHGORDS>
                <PATRKCOBDGADDFLY>1</PATRKCOBDGADDFLY>
            </taPAProjects>
        </taPAProjects_Items>
        <taPAProjectBillingCycle_Items>
            <taPAProjectBillingCycle>
                <PAPROJNUMBER>FF94981</PAPROJNUMBER>
                <PABILLCYCLEID>BIWEEKLY</PABILLCYCLEID>
                <PABILLFORMAT>T&M MULTIWK SUMMARY</PABILLFORMAT>
            </taPAProjectBillingCycle>
        </taPAProjectBillingCycle_Items>
        <taPAProjectAccess_Items xsi:nil="true"/>
        <taPAProjectEquip_Items xsi:nil="true"/>
        <taPAProjectFeeSchedule_Items xsi:nil="true"/>
        <taPAProjectFee_Items xsi:nil="true"/>
        <taPAProjectBudgetMaster_Items>
            <taPAProjectBudgetMaster>
                <PAPROJNUMBER>FF94981</PAPROJNUMBER>
                <PACOSTCATID>SERVICES</PACOSTCATID>
                <PAProfitType>1</PAProfitType>
                <PAbllngtype>1</PAbllngtype>
                <PABBeginDate>12/12/2016</PABBeginDate>
                <PABEndDate>1/31/2017</PABEndDate>
                <PABQuantity>158.40</PABQuantity>
                <PABUnitCost>80.290000</PABUnitCost>
                <PABProfitAmt>185.000000</PABProfitAmt>
                <PABProfitPcnt>35.000000</PABProfitPcnt>
                <PABaselineOvrhdPct>35.000000</PABaselineOvrhdPct>
            </taPAProjectBudgetMaster>
        </taPAProjectBudgetMaster_Items>
    </PAContractsType>
</eConnect>
Version: GP 2015
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