devendra.p

Hi There, We changed the datatype of our date based parameter $P{param_date} from 'java.util.Date' to 'net.sf.jasperreports.types.date.DateRange' and then created another parameter with type 'java.util.Date' which takes the default value as $P{param_date}.getStart(). This was done to enable users to pass date inputs as 'month', 'month+1','month-1', etc. After deploying the report in Jaspersoft Server, already scheduled instances of this report started to fail with error message - "Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: $P{param_date}.getStart() ... 41 more Caused by: java.lang.ClassCastException: java.util.Date cannot be cast to net.sf.jasperreports.types.date.DateRange " We had to manually re-schedule these reports which made them run successfully. However, Would like to know why the scheduled reports failed after above changes.

Hi There, We are for the first time trying to make connection to Snowflake account through TIBCO Jaspersoft® Studio Professional 7.1.0. Client has provided us: 1. Username and Password, 2. JDBC URL: jdbc:snowflake://<my_server_ip>.snowflakecomputing.com/?account=<myaccount>&warehouse=query_nonprod 3. JAR file: snowflake-jdbc-3.6.9.jar From Jaspersoft Studio, I tried to create new data adaptor following below steps. 1. Used below three JDBC driver names one by one. 2. Entered above provided JDBC URL, and credentials. 3. In Driver Classpath added the path of JAR file. I received below error messages with each JDBC Driver: I. JDBC DRIVER: cdata.jdbc.snowflake.SnowflakeDriver ========================================================================================================================================================= net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: cdata.jdbc.snowflake.SnowflakeDriver cannot be found by net.sf.jasperreports_7.1.0.final Caused by: java.lang.ClassNotFoundException: cdata.jdbc.snowflake.SnowflakeDriver cannot be found by net.sf.jasperreports_7.1.0.final II. JDBC DRIVER: com.snowflake.client.jdbc.SnowflakeDriver ========================================================================================================================================================== net.sf.jasperreports.engine.JRException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC.. Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC.. III. JDBC DRIVER: net.snowflake.client.jdbc.SnowflakeDriver =========================================================================================================================================================== net.sf.jasperreports.engine.JRException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC.. Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC.. Regards, Devendra Jakhmola

We use Jaspersoft as BI solution with CA Clarity. For past few days, while logging to Jaspersoft Server hompage for accessing organization's reports we get the distorted home page. Please find the screenshot of homepage below. Could anyone advise how to fix this. This is reported by many users in my organization.