Unable to run column analysis in Information Analyzer
Posted: Thu Oct 25, 2012 5:06 pm
We have setup Information Analyzer 8.7 for SQL Server. While running the column analysis it is erroring out. Below is the error message:-
Details are:-
The table which I am analyzing has only 1000 records. Also the login id has admin privilges.
From where it is getting the hexa decimal object name "Invalid object name 'ec1481df.c862f974.000jl65kr.m1fo9qg.8t0keg.8ska2nlhecb2jvmnc2vu4_FD'"??
Appreciate all your help on this!!
Thanks in Advance!!
Code: Select all
Failed to create FreqDist Summary
Code: Select all
Failed to create FreqDist Summary for com.ascential.investigate.exception.CreateFrequencyDistributionException: Failed to create FreqDist Summary for ec1481df.c862f974.000jl65kr.m1fo9qg.8t0keg.8ska2nlhecb2jvmnc2vu4
at com.ascential.investigate.ca.job.ProfileSummaryBuilder.createFreqDistSummary(ProfileSummaryBuilder.java:447)
at com.ascential.investigate.ca.job.BaseProfileJob.doPostProcess(BaseProfileJob.java:712)
at com.ascential.investigate.utils.jobs.JobProcessor.execute(JobProcessor.java:156)
at com.ascential.investigate.auth.engine.Task.execute(Task.java:93)
at com.ascential.investigate.auth.engine.Worker.run(Worker.java:84)
at java.lang.Thread.run(Thread.java:736)
Caused by:
java.sql.SQLSyntaxErrorException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid object name 'ec1481df.c862f974.000jl65kr.m1fo9qg.8t0keg.8ska2nlhecb2jvmnc2vu4_FD'.
at java.lang.Throwable.<init>(Throwable.java:67)
at java.sql.SQLException.<init>(SQLException.java:101)
at com.ibm.isf.jdbc.sqlserverbase.dda4.b(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.dda4.a(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.dda3.b(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.dda3.a(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.ddj.l(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.ddde.e(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.ddde.a(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.ddde.v(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.ddde.u(Unknown Source)
at com.ibm.isf.jdbc.sqlserverbase.ddde.executeQuery(Unknown Source)
at com.ascential.investigate.sda.ScratchDataAccessImpl.execQueryforResultSetInternal(ScratchDataAccessImpl.java:613)
at com.ascential.investigate.sda.ScratchDataAccessImpl.executeQueryforResultSet(ScratchDataAccessImpl.java:155)
at com.ascential.investigate.ca.job.ProfileSummaryBuilder.setUniqueValueCount(ProfileSummaryBuilder.java:1791)
at com.ascential.investigate.ca.job.ProfileSummaryBuilder.createFreqDistSummary(ProfileSummaryBuilder.java:413)
... 5 more
From where it is getting the hexa decimal object name "Invalid object name 'ec1481df.c862f974.000jl65kr.m1fo9qg.8t0keg.8ska2nlhecb2jvmnc2vu4_FD'"??
Appreciate all your help on this!!
Thanks in Advance!!