ANSWERED - eConnect Issue with Project Creation.

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

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

DynDeveloper.com

eConnect Issue with Project Creation.