COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: ashishberry on 18 Mar 2009 01:44:43 PM

Title: Oracle ora-00972 error using Framework Manager extension
Post by: ashishberry on 18 Mar 2009 01:44:43 PM
Hello,

I used the framework manager model extension within Contributor administration to build a framework model off of my Contributor Application. I am unable to report off of the model within report studio and recieve the following generic oracle error: "Oracle ora-00972.  Identifier is too long"

Is this an issue of getting Oracle and planning to work well together? How would you resolve this? I have Cognos support stumped for the moment would appreciate any input you all may have. Please let me know if you need any additional information.
Title: Re: Oracle ora-00972 error using Framework Manager extension
Post by: mrobby on 20 Mar 2009 03:14:31 PM
Do you get this message on every attempt to run a report studio report or only from certain cubes or datasets?

My thought is that a dataype for one of your columns is causing an issue with the SQL query that report studio is passing through.

Can you test some of the data in your FM package from within FM without getting the error?