I have an APD (source data - a Bex Query and Destination - a csv file). The output of the csv file is as per the Logical path name.This APD is being called several times by numerous Process Chains . The Process Chains executing the APD are all placed one after the other and before the executing the APD the physical filename is being populated via a program - updating the details of table 'FILENAMECI'.
This solution works for most of the APD executions - however sometimes I can see even though the physical file name is updated in table FILENAMCI - the APD writes to the previous file name. For example :-
APD Execution 1 :- Physical file name in table FILENAMCI is 'XXX' - APD output is 'XXX.csv'
APD Execution 2 :- Physical file name in table FILENAMCI is 'YYY' - APD output is 'XXX.csv' - though contents are as per 'YYY'.
Is there anyway we can fix the issue?