Too many errors in log file
12 July, 2013
Hi David,
Plz look into attached print screen and tell me what is this problem exactly and how to resolve the same.
While debugging above DB connection popup alert issue I've found following error log in catalina.out file. Can you plz tell me what causes the following errors?
1) Invalid row number (65536) outside allowable range (0..65535) - Is this will create problems while Exporting Report?
YF:2013-07-11 22:07:17:ERROR (XlsExporter:A) - java.lang.IllegalArgumentException: Invalid row number (65536) outside allowable range (0..65535)
YF:2013-07-11 22:07:17:ERROR (ReportBroadcastProcess:A) - Error sending report: java.lang.NullPointerException
YF:2013-07-11 22:07:17:ERROR (DBAction:A) - Error occured creating DB Statement: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (DBAction:doInsert) - Error occured doing insert: java.lang.Exception: DBAction.createStatement() exception
YF:2013-07-11 22:07:17:ERROR (EventManager:insertEvent) - Errors occured inserting into Event: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (EventManager:insertEvent) - SQL Stmt:
YF:2013-07-11 22:07:17:ERROR (EventManager:createEvent) - Error: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (DBAction:commit) - Error occured performing commit: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (DBAction:disconnect) - Error occured when disconnecting from the database: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (TaskScheduler:A) - java.lang.Exception: DBAction.commit() exception
2) Table 'yellowfin.iprltshp' doesn't exist
YF:2013-07-11 22:38:28:ERROR (DBAction:doSelect) - Error occured selecting data: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'yellowfin.iprltshp' doesn't exist
YF:2013-07-11 22:38:28:ERROR (ReportViewSourceManager:clientSourceForClientOrg) - Errors occured obtaining ReportViewSourceBeans: Exception selecting data from database
YF:2013-07-11 22:38:28:ERROR (ReportViewSourceManager:clientSourceForClientOrg) - SQL Stmt:
Thanks
Plz look into attached print screen and tell me what is this problem exactly and how to resolve the same.
While debugging above DB connection popup alert issue I've found following error log in catalina.out file. Can you plz tell me what causes the following errors?
1) Invalid row number (65536) outside allowable range (0..65535) - Is this will create problems while Exporting Report?
YF:2013-07-11 22:07:17:ERROR (XlsExporter:A) - java.lang.IllegalArgumentException: Invalid row number (65536) outside allowable range (0..65535)
YF:2013-07-11 22:07:17:ERROR (ReportBroadcastProcess:A) - Error sending report: java.lang.NullPointerException
YF:2013-07-11 22:07:17:ERROR (DBAction:A) - Error occured creating DB Statement: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (DBAction:doInsert) - Error occured doing insert: java.lang.Exception: DBAction.createStatement() exception
YF:2013-07-11 22:07:17:ERROR (EventManager:insertEvent) - Errors occured inserting into Event: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (EventManager:insertEvent) - SQL Stmt:
YF:2013-07-11 22:07:17:ERROR (EventManager:createEvent) - Error: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (DBAction:commit) - Error occured performing commit: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (DBAction:disconnect) - Error occured when disconnecting from the database: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 22:07:17:ERROR (TaskScheduler:A) - java.lang.Exception: DBAction.commit() exception
2) Table 'yellowfin.iprltshp' doesn't exist
YF:2013-07-11 22:38:28:ERROR (DBAction:doSelect) - Error occured selecting data: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'yellowfin.iprltshp' doesn't exist
YF:2013-07-11 22:38:28:ERROR (ReportViewSourceManager:clientSourceForClientOrg) - Errors occured obtaining ReportViewSourceBeans: Exception selecting data from database
YF:2013-07-11 22:38:28:ERROR (ReportViewSourceManager:clientSourceForClientOrg) - SQL Stmt:
Thanks
Please include following too
3) No operations allowed after connection closed. - Is connection pooling working fine in Yellowfin? because i see 15-20 mysql db connections has been inactive for too long time on "yellowfin" database
YF:2013-07-11 04:34:11:ERROR (DBAction:doSelect) - Error occured selecting data: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
YF:2013-07-11 04:34:11:ERROR (ReportRunner:L) - Error retrieving results: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 04:34:11:ERROR (DBAction:disconnect) - Error occured when disconnecting from the database: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
3) No operations allowed after connection closed. - Is connection pooling working fine in Yellowfin? because i see 15-20 mysql db connections has been inactive for too long time on "yellowfin" database
YF:2013-07-11 04:34:11:ERROR (DBAction:doSelect) - Error occured selecting data: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
YF:2013-07-11 04:34:11:ERROR (ReportRunner:L) - Error retrieving results: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
YF:2013-07-11 04:34:11:ERROR (DBAction:disconnect) - Error occured when disconnecting from the database: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
Hi,
Please see comments below on the errors you have seen;
1) This happens when you are exporting to XLS when the number of rows exceeds the max XLS row size. You cannot export a report with more than 65,535 rows.
You should be able to export to CSV.
2) This error is stating it cannot find a system table in the Yellowfin DB.
These tables need to exist in Yellowfin, so suprised that you would see this.
3) This is a message stating the connection to the DB has been lost.
This is usually a 'follow-on' error, e.g. The DB connection has timed out, so all other requests to the database trying to use that connection will show that error.
This could also be the reason by you see the error in 2).
For any connection problems, you should check the JDBC & Source log files . More information on what each log contains can be found here :
Yellowfin 5.0 logging
These are usually caused by timeout issues.
More information on DB connections, including how to configure the timeout settings, please see here :
How Yellowfin uses connections to the DB (connection pooling)
Please let me know your findings.
Regards,
David
Please see comments below on the errors you have seen;
1) This happens when you are exporting to XLS when the number of rows exceeds the max XLS row size. You cannot export a report with more than 65,535 rows.
You should be able to export to CSV.
2) This error is stating it cannot find a system table in the Yellowfin DB.
These tables need to exist in Yellowfin, so suprised that you would see this.
3) This is a message stating the connection to the DB has been lost.
This is usually a 'follow-on' error, e.g. The DB connection has timed out, so all other requests to the database trying to use that connection will show that error.
This could also be the reason by you see the error in 2).
For any connection problems, you should check the JDBC & Source log files . More information on what each log contains can be found here :
Yellowfin 5.0 logging
These are usually caused by timeout issues.
More information on DB connections, including how to configure the timeout settings, please see here :
How Yellowfin uses connections to the DB (connection pooling)
Please let me know your findings.
Regards,
David