0 Kb reports being generated for BizTalk about pal

[clinthuffman]

Can you send me the counter log? I’ll debug it. Upload it to http://bit.ly/PalUpload and let me know when it is uploaded. Thank you,

…

________________________________ From: Norman Gillis <[email protected]> Sent: Tuesday, February 26, 2019 11:47:42 AM To: clinthuffman/PAL Cc: Subscribed Subject: [clinthuffman/PAL] 0 Kb reports being generated for BizTalk (#39) PAL is consistently generating 0 Kb report files for BizTalk. All the charts have been generated in the charts folder however the html report is 0 kb. I have reverted to an old version of PAL for my BizTalk blg files which does work correctly. Any chance of getting this fixed for the new version? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fclinthuffman%2FPAL%2Fissues%2F39&data=02%7C01%7C%7Cb7c8a69685634d2ecffc08d69c2346f4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636868072653015265&sdata=8i5YGVxJnx53WXr2isuSOwzLYcJDGjf%2FEaL9TkUyp08%3D&reserved=0>, or mute the thread<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAS48VOQ88DOv9iPxmuWwYfujwAwSQza9ks5vRY9egaJpZM4bS-Wj&data=02%7C01%7C%7Cb7c8a69685634d2ecffc08d69c2346f4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636868072653025276&sdata=SNQzoLx1n7Pm9lPsXievGAwqDDLc7Fi2w5lJTuABfE0%3D&reserved=0>.

[AlexG7796]

Hello.

I have faced with similar issue: 0kb PAL report generated for old Win2008 / SQL2005 environment. I'm getting folder with graphs and empty HTML. Is there any simple workaround?

[Emrikol01]

If I remember correctly this issue arose when I was using PAL on a non-English operating system. It's also possible the perfmon counters are broken, (not uncommon on an old SQL Server) and you may try re-registering them. Check to see if your blg files actually contain some data, (are they just a few kb's in size or much bigger?) and open them in perfmon off the prod server somewhere secure. If there is data there you can do some manual analysis, unfortunately that's time intensive. There are some things that you can do to help yourself such as using Relog to export the counters, (cpu util, avail ram) you are interested in to csv. The csv can then be imported into excel where you can create nice tables.

[AlexG7796]

I checked .blg file, it has correct data inside. Counters state and OS/SQL langs also are fine.
My collegue also gave advice to seek in config file for some misconfigurations. If no luck, then I'll try to parse blg with suggested ways.

Anyway, thank you for your time!