Topic
  • 6 replies
  • Latest Post - ‏2013-07-09T15:35:53Z by KerryN
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic Error

‏2011-07-15T11:35:11Z |
Hi,

When every i run a report the following error comes

Error : QE-DEF-0459 CCLException

Details of Error:

QE-DEF-0260 Parsing error before or near position: 10 of: "testValue"
QE-DEF-0261 QFWP - Parsing text: testValue

any one help me, how to solve this issue
Updated on 2011-08-30T21:59:23Z at 2011-08-30T21:59:23Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Error

    ‏2011-07-15T11:44:09Z  
    hi
  • OpherB
    OpherB
    664 Posts

    Re: Error

    ‏2011-07-15T16:55:16Z  
    It appears there is an error in the expression of something called 'testValue'. Is this a calculation in your report? You should include that expression.

    Also, what version of Cognos BI and what data source/version are you working with?

    Opher
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Error

    ‏2011-08-30T19:32:58Z  
    • OpherB
    • ‏2011-07-15T16:55:16Z
    It appears there is an error in the expression of something called 'testValue'. Is this a calculation in your report? You should include that expression.

    Also, what version of Cognos BI and what data source/version are you working with?

    Opher
    Same getting the Error When i am using the If statement or even using the Case Statement.it's Urgent
    if Presentation View.Sales Stage.S/S in ('04', '05', '06', '07', '08') then
    Presentation View.EIW Facts.CW Ext Dtl Rev
  • OpherB
    OpherB
    664 Posts

    Re: Error

    ‏2011-08-30T19:49:15Z  
    Same getting the Error When i am using the If statement or even using the Case Statement.it's Urgent
    if Presentation View.Sales Stage.S/S in ('04', '05', '06', '07', '08') then
    Presentation View.EIW Facts.CW Ext Dtl Rev
    If would be better if you included the actual expression, since the syntax may be the problem. use the 'code' tag as shown on the right of the screen.

    What version of Cognos BI are you using?

    Opher
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Error

    ‏2011-08-30T21:59:23Z  
    • OpherB
    • ‏2011-08-30T19:49:15Z
    If would be better if you included the actual expression, since the syntax may be the problem. use the 'code' tag as shown on the right of the screen.

    What version of Cognos BI are you using?

    Opher
    As Opher mentioned, it would be good to include the full expression with the code tags. It would also help to let us know where the expression is being defined (detail filter, data item, layout calculation, etc.).

    Also, an error message that complains about 'testValue' typically has something to do with a parameter. 'testValue' is the dummy value used to validate the query when a parameter value is not available. I would start by looking at where and how the parameters are being used in your report.

    Next, it might be helpful to post your report specification. While this will not allow people to run or validate the report it may be possible to pick up areas where you can investigate further.
  • KerryN
    KerryN
    1 Post

    Re: Error

    ‏2013-07-09T15:35:53Z  

    A bit late to the thread but I discovered this while researching my own issue on the subject.  IBM has a support document that describes how to resolve this issue. 

    http://www-01.ibm.com/support/docview.wss?uid=swg21388529