Solved

Blob column in cognos

Posted on 2009-04-14
4
3,104 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

691 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