Somebody will pat me , somebody will envy on me , somebody will congrats me , somebody will ignore me ….. That’s life ! From LinkedIn +200 Million members my profile viewed in top 1% list … ! Thanks LinkedIn for capturing every moments …
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 210,000 times in 2012. If it were Liechtenstein, it would take about 4 years for that many people to see it. Your blog had more visits than a small country in Europe!
“The current xml is invalid with the following errors: Bad xml instance!” is very unusual error but when this has been encountered it is become frustrating as it sounds the entire report can’t be saved !
I remember last time I had faced the similar issue in 184.108.40.206 version while I was building a new report from scratch . The error enforced me not to even edit the reports so I neither I can move to criteria nor I can save this . That was weird ! The only option left was to edit the XML using Catalog manager but until and unless you know where the problem lies you can’t fix it right ?
Now recently I got similar kind of issue in one of our upgraded 220.127.116.11 report which is a Combined request report and when I tried to edit the Criteria Analysis properties Interaction tab to remove Sort column of un-check any other options it throws me below error during the save:
Okay … so the error was at the very last line of the displayed XML as below:
Line:814, Col:61, Element ‘criteria’ is not valid for content model: ‘((criteria,interactionOptions,views,prompts,listOptions),segmentOptions)’
so the bug is around the green circled tags !! Reason is whenever you un-check some options under “Analysis-Properties” it will throw errors !! Probably this is some problem with the up-graded code in 11g from 10g as I tried to replicate the same creating a new reports from scratch which was pretty cool and removing any interaction works perfectly okay in the dashboard report .
After spending some times the reason of the issue found with the fix . I have customized the location for the below tag from Advanced XML :
<saw:interactionOptions drill=”true” movecolumns=”true” sortcolumns=”false” addremovevalues=”true” groupoperations=”true” calcitemoperations=”true” showhidesubtotal=”true” showhiderunningsum=”true” inclexclcolumns=”true”/>
Edited the XML and moved it from beforesection to the end of all. As it is combined request hence several would be present but placed it after all of them.
After that apply the changes in Advanced XML and voila …. your problem fixed ! Note that this could be the one of incident with BAD XML error and probably you can found it in several other places with no relation to my above fix note . This those cases you need to dig down into more details of the Advanced XML generated and fix those issues as applicable for your case .
Bottom line is same . Dig into the XML details to find out the crappy code and the fix it ! …
So that’s it …. till next time… Happy weekend 🙂
Hello friends, after long time , I am again back on track … I was quite busy with couple of my mandatory schedules for last couple of weeks!
So today my topic is what are the Performance tuning key measures useful while doing report Performance testing. There are lots and I just tried to pull most of them and cover the highlights which would be very helpful while doing the Report Performance testing. Actually this could be separated across several areas like sometime it would be from DB perspective, sometime Environment parameters and sometime it would be the Repository design perspective. However the target objective is same but we need to work well to understand the performance bottleneck from which angles! This will definitely come with the experience and the different challenging environment and every places different rules needs to be applied.
<!– Remove from the cache everything older than N minutes –>
<!– AbsoluteMaxEntries is the enforced maximum number of entries. When this maximum is reached –>
<!– subsequent queries will fail until the maximum is no longer exceeded. –>
<!– CruiseEntries is amount of entries the OracleBI Presentation server tries to maintain in its cache. –>
<!– Forces the cache to attempt to remove an old entry when MaxEntries is exceeded. –>
<!– Cleanup this cache every N minutes. –>
•Bitmap Join Indexes
•Gathering Stats 30%
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 160,000 times in 2011. If it were an exhibit at the Louvre Museum, it would take about 7 days for that many people to see it.
Most of the common question is how to Install OBIEE 11g(18.104.22.168) but a bit un-common question is how to De-install until and unless you are facing problem with current installation process . Here are the steps at high level (not screenshot by screenshot) which will perform the orthodox De-install process. As the selection is quite straightforward hence I am skipping the screenshot’s part. There are several blog where you can find the screenshot to help you out.
Briefly, I had the full installation with Weblogic , RCU , Oracle in some path in Windows Server(2008,R2, 64 bit) and after De-installation I want to continue using the same path so all the De-install process should be very clean so that it will not leave any footprints of previous installation in any of the places for a successful installation once again.
Here you go …
Thats it , Welldone! until you have performed the clean installation once again …..:)
Bonjour et bonne année 2012 …
The new journey begins as we landed to New year 2012… Forgetting the old torn memories as it should be better to be in oblivion …. Keep the memories of delightful times and live in each day now as it is to be spent…. ! It is an immense pleasure to let you know my best New year wishes for you … The people … my near and dear ones , my enemy , my followers (Twitters et all) , my critics , my seniors and beloved juniors , finally them whom I don’t know when they silently came to my blog and escape … Hope for all of them it will be a very good year ahead of you both personally and professionally.
Thank you all who encouraged me to carry on my blog and hopefully GOD & you all bless me and it will be continued in greater extent in this year and I hope my threads someway, sometime help you !
last but not the least a Season Greetings Card for all of you… Smile 🙂
Cheers …. and bonne santé …. !
See you soon with some new geeks and hope you will enjoy … Till then …