Reported Issue
Connect2 is failing with: java.lang.Exception: VALIDATION ERROR: Schema [[dfs, root]] is not valid with respect to either root schema or current default schema. Current default schema: dfs
- Due to the error, the Connect job is not running and all data feeds are out of date.
- From SS&E > Admin > Advanced Administration > External Logging > The Connect2 Application Log file shows an Apache Drill validation error.
oadd.org.apache.drill.common.exceptions.UserRemoteException:
VALIDATION ERROR: Schema [[dfs, root]] is not valid with respect to either root schema or current default schema.
Resolution
In the past, the following steps have resolved this error.
- Verify that the Admin password is set to "password never expires" both on the Connect server and the Informer server.
- Verify that dfs.root exists as a schema. This can be validated by running the command to "Show Schema" in Apache Drill and validating that the output includes the dfs.root schema or not.
-
- apache drill (dfs)> SHOW SCHEMAS;
-
- Check the user assigned to the Connect job following the steps below.
- Confirm that Drill is querying from the right directory following the steps below.
- Check the Apache Drill Storage Plugin Configuration. If needed, reconfigure the plugin.
-
- Storage plugins enable Drill to access data sources.
- For more information, click here.
-
How to check the Connect Job User:
From the Windows Start menu on the Connect server, search for the "Task Scheduler" Application.
- Highlight the Aviso Connect/Connect2 job.
- Check the General tab to view the user that is "running" the task scheduler Aviso Connect job.
- If you need to change the user on the scheduled task, right-click on the Connect job and select "Properties". Then, from the General tab, change the user if needed.
- We recommend setting the Connect task user account to not expire or changing it to a service account on the Connect server (local machine), and validating the task security options so that this does not change/reoccur.
How to check the Drill Directory:
- Make sure the Drill directory is pointing to the same place that the CSV files are being exported to.
-
- Confirm that this is the right directory and that the directory path is formatted correctly.
- If this is a network directory and not a local directory, a symbolic link may be needed.
-
- Access the Drill web ui by going to: http://localhost:8047/ from a web browser on the Connect server.
- Under Drill Storage > Enabled Storage Plugins, click the Update button next to dfs.
- In the Configuration XML, change the root location to the CSV directory.
-
- The default is C:\Aviso\csv, but can be set to something else if CSVs are being exported to a different directory.
- Define the path relative to the C:\ and use forward slashes ( / ) instead of backslashes.
- For example C:\Aviso\CSV would be /Aviso/csv.
-
-
"root": { "location": "/Aviso/csv", "writable": false, "defaultInputFormat": null, "allowAccessOutsideWorkspace": false }