linvicch

u can configure in jasper server properties file

oracle 10G Around 1100 tables some of which around 200 are materialise view I have not play around with the sample domain recently but from memory it did not cause an issue Would the number of tables be the cause here?

What is up with the horrible horrible performance of jasperserver domain. Takes me 15 minutes just to open up an existing domain for edit

We have a crosstab where the exact number of rows and columns is unknown but has a upper limit there will be a maximum of 100 columns. its a csv report When we run this report, the columns got truncated. Is there a report parameter / config that can be changed to not limit the number of columns exported?

Hi Andrew, I have made some changes as well as debug the except. now everything works and I can see all tables and fields, synonyms or non-synonyms. Changed the treeset to a linkedlist and create a filter on the table names where the name != "/". This implies that the driver is working fine? Connected! AC_ACCOUNT ID : 3 : NUMBER ID : 3 : NUMBER CONTACT_ID : 3 : NUMBER CONTACT_ID : 3 : NUMBER UPDATE_USER : 3 : NUMBER UPDATE_USER : 3 : NUMBER UPDATE_DATE : 91 : DATE UPDATE_DATE : 91 : DATE UPDATE_VERSION : 3 : NUMBER UPDATE_VERSION : 3 : NUMBER ACCOUNT_TYPE : 3 : NUMBER ACCOUNT_TYPE : 3 : NUMBER CURRENCY_ID : 3 : NUMBER CURRENCY_ID : 3 : NUMBER RESERVED_VALUE_FLAG : 3 : NUMBER RESERVED_VALUE_FLAG : 3 : NUMBER AGENT_NUMBER : 12 : VARCHAR2 AGENT_NUMBER : 12 : VARCHAR2 BANK_ACCOUNT_ID : 3 : NUMBER BANK_ACCOUNT_ID : 3 : NUMBER PAYMENT_PLAN_ID : 3 : NUMBER PAYMENT_PLAN_ID : 3 : NUMBER PAYMENT_DAY : 3 : NUMBER PAYMENT_DAY : 3 : NUMBER BRAND_COMPANY_ID : 3 : NUMBER BRAND_COMPANY_ID : 3 : NUMBER POLICY_HEADER_ID : 3 : NUMBER POLICY_HEADER_ID : 3 : NUMBER CLAIM_ID : 3 : NUMBER CLAIM_ID : 3 : NUMBER GL_ACCOUNT_ID : 3 : NUMBER GL_ACCOUNT_ID : 3 : NUMBER FREEZE_DATE : 91 : DATE FREEZE_DATE : 91 : DATE FREEZE_START_DATE : 91 : DATE FREEZE_START_DATE : 91 : DATE MAIN_AGENT_ACCOUNT_ID : 3 : NUMBER MAIN_AGENT_ACCOUNT_ID : 3 : NUMBER HANDLING_CONTACT_ID : 3 : NUMBER HANDLING_CONTACT_ID : 3 : NUMBER HANDLING_ACCOUNT_ID : 3 : NUMBER HANDLING_ACCOUNT_ID : 3 : NUMBER DEFAULT_ENTRY_STATUS_ID : 3 : NUMBER DEFAULT_ENTRY_STATUS_ID : 3 : NUMBER PAYMENT_DELAY_POINT : 3 : NUMBER PAYMENT_DELAY_POINT : 3 : NUMBER PAYMENT_DELAY : 3 : NUMBER PAYMENT_DELAY : 3 : NUMBER PAYMENT_TYPE : 3 : NUMBER PAYMENT_TYPE : 3 : NUMBER MASTER_POLICY_HEADER_ID : 3 : NUMBER MASTER_POLICY_HEADER_ID : 3 : NUMBER EXTERNAL_NUMBER : 12 : VARCHAR2 EXTERNAL_NUMBER : 12 : VARCHAR2 IS_LOCKED_BY_BILLING_PROC : 3 : NUMBER IS_LOCKED_BY_BILLING_PROC : 3 : NUMBER WH_TRANSFER_ID : 3 : NUMBER WH_TRANSFER_ID : 3 : NUMBER AC_ACCOUNT_RACI ID : 3 : NUMBER ID : 3 : NUMBER LAST_STATEMENT_RUN_DATE : 91 : DATE LAST_STATEMENT_RUN_DATE : 91 : DATE WH_TRANSFER_ID : 3 : NUMBER WH_TRANSFER_ID : 3 : NUMBER ID : 3 : NUMBER LAST_STATEMENT_RUN_DATE : 91 : DATE WH_TRANSFER_ID : 3 : NUMBER AC_AGENT_DETAIL ID : 3 : NUMBER ID : 3 : NUMBER ACCOUNT_ID : 3 : NUMBER ACCOUNT_ID : 3 : NUMBER public static void main(String[] args) throws Exception { if (true) { readProperties("H:\\oracle_synonyms\\oracle.properties"); } else { System.out.println("No Property file !"); System.exit(1); } Class driverClass = Class.forName(driver); Connection conn = DriverManager.getConnection(connStr, user, pass); // Oracle specific if (true) { ((oracle.jdbc.OracleConnection) conn).setIncludeSynonyms(true); } DatabaseMetaData md = conn.getMetaData(); System.out.println("Connected!"); List<String> tables = new LinkedList<String>(); { ResultSet rs = null; try { rs = md.getTables(null, schema, tablepattern, TABLE_TYPES); while (rs.next()) { String tableName = rs.getString("TABLE_NAME"); //System.out.println(tableName); tables.add(tableName); } } finally { if (rs != null) { try { rs.close(); } catch (Exception ex) { } } } } for (String tableName : tables) { if (tableName.indexOf("/")==-1) { System.out.println(tableName); ResultSet rs = null; try { rs = md.getColumns(null, schema, tableName, null); while (rs.next()) { String colName = rs.getString("COLUMN_NAME"); int typeCode = rs.getInt("DATA_TYPE"); String dbVendorType = rs.getString("TYPE_NAME"); System.out.println(" " + colName + " : " + typeCode + " : " + dbVendorType); } } finally { if (rs != null) { try { rs.close(); } catch (Exception ex) { } } } } } conn.close(); }

Hi, I would like to pass the returned value of a sciplet into the default expression of a parameter. It doesn't seem to work.. this is what I have done parameter: flag-> java.lang.Integer default expression:new Integer(ReportTrigger.getFlag()) and on my filter expression I have new Boolean($P{flag}.intValue()==1?true:false) I can't populate the filter expression with a parameter that reads in a scriplet?

Hi Andrew, There is error with displaying the fields and the except thrown is From reading the code I think it should print out all table names then all the fields following table1 table2 table1.field1 table1.field2 table2.field1 table2.field2 my result are as followed T_ASSET_DATA_SOURCE T_ASSET_INSURANCE_FORMULA T_ASSET_ITEM_TYPE T_ASSET_RISK So you believe the issue lies with the driver? Exception in thread "main" java.sql.SQLException: ORA-01424: missing or illegal character following the escape character at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:218) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:969) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1071) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:853) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1153) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3369) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3414) at oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:273) at test.GetMetaData.main(GetMetaData.java:68)

