This is what I can interpret for minus( -) , the processing still requires that amount of memory and that is not available!

Hi, Can someone please help me with this? how can I understand the negative number of TOTAL_TEMP_KB in usage tracking table(S_NQ_ACCT) ? I found following numbers which looks very huge and I believe this is impacting the performance of the system! any docs we have to refer about this more? -687312572 -687313848 -691213346…

Thanks Joel, What I am not able to understand is how can that value can be a negative(-) value for that column? how can I interpret that ? I can understand if something 5000 KB, but not sure what does -5000 KB? is that something like it was using Disk memory instead of RAM memory for processing? Regards Hesh

Thanks Christian, But even though you choose different servers.. you will be still accessing the target tables for loading? and that will consume target server resources as well.. what would you suggest here.. what best can be done with minimal work? Regards Hesh

Thanks Christian! ... but I can not find anything in the help that says anything about the target path 'where' to archive.. ...I mean we need to move the object (Analysis in my scenario) from Catalog to somewhere else ?(like /tmp in my scenario) Syntax runcat.cmd/runcat.sh -cmd archive -folder <path{:path}> -folderFromFile…

Sorry I have now noticed that file got generated! ..not sure why it says error! Anyhow.. thanks! Regards Hesh

Thanks Gianni Ceresa!

Thanks Gianni Ceresa, Good thought! usage tracking should be perfect fit to know what are the Analysis in use.. I will try to integrate runcat along with usage tracking.. Regards Hesh

Awesome ! Many Thanks

Thanks again Christian Berg, Sounds interesting, 'Life-cycle management' should be the thing what I should look for.. I will download the SampleApp and explore.. Can you please point me to any specific blogs links you would like me to refer? Regards Hesh

Thank you Christian Berg, I will review runcat.sh . Many things running over my mind, if we archive one Analysis and that Analysis is used in one dashboard.. I believe that will throw error! ...any more other thoughts where things can be surprising? I thought it would be easy thing to do but now looks a bit complicated…

Nothing specified about the type

Hi Robert, I have tried with a new Analysis and also with DISABLE_CACHE_HIT=1 but still the same results. But interestingly when I rerun ts working fine in the original report and when I check again with a new report its working fine as well. But issue is back with when I run wiht Disable Cache Hit ! Regards Hesh

Hi Joel, Robert, you are correct this is not Time Dimension, this is different dimension. There are no keys for BXYZ column, only values are used for that column. And there is no one to one relation between BXYZ and next RXYZ columns... like below.. for one BXYZ column values there are many RXYZ values.. One more thing is…

Thanks Joel , From RPD what I can find is.. The column 'BXYZ' from where the drill is behaving like this is derived from Four physical tables/table aliases (two tables). First two are from Master table and the next two are from Detail table. So I need to check this 'BXYZ' column is unique at that level in both Master and…

Thanks Robert, Joel May be you are correct about the data in the table, because, this drill works correctly on one day and it broke on the next day! and again works fine on the next day! can you please suggest on what would be the best way to check the data in the table? kind of lost here! Regards Hesh

This issue has been resolved now. Admin contacted Oracle, they thought certificate expire issue was causing this issue.We did a import of certificates and it worked. Not very sure if this is the reason as we did the import few times even before contacting Oracle but did not work!

Christian, I can not view any screenshot! One from my team believes there is some keystore issue, as he finds may errors in the log. Not sure where this heading now.. Regards Hesh

Thanks Christian, Do you think Trust Service Identity Asserter causing the issue here? what is that for?

Hi Christian Both DefaultAuthenticator and ADAuthenticator have SUFFICIENT in Control Flag. How to understand Order of providers? I did not find anywhere! Regards Hesh