AnsweredAssumed Answered

Jaspersoft installation error

Question asked by Sreeram601 on Aug 26, 2015
Latest reply on Sep 9, 2015 by Sreeram601

Hi,

 

While installing Jaspersoft 5.6.1 , following error occurs

"D:\Jaspersoft_5.6.1_4.7\install.xml:159: Unable to connect Jasper Database

  ERROR: java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver]Error establishing socket. Unknown host: Oracle Hostname- ORAHost"

 

Following are the steps we took

1.Installed JDK1.7.0_67 and set the Java_Home and Added in Path

2.Installed Tomcat 7 from cmd prompt from bin folder Services.bat Install.

3.Created Tablespace for Jaspersoft using the following command

 

CREATE TABLESPACE "PPM_JASPER_TS" DATAFILE '<ORACLE_BASE>\ORADATA\<SID>\PPM_JASPER_TS.DBF' SIZE 500M REUSE AUTOEXTEND ON NEXT 25M MAXSIZE 10G LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

 

Do we need to provide ORACLE_BASE as our DB hostname and then SID as our Clarity SID Name in this line '<ORACLE_BASE>\ORADATA\<SID>\PPM_JASPER_TS.DBF' ?

 

4.Created a database user and set the required privileges using the following command

 

CREATE USER PPM_JASPERSOFT IDENTIFIED BY PASSWORD123;

DEFAULT TABLESPACE PPM_JASPER_TS TEMPORARY TABLESPACE TEMP;

GRANT CONNECT TO PPM_JASPERSOFT;

GRANT RESOURCE TO PPM_JASPERSOFT;

GRANT CREATE SESSION TO PPM_JASPERSOFT;

 

5.Unzipped the installable file and ran the command Run install.bat

  • Select Installation Mode - Standalone
  • Select DB Server type - Oracle
  • Select Oracle Standalone
  • Fill the following details

  a) Enter Oracle Database Hostname : Oracle Hostname

  b) Enter Oracle Database Port Number : 1521

  c) Enter Oracle SID Name : Clarity SID

  d) Enter Jaspersoft Database Username : PPM_JASPERSOFT

  e) Enter Jaspersoft Database Password : PASSWORD123

 

Once I give the above command, the command prompt disappears. Then I checked the log files and found the above error. Is it the jasper user account issue or the Java error?

 

Could you please advise

 

Thanks

 

Sreeram

Outcomes