Problems generating forum reports

[former_member184352]

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.

[thunder_feng]

Hi Jose,

As the "caused by" says

- which has JDBC type BIGINT into a Java variable of type int

i,e the error occurs when a conversion from JDBC type BIGINT to java standard variable type int.

If you JDK fulfills the requirement of 7.0 EHP1 SP6, then it is very likely there is a bug in the Portal/Application programs.

So I would like to suggest you:

1. check your JDK version with "java -version", or check the log file like

/usr/sap/<SID>/<instance>/work/dev_server0

and compare the version with the requitement of note 723909(section 1. Java version)

2. then if the issue persists, I would like to support you report this issue to SAP product support,

as it is very likely to be a problem in the program.

Best Regards,

Thunder

[safter_maskan]

Hİ José ,

Thats looks like a JDK problem which jdk are you using? Please try to use jdk 1.4.2.22

Best Regards

[former_member184352]

HI Safter, I'm not realy sure about what JDK version we have, what is the best way to know that. Sorry I'm not a java expert.

[Former Member]

Jose, this might help you find out info about your Java version: http://www.javatester.org/version.html

Edited by: swong77 on Sep 14, 2010 4:07 PM