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
3