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