Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: saumil287 on 18 Oct 2013 02:40:43 AM

Title: Framework manager validates only the part of the alias names given
Post by: saumil287 on 18 Oct 2013 02:40:43 AM

Hi All,

I am having a query containing with clause which validates with sql type set to pass through.

Since my query has an multiple alias names as shown 
For eg
"Name of the Applicant Address 1"
"Name of the Applicant Address 2"
and so on.

On validating the above query

It throws an error as follows:
RQP-DEF-0191 Column names must be unique. Column name
'Name of the Applicant Addr' is used more than once.

Want to know why it is validating only Half name of the alias.


data source is db2
Sql Type is Pass-through

The alias name is set as followsin the query:
App_Name1 "Name of the Applicant Address 1"


Your guidance is appreciated.

Thanks in Advance
saumil





Title: Re: Framework manager validates only the part of the alias names given
Post by: MFGF on 18 Oct 2013 05:50:28 AM
Hi,

It would appear that your data source might have a limitation on the length of names. From your message, this appears to be 26 characters. Try shortening your aliases to 26 or fewer characters - this ought to solve your issue.

Regards,

MF.
Title: Re: Framework manager validates only the part of the alias names given
Post by: saumil287 on 18 Oct 2013 06:51:43 AM
Hi MFGF,
  Thanks for your reply.

Our client tried this running in db2 iseries , it is working fine.

Is there setting in fm for any columns alias length.


Thanks


Title: Re: Framework manager validates only the part of the alias names given
Post by: MFGF on 18 Oct 2013 07:42:56 AM
Not one that I'm aware of. How are you connecting to the I series DB2 instance from your Cognos server? I would guess that the limitation you are seeing is in the client you are using to connect to DB2.

MF.
Title: Re: Framework manager validates only the part of the alias names given
Post by: saumil287 on 19 Oct 2013 01:47:10 AM
Hi MFGF,
  The datasource is created from the server where db2 as a content store  is installed and BI server with framework manager is installed.
The datasource from where the data is accessesd is in the diff server.
The data source is created using the name given in db2 data source which exist in thier server.

Thanks
saumil
 
Title: Re: Framework manager validates only the part of the alias names given
Post by: MFGF on 19 Oct 2013 09:47:52 AM
From what you said, it sounds like your DB2 database is on an i-Series IBM machine (what we used to call an AS400 in the good old days). Since Cognos doesn't run natively on i-Series, you must be using some DB2 client drivers to allow your Cognos server to see DB2 on the i-Series. I think these drivers are the limiting factor here.

I just did a quick Google search and found this:

http://www.ibm.com/developerworks/data/library/techarticle/milligan/0108milligan.html

The maximum name length permitted appears to be 28 characters. It's a limitation of DB2 on an i-Series. Nothing to do with Cognos.

Cheers!

MF.
Title: Re: Framework manager validates only the part of the alias names given
Post by: saumil287 on 21 Oct 2013 01:28:37 AM
Hi MFGF,

Thank you very much for your replys.

Appreciated a Lot.

Thanks again
Text only | Text with Images