Hi Andrew, The script ran fine and I can see all tables irregardless of setIncludeSynonyms(true) or setIncludeSynonyms(false). When i add my domain, I can see all the tables but the issue only arise when I drag a synonym table from the left to the right. Thats when the error appear "At present time tables which doesn't contain any columns are not supported.Following empty tables will not be added" . This piece of code seem to be used to display the tables. Would you be able to send me the code that listens to the event when a user drag a table from the left selection to the right?

Hi Andrew, thank you for taking time in assisting us :) jasperserver 3.5 pro (OEM) oracle 10g ojdbc14-10.2.0 apache-tomcat-5.5.28 the driver is placed on the server level. would that make a difference? -> common/lib I am 100% sure the synonyms and table are correctly created as they are currently in used by our reports. There is nothing logged on that error as well.. the last log was 10:32:52,357 WARN LoggerListener,http-8080-Processor19:55 - Authentication event AuthenticationSuccessEvent: jasperadmin; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@fffc7f0c: RemoteIpAddress: 172.16.5.35; SessionId: D4225850F8A690C60743F279CD24B5F9 10:32:52,359 WARN LoggerListener,http-8080-Processor19:55 - Authentication event InteractiveAuthenticationSuccessEvent: jasperadmin; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@fffc7f0c: RemoteIpAddress: 172.16.5.35; SessionId: D4225850F8A690C60743F279CD24B5F9

