[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1040
  • Last Modified:

Error when running report in BOE Business Objects

Anyone tell me why I might get this error in BOE?  This is a formula in a crystal report.  The report runs fine when it is hitting the database outside of BOE.  But after it is loaded in BOE we keep getting the error at the bottom of this text.  
---------------------------------------------------------------------------------------------------------------------------------------------
There is a formula called DLOS.  The formula says:
if isnull({CLARITY_UCL_PB.PROCEDURE_ID}) then 0
else
if {CLARITY_UCL_PB.PROCEDURE_ID} in [110202,110204,110206,4,65737,102604,23646,23648,
23650,23652,23654,23656,23658,23660,23662,23664,160493]
then 1
else 0
--------------------------------------------------------------------------------------------------------------------------------------------
Error in File ~tmp5ae86fcc76dd1a90.rpt: Error in formula DLOS: 'if ' A string is required here. Details: errorKind
--------------------------------------------------------------------------------------------------------------------------------------------
0
Becky Edwards
Asked:
Becky Edwards
1 Solution
 
Kurt ReinhardtCommented:
It sounds like the database connection/driver being used on the development machine isn't the same as what's being used on the Enterprise server.  One is recognizing the procedure code as numeric, the other isn't. You could test this by putting quotes around each of the procedure codes for the Enterprise version.

If you find that's the case, then you need to re-consider how you develop and publish your Clarity reports.  Best practices dictate having exactly the same type of connection for both developer and server machines.

Also, it's pretty common for Clarity fields to change datatypes between builds.  I've run into many situations where fields that were previously string/numeric changed to numeric/string.  You might try doing a simple "Verify Database" in Crystal Reports to see if the tables have changed.  I'm actually working on a project this week where I imported about 1500 EPIC Clarity reports from an old Enterprise Server to a new one.  I needed to modify about 50 reports and found at least 10 where the tables had changed since the report was last published.
0
 
Becky EdwardsEpic Clarity DeveloperAuthor Commented:
You were so right!!!!!  Opened the report up in Crystal on the BOE server and verified the database.  EPIC has changed the proc id to a string, and I didn't know it.  We changed everything and the report runs perfectly.

Thanks so much for your help!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now