Hi guys, We have EP Portal 7.0 EHP1 SP6, We are having problems when we tray to generate reports from forum installed in the portal, this it the error details.
2010.09.09 11:34:02 [error] Cannot fetch column 1, which has JDBC type BIGINT, into a Java variable of type int.
com.sap.sql.log.OpenSQLException: Cannot fetch column 1, which has JDBC type BIGINT, into a Java variable of type int.
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)
at com.sap.sql.types.TypedResultColumn.fetchError(TypedResultColumn.java:74)
at com.sap.sql.types.TypedResultColumn.getInt(TypedResultColumn.java:91)
at com.sap.sql.jdbc.common.CommonResultSet.getInt(CommonResultSet.java:369)
at com.jivesoftware.forum.stats.report.QuestionResolutionTime.execute(QuestionResolutionTime.java:62)
at com.jivesoftware.base.stats.AbstractReportRunner.doRun(AbstractReportRunner.java:232)
at com.jivesoftware.util.AbstractPollableRunnable.run(AbstractPollableRunnable.java:97)
at com.jivesoftware.base.stats.StatsTaskEngine$TaskEngineWorker.run(StatsTaskEngine.java:318)
2010.09.09 11:34:02 [error] com.sap.sql.log.OpenSQLException: Cannot fetch column 1, which has JDBC type BIGINT, into a Java variable of type int.
com.jivesoftware.base.JiveRuntimeException: com.sap.sql.log.OpenSQLException: Cannot fetch column 1, which has JDBC type BIGINT, into a Java variable of type int.
at com.jivesoftware.forum.stats.report.QuestionResolutionTime.execute(QuestionResolutionTime.java:97)
at com.jivesoftware.base.stats.AbstractReportRunner.doRun(AbstractReportRunner.java:232)
at com.jivesoftware.util.AbstractPollableRunnable.run(AbstractPollableRunnable.java:97)
at com.jivesoftware.base.stats.StatsTaskEngine$TaskEngineWorker.run(StatsTaskEngine.java:318)
Caused by: com.sap.sql.log.OpenSQLException: Cannot fetch column 1, which has JDBC type BIGINT, into a Java variable of type int.
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)
at com.sap.sql.types.TypedResultColumn.fetchError(TypedResultColumn.java:74)
at com.sap.sql.types.TypedResultColumn.getInt(TypedResultColumn.java:91)
at com.sap.sql.jdbc.common.CommonResultSet.getInt(CommonResultSet.java:369)
at com.jivesoftware.forum.stats.report.QuestionResolutionTime.execute(QuestionResolutionTime.java:62)
... 3 more
2010.09.09 11:34:02 [error] F:\usr\sap\PEP\J07\j2ee\cluster\server0\apps\sap.com\com.sap.netweaver.coll.forumsHome\servlet_jsp\forumsHome\root\jiveHome\stats\reports\2010-09-09_02\report-section-1.html (The system cannot find the file specified)
java.io.FileNotFoundException: F:\usr\sap\PEP\J07\j2ee\cluster\server0\apps\sap.com\com.sap.netweaver.coll.forumsHome\servlet_jsp\forumsHome\root\jiveHome\stats\reports\2010-09-09_02\report-section-1.html (The system cannot find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at java.io.FileReader.<init>(FileReader.java:55)
at com.jivesoftware.base.stats.HTMLReportTemplate.render(HTMLReportTemplate.java:70)
at com.jivesoftware.base.stats.AbstractReportRunner.doRun(AbstractReportRunner.java:280)
at com.jivesoftware.util.AbstractPollableRunnable.run(AbstractPollableRunnable.java:97)
at com.jivesoftware.base.stats.StatsTaskEngine$TaskEngineWorker.run(StatsTaskEngine.java:318)
Somebody have any idea about this, thanks in advance.