Clarity

  • 1.  Where to set up Clarity database driver jdbc?

    Posted 04-26-2018 10:21 AM

    Hi All,

     

    I’d like to ask you where it can be set driver setting/path which is used to connect Clarity to the database – We suppose it should be file ojdbc14.jar in niku/clarity/lib folder…

    We are getting this error in admin.log when tried to run Clarity services. (our DB team upgraded to Oracle 12c database)

     

    4/26/18 8:44 AM (admin) Verifying Java Configuration...
    4/26/18 8:44 AM (admin) Verifying Database Configuration...
    4/26/18 8:44 AM (admin) Failure: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-28040: No matching authentication protocol
    4/26/18 8:44 AM (admin) Verifying App Service (app) Configuration...


    Here is the same issue with my SQL developer used ojdbc14.jar:

     

     

    However, My colleague, who has ojdbc8.jar file in his newer SQL developer, can connect to that Oracle 12c Database…

     

    So for us the point is how can we set this driver to use it in Clarity? Simple copying ojdbc8.jar file into niku/clarity/lib and restarting Clarity didn’t help…Or if you have any other way how can we solve it, please advise.

     

    Appreciate help fromNika_Hadzhikidi, gcubed, nick_darlington in advance as this is quite urgent for us because we can't move on with our upgrade activities.

     

    Thanks a lot!

    Matej



  • 2.  Re: Where to set up Clarity database driver jdbc?

    Posted 04-26-2018 10:25 AM

    What Clarity version are you on - IIRC when 12c was "new" then Clarity did not support it for a few versions but you could get it to work by using 12c in a legacy mode (i.e. fix the database not Clarity)

     

    ( ref Road map of Oracle 12c support )



  • 3.  Re: Where to set up Clarity database driver jdbc?
    Best Answer

    Posted 04-26-2018 10:28 AM

    Try setting the SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

     

    https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016

     

    V/r,

    Gene



  • 4.  Re: Where to set up Clarity database driver jdbc?

    Posted 04-26-2018 10:36 AM

    ^ you mean like it says in the "Actions" in that error message



  • 5.  Re: Where to set up Clarity database driver jdbc?

    Posted 05-03-2018 05:07 AM

    Hi, 

     

    After setting of param, unfortunately we got to this bug which should be solved in 15.4 installation

     

    https://communities.ca.com/message/242014110-re-when-we-run-installbat-oracle-ora-01017-invalid-username-password-denied… 

     

    Thanks guys again, 

     

    Matej