Framework manager validates only the part of the alias names given

[saumil287]

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

[MFGF]

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.

[saumil287]

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

[MFGF]

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.

[saumil287]

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
 

[MFGF]

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.

[saumil287]

Hi MFGF,

Thank you very much for your replys.

Appreciated a Lot.

Thanks again