I seem to recall one of my clients experiencing something similar when I was at STI. If I recall correctly, they had several versions of Crystal reports: 9, 10 and 11 in their shop, and the workstations that were experiencing the issue had either multiple versions installed on their machine or had upgraded, causing an issue with a DLL file. I recall BMC support sending me a file to replace the DLL with, but this was two years and three contracts ago, so I don't recall specifics, but you may want to look at the crpe32.dll. I've seen a variety of problems with it over the years.
Jennifer Meyer Data Manager Mystikal Solutions "Bringing Order to Chaos" desk: 843-218-7120 cell: 919-995-2402 [EMAIL PROTECTED] [EMAIL PROTECTED] From: Susan Palmer Sent: Thu 01-May-08 10:55 To: arslist@ARSLIST.ORG Subject: Re: Crystal Report error on particular form and particular PC ------=_Part_5768_6353798.1209653719735 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 ope= n 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. Althoug= h 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\Commo= n 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, mak= e 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 recommen= d 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 o= r > 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 =96 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" ------=_Part_5768_6353798.1209653719735 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ** <div>Hi Dwayne,</div> <div> </div> <div>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 othe= rs. To me it seemed that a report with subreports caused more problem= s but that wasn't consistent either.</div> <div> </div> <div>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 workf= low to open window strategy.</div> <div> </div> <div>Even after we get the user working, periodically they start getting th= e errors again. I believe it is ODBC related. And it is general= ly after an application has been installed so there must be some .dll overl= ap. Although I cannot prove that theory out, we'll go with intuit= ion.</div> <div> </div> <div>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, mak= e sure all options are chosen correctly etc. and then it generally will wor= k. (well until the next time)</div> <div> </div> <div>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.</div> <div> </div> <div>I hope some of this info helps, feel free to ask questions, I ma= y have forgotten something.</div> <div> </div> <div>Susan<br><br></div> <div class=3D"gmail_quote">On Thu, May 1, 2008 at 8:21 AM, Dwayne Martin &l= t;<a href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Susan,<br><br>Thank you for y= our reply. To answer your questions:<br><br>Re:What version of Crysta= l are the reports created in?<br> 9<br><br>Re: Did you recently upgrade from a lower version of ARS?<br>Not q= uite a year ago we upgraded from 6.3 to 7.1<br><br>Re:What kind of a/l acti= on are you using to initiate the reports, macro or open window?<br>Open Win= dow.<br> <br>Re: In tools/options/advanced do you have ODBC user Underscores c= hecked?<br>Yes<br><br>Re: Is the ODBC driver configured for ARS?<br>Yes. (R= eports for other forms display OK.)<br><br>Re: Have you cleared cache?<br>W= e cleared the cache for the IT:Request form. There isn't any cach= e for the reports.<br> <br><br>Re: On the c drive in common files there is a business object folde= r that needs to be cleared (would have to check my notes, sorry for vaguene= ss).<br>We don't have a C:\Common Files folder, but please tell us more= . This could be the problem.<br> <br>Thanks again,<br>Dwayne<br> <div> <div></div> <div class=3D"Wj3C7c"><br>---- Original message ----<br>>Date: Wed, 30 A= pr 2008 15:41:14 -0500<br>>From: Susan Palmer <<a href=3D"mailto:suza= [EMAIL PROTECTED]">[EMAIL PROTECTED]</a>><br>>Subject: Re: Crysta= l Report error on particular form and particular PC<br> >To: <a href=3D"mailto:arslist@ARSLIST.ORG";>arslist@ARSLIST.ORG</a><br>&= gt;<br>> **<br>> Hi Dwayne,<br>><br>> What= version of Crystal are the reports created in?<br>> Did you rece= ntly upgrade from a lower version of<br> > ARS?<br>> What kind of a/l action are you using to in= itiate<br>> the reports, macro or open window?<br>> In = tools/options/advanced do you have ODBC user<br>> Underscores &nb= sp;checked?<br>> Is the ODBC driver configured for ARS?<br> > Have you cleared cache?<br>> On the c drive in common= files there is a business<br>> object folder that needs to be cl= eared (would have<br>> to check my notes, sorry for vagueness).<b= r>><br>> We have this and similar problem periodically. = For<br> > a while it was rampant. Personally I believe it is<br>>= ; ODBC related since the installation of some little<br>> = non-related tool we use can cause running CR to act<br>> up like = this.<br>><br>> Sorry if this email is a little disjointed, I&= #39;ve<br> > been writing it for hours, word by word,<br>> interru= ption by interruption.<br>><br>> Susan<br>><br>><br>>= On Wed, Apr 30, 2008 at 12:26 PM, Dwayne Martin<br>> <= <a href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>> wrote:<br> ><br>> Dear List,<br>><br>> We have= a form (IT:Request) with two buttons, each<br>> of which = calls an Active Link, which launches a<br>> Crystal Report= stored in the Report form.<br>><br> > On one of our PCs, if someone, it doesn't matter<br>= > who, clicks one of these buttons they get:<br>><br>&g= t; "An unknown error occurred while generating the<br>&g= t; Crystal Report. 0x80047r41 =96 Unknown Database<br> > Connection Error [ARERR 1904]"<br>><br>> &nbs= p; If they click a similar button on another form the<br>> = report displays OK. If they go to another<br>> &nbs= p; computer even the IT:Request reports display OK.<br> ><br>> The WUT configuration and version are the same a= s<br>> on other computers. I couldn't find anyth= ing in<br>> Support KB about ARERR 1904. The user can disp= lay<br>> the reports from Mid-Tier launched from her<br> > computer.<br>><br>> Any idea what mi= ght be going on?<br>><br>> (ARS and WUT 7.1, RH Linux s= erver, Oracle 10.2 db)<br>> Dwayne Martin<br>> &= nbsp; James Madison University<br>><br></div> </div>> __Platinum Sponsor: <a href=3D"http://www.rmsportal.com/"= target=3D"_blank">www.rmsportal.com</a> ARSlist:<br>> "Wher= e the Answers Are" html___<br></blockquote></div><br> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ------=_Part_5768_6353798.1209653719735-- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
