Hi Dwayne, We had numerous people in the same situation as you did. And it wasn't across the board, they could run some reports but not others. To me it seemed that a report with subreports caused more problems but that wasn't consistent either.
We upgraded from 5.1.2 so we had many a/l buttons that still ran on a macro and that appears to be a problem so we've had to change the workflow to open window strategy. Even after we get the user working, periodically they start getting the errors again. I believe it is ODBC related. And it is generally after an application has been installed so there must be some .dll overlap. Although I cannot prove that theory out, we'll go with intuition. When we have a user like that we do a removal of the C:\Program Files\Common Files\Business Objects folder, clearing of all cache files (we have a cool little program that does it that our new support provider TuringSMI provided), complete uninstall / reboot / install, reconfigure the ODBC, make sure all options are chosen correctly etc. and then it generally will work. (well until the next time) I had a ticket with bmc and that went no where. After months of logging, hoop jumping, doing it over and over on webex, the best they could recommend was switching from macro to open window a/l's. Sort of works but was not a total fix. I hope some of this info helps, feel free to ask questions, I may have forgotten something. Susan On Thu, May 1, 2008 at 8:21 AM, Dwayne Martin <[EMAIL PROTECTED]> wrote: > Hi Susan, > > Thank you for your reply. To answer your questions: > > Re:What version of Crystal are the reports created in? > 9 > > Re: Did you recently upgrade from a lower version of ARS? > Not quite a year ago we upgraded from 6.3 to 7.1 > > Re:What kind of a/l action are you using to initiate the reports, macro or > open window? > Open Window. > > Re: In tools/options/advanced do you have ODBC user Underscores checked? > Yes > > Re: Is the ODBC driver configured for ARS? > Yes. (Reports for other forms display OK.) > > Re: Have you cleared cache? > We cleared the cache for the IT:Request form. There isn't any cache for > the reports. > > > Re: On the c drive in common files there is a business object folder that > needs to be cleared (would have to check my notes, sorry for vagueness). > We don't have a C:\Common Files folder, but please tell us more. This > could be the problem. > > Thanks again, > Dwayne > > ---- Original message ---- > >Date: Wed, 30 Apr 2008 15:41:14 -0500 > >From: Susan Palmer <[EMAIL PROTECTED]> > >Subject: Re: Crystal Report error on particular form and particular PC > >To: arslist@ARSLIST.ORG > > > > ** > > Hi Dwayne, > > > > What version of Crystal are the reports created in? > > Did you recently upgrade from a lower version of > > ARS? > > What kind of a/l action are you using to initiate > > the reports, macro or open window? > > In tools/options/advanced do you have ODBC user > > Underscores checked? > > Is the ODBC driver configured for ARS? > > Have you cleared cache? > > On the c drive in common files there is a business > > object folder that needs to be cleared (would have > > to check my notes, sorry for vagueness). > > > > We have this and similar problem periodically. For > > a while it was rampant. Personally I believe it is > > ODBC related since the installation of some little > > non-related tool we use can cause running CR to act > > up like this. > > > > Sorry if this email is a little disjointed, I've > > been writing it for hours, word by word, > > interruption by interruption. > > > > Susan > > > > > > On Wed, Apr 30, 2008 at 12:26 PM, Dwayne Martin > > <[EMAIL PROTECTED]> wrote: > > > > Dear List, > > > > We have a form (IT:Request) with two buttons, each > > of which calls an Active Link, which launches a > > Crystal Report stored in the Report form. > > > > On one of our PCs, if someone, it doesn't matter > > who, clicks one of these buttons they get: > > > > "An unknown error occurred while generating the > > Crystal Report. 0x80047r41 – Unknown Database > > Connection Error [ARERR 1904]" > > > > If they click a similar button on another form the > > report displays OK. If they go to another > > computer even the IT:Request reports display OK. > > > > The WUT configuration and version are the same as > > on other computers. I couldn't find anything in > > Support KB about ARERR 1904. The user can display > > the reports from Mid-Tier launched from her > > computer. > > > > Any idea what might be going on? > > > > (ARS and WUT 7.1, RH Linux server, Oracle 10.2 db) > > Dwayne Martin > > James Madison University > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: > > "Where the Answers Are" html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
