Pentaho Report Designer

Report Designer freezes if database connection is not available

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: 3.5.0 (CITRUS)
  • Fix Version/s: 3.6.0
  • Component/s: Data Source
  • Customer Case:
  • QA Validation Status:
    Validated by QA
  • Description:
    Hide
    The customer has developed report with the Report Designer 3.5 and defined a database connection (not localhost). Later when the same report was opened, the defined database connection was no longer available and the Report Designer stopped responding. It seems that it is trying to access the database and is not giving any error messages but just freezes.

    To replicate the problem:
    Open a Report Designer, add a new query. Define the host name that is not available (e.g. 123456789). Click 'OK'. The Report Designer stops responding.
    Show
    The customer has developed report with the Report Designer 3.5 and defined a database connection (not localhost). Later when the same report was opened, the defined database connection was no longer available and the Report Designer stopped responding. It seems that it is trying to access the database and is not giving any error messages but just freezes. To replicate the problem: Open a Report Designer, add a new query. Define the host name that is not available (e.g. 123456789). Click 'OK'. The Report Designer stops responding.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Sridhar Dhanapalan added a comment - 08/Oct/09 6:07 AM
Here's a common real-world scenario that can trigger this: we developed a report for a customer in-house and then moved it to their environment. Because our test database wasn't available on their network, PRD would freeze when trying to edit the report.
Show
Sridhar Dhanapalan added a comment - 08/Oct/09 6:07 AM Here's a common real-world scenario that can trigger this: we developed a report for a customer in-house and then moved it to their environment. Because our test database wasn't available on their network, PRD would freeze when trying to edit the report.
Hide
Permalink
Kurtis Cruzada added a comment - 13/Oct/09 8:25 AM
We can't repro this on GA. Please try GA.
Show
Kurtis Cruzada added a comment - 13/Oct/09 8:25 AM We can't repro this on GA. Please try GA.
Kurtis Cruzada made changes - 13/Oct/09 8:25 AM
Field Original Value New Value
Status Open [ 1 ] Open [ 1 ]
Assignee Triage [ project admin ] Priya Muraleedharan [ pmuraleedharan ]
Priority Unknown [ 7 ] None [ 8 ]
Hide
Permalink
Priya Muraleedharan added a comment - 15/Oct/09 1:27 AM
I created a database connection with a dummy host name and saved the report. Close and open the report once again in the design view of the report designer. The Report Designer freezes and cannot edit the database connection. It is only after some time, that i was able to edit the connection settings in the Report Designer.

This was not the case with 3.0 version. I tried to replicate the same scenario in Report Designer 3.0. It did not freeze when i opened a report with dummy host name. I was able to edit the database connection without any issue.
Show
Priya Muraleedharan added a comment - 15/Oct/09 1:27 AM I created a database connection with a dummy host name and saved the report. Close and open the report once again in the design view of the report designer. The Report Designer freezes and cannot edit the database connection. It is only after some time, that i was able to edit the connection settings in the Report Designer. This was not the case with 3.0 version. I tried to replicate the same scenario in Report Designer 3.0. It did not freeze when i opened a report with dummy host name. I was able to edit the database connection without any issue.
Priya Muraleedharan made changes - 15/Oct/09 1:30 AM
Assignee Priya Muraleedharan [ pmuraleedharan ] Kurtis Cruzada [ kcruzada ]
Kurtis Cruzada made changes - 11/Nov/09 2:21 PM
Status Open [ 1 ] Open [ 1 ]
Fix Version/s 3.6.0 [ 10811 ]
Assignee Kurtis Cruzada [ kcruzada ] Thomas Morgner [ tmorgner ]
Hide
Permalink
Thomas Morgner added a comment - 11/Nov/09 3:09 PM
I dont see how we can solve that in a transparent manor. JDBC connections are intransparent to the report-designer - we only know that there is a JDBC driver. We do not know, whether it communicates over the network or with which host it may communicate, or whether that host is available or blocked by a firewall that does not return proper error codes.

Therefore the only solution I could offer is a "offline" mode, where the report-designer will actively avoid network connections (with the side-effect that preview will be unavailable and that the field-selector will not show any fields of the query) to hosts other than "localhost" or a known whitelist.
Show
Thomas Morgner added a comment - 11/Nov/09 3:09 PM I dont see how we can solve that in a transparent manor. JDBC connections are intransparent to the report-designer - we only know that there is a JDBC driver. We do not know, whether it communicates over the network or with which host it may communicate, or whether that host is available or blocked by a firewall that does not return proper error codes. Therefore the only solution I could offer is a "offline" mode, where the report-designer will actively avoid network connections (with the side-effect that preview will be unavailable and that the field-selector will not show any fields of the query) to hosts other than "localhost" or a known whitelist.
Hide
Permalink
Thomas Morgner added a comment - 11/Nov/09 3:10 PM
Lets make this issue more than a "none" issue.
Show
Thomas Morgner added a comment - 11/Nov/09 3:10 PM Lets make this issue more than a "none" issue.
Thomas Morgner made changes - 11/Nov/09 3:10 PM
Priority None [ 8 ] Critical [ 2 ]
Thomas Morgner made changes - 12/Nov/09 12:51 PM
Status Open [ 1 ] In Progress [ 3 ]
Hide
Permalink
Thomas Morgner added a comment - 12/Nov/09 12:55 PM
There is a "offline" mode setting now available. When that one is active, only connections to "localhost" are allowed.
Be aware that this blocks *all* network connections, including the publish settings, image loading and the version-checker.

