Skip to Content

SQLExpression: when evaualting it comes on a random basis to "FailedToRetrieveColumnForField" error

When running a report from an application the report engine creates an exception

Logfile:
Caused by: com.crystaldecisions.reports.formulas.FormulaException: Ausnahme in Formel ""{@payingGuestID}"" bei ""{%payingGuestID}"":
FailedToRetrieveColumnForField
   at com.crystaldecisions.reports.formulas.j.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.k.if(Unknown Source)
   at com.crystaldecisions.reports.formulas.j.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.k.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.k.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.j.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.j.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.k.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.j.do(Unknown Source)
   at com.crystaldecisions.reports.formulas.k.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.k.if(Unknown Source)
   at com.crystaldecisions.reports.formulas.k.b(Unknown Source)
   at com.crystaldecisions.reports.formulas.e.a(Unknown Source)
   at com.crystaldecisions.reports.formulas.FormulaInfo.do(Unknown Source)
   at com.crystaldecisions.reports.formulas.FormulaService.evaluate(Unknown Source)
   at com.businessobjects.reports.dpom.processingplan.FormulaField.evaluate(Unknown Source)
   ... 53 more
Caused by: com.crystaldecisions.reports.formulas.FormulaClientException: FailedToRetrieveColumnForField
   at com.crystaldecisions.reports.saveddata.saveddata.WorkingRecord.getCurValue(Unknown Source)

..


                        
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 26 at 02:06 PM

    What version of Crystal are you using? What is the code in the SQL Expression? Is it possible for it to return Null? If so, your formula will have to either set default values for null or it will have to explicitly handle it.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • May 23 at 07:26 AM

    I could not locate the error, so I replaced the errorneous by an older working version of that report.

    Add comment
    10|10000 characters needed characters exceeded

  • May 23 at 07:29 AM

    I could not locate the error, so I replaced the errorneous by an older working version of that report.

    The SQL expression is still used, the error probably has another source - therefore with that older version it worked.

    Guesst, that this is an unreported error and maybe fixed in a later Crystal Version which was not available for my environment, resp. the live environment where the error ocurred.

    Add comment
    10|10000 characters needed characters exceeded