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?