We've had reporting problems in Remedy User 7.0.1. All of our reports use either Local or Reporting Form. Unless the server name is entered in the User DSN we get:
"An error occurred while generating the Crystal report: 0x80047e48 - Logon failed. (ARERR 1904)" It doesn't matter whether the server is 6.3 or 7.0.1, we get the same results with both. BMC's workaround of specifying the server name in the User DSN is not very convenient for us since we have several different servers and some users may not always use the same one. If they don't consciously change the User DSN prior to running any reports they could get the wrong data and not realize it. I noticed that Remedy User 6.3 actually updates the User DSN to include the current server name every time you fire workflow that opens the Crystal viewer. Remedy User 7.0.1 does not do that. My first thought was that's a bug in 7.0.1, but BMC tells me it does what it needs to do behind the scenes without having to update the DSN. In any case, it doesn't do everything it needs to do or it would be working. I also tried 7.1 with the same results. On a side note, I also noticed that active links saved in 6.3 show a Report Type of 2 instead of Crystal when opened in Admin 7.0.1. I first tried to change these by reselecting Crystal in the 7.0.1 admin tool but that actually broke the workflow for 6.3 clients. I found that going back into the 6.3 admin tool and reselecting Crystal was the only way to make it work for both 6.3 and 7.0.1 clients (7.0.1 still required User DSN modification). So it looks funny in a 7.0.1 admin tool, but it works. Chad Hall (501) 342-2650 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Westbrock Sent: Monday, March 03, 2008 3:04 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal 9 embedded reports not working on ARS 7.0.1 Thanks to Frederick and Susan for your replies. I'm calling the reports using an Open Window action (not a macro), this has been the case for several years. The active link was imported via def file from the 5.1.2 server into the 7.0.1 server. I don't use the Report form for this application, the users click a button on a display form which in turn calls the active link. The only action in the AL is an Open Window as follows: Window Type: Report Target Location: New Server Name: the new 7.0.1 server Form Name: CM:ChangeManagement (the regular form that has the data for the report) Form View: (Clear) The qualification is ( 'Implementation Date/Time' > $TIMESTAMP$) AND ( 'Implementation Date/Time' < ($TIMESTAMP$ + (((60 * 60) * 24) * 10))) AND ( 'Status' = "Approved") The Report Information tab shows this: Report Type: Crystal Name: the correct path & file name appear here Destination: Screen Operation: Run Location: Embedded Query Override: Yes I opened a case with Support and they said that the 5.1.2 user tool is not supported with 7.0.1 server (but we have used on older WUT against a newer server before with no issues and all other functionality works fine). Below are other notes from Support for this case: "This is due to incomparability between arodbc driver and the version that Crystal report application uses. I have seen this problem and re-installing the user tool has helped. Also ensuring that the user DSN is pointed to the right server (Each user must manually configure the Remedy ODBC under User DSN then it will allow the users to access the reports without error) has also resolved this problem. If the problem still exists then open the report in crystal 11 versions and re-save it. I hope this helps because user tool 7.x version is compatible with crystal 11 reports." My laptop which is a fresh install of Windows XP Pro and WUT 7.0.1 patch 6 displays the 1904 error so it's not strictly WUT version related. I actually re-installed over the top and still get the error on this clean laptop (which has never had any version of Crystal tools on it nor any other version of the WUT). The laptop has a user DSN for Remedy as does the server. Of course we don't own any version of Crystal higher than 9 so upgrading it not an option at this time. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, March 03, 2008 12:38 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal 9 embedded reports not working on ARS 7.0.1 We had some problems with Crystal embedded in ALs when we switched from 5.1.2 to 6.3 as well. We saved the reports out of the ALs and imported them as attachments into the Report form (luckily we didn't have that many embedded). We then switched those ALs to use the Window Open (Window Type=Report). In oder to keep compatability (while we migrated users to the new User Tool) we kept the old ALs and just added to their Run-If ($VERSION$ like "%5.01.%"). The new ALs have (NOT ($VERSION$ like "%5.01.%")) in their Run-If. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Westbrock Sent: Monday, March 03, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: Crystal 9 embedded reports not working on ARS 7.0.1 Hello all- My current production environment is ARS 5.1.2 patch 1283 (server and WUT) and I have several buttons that call active links to open Crystal reports; these reports were written with version 9 of Crystal Reports Designer. This process has been working fine for several years now. The report files are embedded in the active links. The application and database servers are both Windows 2000 (SQL 2000) and the users are on XP Pro. We are in the process of upgrading to version 7.0.1 patch 6 (installed fresh on a new server running Windows Server 2003 Standard) and I've discovered that the Crystal reports do not work against this server. The new 7.0.1 server is pointing to a new database on the existing DB server. When using WUT 5.1.2 (as my users will be for a time after we repoint to the new server) they get an hourglass for a minute or so and then nothing. When using the 7.0.1 patch 6 WUT the hourglass comes up for 1-2 minutes but then the following error is displayed: An error occurred while generating the Crystal report: 0x80043ac3 - File not found. Details: error (ARERR 1904) The error message catalog doesn't show this error number (1904) and I searched the KB and couldn't my exact problem there, either. I did find solution #214704 but that was regarding the user having another Crystal Reports component on their system (which is not applicable in this case). None of the other six KB results was applicable, either. This morning I had a user open his 5.1.2 WUT and he was able to open a Crystal report against the 5.1.2 server with no issue. I had him log in again, this time to the 7.0.1 server and the report window never opens so I believe that I've narrowed down the issue to the ARS version (or possibly the Windows version of the server). This user has never had a version of the WUT higher than 5.1.2 installed on his machine. When I opened the active link in the 7.0.1 Admin tool the type was set to 2 instead of Crystal so I used the menu to change it to Crystal and saved the AL but that didn't help. I also resaved the .rpt file into the AL and that didn't help either. Has anyone else run into Crystal Reports problems when upgrading to version 7 (any flavor)? Thanks, Rick __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. **************************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"