Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3390
  • Last Modified:

Blob column in cognos

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
ac_davis2002
Asked:
ac_davis2002
  • 2
1 Solution
 
RWrigleyCommented:
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
 
ac_davis2002Author Commented:
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
 
ac_davis2002Author Commented:
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
 
nmcdermaidCommented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now