Skip to Content
0
Sep 09, 2010 at 07:11 PM

Problems generating forum reports

29 Views

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.