Pentaho Report Designer

PRD doesn't reuse mondrian connections

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker Blocker
  • Resolution: Fixed
  • Affects Version/s: 3.5.0 (CITRUS)
  • Fix Version/s: 3.6.0 M1
  • Component/s: Data Source
  • Customer Case:
  • QA Validation Status:
    Validated by QA
  • Description:
    Hide
    While developing a report in PRD 3.5 with Pentaho Analysis datasource, for every operation where it needs the metadata/results from the database it starts a new mondrian instance.


    It's absolutely unacceptable that every time that I need to switch to the preview window I need to wait for ~45 seconds and have my database on heavy loads. On this particular case, for every preview I do mondrian is hitting the ~10B rows vertica database of mozilla.


    Our development in 3.5 is currently halted until we figure out a solution
    Show
    While developing a report in PRD 3.5 with Pentaho Analysis datasource, for every operation where it needs the metadata/results from the database it starts a new mondrian instance. It's absolutely unacceptable that every time that I need to switch to the preview window I need to wait for ~45 seconds and have my database on heavy loads. On this particular case, for every preview I do mondrian is hitting the ~10B rows vertica database of mozilla. Our development in 3.5 is currently halted until we figure out a solution

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Will Gorman added a comment - 02/Oct/09 12:34 PM
Another related item to this case is being able to alter the log4j.xml file to see what mondrian is doing. Right now the file is in a jar, making it difficult to customize. I recommend leaving this in a config directory so it is easy to modify if necessary.
Show
Will Gorman added a comment - 02/Oct/09 12:34 PM Another related item to this case is being able to alter the log4j.xml file to see what mondrian is doing. Right now the file is in a jar, making it difficult to customize. I recommend leaving this in a config directory so it is easy to modify if necessary.
Hide
Permalink
Pedro Alves added a comment - 02/Oct/09 12:38 PM
One more note; I'm migrating a report that was developed in the old version of the designer;

Being the current designer unusable, on the old one either the entire resultset was cached or mondrian wasn't building a new rolap schema on every action...
Show
Pedro Alves added a comment - 02/Oct/09 12:38 PM One more note; I'm migrating a report that was developed in the old version of the designer; Being the current designer unusable, on the old one either the entire resultset was cached or mondrian wasn't building a new rolap schema on every action...
Hide
Permalink
Pedro Alves added a comment - 02/Oct/09 12:41 PM
One more note (part 2): Will's comment is http://jira.pentaho.com/browse/PRD-2066 . While turning this on I noticed that my agg tables were not being used; I fixed that by adding a mondrian.properties file to the resources directory.

