Archive for April, 2011
Here is an odd case I helped (partially) resolve recently. The customer is using CR v11(XI) to connect to an IBM U2 database (via ODBC). The database was hosted on a Windows 2003 server.
They had two seemingly identical client system configurations using the same exact version of CR and the same ODBC driver. On both we would start a simple report using just one table and a few fields. The report would run fine in one environment but the other would generate an error message:
Failed to retrieve data from the database.
Details: HY000:[IBM][UVODBC]Error ID: 46 Severity:ERROR Facility: DBCAPERR - UCI Error. Func: SQLPrepare(DML); State: S1000; uniVerse code: 950088; Msg: [IBM][SQL Client][UNIVERSE]Universe/SQL:syntax error. Unexpected filename.
When I compared Continue Reading »
Odd Error using ODBC to IBM U2
This month an unusual number of customers have brought me errors to troubleshoot. Most of them involve errors outside of Crystal with things like missing DLL files or installs that seem the same but that behave differently. So I was pleasantly surprised to find a recent blog post on the SAP web site that provides a list of free tools for helping to troubleshoot things like this. There are 5 tools listed but I think two would apply most to the problems I faced this month:
1) Modules is a free utility from the SAP web site. It allows you to run a report on two different systems (ie one that works and one that doesn’t) and find all the files that are different in those two environments. It makes a list of the files used in each environment and then compares to see which are different. It is an old tool but worked fine in my Win7 64 environment.
2) Depends.exe (Dependency walker) is another free tool that takes an EXE or DLL file and lists all of the other files that it relies on. This is perfect for when you have a DLL that won’t work or register correctly. Often a missing dependent file is part of the problem.
And if you need to troubleshoot hangs and crashes, monitor HTTP / HTTPS traffic or monitor local file system and registry activity, the other tools should help.
I am used to helping users troubleshoot blank pages in their Crystal Reports. The usual culprits are blank report footers or group footers that need to be suppressed. Occasionally there is a page break that isn’t put in correctly. But I recently had one that I had not seen before. In preview the report showed 3 pages. But if the report was printed there were double the number of pages, with a blank page between each printed page. The same doubling would happen when it was exported to a PDF.
What I found was an image object (an OLE object) that was just a hair wider than the printable area on the page. In preview this would show as a white space to the right of the printed page, which was easy to overlook. It also didn’t affect the page count. But when printed or exported to PDF it would alternate printed and blank pages and double the page count. Once the OLE object was moved to within the printable area the blank pages went away.
This surprised me because normal CR objects that have a static size (fields, charts, boxes, etc) are just truncated if they stretch to the right too far. The only object that I knew of that could generate these pages to the right were cross-tabs, because their width is dynamic. So if you have a mysterious extra page in your report this is one more thing to check.
Blair Wheadon of SAP has published an updated overview of Crystal Reports licensing terms. He does a good job and covers multiple versions and editions. So this is a good place to start if you have question on product licenses. If this doesn’t answer your questions I might be able to help (I actually read them).
My only other comment on this article is that SAP still has not given up trying to add a hefty fee to every Crystal Reports course book produced by anyone. They try to do this by Continue Reading »
New Crystal Reports licensing overview