AnsweredAssumed Answered

Jasper Studio New Data Adapter throws ORA-01017: invalid username/password; logon denied error

Question asked by Sajeela on Jan 18, 2018
Latest reply on Jan 19, 2018 by Sajeela

Hi Team,

 

We are using Clarity Version 15.2. I have Jaspersoft Studio installed on my local machine. We have got one new database user ID created for technical team in Clarity Production Database, which is different from the user ID used in database connection in CSA. I'm trying to use this new user ID to create a New Data Adapter in Jaspersoft Studio. My purpose is to publish the reports from Studio to Production jaspersoft Reports server.

For New Data Adapter set up, I'm using JDBC Driver: 'tibcosoftware.jdbc.oracle.OracleDriver'. After entering the hostname, port number, SID, username and password, I get this error message:

Caused by: java.sql.SQLInvalidAuthorizationSpecException: [TibcoSoftwareInc][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

Whereas, the same user ID and Password works fine with Oracle SQL Developer. So, the problem is not with the username and password.

 

In some online help, I came to know that one of the possibilities is because of the old JDBC driver and needs a proper driver to use with Studio. If this is the case, can you please suggest me which files to change and where?

Else if this is not the issue, can you help me create the Data Adapter successfully to publish the reports?

 

Thank You.

Kind Regards,

Sajeela.

Outcomes