It would be very helpful to have a default file in there so ppl would notice it's a configuration they can change
Show
Pedro Alves added a comment - 02/Oct/09 12:41 PM One more note (part 2): Will's comment is http://jira.pentaho.com/browse/PRD-2066 . While turning this on I noticed that my agg tables were not being used; I fixed that by adding a mondrian.properties file to the resources directory. It would be very helpful to have a default file in there so ppl would notice it's a configuration they can change
Brian Hagan made changes - 02/Oct/09 1:19 PM
Field Original Value New Value
Customer Case 7371
Kurtis Cruzada made changes - 06/Oct/09 8:38 AM
Status Open [ 1 ] Open [ 1 ]
Fix Version/s SUGAR [ 10723 ]
Fix Version/s CITRUS [ 10552 ]
Kurtis Cruzada made changes - 06/Oct/09 8:38 AM
Status Open [ 1 ] Open [ 1 ]
Priority Critical [ 2 ] Blocker [ 1 ]
Assignee Triage [ project admin ] Thomas Morgner [ tmorgner ]
Kurtis Cruzada made changes - 06/Oct/09 8:39 AM
Status Open [ 1 ] Open [ 1 ]
Thomas Morgner made changes - 09/Oct/09 12:12 PM
Fix Version/s 3.5.1 [ 10811 ]
Fix Version/s SUGAR [ 10723 ]
Affects Version/s 3.5.0 (CITRUS) [ 10552 ]
Thomas Morgner made changes - 09/Oct/09 12:13 PM
Status Open [ 1 ] In Progress [ 3 ]
Hide
Permalink
Thomas Morgner added a comment - 09/Oct/09 12:14 PM
Added Caching for JDBC datasources so that mondrian always sees the same instance and thus is having the same System#identityHashCode from the datasource-object.
Show
Thomas Morgner added a comment - 09/Oct/09 12:14 PM Added Caching for JDBC datasources so that mondrian always sees the same instance and thus is having the same System#identityHashCode from the datasource-object.
Hide
Permalink
Thomas Morgner added a comment - 09/Oct/09 12:33 PM
Made all the JNDI datasources use a singleton initial-context. As long as the JNDI system performs some sort of caching of DataSource objects, this should be sufficient to get some sense into Mondrian's caching algorithm.
Show
Thomas Morgner added a comment - 09/Oct/09 12:33 PM Made all the JNDI datasources use a singleton initial-context. As long as the JNDI system performs some sort of caching of DataSource objects, this should be sufficient to get some sense into Mondrian's caching algorithm.
Thomas Morgner made changes - 09/Oct/09 12:33 PM
Assignee Thomas Morgner [ tmorgner ] Kurtis Cruzada [ kcruzada ]
Status In Progress [ 3 ] Ready For Test [ 10004 ]
Hide
Permalink
Daniel Einspanjer added a comment - 09/Oct/09 1:34 PM
Thank you for the fast work on this issue, we really appreciate it.
Show
Daniel Einspanjer added a comment - 09/Oct/09 1:34 PM Thank you for the fast work on this issue, we really appreciate it.
Kurtis Cruzada made changes - 11/Nov/09 2:15 PM
Assignee Kurtis Cruzada [ kcruzada ] Golda David [ gdavid ]
Kurtis Cruzada made changes - 16/Nov/09 1:48 PM
Assignee Golda David [ gdavid ] Pedro Alves [ pmalves ]
Hide
Permalink
Priya Muraleedharan added a comment - 20/Nov/09 6:55 AM
Could you please provide steps to validate this issue.

Regards,
Priya
Show
Priya Muraleedharan added a comment - 20/Nov/09 6:55 AM Could you please provide steps to validate this issue. Regards, Priya
Hide
Permalink
Pedro Alves added a comment - 20/Nov/09 9:12 AM
Since this is assigned to me, I'll close it. I can confirm it's fixed.
Show
Pedro Alves added a comment - 20/Nov/09 9:12 AM Since this is assigned to me, I'll close it. I can confirm it's fixed.
Pedro Alves made changes - 20/Nov/09 9:12 AM
Status Ready For Test [ 10004 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
David Kincade made changes - 01/Dec/09 3:34 PM
Fix Version/s 3.6.0 M1 [ 10841 ]
Fix Version/s 3.6.0 [ 10811 ]
Kurtis Cruzada made changes - 22/Jan/10 9:12 AM
Status Resolved [ 5 ] Closed [ 6 ]
QA Validation Status Not Yet Validated Validated by QA
Marc Batchelor made changes - 06/May/10 6:49 PM
Workflow Pentaho Engineering 6.0 Workflow [ 487990 ] Pentaho Engineering 7.0 Workflow [ 500691 ]
Marc Batchelor made changes - 04/Aug/10 10:16 PM
Workflow Pentaho Engineering 7.0 Workflow [ 500691 ] Pentaho Engineering 8.0 Workflow [ 523037 ]
Transition Status Change Time Execution Times Last Executer Last Execution Date
Open Open Open Open
3d 20h 25m
1
Kurtis Cruzada
06/Oct/09 8:38 AM
Open Open Open Open
14s
1
Kurtis Cruzada
06/Oct/09 8:38 AM
Open Open Open Open
17s
1
Kurtis Cruzada
06/Oct/09 8:39 AM
Open Open In Progress In Progress
3d 3h 34m
1
Thomas Morgner
09/Oct/09 12:13 PM
In Progress In Progress Ready For Test Ready For Test
20m 14s
1
Thomas Morgner
09/Oct/09 12:33 PM
Ready For Test Ready For Test Resolved Resolved
41d 21h 38m
1
Pedro Alves
20/Nov/09 9:12 AM
Resolved Resolved Closed Closed
63d
1
Kurtis Cruzada
22/Jan/10 9:12 AM

People

Dates

  • Created:
    02/Oct/09 12:13 PM
    Updated:
    22/Jan/10 9:12 AM
    Resolved:
    20/Nov/09 9:12 AM
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Pentaho.org. Try JIRA - bug tracking software for your team.