vchinni
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by vchinni
-
-
Thanks hozawa for sharing the link. However, I do not see an issue with size limit on LDAP Soft LDAP Browser and also the search filter sAMAccountName = ${username} brings up only two accounts - catest and catest02. I'm still not sure of why we are seeing the error for this account and may have to test using other accounts as well.
-
-
I currently have an issue in running an OOTB JasperReports Server 6.2 report query in Jaspersoft Studio 6.3, which I have already raised in another thread. For now, I have downgraded to Jaspersoft Studio-6.2.2 and looking to install the license file but I don't see an option in this release. Please suggest from where I can install the license file.
-
I'm new to JasperReports development, so I'm trying to learn through OOTB reports that is packaged within Jasperreports Server 6.2. I was able to configure the adapter in Jaspersoft Studio 6.3 to communicate with Jasperreports server 6.2. I ran an OOTB report which seems to get some results and when tried to valiate the query in dataset and query window, it failed with the below error. Please suggest a solution on how I could get rid of this error to succesfully validate the query.
See below for the error output: net.sf.jasperreports.engine.JRException:
Error preparing statement for executing the report query: SELECT cr.group_name, cr.ref_num, cr.open_date, cr.priority_symbol, cr.status_symbol, cr.request_area_symbol, cr.active, cr.web_url, (PdmToday() - cr.open_date)/(7*24*3600), (PdmToday() - cr.open_date)/(24*3600), (PdmToday() - cr.open_date)/3600, (case when ((PdmToday() - cr.open_date)/(7*24*3600)) <2 then '1' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=2 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <3 then '2' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=3 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <4 then '3' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=4 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <5 then '4' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=5 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <8 then '5' when ((PdmToday() - cr.open_date)/(7*24*3600)) >=8 then '6' ELSE '' end ) as WeeksOpened, case when ((PdmToday() - cr.open_date)/(7*24*3600)) < 2 THEN 1 ELSE 0 END AS "1Week", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 2 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 3 THEN 1 ELSE 0 END AS "2Weeks", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 3 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 4 THEN 1 ELSE 0 END AS "3Weeks", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 4 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 5 THEN 1 ELSE 0 END AS "4Weeks", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 5 AND ((PdmToday() - cr.open_date)/(7*24*3600)) < 8 THEN 1 ELSE 0 END AS "30-60Days", case when ((PdmToday() - cr.open_date)/(7*24*3600)) >= 8 THEN 1 ELSE 0 END AS "Over60Days" FROM cr WHERE cr.active=1 AND cr.group_name IS NOT NULL AND cr.type = 'R' AND (cr.group_name in or '*' in ) ORDER BY cr.priority_symbol ASC, cr.open_date ASC, cr.group_name ASC at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:528) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:297) at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:79) at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:75) at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:396) at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:53) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) Caused by: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]syntax error, unexpected OR, expecting '(' at group_name ... or at com.ddtek.openaccess.ssp.Diagnostic.toSQLException(Unknown Source) at com.ddtek.openaccess.ssp.Chain.cnvDiagnostics(Unknown Source) at com.ddtek.openaccess.ssp.Chain.decodeDiagnostic(Unknown Source) at com.ddtek.openaccess.ssp.Chain.decodeBody(Unknown Source) at com.ddtek.openaccess.ssp.Chain.decode(Unknown Source) at com.ddtek.openaccess.ssp.Chain.send(Unknown Source) at com.ddtek.openaccess.ctxt.stmt.StatementContext.associate(Unknown Source) at com.ddtek.jdbc.openaccess.OpenAccessImplStatement.prepare(Unknown Source) at com.ddtek.jdbc.oabase.BaseImplStatement.prepare(Unknown Source) at com.ddtek.jdbc.oabase.BasePreparedStatement.prepareSQL(Unknown Source) at com.ddtek.jdbc.oabase.BaseStatement.preProcessSQL(Unknown Source) at com.ddtek.jdbc.oabase.BasePreparedStatement.(Unknown Source) at com.ddtek.jdbc.oabase.BaseConnection.prepareStatement(Unknown Source) at (message continues in next comment)
Enable SSL for Jaspersoft 6.2 web server using a wildcard cert file
in Products
Posted
I'm trying to enable SSL for Jaspersoft Web Server v6.2 having tomcat 8.5.x using a Wildcard cert file (*.pfx) that is currently implemented on apache tomcat for an ITSM application. if it's possible to use the same cert file then could anyone please help me with the steps to implement SSL for Jaspersoft web server?
I have tried few options so far and no luck in enabling SSL for Jaspersoft. under $CATALINA_BASE/conf/server.xml file, where $CATALINA_BASE represents the base directory for the Tomcat instanc. See below, for your reference.
Option 1