COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: actcognosuser on 01 Apr 2020 09:08:57 AM

Title: Impact of Change in varchar length for Framework Manager Query Subjects
Post by: actcognosuser on 01 Apr 2020 09:08:57 AM
Hi,

The character length for a column  has changed in the table. Do the query subjects in Framework Manager need to be validated ?
Will it fail ?
Title: Re: Impact of Change in varchar length for Framework Manager Query Subjects
Post by: MFGF on 01 Apr 2020 09:31:17 AM
Quote from: actcognosuser on 01 Apr 2020 09:08:57 AM
Hi,

The character length for a column  has changed in the table. Do the query subjects in Framework Manager need to be validated ?
Will it fail ?

Hi,

I'm assuming this won't cause you problems unless you have specific calculations that are created based on the assumption the item is a specific length. Has the size increased or decreased?

MF.
Title: Re: Impact of Change in varchar length for Framework Manager Query Subjects
Post by: actcognosuser on 01 Apr 2020 10:02:14 AM
Hi MFGF,

The reports do not use this field. The char length has changed from 10 to 12.
Will the query subject throw an error while package is being published?
Title: Re: Impact of Change in varchar length for Framework Manager Query Subjects
Post by: MFGF on 01 Apr 2020 10:51:11 AM
Quote from: actcognosuser on 01 Apr 2020 10:02:14 AM
Hi MFGF,

The reports do not use this field. The char length has changed from 10 to 12.
Will the query subject throw an error while package is being published?

I'm pretty sure it won't be a problem. I'm not even sure you will need to re-publish the package.

Cheers!

MF.
Title: Re: Impact of Change in varchar length for Framework Manager Query Subjects
Post by: actcognosuser on 01 Apr 2020 12:07:57 PM
Thank You!