Hi all,
I am doing the AA Budget uploading in Microsoft Dynamics GP 10 SP5. In my environment we have multiple dimensions and dimension codes linked to it. I had created a new Budget ID with new Budget Tree and assigning the Dimension codes from first to last in a Dimension Code. When i am trying to assign all the codes in Assign Budget Tree codes window, I am getting a Primary key violation error for a temp table as subquery returned more than 1 value. Followed by the error "The stored procedure aagBuildBudgetTree returned error the following results: DBMS : 16917.
I took the profiler and got the query mentioned below:
insert into ##1022527(aaBudgetTreeID,aaTrxDimCodeID, aaTrxDimParCodeID,aaCodeSequence,aaLevel,aaLvlCodeString,aaTrxDimCodeDescr1)
(select 15,65745,0,3600,1,65745, AAG00401.aaTrxDimCodeDescr from AAG00401 WHERE AAG00401.aaTrxDimCodeID =65745)
My understandings from the above query is, there is a where condition only on TrxDimcodeid without Dimid. In my case i have more than 1 results in aag00401 table with same dimcodeid value. So getting the errors and this is stopping me to assign Budget tree codes.
