Solved

Blob column in cognos

Posted on 2009-04-14
4
2,860 Views
Last Modified: 2012-05-06
Hi

I am producing a report in cognos (8) using a table with a column of text type and I am getting the following error

Using a blob column in this query requires that the query subject [ICAS DB].[CTFirstCall] must have either a key or a unique index.

Can anyone tell me how I can get round this?

Cheers
0
Comment
Question by:ac_davis2002
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 24143955
you don't mention what the actual datatype is, but if its a varchar(max) or a varchar of greater then 2048 characters, Cognos will treat it like a CLOB.  It does this because there are certain functions and operations that won't work against these datatypes.  You need to ensure that the table that contains this dataitem has a primary key defined, and that you've imported that into Framework Manager and set its usage attribute as "Identifier".
0
 

Author Comment

by:ac_davis2002
ID: 24145259
interesting, its actually a text data tiype. If I look at the table in the sql database it does have a primary key on it called cpcompanyid. I have imported this into framework manager but I will check to see if its set as an identifier and let you know.

Thanks for your help
0
 

Author Comment

by:ac_davis2002
ID: 24145483
ok from within framework manager I have recreated the package making sure I have imported the primary keys. I have then set CPCompanyid (the primary key on that table) as an identifier. Have recreated the report in report studio but I am still getting the error. Is there anything else I can check?
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 33632306
I hate to see a question unanswered.
To fix this issue, edit the database level query subject, go to the determinants tab, create a new determinant, mark it as Uniquely identified then drag the unique key of the table into the 'key' section.
This explicitly tells Cognos that this column is a unique key.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now