Unable to import the log data in excel
Hi,
PLA tool is not importing the data into Excel, also tried to do the macro settings as suggested in the PDN, however still the issue persist, SR - C46480.
Please help!
Thanks!
***Moderator Edit: Vidyaranjan | Updated SR details and title***
Accepted Solution
Pegasystems Inc.
US
The Log Analyzer tool was being run on a different server so the data files were not exported to the local machine. When running the Log Analyzer tool on the local machine, the data files are exported to the C:\Windows\Temp directory and can be viewed in the AES_LiteParser.xls file when macros are enabled.
Merkle
GB
Hi,
Was there any error while you tried to import? Could you please share some screen shots to understand that further?
Also, check if the same issue with other system too? Might be some system privilege related issue!
Regards,
Gopesh
Cognizant
IN
Hi, Thanks for your prompt update!
No I didnt get any error while import, as no error not sure what screenshot I needs to share?
I dont have access to validate on other systems.
Regards,
Riaz
Pegasystems Inc.
US
When you export the data from the Log Analyzer tool you should see the files generated in the C:\WINDOWS\Temp directory. When you click import, it should try to re-import the files from that directory.
I tested with Alerts and saw these files generated in my temp directory.
alert_export.txt
exceptions_export.txt
Do you see the export files present in your temp directory?
Cognizant
IN
I have tried to access the C:\WINDOWS\Temp directory but seems access is restricted for me, so I changed this temp path in the excel to other drive and tried but its not working, do we have anyother alternative to make it work?
Please advise.
Thanks!
Pegasystems Inc.
US
The export files would need to be present in the other directory for it to work. When I export, the files are automatically exported to C:\WINDOWS\Temp. I do not see a configuration option to change where the files are exported. Maybe someone else will know how to change it.
Pegasystems Inc.
US
I looked at the export function in the ViewMainActionBean.class and I see the filename hardcoded with C:\WINDOWS\Temp.
Merkle
GB
Hi,
Seems some access issue with you to perform certain action, is there any option to get access in 'C:\WINDOWS\Temp' directory and try that?
Regards ,
Gopesh
Cognizant
IN
Hi,
Let me check with windows team to get the access for Temp dir, however if they didnt grant the access to me then it looks I cant use the PLA tool....(
Thanks!
Regards,
Riaz
Pegasystems Inc.
US
If you upload an Alert log and then export that row to Excel, do you see the files alert_export, exceptions_export, and gc_event_export in C:\WINDOWS\Temp?
Cognizant
IN
By Using Pega log analyser export the excel file in to my local system in Temp path and then uploaded the alert logs in the path then opened the excel but it doesnt reflected the data.
Pegasystems Inc.
US
Hi @RiazA091!
After speaking with my Subject Matter Experts, they suggest that you open a Support Request so that a Screen Share can be done to see what is happening. When you open a Support Request, please reference this thread to help the Engineer who is assigned to assist you. Also, please let us know here the SR ID so that we may track its progress for you.
Thank you so much!
Accepted Solution
Pegasystems Inc.
US
The Log Analyzer tool was being run on a different server so the data files were not exported to the local machine. When running the Log Analyzer tool on the local machine, the data files are exported to the C:\Windows\Temp directory and can be viewed in the AES_LiteParser.xls file when macros are enabled.