ihub error 17070

Hello
I have downloaded Birt iHub and whenever I run a report it brings up the attatched error.
 
I have looked at other forums for the answer and tried a few things but just cant seem to get it working
 
also the only thing I can see on the error log is what it says below
 
please someone help......

Find more posts tagged with

Comments

gowtham

Your report working fine in local?

Ivo Anusic

yes in normal birt it runs fine with no problems
 
had a slight fiddle around and the error log is now as attached

Clement Wong

The highlighted error in your screenshot above says it is not able to connect to localhost:15200 Port 15200 is a SOAP port associated with the "ihubc" process. 
This tells me that if you looked at your running processes in Windows Task Manager, you would not see ihubc in the list? Do you see the following processes: ihub and ihubd? 
To troubleshoot further, can you please answer this questions... 
1. To confirm, are you able to run the reports in the Designer, but not in the iHub? 
2. Are you even able to log in @ <a data-ipb='nomediaparse' href='http://localhost:8700/iportal?'>http://localhost:8700/iportal?</a> 
3. Can you run any sample reports (not your own) successfully? 
4. Can you run any of your other reports successfully? 
5. Are you able to schedule and run any reports sucessfully? We can get the details of the 17070 error via the Job Status messages. 
6. From the command line, get a list of running processes and attach the text file. 
 "tasklist > list.txt" 
 
 We'll verify which iHub processes are running and which are not 
7. ZIP up the iHub log directory @ C:\Actuate3\BIRTiHubVisualization\modules\BIRTiHub\iHub\data\server\log 
 Attach it to this thread, or M me with a private shared file location. 
 
 We'll be look through the logs to see if there other issues. 
 
 
8. Did you install iHub Trial Edition? Do you have an expired iHub license key? When did you first install the product?

Ivo Anusic

1) yes I am able to see them in designer with no issues what so ever just issues in ihub.
2) yes I log in as administrator, I have logged in uploaded the report tried to run and now failed.
3) cant find any sample reports
4) no non of my reports work
5) no
6) attatched
7) attatched
8 ) yes I did instal the trial addition I have 43 days left it says and 2 days ago

Clement Wong

1. Attached is a very simple report. Please upload to iHub and run. Based on the logs, your iHub is running properly and will display this "Hello World" report. 
2. There are a few issues running your specific reports. Since we don't have your .rptdesign(s), we noticed that your reports are using two different JDBC drivers, jTDS and a JDBC/ODBC bridge. 
Adding JDBC drivers to iHub is easy:
 
A. Stop the iHub service 
B. Copy the JDBC drivers to: 
 C:\Actuate3\BIRTiHubVisualization\modules\BIRTiHub\iHub\Jar\BIRT\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_X.X.X.vYYYYMMDD-AAAA\drivers 
 where ****, YYYYMMDD-AAAA will vary on your build number 
C. Restart the iHub service

Unfortunately, the JDBC/ODBC bridge, which was previously not supported by Sun/Oracle for production use, was remvoved in Java 8 (Java tech note @ <a data-ipb='nomediaparse' href='http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html):'>http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html):</a>
 The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8. In addition, Oracle does not support the JDBC-ODBC Bridge. Oracle recommends that you use JDBC drivers provided by the vendor of your database instead of the JDBC-ODBC Bridge.
 
 
Here are the log entries: WARNING: [Ljava.lang.StackTraceElement;@4c6164b4 
[Thread 47, PFF-OPS1--2016-02-10 15:55:30--2] 2016-02-10 15:55:31 UTC+0000 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadExtraDriver() 
SEVERE: DriverClassLoader failed to load class: net.sourceforge.jtds.jdbc.Driverjava.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver 
[Thread 40, PFF-OPS1--2016-02-11 08:59:30--4] 2016-02-11 08:59:33 UTC+0000 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadExtraDriver() 
SEVERE: DriverClassLoader failed to load class: sun.jdbc.odbc.JdbcOdbcDriverjava.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
 
3. Another issue with your report is that it is referencing an EFACS object. Is that a custom class? 
For iHub, you would need to add them to: 
 C:\Actuate3\BIRTiHubVisualization\modules\BIRTiHub\iHub\MyClasses\eclipse\plugins
Here is the log entry:
 
[Thread 47, PFF-OPS1--2016-02-10 15:55:30--2] 2016-02-10 15:55:31 UTC+0000 com.actuate.reportapi.engine.birt.BirtUtil.logBirtEngineError() 
SEVERE: There are errors evaluating script "EFACS.getCompanyName(reportContext)": 
ReferenceError: "EFACS" is not defined. (<inline>#1) org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "EFACS.getCompanyName(reportContext)": 
ReferenceError: "EFACS" is not defined. (<inline>#1) org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "EFACS.getCompanyName(reportContext)": 
ReferenceError: "EFACS" is not defined. (<inline>#1)
 

On a side note, there are sample applications and reports that should have been installed as part of the installation.

Ivo Anusic

I cant see any attatched file
 
if the driver I am using isn't supported can you tell me how to get another one that will work? what drivers am I copying into the folder?
 
and efacs is a stock system that we use so I understand now why that is failing so ignore that one.

Clement Wong

I did not attach any file to my previous post.
 
iHub runs is shipped with Java 8 and Java 8 removed ODBC/JDBC support.
 
What database are you attempting to connect with this ODBC/JDBC bridge? There might be a JDBC driver that we can use as an alternative.
 
We can have a local Sales Consultant work with you offline. Please PM me your contact information if you would like that.

Ivo Anusic

I am attempting to connect to an odbc sql server data source that is listed in
administrative tools >> data sources (odbc) >> system dsn or user dsn.

Clement Wong

ODBC/JDBC bridges are not supported in Java 8. What is your underlying database/data source that the ODBC is connecting to?