[SAXException: Bad envelope tag: html]

 

I've seens ome issues with this error from back i the 3.x versions of iReport. I'm using iReport 4.7.0, Jasperserver Product Version: 4.0.0 Build: 20110202_0654.

 

When I try to publish a report created in iReport 4.0.0, i get this error:

 

Error:

; nested exception is:

org.xml.sax.SAXException: Bad envelope tag: html

 

Anyone know what's causing this and how to resolve it? My respository is correct with http://localhost:8080/jasperserver/services/repository

 

 

[Run a query through webservice?]

 Is it possible to suppply a query to jasper and retrieve an answer set via the webservice? If so is there any examples of this? I have a sharepoint that has no DSN to the data warehouse available, only SOAP/XML. We need to query for data from forms in real-time and the Jasperserver jdbc connection would be a fantastic solution. Is this possible?

[Input Control: Specify a valid value for type Date]

I ran into a similar issue trying to supply a standard ISO date to Teradata using the java.util.date parameter. I needed to supply starting and ending date in format as '2012-09-01' but it kept passing the longer format and resulting in errors. The solution was to format the date in the where clause.

 

In my case:

 

SELECT

*

FROM

VIEW.TAB

WHERE Tab.Col = '$P{Start_Date}' (Date, Format 'yyyy-mm-dd')

[JasperReport parameters works in iReport but fails on JasperServer with input control]

 Is the name of the parameter you created in iReport exactly the same as the ID of the control in the respository? I had this exact same problem starting out, and it was from using an underscore in the repo but not in the parameter name in iReport

[No expression for the array constructor call]

 

 

Disregard, I got this woeking by just using the final parameter in my query, so the report is working...

 

I'd still love to know whhy its failing when I try to use $X{param1,param2} with a collection type parameter

[No expression for the array constructor call]

I'm trying to build a report with cascading paramters and my last parameter that would return a list of managers based on area-managers is causing some issues.

I have a parameter Select_AD_Name_from_list which is populated on jasperserver by a query. This control is working fine in the report.

The second parameter "Select_Manager" is causing issues. When I set it to a string, the dropdown is showing the correct names per the query (which uses $P{Select_AD_Name_from_list} as a filter in the query). The report will try to run if I set this parameter to string, but will fail in the query since it needs $X to populate. But if I set this parameter to a Collection and use the expression

new ArrayList(Arrays.asList(new String[] {“a”}))

It fails to compile with the error:

 
     net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
calculator_AD32Manager32Agent32Drill32Down_1307728316127_643967: 175: No expression for the array constructor call at line: 175 column: 76. File: calculator_AD32Manager32Agent32Drill32Down_1307728316127_643967 @ line 175, column 76.
1 error

What am I doing wrong here?

[Hyperlink to drilldown not working]

I'm still struggling with this , is there anyone that can offer a suggestion?

[Hyperlink to drilldown not working]

Anyone able to offer any suggestions?

[Hyperlink to drilldown not working]

I've read through the forum posts I could find and followed posted instructions but I'm not able to get a hyperlinked field to work correctly.

 

I have a dashboard that contains a subreport. in the subreport I've set a field $F{agent_id} as a hyperlink to point to another report that will serve as a drilldown. In the subreport I've added the parameter $P{AGENT_ID_PARAM}. My drill down report has a matching parameter.

The drilldown works fine on its own, I can run it on the sever, it prompts for agent_id and runs fine. When I click the hyperlink in the subreport of the dashboard, I'm getting the below error. I've checked and double checked the repo: path to this drill down report and confirmed the XML shows it correctly.

The xml in the subreport appears to be correct, showing the repo: path that the target report has when viewing the navigator.

 

<detail>
  <band height="20" splitType="Stretch">
   <textField hyperlinkType="ReportExecution">
    <reportElement x="0" y="0" width="100" height="20"/>
    <textElement/>
    <textFieldExpression class="java.lang.String"><![CDATA[$F{agent_id}]]></textFieldExpression>
    <hyperlinkParameter name="_report">
     <hyperlinkParameterExpression><![CDATA["repo:/subreports/offenders_drill_down_files/offenders_drill_down_jrxml"]]></hyperlinkParameterExpression>
    </hyperlinkParameter>
    <hyperlinkParameter name="AGENT_ID_PARAM">
     <hyperlinkParameterExpression><![CDATA[$P{AGENT_ID_PARAM}]]></hyperlinkParameterExpression>
    </hyperlinkParameter>
   </textField>
   <textField>

 

The path from the Repository Navigator when viewing properties of the target report:

/subreports/offenders_drill_down_files/offenders_drill_down_jrxml

 

 

The xml from the target drill-down report appears to match:

 

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Offenders Drill Down" language="groovy" pageWidth="2120" pageHeight="555" orientation="Landscape" columnWidth="2120" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
 <property name="ireport.zoom" value="1.0"/>
 <property name="ireport.x" value="0"/>
 <property name="ireport.y" value="0"/>
 <parameter name="AGENT_ID_PARAM" class="java.lang.String">
  <parameterDescription><![CDATA[Agent ID]]></parameterDescription>
 </parameter>
 <queryString>

 

 

 

