Re: Crystal Report error on particular form and particular PC
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___
Re: Crystal Report error on particular form and particular PC
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
Re: Crystal Report error on particular form and particular PC
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
Re: Crystal Report error on particular form and particular PC - SOLVED sort of
Hi Susan, I should have mentioned a point that didn't seem important at the time, but turned out to be the key. The user installed Remedy WUT as PC Administrator, but was running as PC User. (Lots of our people are doing that as a security precaution.) She did try renaming the Business Objects file, but it didn't help. So she re-installed the WUT as Administrator and ran it as Administrator and the problem went away. Probably the PC User didn't have permission to some folder or object. Unfortunately, she has destroyed the evidence so I have no way of tracking down the problem. Thank you for your suggestions and info. I'll keep a copy of your emails in case this happens again. Dwayne Original message Date: Thu, 1 May 2008 09:55:19 -0500 From: Susan Palmer [EMAIL PROTECTED] Subject: Re: Crystal Report error on particular form and particular PC To: arslist@ARSLIST.ORG ** 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
Re: Crystal Report error on particular form and particular PC
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are