trepetti 12/26/2019 9:37:27 AM

Error 6149 from taPaProjects when creating new project in GP with SmartConnect

Working on a SmartConnect map that will create a new GP project  / project budget using a SQL table as a source.  I am in the testing phase, so prior to running the map I set the associated Contract status to 4 prior to execution.

 

The map fails with an eConnect error of 6149, "Invalid Project Number (PAPROJNUMBER) - Project Number already exists in the PA01201 Table".  But there is no existing project in the PA01201 with the same number.  I even rebuilt the indexes on PA01101 and PA01201 to see if the issue was with an indexed lookup.  

 

Anyone come across this before?

Version: GP 2015
Section: Dynamics GP, eConnect, SmartConnect


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