http://www.sqlpower.ca/forum/forums/show/208.page JForum - http://www.jforum.net
[url]http://www.sqlpower.ca/page/FAQ[/url]]]> http://www.sqlpower.ca/forum/posts/preList/2622/5890.page http://www.sqlpower.ca/forum/posts/preList/2622/5890.page GMT
I'm tunneling in (and then using a browser bookmark with Mozilla Firefox 3.0.6) to our internal server on my MacOSX 10.4.11. When I tried to log in this morning, I got:

[color=darkblue]The application has experienced an internal inconsistency. Please contact SQLPower Support.[/color]

I tried refreshing the page and actually got in and was able to make changes with no perceptible lag times or other problems.

I tried to log in about an hour and a half after that and was unable to regain access using that trick. Instead, it kicked up:

[color=darkblue]HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Servlet execution threw an exception
root cause
java.lang.OutOfMemoryError: Java heap space
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.[/color]

However, when I tried to log in about an hour later using the exact same tunneling/bookmarking approach, I had no problems getting in and was able to use all of the functionality. I am now unable to replicate the error... so I guess this is really just a long-winded fyi!

thanks.]]> http://www.sqlpower.ca/forum/posts/preList/2223/4529.page http://www.sqlpower.ca/forum/posts/preList/2223/4529.page GMT
My KPI drill down screen currently has 3 dates dimensions (Dec 2007, Jan 2008, Feb 2008).

When i drill down on Dec 2007 or Jan 2008, the Dashboard works fine. But when i drill down on Feb 2008, i get this error:

"The application has experienced an internal inconsistency. Please contact SQLPower Support."

Not sure what's different about this date dimension than the others. Also, i did not have this problem before. I dont remember doing any major changes to the KPI.

Please help!
thanks :)]]> http://www.sqlpower.ca/forum/posts/preList/1995/3101.page http://www.sqlpower.ca/forum/posts/preList/1995/3101.page GMT
How do I manage the dates that appear on the 'Select Date Range' screen? There are currently too many dates/years (see attached). I would like to see only from 2000 on. I dont think i need anything before that.

thanks.
]]> http://www.sqlpower.ca/forum/posts/preList/1919/2840.page http://www.sqlpower.ca/forum/posts/preList/1919/2840.page GMT http://www.sqlpower.ca/forum/posts/preList/1834/2470.page http://www.sqlpower.ca/forum/posts/preList/1834/2470.page GMT
1. the column name of the related data table sometime saved in lower case, that makes that line of related data setup invisible, unchangeable, undeletable, and it wouldn't show up in the dashboard view.
2. in the popup window of related data, most of the window size is taken by the mete-data, that's useless for the end-user, how about put the description in the window title and hide the mete-data.
3. the dashboard should support custom SQL instead of just database table in the setup of related data.
]]> http://www.sqlpower.ca/forum/posts/preList/1820/2408.page http://www.sqlpower.ca/forum/posts/preList/1820/2408.page GMT
-Thanks]]> http://www.sqlpower.ca/forum/posts/preList/1784/2256.page http://www.sqlpower.ca/forum/posts/preList/1784/2256.page GMT
We were trying to run the Power*Dashboard engine on the DASH_DEMO_TRAVEL_SUMMARY threshold on dash_demo of deepthought oracle and we got the following:

Processing parameters
Error: Section with Logical=DASH_DEMO not found
Program exit with error:52

Could you please help us to understand the error?
Thanks in advance :D ]]> http://www.sqlpower.ca/forum/posts/preList/1783/2253.page http://www.sqlpower.ca/forum/posts/preList/1783/2253.page GMT http://www.sqlpower.ca/forum/posts/preList/1686/1883.page http://www.sqlpower.ca/forum/posts/preList/1686/1883.page GMT
My Global Application Preferences (under Admin > User Preferences) show the option "Use applets when possible" to be 'YES'. I assume this means the Java applet will be used in all KPIs unless selected otherwise within a specific KPI (in KPI Preferences), right?

How come then when go in a KPI, say KPI-1, and change the KPI Preferences for "Use Applet for this KPI" to "NO" (by checking the box and the 'no' radio button), I notice that the Java applet is disabled in KPI-1 but also in all other KPI's. The change had an effect in all my KPIs.

But when i switch the preference for KPI-1 for "Use Applet for this KPI" to 'YES' (with check box too), all other KPI's have changed back to using the applet as well.

How can I just single out one KPI to not use the Applet?

thanks.]]> http://www.sqlpower.ca/forum/posts/preList/1676/1825.page http://www.sqlpower.ca/forum/posts/preList/1676/1825.page GMT
Dashboard freezes at kpi_drill_down_applet.jsp with Mac Firefox 2.0.0.1. According to Jonathan, it has to do with Firefox not accepting our cookies or something....

Anyways, the fix is easy: upgrade your Mac Firefox to 2.0.0.5.

gQ]]> http://www.sqlpower.ca/forum/posts/preList/1668/1798.page http://www.sqlpower.ca/forum/posts/preList/1668/1798.page GMT
I'm in my drill-down screen and the numbers in this one dimension do not add up. The summation shows 0 at the top level even though there are numbers within that level.

My KPI is set to 'Show all green'.

Can someone help me solve this mystery? :shock:

(I have a screen shot if you need one but how do I submit it?)

thanks!

]]> http://www.sqlpower.ca/forum/posts/preList/1637/1664.page http://www.sqlpower.ca/forum/posts/preList/1637/1664.page GMT
The new Scorecard feature in the Power*Dashboard is great .. I did come across a bunch of minor buglettes though .. I'll list them here:
- Occasional mis-formatting on the Scorecard display screen shifting the measure target column off the screen
- Does not seem to accept fractional objective weighting
- If the objective name has an apostrphe in it .. it doesn't seem to allow me to edit any of the weight, base, actual or target columns?

Please advise as to when you expect these items to be fixed]]> http://www.sqlpower.ca/forum/posts/preList/1633/1659.page http://www.sqlpower.ca/forum/posts/preList/1633/1659.page GMT
This is just a minor issue. Not sure what I do differently when I login to the Dashboard but sometimes the scroll bar is missing.

Any idea why that happens sometimes :?:

Thanks!

(I would show you screen shots to clarify my problem but I don't see any option to paste/upload pics other than your 'Insert Image'.)]]> http://www.sqlpower.ca/forum/posts/preList/1619/1642.page http://www.sqlpower.ca/forum/posts/preList/1619/1642.page GMT