The offline mode can be enabled via the commandline option "-o" (or "--offline"). A more expensive offline mode for UDP communications is available by installing a extra security manager (option "--with-offline-mode-security-manager") which is not active by default and has to be specified on the commandline everytime PRD is started.

The ordinary (non security manager) filter should already prevent almost all network connections (unless one specifies a manual proxy override when constructing a socket-object).
Show
Thomas Morgner added a comment - 12/Nov/09 12:55 PM There is a "offline" mode setting now available. When that one is active, only connections to "localhost" are allowed. Be aware that this blocks *all* network connections, including the publish settings, image loading and the version-checker. The offline mode can be enabled via the commandline option "-o" (or "--offline"). A more expensive offline mode for UDP communications is available by installing a extra security manager (option "--with-offline-mode-security-manager") which is not active by default and has to be specified on the commandline everytime PRD is started. The ordinary (non security manager) filter should already prevent almost all network connections (unless one specifies a manual proxy override when constructing a socket-object).
Thomas Morgner made changes - 12/Nov/09 12:55 PM
Status In Progress [ 3 ] Ready For Test [ 10004 ]
Assignee Thomas Morgner [ tmorgner ] Kurtis Cruzada [ kcruzada ]
Hide
Permalink
Kurtis Cruzada added a comment - 03/Dec/09 3:59 PM
Thomas... I set the report designer to offline and I'm not able to connect to my localhost sampledata.
Show
Kurtis Cruzada added a comment - 03/Dec/09 3:59 PM Thomas... I set the report designer to offline and I'm not able to connect to my localhost sampledata.
Kurtis Cruzada made changes - 03/Dec/09 3:59 PM
Status Ready For Test [ 10004 ] Reopened [ 4 ]
Assignee Kurtis Cruzada [ kcruzada ] Thomas Morgner [ tmorgner ]
Kurtis Cruzada made changes - 03/Dec/09 3:59 PM
Status Reopened [ 4 ] Open [ 1 ]
Thomas Morgner made changes - 07/Dec/09 4:01 PM
Status Open [ 1 ] In Progress [ 3 ]
Hide
Permalink
Thomas Morgner added a comment - 07/Dec/09 4:02 PM
Localhost was not on the whitelist. Now it is
Show
Thomas Morgner added a comment - 07/Dec/09 4:02 PM Localhost was not on the whitelist. Now it is
Thomas Morgner made changes - 07/Dec/09 4:02 PM
Status In Progress [ 3 ] Ready For Test [ 10004 ]
Assignee Thomas Morgner [ tmorgner ] Kurtis Cruzada [ kcruzada ]
Kurtis Cruzada made changes - 11/Jan/10 2:02 PM
Status Ready For Test [ 10004 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
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 [ 488107 ] Pentaho Engineering 7.0 Workflow [ 500760 ]
Marc Batchelor made changes - 04/Aug/10 10:17 PM
Workflow Pentaho Engineering 7.0 Workflow [ 500760 ] Pentaho Engineering 8.0 Workflow [ 523107 ]
Transition Status Change Time Execution Times Last Executer Last Execution Date
Open Open Open Open
5d 3h 31m
1
Kurtis Cruzada
13/Oct/09 8:25 AM
Open Open Open Open
29d 6h 55m
1
Kurtis Cruzada
11/Nov/09 2:21 PM
Open Open In Progress In Progress
22h 30m
1
Thomas Morgner
12/Nov/09 12:51 PM
In Progress In Progress Ready For Test Ready For Test
3m 56s
1
Thomas Morgner
12/Nov/09 12:55 PM
Ready For Test Ready For Test Reopened Reopened
21d 3h 4m
1
Kurtis Cruzada
03/Dec/09 3:59 PM
Reopened Reopened Open Open
8s
1
Kurtis Cruzada
03/Dec/09 3:59 PM
Open Open In Progress In Progress
4d 2m
1
Thomas Morgner
07/Dec/09 4:01 PM
In Progress In Progress Ready For Test Ready For Test
18s
1
Thomas Morgner
07/Dec/09 4:02 PM
Ready For Test Ready For Test Resolved Resolved
34d 22h
1
Kurtis Cruzada
11/Jan/10 2:02 PM
Resolved Resolved Closed Closed
10d 19h 9m
1
Kurtis Cruzada
22/Jan/10 9:12 AM

People

Dates

  • Created:
    08/Oct/09 4:54 AM
    Updated:
    22/Jan/10 9:12 AM
    Resolved:
    11/Jan/10 2:02 PM
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.