Hi As per instructed, i have modified <property name="includeSynonymsForOracle"> <!-- set 'true' if you use Oracle synonyms in Domains --> <value>true</value> </property> my synonyms table works BUT NOW my non Synonyms table doesn't work throwing me the error At present time tables which doesn't contain any columns are not supported. Following empty tables will not be added

By slow in performance, what will that affect? Does it affect the performance of future query or only on initial setup? Thank you :D karma deserving :p Post Edited by linvicch at 02/17/2010 02:07

I receive this error, At present time tables which doesn't contain any columns are not supported. The table for the domain is a synonym on oracle 10g. From the thead above this seem to be a bug. we are using Jasperserver pro 3.5(oem). Is this issue fixed yet? No event triggered scheduling and if it doesn't even support synonyms, its time to look at other options >.<

Hi mpenningroth, I have manage to get the jasperserver xml/A client to connect. All that was needed was a restart of the server. I have a oem version of JS-pro from our vendor. From the sound of it, Jaspersoft odbo should be the same as simba which is the driver I am using. At this point I am certain that my xml/A is properly configured. I am also certain that my simba driver is properly configured as I am able to successfully connect to xml/A, able to view its schema and cube. I was also able to successfully connect using excel 2007 if i keep on re-trying the connect after it threw a "unable to initialize datasource error". Thank you for taking time in helping me out. Sadly none of the jaspersoft administrator seem to know much about this. Thak you once again

Extremely frustrating Does JS support all ODBO driver or only jaspersoft odbo? Is there an evaluation version of jaspersoft ODBO? Can jaspersoft ODBO be used with any other product such as business object? We have a oem version of JS pro. does that come with jaspersoft odbo? Any form of reply will be helpful as there has been nothing helpful at all so far Thanks :)

Hi Andrew, I can't seem to find any more detail on the exception. The error I received is from excel. I am going to work on the assumption that jaspersoft doesn't like simba odbo very much and perhaps give jasper odbo a shot. As mentioned on my first post, everything seem to connect find, i am able to "see" the cube and when I use excel 2007, it gave me the same error but if I keep on trying, eventually it will allow me through. I have a tcp trace if that help. It says authentication error, but i have provide all the necessary authentication required which is require thats why I am able to view the cube. HTTP/1.1 100 Continue HTTP/1.1 401 Unauthorized Server: Apache-Coyote/1.1 Set-Cookie: JSESSIONID=1B421DA5DB004D0CD151FA0F2F44D4D3; Path=/jasperserver-pro WWW-Authenticate: Basic realm="Protected Area" Content-Type: text/html;charset=utf-8 Content-Length: 1119 Date: Fri, 29 Jan 2010 02:53:22 GMT HTTP Status 401 - Full authentication is required to access this <html><head><title>Apache Tomcat/5.5.28 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 401 - Full authentication is required to access this resource</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Full authentication is required to access this resource</u></p><p><b>description</b> <u>This request requires HTTP authentication (Full authentication is required to access this resource).</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/5.5.28</h3></body></html>HTTP/1.1 100 Continue Post Edited by linvicch at 01/31/2010 04:44