If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Impact of Change in varchar length for Framework Manager Query Subjects  (Read 2727 times)

Offline actcognosuser

  • Community Leader
  • *****
  • Join Date: Dec 2009
  • Posts: 198
  • Forum Citizenship: +0/-0
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 ?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,635
  • Forum Citizenship: +676/-10
  • Cognos Software Muppet
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.
Meep!

Offline actcognosuser

  • Community Leader
  • *****
  • Join Date: Dec 2009
  • Posts: 198
  • Forum Citizenship: +0/-0
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?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,635
  • Forum Citizenship: +676/-10
  • Cognos Software Muppet
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.
Meep!

Offline actcognosuser

  • Community Leader
  • *****
  • Join Date: Dec 2009
  • Posts: 198
  • Forum Citizenship: +0/-0
Thank You!