Unable to run column analysis in Information Analyzer

[AmeyJoshi14]

We have setup Information Analyzer 8.7 for SQL Server. While running the column analysis it is erroring out. Below is the error message:-

Code: Select all

Failed to create FreqDist Summary

Details are:-

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

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!!

[stuartjvnorton]

Have you successfully done column analysis before?
Can you open the CA results in IA to at least see the overall summary results?
Do you know which field it was for? Were you just running CA on a single field?

The FD table name looks like it is made of a few parts:
- the GUID bit is probably the primary key in the Column Analysis Master or Data Field definition table for the field it was trying to create the frequency table for.
- _FD is the suffix for all frequency distribution tables in IADB.

It may be something to do with QUOTED_IDENTIFIER being set to off. To refer to the FD tables in SQL scripts, you need to double-quote the table name when you refer to it because of the full stops, and the table that stores the name of the FD table for each column analysis master record stores them with the double-quotes included.