You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If I perform Quick Analysis of a table in SQL Server, I get the expected results.
If I perform Quick Analysis of a table in Sybase, I get the error reported below.
How can I see the SQL statements getting executed (I tried loglevel=debug and trace in log4j.xml file to no avail)
Is this a defect or configuration error?
I attached both test jobs in zip file.
Thank you,
--- DataCleaner progress information user-log ---
09:49:07 INFO: Job begin
09:49:08 INFO: Starting processing of ADDRESS (approx. 8501951 rows)
09:49:08 INFO: Starting component 'Date/time analyzer (5 columns)'
09:49:08ERROR: An error occurred in the analysis job!
java.sql.SQLException: The column prefix '"ADDRESS"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
org.apache.metamodel.jdbc.UncheckedSQLException: java.sql.SQLException: The column prefix '"ADDRESS"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
at org.apache.metamodel.jdbc.JdbcUtils.wrapException(JdbcUtils.java:70)
at org.apache.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:541)
at org.apache.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:523)
at org.datacleaner.job.runner.SourceTableRowProcessingPublisher.processRowsInternal(SourceTableRowProcessingPublisher.java:220)
at org.datacleaner.job.runner.AbstractRowProcessingPublisher.processRows(AbstractRowProcessingPublisher.java:208)
at org.datacleaner.job.tasks.RunRowProcessingPublisherTask.execute(RunRowProcessingPublisherTask.java:43)
at org.datacleaner.job.concurrent.TaskRunnable.run(TaskRunnable.java:61)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
The details of the log config file escapes me, but I do know that if you can enable debug logging for the context org.apache.metamodel.jdbc then you'll be able to see the raw SQL statements in your log
If I perform Quick Analysis of a table in SQL Server, I get the expected results.
If I perform Quick Analysis of a table in Sybase, I get the error reported below.
I attached both test jobs in zip file.
Thank you,
--- DataCleaner progress information user-log ---
09:49:07 INFO: Job begin
09:49:08 INFO: Starting processing of ADDRESS (approx. 8501951 rows)
09:49:08 INFO: Starting component 'Date/time analyzer (5 columns)'
09:49:08ERROR: An error occurred in the analysis job!
java.sql.SQLException: The column prefix '"ADDRESS"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
org.apache.metamodel.jdbc.UncheckedSQLException: java.sql.SQLException: The column prefix '"ADDRESS"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
Test1.analysis.zip
TestJobs.analysis.zip
The text was updated successfully, but these errors were encountered: