Bruce, Thanks for the tip. You must have done a better search than I did ! I'm going to give this a try.
Thanks, Susan On Nov 15, 2007 8:58 AM, Wilson, Bruce B <[EMAIL PROTECTED]> wrote: > Susan, > We are using 7.0.01 Patch 002. > We spent a lot of time figuring out this problem. > We fixed it by taking two steps: > > 1. Rename the folder > C:\Program Files\Common Files\Business Objects\3.0 > To > C:\Program Files\Common Files\Business Objects\3.0_OLD > > 2. Reinstall the Remedy user client. This forces the install to > reinstall the crystal link. > > After spending too much time on the phone with Remedy support, > we decided to research the problem on > www.ARSList.org<http://www.arslist.org/>web site and found > the answer. didn't realize researching a problem on the > www.ARSList.org<http://www.arslist.org/> > web site was so easy. > > Bruce Wilson > Norfolk Southern Corporation > C&S Remedy Administrator > Atlanta, GA > > > -----Original Message----- > From: FRANK, GORDON CTR DISA JSSC [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 14, 2007 1:47 PM > Subject: Re: Crystal Report ARERR 1904 - Error while generating a > Crystal Report (UNCLASSIFIED) > > Classification: UNCLASSIFIED > Caveats: NONE > > Make sure you have "ODBC Use Underscores" is checked under options for > these users. Crystal requires the underscores substituted for spaces. > > Gordon M. Frank > DISA\Version FNS > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer > Sent: Wednesday, November 14, 2007 1:01 PM > To: [email protected] > Subject: Crystal Report ARERR 1904 - Error while generating a Crystal > Report > > ** > Hi Everyone, > > In the last couple of weeks we have had a rash of Crystal report errors > with various users. They are reports generated by clicking on a button > and a couple of active links run. One AL provides a display form for > parameters, the second AL contains the Run Macro with the query macro > and the Crystal Report.rpt file. These actually have been working fine > for years and when we upgrade to ARS v7 last June I upgrade the Crystal > Reports as necessary to CR v11. Been working fine for months. > > Then with what seems no provocation, other than I attended BMC > UserWorld, the users started seeing the 1904 error on 'some' reports, > not all reports. No changes to the system. We've cleared cache, > checked ODBC driver config, checked Use Underscores is checked, > everything appears fine. I've even created new ALs to replace the > original ones. > > I also had the errors but now do not. I think it was because I install > v7.1 user tool in separate folder, still got the error, then went back > to v7.0.1P3 user tool and didn't get the error. Very little logic to > that fix. I have logged into another person's PC and received the error > even though I didn't get it on mine. > > Which really leads me to the ODBC driver itself. What is different > about my PC and someone else's? We're going to be doing some clean > installs and more experimentation. > > Our support provider found the following bug reports which seem to fit > our situation. The prognosis does not sound good. We're also going to > try the v7.1 user tool. > > I was wondering if anyone else has seen these symptoms and how did you > cure it. > > Thanks for your help, > Susan > > > SW00277690 > > User is getting error "An error occurred while generating the Crystal > report: 0x80047e44 - The table " could not be found. > (AREER 1904) > > Regression problems in user tool 7.0.1 patch 001,002,003 and 004. This > is the problem with user tool 7.1 also. > > ARERR 1904, this problem is mainly comes with ODBC DLL. > > Most of the customer are getting ARERR 1904 with user tool 7.0.1 patch > 001 OR patch 002 OR 003 OR 004 while running the crystal reports. > > Re-installing the user tool has helped. Also ensuring that the user DSN > is pointed to the right server has also resolved this problem. > > It works most of the times but we have some issues after applying this > workaround still they are getting problem. > > We have lot of US tickets which releated this ARERR 1904. We got almost > 45 issues in 3 months related this problem. > > > SW00228569 > Receiving "An error occurred while generating the Crystal report: > 0x80047e44 - The table '' > could not be found. (ARERR 1904)" > > Report runs on User tool 6.3 (Patch 003). > Report also runs on PC that has Cyrstal Designer installed, but gets > error on PC's that don't have it installed. > > > SW00253745 > > An error occurred while generating the Crystal report: 0x80047e48 - > Logon failed. (ARERR 1904) > > > > Susan Palmer > > ShopperTrak > > ARS v7.0.1P3 > > Oracle 10g > > Windows 2003 > > User/Admin v7.0.1P3 > > __20060125_______________________This posting was submitted with HTML in > it___ > Classification: UNCLASSIFIED > Caveats: NONE > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
