ETL Mapping Error

[mmuthu]

Hi There,
I tried using the ETL tool to import the data from SQL Server 2017 to Neo4j. However I am getting the following error.

COMMAND: java -cp "C:\Neo4j\AppData\graphApps\neo4j-etl-ui/dist/neo4j-etl.jar;C:\Users\mmuthu\Desktop\Works\SQL Server\jdbc\sqljdbc_7.2\enu\mssql-jdbc-7.2.2.jre8.jar" org.neo4j.etl.NeoIntegrationCli generate-metadata-mapping --rdbms:url "jdbc:sqlserver://XXX.XXX.XXX.XXX:1433;databaseName=TestDB" --rdbms:password "TestPassword" --rdbms:user "databasereader" --schema "dbo" --output-mapping-file "C:\Neo4j\AppData\neo4jDatabases\database-eb24e79c-8388-4c15-9158-ce8201018bdb\installation-3.5.6/import/mssql_testdb_dbo_mapping.json"

• Skipping reading import options from file because file doesn't exist.

• Creating RDBMS to CSV mappings...

• Using database plugin for

• Crawling schemas

• Retrieving all schemas

• Retrieving all catalogs

• Processed 13 rows for

• Retrieved 0 schemas

• Total time taken for - 00:00:00.052 hours

• 98.1% - 00:00:00.051 -

• 1.9% - 00:00:00.001 -

• Command failed due to error (SQLException: No matching schemas found). Rerun with --debug flag for detailed diagnostic information.

Where I executed with --debug mode the error ends with the following..
java.sql.SQLException: No matching schemas found
at org.neo4j.etl.sql.DatabaseClient.getCatalog(DatabaseClient.java:151)
at org.neo4j.etl.sql.DatabaseCatalog.(DatabaseCatalog.java:81)
at org.neo4j.etl.sql.metadata.TableInfoAssembler.(TableInfoAssembler.java:35)
at org.neo4j.etl.commands.DatabaseInspector.buildSchemaExport(DatabaseInspector.java:35)
at org.neo4j.etl.commands.rdbms.GenerateMetadataMapping.call(GenerateMetadataMapping.java:110)
at org.neo4j.etl.commands.rdbms.GenerateMetadataMapping.call(GenerateMetadataMapping.java:31)
at org.neo4j.etl.cli.rdbms.GenerateMetadataMappingCli.run(GenerateMetadataMappingCli.java:118)
at org.neo4j.etl.util.CliRunner.run(CliRunner.java:42)
at org.neo4j.etl.util.CliRunner.run(CliRunner.java:35)
at org.neo4j.etl.NeoIntegrationCli.main(NeoIntegrationCli.java:43)
Caused by: schemacrawler.schemacrawler.SchemaCrawlerException: No matching schemas found
at schemacrawler.crawl.SchemaCrawler.crawlSchemas(SchemaCrawler.java:406)
at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:814)
at schemacrawler.utility.SchemaCrawlerUtility.getCatalog(SchemaCrawlerUtility.java:75)
at org.neo4j.etl.sql.DatabaseClient.getCatalog(DatabaseClient.java:148)
... 9 more

I would appreciate if anyone can help in fixing this.
Thanks,
Mahendar

[tregovic]

A few months late, but I was having the same problem.
It worked when I used dbname.schema explicitly.
e.g. "TestDB.dbo"

[raavva]

@tregovic your absolutely right.