Saturday, September 19, 2009

Application engine Log file

After spending three days with Peoplesoft Application engine log file , I came across few intresting fun facts about the way peoplsoft put log file in distribution agents ( aka process monitor ) . I did use a simple code .

&Log = 1Aet.filename | String(1.AET.PROCESS_INSTANCE) | ".LOG"
&LogFile = GetFile(&Log, "W", "ANSI", %FilePath_Relative);

Though I was able to confirm that log file was created but this file was not copied to report server . Bit scary but thanks to Nitin sir ( there was a "." in file name ans due to double "." ) this file was not copied to report server . Bingo problem solved .

But that wasn't my problem , My problem was to have multiple log files for multiple input files :-) ( I demand too much from peoplesoft ) . My peanut brain thought due to a loop and distinct file name this process will create new log files .

It seems peoplesoft doesn't share my idea , if we have multiple log file with same extensions . It will not put all files in report server ( not even first one ) . You will need new file extensions for each file and peoplesoft accepts only few such extensions like ".ERR", ".TXT" ..One more thing , when I opened this file in append mode it didn't publish that files .

So how did I get my problem solved , just simple I used few global variables along with file open mode in "U" mode , getpostion and set position and bingo it worked like charm :-) . Now I have to check the script which copies files .