Any suggestions or ideas ?

Post Edited by dolm at 06/07/2011 14:34

Code:

The server has encountered an error. Please excuse the inconvenience. Error Messagejava.lang.IllegalArgumentException: No matching action map for resource class offenders_drill_down_jrxmlError Tracejava.lang.IllegalArgumentException: No matching action map for resource class offenders_drill_down_jrxml	at com.jaspersoft.jasperserver.war.action.ResourceTypeMappingAction.doPreExecute(ResourceTypeMappingAction.java:51)	at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:186)	at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)	at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79)	at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)	at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145)	at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)	at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101)	at org.springframework.webflow.engine.State.enter(State.java:194)	at org.springframework.webflow.engine.Flow.start(Flow.java:535)	at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:364)	at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:234)	at org.springframework.webflow.engine.SubflowState.doEnter(SubflowState.java:101)	at org.springframework.webflow.engine.State.enter(State.java:194)	at org.springframework.webflow.engine.Transition.execute(Transition.java:227)	at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391)	at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)	at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:560)	at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386)	at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)	at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230)	at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196)	at org.springframework.webflow.engine.Flow.resume(Flow.java:545)	at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259)	at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163)	at sun.reflect.GeneratedMethodAccessor195.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	at $Proxy17.resumeExecution(Unknown Source)	at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183)	at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174)	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)	at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)	at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)	at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)	at java.lang.Thread.run(Thread.java:662) About JasperReports Server Copyright © 2000-2011 Jaspersoft Corpora

Post Edited by dolm at 06/07/2011 14:35

[JasperServer 4.0.0 on Ubuntu 11.04 - login not loading]

I ran the buildomatic script which after figuring out some of the correct setup worked ok, after running it a couple times. There was some issues with it failing on database creation..it would drop the db after prompting to do so, then build it, then fail saying it wasnt found. Ran the script again and it installed completely. No idea what was going on there.

 

I used an existing MySQL5 installation, existing Tomcat6. Make sure you have updated your Ubuntu install (specificaly check that you have Ant 1.8.x)

 

