1. 

   nsepetys, Member

   Hi!

   How are you doing? We just got our reporting server updated last night to 4.4 and it seems that we've run into an issue that is causing the proc_name to not be inserted into the mydbr_statistics table. Do you have any suggestions on how we can debug/fix this issue? I saw there was a "Ability to customize / disable report statistics" feature added so I'm wondering if this has something to do with it?

   Thanks,
   Noah
2. 

   nsepetys, Member

   I should note that all other columns are correctly populated in the mydbr_statistics table. It's just the one column that is blank (not null)
3. 

   myDBR Team, Key Master

   You can run the updater to get latest build which corrects this.

   The procedure name can also be found fron the query column which contains the full query with parameters. If you need, you can repopulate the empty proc_name-column with following command (in MySQL):

   update mydbr_statistics
   
   set proc_name = substring(query, 6,locate('(', query)-6)
   
   where proc_name='';

   
   Thanks for pointing this out.

   --
   myDBR Team

Reply

You must log in to post.