nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

ProdInfra

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,

Accepted answers

All comments

ben_speight

Have you copied over your Oracle thin JDBC driver zip file from the lib directory of your 1.3 installation?

ProdInfra

Yes we have made a parallel copy of the existing to the new version.

ProdInfra

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

ben_speight

Is the %OracleDriver% variable set earlier in the script? It should probably be oracle.jdbc.OracleDriver.

The lib folder only has the following files in a clean install:
bcprov-jdk15on-164.jar
InstallBouncyCastle.bat
InstallBouncyCastle.sh
README.md
You only need to copy over the Oracle JDBC driver jar(s), not the others.

ProdInfra

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"

ben_speight

ojdbc6_g.jar is just a variant of ojdbc6.jar with debug logging capabilities. Unless you want to trace the SQL queries (and know how to configure the logging) you probably don't need it, and only one of the two is required.

If you have -loadclass oracle.jdbc.driver.OracleDriver (or oracle.jdbc.OracleDriver) on the command line, then the driver should be registered when you use a jdbc:oracle:thin:... connection string, but the "no suitable driver found" error suggests this is not the case. Another way of registering the driver is to

set JAVA_OPTS=-Djdbc.drivers=oracle.jdbc.driver.OracleDriver

I'm assuming the remainder of your actual connection string is different, and you've also omitted the -service, -workspace and -model parameters.

ProdInfra

Hello,

Thanks a lot for your advice.

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

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…