With iReport (4.0.2), my biggest issue is the fact you can't use it very well if you're not a coder/developer type. I'm no coder and don't plan to be. Why have a beautiful GUI and still require script/code and 4 hours of hammering to accomplish what I can do in Excel in 10 minutes? (Just my opinion, bear in mind I'm not a coder)

Also, publishing to your Jasper instance is a serious pain when it comes to subreports. Working with them locally, the subreport dir path and path to each referenced subreport is entered as either a direct path, or relative with a parameter in the XML. No where could I find this documented, so I had to scour half-explained posts to figure out how to change the path info to get subreports to work on the server.

 

That brings to point another issue with these forums. If you search for a phrase with more than a couple of words you'll get no results.

 

[JasperServer 4.0.0 on Ubuntu 11.04 - login not loading]

Sorry.. were running 10.0.4 64 bit.seemed stable enough but a data set of more than 75 rows or so will choke IE. We've since started testing Pentaho BI due to limitations with the iReport software and the messed up way subreports work.

[Simple Groovy expressions not working]

This is still messed up. My bar chart is showing all centers, with 2 bars for each, showing valid and invalid, but it looks like all lines are scaled to the max value. For example, one center that only has a total of 4 rows in my query result is scaled showing 36 and 6 on the bars values. What gives?

[Simple Groovy expressions not working]

I figured out my issue but now i need to figure out how to change the color of the bars..anyone know?

 

[Simple Groovy expressions not working]

I figured out part of my problem, I changed Category to $F{DISPATCH_VALIDITY} == "Valid"

And the value expression to $V{REPORT_COUNT} but this gives me two categories with multiple series of True / False

Post Edited by dolm at 05/30/2011 14:00

[Simple Groovy expressions not working]

I'm trying to build simple charts and I cant seem to get these expressions to work. My data has a field DISPATCH_VALIDITY that has a value of either Valid or Invalid. I need a bar chart that has each center name, with two series (total count) for "Valid" and "Invalid".

My first series is ---

Series expression:

$F{AGENT_CENTER}

Category expression:

$F{AGENT_CENTER}

Value expression:

$F{DISPATCH_VALIDITY} == "Valid"

 

 

This fails with the error:

Error filling print... Error evaluating expression : 
    Source text : $F{DISPATCH_VALIDITY} == "Valid"

 

 

What am I doing wrong? Is there a tutorial somewhere to help with learning Groovy expressions?

 

[JDBC MySQL data connection failing after successful install 4.0.0]

Ernestoo,

 

I enabled loggingto check as you suggested and nothing is populating in the log file. I'm not sure I'd be able to watch pakets because this db is used for other things and has a constant flux of some 200 users generating traffic on it.

[Trouble formatting date to acceptable format for our db]

 

 

Anyone? Hello?  Still haivng trouble with iReport not supplying my date parameterin the pattern i specified. No matter what I've tried, it allways supplies the date in the long format mentioned above.

Post Edited by dolm at 05/26/2011 15:00

[problem in exporting data to Excel file]

Mannig,

 

There is an option to disable text wrapping in cells, check here:

http://jasperforge.org/website/jasperreportswebsite/trunk/config.reference.html?group_id=252

 

[Trouble formatting date to acceptable format for our db]

 

 

I'm trying to format the date for my query in a paramater(java.util.Date) as 'YYYY-mm-dd' when i set this as a custom pattern, iReport is still supplying the query with the long format as:

Mon May 02 00:00:00 CDT 2011

what does it take to format the way I need?

[JDBC MySQL data connection failing after successful install 4.0.0]

Anyone at all? Any ideas what to look at?

[JDBC MySQL data connection failing after successful install 4.0.0]

I have installed jasper server on a completely different server and as before, the install is successful, yet the sample jdbc datasource is failing to connect.

 

Does anyone have any idea what might be going on?

[Teradata JDBC works in server, not in iReport, vice versa with mysql jdbc]

Disregard this post, i figured out i was missing a configuration jar that comes with the driver, added it and restarted iReport and its working now.

 

Still have issues with the local mysql jdb on the server but thats posted in the jasper reports server forum.

[Teradata JDBC works in server, not in iReport, vice versa with mysql jdbc]

iReport spits this out when i try to connect to our teradata with jdbc. I've added the driver jars and all, and the jdbc in jasper server is working fine.

Exception
 

Message:
    java.lang.NullPointerException
Level:
    SEVERE
Stack Trace:
null
    com.teradata.tdgss.jtdgss.TdgssConfigApi.GetMechanisms(Unknown Source)
    com.teradata.tdgss.jtdgss.TdgssManager.<init>(Unknown Source)
    com.teradata.tdgss.jtdgss.TdgssManager.getInstance(Unknown Source)
    com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM(GenericTeraEncrypt.java:623)
    com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:641)
    com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:734)
    com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
    com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
    com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
    com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:218)
    com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
    com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
    com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:127)
    com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:219)
    com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:152)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:447)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    java.awt.EventQueue.access$000(Unknown Source)
    java.awt.EventQueue$1.run(Unknown Source)
    java.awt.EventQueue$1.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue$2.run(Unknown Source)
    java.awt.EventQueue$2.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.Dialog$1.run(Unknown Source)
    java.awt.Dialog$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Unknown Source)
    java.awt.Component.show(Unknown Source)
    java.awt.Component.setVisible(Unknown Source)
    java.awt.Window.setVisible(Unknown Source)
    java.awt.Dialog.setVisible(Unknown Source)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonNewParameterActionPerformed(ConnectionsDialog.java:578)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$400(ConnectionsDialog.java:47)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$7.actionPerformed(ConnectionsDialog.java:221)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    java.awt.EventQueue.access$000(Unknown Source)
    java.awt.EventQueue$1.run(Unknown Source)
    java.awt.EventQueue$1.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue$2.run(Unknown Source)
    java.awt.EventQueue$2.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.Dialog$1.run(Unknown Source)
    java.awt.Dialog$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Unknown Source)
    java.awt.Component.show(Unknown Source)
    java.awt.Component.setVisible(Unknown Source)
    java.awt.Window.setVisible(Unknown Source)
    java.awt.Dialog.setVisible(Unknown Source)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651)
    com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46)
    org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118)
    org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77)
    org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    java.awt.EventQueue.access$000(Unknown Source)
    java.awt.EventQueue$1.run(Unknown Source)
    java.awt.EventQueue$1.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue$2.run(Unknown Source)
    java.awt.EventQueue$2.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source)

 

[JDBC MySQL data connection failing after successful install 4.0.0]

My data connection (the same ones used to build and populate the sample data and tables) is failing within Jasper server. I have a teradata jdbc connection that is working fine. The jasperreports server is located on the same machine as the mysql server. I set the script to use the ip address and default port 3306, which worked fine. I've tried editing the connection to use the ip insteadl of localhost and it still fails.

 The sample connection/db is configured as

Driver: com.mysql.jdbc.Driver

URL: jdbc:mysql://localhost:3306/sugarcrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true

Is there somewhere to view logs to see whats failing, anyone have any idea what to look at?

Post Edited by dolm at 05/20/2011 13:41

[Teradata JDBC works in server, not in iReport, vice versa with mysql jdbc]

My mysql jdbc setting shave stopped working. When I got jasperreports server installed, the connects to the sample databases were testing ok. Now when im trying to actually build reports, they are not. the same is true for the actual production db im trying to use.

 

Oddly, in iReports the connections to my production db in mysql work fine, but once i upload the report it doesnt work, since the jdbc is not working now.

 

The converse is true with iReports and my teradata jdbc. The connection is working fine in the server, but nothing i do will get it to connect in iReports in windows.

 

Any suggestions?

Post Edited by dolm at 05/19/2011 19:00