Error : Anaplan API: Could not connect to database! (SQL: No suitable driver found for

Options
ProdInfra
ProdInfra Member, ALL USERS Posts: 5 New Contributor
in Extensibility

Hello,

We are currently of migration from Anaplan Connect 1.3.3 to 1.4.3.
When we launch our .bat, we get the following error message:
 
 

printed screen.JPG

 
 
 
 
 
 
Could you help us about this error message ?
 
Regards,
Tagged:

Comments

  • ProdInfra
    ProdInfra Member, ALL USERS Posts: 5 New Contributor
    Yes we have made a parallel copy of the existing to the new version.
     
    Lib directory.JPG

     

     
  • ProdInfra
    ProdInfra Member, ALL USERS Posts: 5 New Contributor

    Some precisions:

     

    We have error with :

     

    set Operation=-debug -auth %AuthLocation% -loadclass %OracleDriver% -file %FILE_01_STAGE% -jdbcproperties %JDBCPROPERTIES% -import %IMPORT_01_STAGE% -execute -output %FILEERROR_01_STAGE% 

     

    printed screen.JPG

     

    And when we remove the -File :

    set Operation=-debug -auth %AuthLocation% -loadclass %OracleDriver% -jdbcproperties %JDBCPROPERTIES% -import %IMPORT_01_STAGE% -execute -output %FILEERROR_01_STAGE%

     

    Without File.JPG

     

     

  • ProdInfra
    ProdInfra Member, ALL USERS Posts: 5 New Contributor

    Yes, Variable is defined in the script

    set OracleDriver="oracle.jdbc.driver.OracleDriver"

     

    The lib folder is now clean but we have always the same error message Anaplan API: Could not connect to database! (SQL: No suitable driver found for "jdbc:oracle:thin:server_name:port:database"

  • ProdInfra
    ProdInfra Member, ALL USERS Posts: 5 New Contributor

    Hello,

     

    Thanks a lot for your advice.

    We found solution. The problem came from " " placed on the sql request in the jdbc.properties

Categories