Re: Crystal report Error-- Resolved

[Nair, Rajesh IN BOM SISL]

Dear List,
This issue has been fixed.
Needed to make a virtual directory for the crystal report on the IIS server. 
Some setting being changes on the ODBC side.

Regards
Rajesh Nair
SIEMENS IT Solutions  Services
GO GAA GPC-One
Hincon House (Old Building)
Lal Bahadur Shastri Marg,
Vikhroli (West),
Mumbai 400 083.
Mailto: nairraj...@siemens.commailto:nairraj...@siemens.com


From: Nair, Rajesh IN BOM SISL
Sent: Thursday, August 12, 2010 5:10 PM
To: 'arslist@ARSLIST.ORG'
Subject: Crystal report Error

Dear List,
I have created a new web server which will be replacing with out existing 
server.
Arsystem 6.3 Patch 23
Midtier 6.3 patch 23

I have installed crystal report enterprise edition 10 on this..

When ever I try to run a report on this server I get this below mentioned below
[cid:image001.jpg@01CB3AE0.0A724F60]

Can any one tell me how to fix this error.

This server is just a replication of my Prod Midtier server. The only diff is 
Prod box is on Win2k and the new server is windows 2003

Regards
Rajesh Nair
SIEMENS IT Solutions  Services
GO GAA GPC-One
Hincon House (Old Building)
Lal Bahadur Shastri Marg,
Vikhroli (West),
Mumbai 400 083.
Mailto: nairraj...@siemens.commailto:nairraj...@siemens.com



Important notice: This e-mail and any attachment there to contains corporate 
proprietary information. If you have received it by mistake, please notify us 
immediately by reply e-mail and delete this e-mail and its attachments from 
your system.
Thank You.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
inline: image001.jpg

Re: Crystal Report error

[Luttmann, Michael W CTR USA NETCOM/9TH SC A 7TH SC]

I have found that most reporting/crystal errors on Mid-Tier are due to 
configuration errors.  There are several areas you need to check:

- Mid-Tier Admin webpage, Report Settings: These values must be set correctly 
for your environment. (** Flush the cache between changes. **)
- AR Server Information, Advanced, Default Web Path: Format should be 
http://[webserver]/arsys;
- Check your User form for the correct user account and permissions for the 
ODBC connection

HTH,

Michael W. Luttmann
Lead Remedy Developer
Fort Carson NEC

If you don't like change, you're going to dislike irrelevance even more.
Gen Shinseki



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra
Sent: Friday, July 23, 2010 1:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report error

Sorry forgot to mention - this is being accessed using mid-tier

-Original Message-
From: Lammey, Peter A. [peter.a.lam...@espn.com]
Date: 07/23/2010 02:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report error

Does your Remedy User client have ODBC use underscores checked?  This can be 
found in the menu Tools -  Options and in the Advanced tab.  Also verify that 
your Remedy application server name is listed in Report Server field (and 
includes TCP if necessary in the TCP field next to that field). 

Thanks
Peter Lammey
ESPN IT Packaging and Automation
860-766-4761 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra
Sent: Friday, July 23, 2010 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Crystal Report error 

We are using Business Objects 11.5 with ARS 7.5 

When I try to run pre-canned reports in Incident Manager, I get the following 
eror 

The table 'HPD_Help_Desk' could not be found. Error in File 
C:\WINDOWS\TEMP\HPD5fAssigee5fModifed1 
{E5FBF338-ED6F-4707-8B9E-E3BA1E0309AB}.rpt: The table could not be found. 

Have to confess am not a experienced crystal report person so need some help. 

Thanks 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are 

Please consider the environment before printing this e-mail. 
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

Re: Crystal Report error

[Debnath, Prijit]

Atul,
You should first try to run the report from the designer itself. As Shafqat 
mentioned, there should be a verify database and a refresh/update database 
option. The refresh/update option used to be in the older versions of Crystal 
Report (not sure if this is still there). If you are able to pull out the 
report, that would mean that your report's connectivity to the backend is fine. 
And that the issue is somewhere between the MT and Crystal Report engine. HTH.


Prijit Debnath
Product Manager, Remedy A R System
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz
Sent: Saturday, July 24, 2010 8:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report error

**
You could also open the report in Crystal and do Verify Database. It is 
possible that the table name has been messed up in the report, so checking the 
database will fix the issue.

thanks
Shafqat Ayaz



--- On Fri, 7/23/10, Lammey, Peter A. peter.a.lam...@espn.com wrote:

From: Lammey, Peter A. peter.a.lam...@espn.com
Subject: Re: Crystal Report error
To: arslist@ARSLIST.ORG
Date: Friday, July 23, 2010, 1:18 PM
Does your Remedy User client have ODBC use underscores checked?  This can be 
found in the menu Tools -  Options and in the Advanced tab.  Also verify that 
your Remedy application server name is listed in Report Server field (and 
includes TCP if necessary in the TCP field next to that field).

Thanks
Peter Lammey
ESPN IT Packaging and Automation
860-766-4761

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG/mc/compose?to=arsl...@arslist.org] On Behalf Of 
Atul Vohra
Sent: Friday, July 23, 2010 2:01 PM
To: arslist@ARSLIST.ORG/mc/compose?to=arsl...@arslist.org
Subject: Crystal Report error

We are using Business Objects 11.5 with ARS 7.5

When I try to run pre-canned reports in Incident Manager, I get the following 
eror

The table 'HPD_Help_Desk' could not be found. Error in File 
C:\WINDOWS\TEMP\HPD5fAssigee5fModifed1 
{E5FBF338-ED6F-4707-8B9E-E3BA1E0309AB}.rpt: The table could not be found.

Have to confess am not a experienced crystal report person so need some help.

Thanks

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

Please consider the environment before printing this e-mail.


_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Crystal Report error

[Lammey, Peter A.]

Does your Remedy User client have ODBC use underscores checked?  This can be 
found in the menu Tools -  Options and in the Advanced tab.  Also verify that 
your Remedy application server name is listed in Report Server field (and 
includes TCP if necessary in the TCP field next to that field).

Thanks 
Peter Lammey 
ESPN IT Packaging and Automation 
860-766-4761

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra
Sent: Friday, July 23, 2010 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Crystal Report error

We are using Business Objects 11.5 with ARS 7.5

When I try to run pre-canned reports in Incident Manager, I get the following 
eror

The table 'HPD_Help_Desk' could not be found. Error in File 
C:\WINDOWS\TEMP\HPD5fAssigee5fModifed1 
{E5FBF338-ED6F-4707-8B9E-E3BA1E0309AB}.rpt: The table could not be found.

Have to confess am not a experienced crystal report person so need some help.

Thanks

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

Please consider the environment before printing this e-mail.

Re: Crystal Report error

[Atul Vohra]

Sorry forgot to mention - this is being accessed using mid-tier

-Original Message-
From: Lammey, Peter A. [peter.a.lam...@espn.com]
Date: 07/23/2010 02:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report error

Does your Remedy User client have ODBC use underscores checked?  This can be 
found in the menu Tools -  Options and in the Advanced tab.  Also verify that 
your Remedy application server name is listed in Report Server field (and 
includes TCP if necessary in the TCP field next to that field). 

Thanks  
Peter Lammey  
ESPN IT Packaging and Automation  
860-766-4761 

-Original Message- 
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra 
Sent: Friday, July 23, 2010 2:01 PM 
To: arslist@ARSLIST.ORG 
Subject: Crystal Report error 

We are using Business Objects 11.5 with ARS 7.5 

When I try to run pre-canned reports in Incident Manager, I get the following 
eror 

The table 'HPD_Help_Desk' could not be found. Error in File 
C:\WINDOWS\TEMP\HPD5fAssigee5fModifed1 
{E5FBF338-ED6F-4707-8B9E-E3BA1E0309AB}.rpt: The table could not be found. 

Have to confess am not a experienced crystal report person so need some help. 

Thanks 

___ 
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are 

Please consider the environment before printing this e-mail. 
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Crystal Report error

[Shafqat Ayaz]

You could also open the report in Crystal and do Verify Database. It is 
possible that the table name has been messed up in the report, so checking the 
database will fix the issue.

thanks

Shafqat Ayaz    
 



--- On Fri, 7/23/10, Lammey, Peter A. peter.a.lam...@espn.com wrote:

From: Lammey, Peter A. peter.a.lam...@espn.com
Subject: Re: Crystal Report error
To: arslist@ARSLIST.ORG
Date: Friday, July 23, 2010, 1:18 PM

Does your Remedy User client have ODBC use underscores checked?  This can be 
found in the menu Tools -  Options and in the Advanced tab.  Also verify that 
your Remedy application server name is listed in Report Server field (and 
includes TCP if necessary in the TCP field next to that field).

Thanks 
Peter Lammey 
ESPN IT Packaging and Automation 
860-766-4761

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra
Sent: Friday, July 23, 2010 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Crystal Report error

We are using Business Objects 11.5 with ARS 7.5

When I try to run pre-canned reports in Incident Manager, I get the following 
eror

The table 'HPD_Help_Desk' could not be found. Error in File 
C:\WINDOWS\TEMP\HPD5fAssigee5fModifed1 
{E5FBF338-ED6F-4707-8B9E-E3BA1E0309AB}.rpt: The table could not be found.

Have to confess am not a experienced crystal report person so need some help.

Thanks

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

Please consider the environment before printing this e-mail.





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Crystal Report error on particular form and particular PC

[Dwayne Martin]

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

[Susan Palmer]

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

[Jennifer Meyer]

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

[Dwayne Martin]

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

[Susan Palmer]

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

Re: Crystal report error on Mid-Tier

[Joe D'Souza]

Is {?Pm-IT_PIQ.PIQ_ID} a formula field on the Crystal report or a field on
the Remedy form? If {?Pm-IT_PIQ.PIQ_ID} is a field on the Remedy form, maybe
the report is confusing it for a formula field because of the '?' as a
prefix to its name. Try renaming it, verify the database in Crystal reports,
add the new rpt file and run the report..

I also have a doubt on the way Crystal is interpreting the '/' character in
the field IT_Resource.Associated PIQ/Request. Have you checked use of
underscores? I don't recall offhand if a '/' character should get converted
to an '_' character as when you use underscores so make sure you have that
checked..

Cheers

Joe D'Souza

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin
Sent: Monday, November 05, 2007 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Crystal report error on Mid-Tier


Hello everyone,

We have a Crystal Report stored in Report form, launched by an active link.

It displays find in the User tool, but on Mid-Tier we get:

--
Error encountered by Crystal PageServer

The error message returned is:
Error in formula . '{IT_Resource.Associated PIQ/Request} =
{?Pm-IT_PIQ.PIQ_ID}' This field name is not known.. File ITPIQ3.rpt. [On
Cache/Page Server: REMEDY.pageserver]
--

I rebuilt the sub-report from scratch, but still get the same error.

Other Crystal Reports display OK on Mid-Tier.

Any ideas?

(Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.2 db)

Dwayne Martin
James Madison University
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.15.23/1113 - Release Date: 11/6/2007
10:04 AM

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Crystal report error on Mid-Tier

[Dwayne Martin]

Joe,

?Pm- means that it is a prompt, and not part of the field name.  It is the 
sub-report link that the main report feeds to the sub-report for record 
selection.

The / could be a problem.  You say to make sure I have Use underscores 
checked.  It is checked on the server ODBC.  Is there anyplace else it should 
be checked?  I can't find anything in Mid-Tier configuration.

Dwayne

 Original message 
Date: Tue, 6 Nov 2007 09:58:51 -0500
From: Joe D'Souza [EMAIL PROTECTED]  
Subject: Re: Crystal report error on Mid-Tier  
To: arslist@ARSLIST.ORG

   **
   Is {?Pm-IT_PIQ.PIQ_ID} a formula field on the
   Crystal report or a field on the Remedy form? If
   {?Pm-IT_PIQ.PIQ_ID} is a field on the Remedy form,
   maybe the report is confusing it for a formula field
   because of the '?' as a prefix to its name. Try
   renaming it, verify the database in Crystal reports,
   add the new rpt file and run the report..

   I also have a doubt on the way Crystal is
   interpreting the '/' character in the
   field IT_Resource.Associated PIQ/Request. Have you
   checked use of underscores? I don't recall offhand
   if a '/' character should get converted to an '_'
   character as when you use underscores so make sure
   you have that checked..

   Cheers

   Joe D'Souza

   -Original Message-
   From: Action Request System discussion list(ARSList)
   [mailto:[EMAIL PROTECTED] Behalf Of Dwayne
   Martin
   Sent: Monday, November 05, 2007 3:40 PM
   To: arslist@ARSLIST.ORG
   Subject: Crystal report error on Mid-Tier

   Hello everyone,

   We have a Crystal Report stored in Report form,
   launched by an active link.

   It displays find in the User tool, but on Mid-Tier
   we get:

   --
   Error encountered by Crystal PageServer

   The error message returned is:
   Error in formula . '{IT_Resource.Associated
   PIQ/Request} = {?Pm-IT_PIQ.PIQ_ID}' This field name
   is not known.. File ITPIQ3.rpt. [On Cache/Page
   Server: REMEDY.pageserver]
   --

   I rebuilt the sub-report from scratch, but still get
   the same error.

   Other Crystal Reports display OK on Mid-Tier.

   Any ideas?

   (Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.2
   db)

   Dwayne Martin
   James Madison University
   __20060125___This posting was
   submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Crystal report error on Mid-Tier

[Joe D'Souza]

Dwayne,

It was the ODBC configuration I was talking about. By the way calling ?Pm-
a formula field was a devils error. I meant the parameter field.. sorry
about that..

If you already have the 'Use underscores' checked, just for the purpose of
eliminating possible problems, could you hit the option to 'Verify Database'
and save the report? On doing so import that report into the Remedy
reporting forms and then try re-running the report.

Joe D'Souza

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin
Sent: Tuesday, November 06, 2007 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal report error on Mid-Tier


Joe,

?Pm- means that it is a prompt, and not part of the field name.  It is the
sub-report link that the main report feeds to the sub-report for record
selection.

The / could be a problem.  You say to make sure I have Use underscores
checked.  It is checked on the server ODBC.  Is there anyplace else it
should be checked?  I can't find anything in Mid-Tier configuration.

Dwayne

 Original message 
Date: Tue, 6 Nov 2007 09:58:51 -0500
From: Joe D'Souza [EMAIL PROTECTED]
Subject: Re: Crystal report error on Mid-Tier
To: arslist@ARSLIST.ORG

   **
   Is {?Pm-IT_PIQ.PIQ_ID} a formula field on the
   Crystal report or a field on the Remedy form? If
   {?Pm-IT_PIQ.PIQ_ID} is a field on the Remedy form,
   maybe the report is confusing it for a formula field
   because of the '?' as a prefix to its name. Try
   renaming it, verify the database in Crystal reports,
   add the new rpt file and run the report..

   I also have a doubt on the way Crystal is
   interpreting the '/' character in the
   field IT_Resource.Associated PIQ/Request. Have you
   checked use of underscores? I don't recall offhand
   if a '/' character should get converted to an '_'
   character as when you use underscores so make sure
   you have that checked..

   Cheers

   Joe D'Souza

   -Original Message-
   From: Action Request System discussion list(ARSList)
   [mailto:[EMAIL PROTECTED] Behalf Of Dwayne
   Martin
   Sent: Monday, November 05, 2007 3:40 PM
   To: arslist@ARSLIST.ORG
   Subject: Crystal report error on Mid-Tier

   Hello everyone,

   We have a Crystal Report stored in Report form,
   launched by an active link.

   It displays find in the User tool, but on Mid-Tier
   we get:

   --
   Error encountered by Crystal PageServer

   The error message returned is:
   Error in formula . '{IT_Resource.Associated
   PIQ/Request} = {?Pm-IT_PIQ.PIQ_ID}' This field name
   is not known.. File ITPIQ3.rpt. [On Cache/Page
   Server: REMEDY.pageserver]
   --

   I rebuilt the sub-report from scratch, but still get
   the same error.

   Other Crystal Reports display OK on Mid-Tier.

   Any ideas?

   (Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.2
   db)

   Dwayne Martin
   James Madison University
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.15.23/1113 - Release Date: 11/6/2007
10:04 AM

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Crystal report error on Mid-Tier

[[EMAIL PROTECTED]]

Does your active link contain a Qualification with datetime references?

- Original Message 
From: Dwayne Martin [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 5, 2007 1:40:23 PM
Subject: Crystal report error on Mid-Tier


Hello everyone,

We have a Crystal Report stored in Report form, launched by an active
 link.

It displays find in the User tool, but on Mid-Tier we get:

--
Error encountered by Crystal PageServer

The error message returned is:
Error in formula . '{IT_Resource.Associated PIQ/Request} =
 {?Pm-IT_PIQ.PIQ_ID}' This field name is not known.. File ITPIQ3.rpt. [On 
Cache/Page
 Server: REMEDY.pageserver]
--

I rebuilt the sub-report from scratch, but still get the same error.

Other Crystal Reports display OK on Mid-Tier.

Any ideas?

(Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.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





__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Crystal report error on Mid-Tier

[Dwayne Martin]

No, the only qualification is:

 'PIQ ID' = $PIQ ID$ 

(PIQ ID is field 1.)

Dwayne 

 Original message 
Date: Tue, 6 Nov 2007 10:11:18 -0800
From: [EMAIL PROTECTED] [EMAIL PROTECTED]  
Subject: Re: Crystal report error on Mid-Tier  
To: arslist@ARSLIST.ORG

   **
   Does your active link contain a Qualification with
   datetime references?

   - Original Message 
   From: Dwayne Martin [EMAIL PROTECTED]
   To: arslist@ARSLIST.ORG
   Sent: Monday, November 5, 2007 1:40:23 PM
   Subject: Crystal report error on Mid-Tier

   Hello everyone,

   We have a Crystal Report stored in Report form,
   launched by an active link.

   It displays find in the User tool, but on Mid-Tier
   we get:

   --
   Error encountered by Crystal PageServer

   The error message returned is:
   Error in formula . '{IT_Resource.Associated
   PIQ/Request} = {?Pm-IT_PIQ.PIQ_ID}' This field name
   is not known.. File ITPIQ3.rpt. [On Cache/Page
   Server: REMEDY.pageserver]
   --

   I rebuilt the sub-report from scratch, but still get
   the same error.

   Other Crystal Reports display OK on Mid-Tier.

   Any ideas?

   (Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.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
   __
   Do You Yahoo!?
   Tired of spam? Yahoo! Mail has the best spam
   protection around
   http://mail.yahoo.com
   __20060125___This posting was
   submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Crystal report error on Mid-Tier

[Pargeter, Christie]

Have you tried to re-select your sub-query's quals?

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Dwayne Martin
Sent: Tuesday, November 06, 2007 10:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal report error on Mid-Tier

No, the only qualification is:

 'PIQ ID' = $PIQ ID$

(PIQ ID is field 1.)

Dwayne

 Original message 
Date: Tue, 6 Nov 2007 10:11:18 -0800
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Crystal report error on Mid-Tier
To: arslist@ARSLIST.ORG

   **
   Does your active link contain a Qualification with
   datetime references?

   - Original Message 
   From: Dwayne Martin [EMAIL PROTECTED]
   To: arslist@ARSLIST.ORG
   Sent: Monday, November 5, 2007 1:40:23 PM
   Subject: Crystal report error on Mid-Tier

   Hello everyone,

   We have a Crystal Report stored in Report form,
   launched by an active link.

   It displays find in the User tool, but on Mid-Tier
   we get:

   --
   Error encountered by Crystal PageServer

   The error message returned is:
   Error in formula . '{IT_Resource.Associated
   PIQ/Request} = {?Pm-IT_PIQ.PIQ_ID}' This field name
   is not known.. File ITPIQ3.rpt. [On Cache/Page
   Server: REMEDY.pageserver]
   --

   I rebuilt the sub-report from scratch, but still get
   the same error.

   Other Crystal Reports display OK on Mid-Tier.

   Any ideas?

   (Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.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
   __
   Do You Yahoo!?
   Tired of spam? Yahoo! Mail has the best spam
   protection around
   http://mail.yahoo.com
   __20060125___This posting was
   submitted with HTML in it___

___
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

Re: Crystal report error on Mid-Tier

[Dwayne Martin]

Hi Christie,

I don't understand your question.  I did delete the subfile and re-write it 
from scratch.  It works fine in the User tool.

Dwayne

 Original message 
Date: Tue, 6 Nov 2007 10:36:44 -0800
From: Pargeter, Christie [EMAIL PROTECTED]  
Subject: Re: Crystal report error on Mid-Tier  
To: arslist@ARSLIST.ORG

Have you tried to re-select your sub-query's quals?

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Dwayne Martin
Sent: Tuesday, November 06, 2007 10:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal report error on Mid-Tier

No, the only qualification is:

 'PIQ ID' = $PIQ ID$

(PIQ ID is field 1.)

Dwayne

 Original message 
Date: Tue, 6 Nov 2007 10:11:18 -0800
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Crystal report error on Mid-Tier
To: arslist@ARSLIST.ORG

   **
   Does your active link contain a Qualification with
   datetime references?

   - Original Message 
   From: Dwayne Martin [EMAIL PROTECTED]
   To: arslist@ARSLIST.ORG
   Sent: Monday, November 5, 2007 1:40:23 PM
   Subject: Crystal report error on Mid-Tier

   Hello everyone,

   We have a Crystal Report stored in Report form,
   launched by an active link.

   It displays find in the User tool, but on Mid-Tier
   we get:

   --
   Error encountered by Crystal PageServer

   The error message returned is:
   Error in formula . '{IT_Resource.Associated
   PIQ/Request} = {?Pm-IT_PIQ.PIQ_ID}' This field name
   is not known.. File ITPIQ3.rpt. [On Cache/Page
   Server: REMEDY.pageserver]
   --

   I rebuilt the sub-report from scratch, but still get
   the same error.

   Other Crystal Reports display OK on Mid-Tier.

   Any ideas?

   (Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.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
   __
   Do You Yahoo!?
   Tired of spam? Yahoo! Mail has the best spam
   protection around
   http://mail.yahoo.com
   __20060125___This posting was
   submitted with HTML in it___

___
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

Re: Crystal report error on Mid-Tier

[[EMAIL PROTECTED]]

Dwayne,
I'm not saying that this is your error but we currently have an open support 
issue with a software defect number SW00280014 directly related to generating a 
Crystal Report on the Mid Tier from an AL which seems similar to your issue.  
According Remedy Tech. this issue has been around since 6.3 and is still 
present in 7.0.1.  Here is the detail information on our issue.  It may be 
worth it to check with support and see if your issue could be related to this 
defect. If it is related then it would certainly help get the defect resolution 
elevated.

ARSystem 7.0.1 Patch 4
Mid-Tier 7.0.1 Patch 4
MSSQL 2000
Win Srv 2003 
Crystal Enterprise 10

An ActiveLink which generates a report of type Crystal causes an error when a 
Qualification contains a datetime field compared to the 10/18/2007 10:52:47 AM 
keyword when executed on the Mid-Tier. (example:  'datetimefield'  10/18/2007 
10:52:47 AM).

ERROR Displayed
Crystal Report Viewer
Error in formula A number, currency amount, boolean, date, time, date-time, or 
string is expected here. 
Details: errorKind. File report.rpt [On Cache/Page Server.  
SERVERNAME.pageserver] 

The report in question has been verified against the database, executes 
correctly with the activelink when the date comparison is removed from the 
Qualification field, runs from the Remedy Report Selection Console, runs when 
executed directly from a web browser, runs from the report function of the User 
Tool.  ActiveLink logging shows successful activelink processing (i.e. 
activelink log shows no errors).  Data for the date field has been manually 
validated and the field contains valid data for all records.
 
HTH,
Dave Fincher


- Original Message 
From: Pargeter, Christie [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Tuesday, November 6, 2007 1:35:31 PM
Subject: FW: Crystal report error on Mid-Tier


You can edit the sub report's links your issue might be there.  You can
 do this in 2 places, right click the sub report  select Change
 Subreports links... or on the criteria of the embedded subreport.

-Original Message-
From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Tuesday, November 06, 2007 11:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal report error on Mid-Tier

Hi Christie,

I don't understand your question.  I did delete the subfile and
 re-write it from scratch.  It works fine in the User tool.

Dwayne

 Original message 
Date: Tue, 6 Nov 2007 10:36:44 -0800
From: Pargeter, Christie [EMAIL PROTECTED]
Subject: Re: Crystal report error on Mid-Tier
To: arslist@ARSLIST.ORG

Have you tried to re-select your sub-query's quals?

___
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





__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Re: Crystal Report Error

[Durrant, Michael M. - ITSD]

Shawn,
 
  Completely remove Windows User Tool and the Crystal XI redistributables that 
get installed with it, reboot, reinstall WUT.  I've had that happen to a couple 
of my users here and that always fixed it.  In my case, it seemed to be related 
to another version of Crystal being installed at the same time.
 
Michael



From: Action Request System discussion list(ARSList) on behalf of Pierson, Shawn
Sent: Wed 6/20/2007 10:47 AM
To: arslist@ARSLIST.ORG
Subject: Crystal Report Error


** 

Good morning folks, 

When attempting to run a report out of the full client in 7.0, I get the 
following error: 

An error occurred while generating the Crystal report: 0x80004003 - Invalid 
pointer (ARERR 1904) 

Any ideas on what this is and how to fix it?  The BMC knowledgebase is useless 
for this problem. 

Thanks, 

Shawn Pierson 

The information in this e-mail, and any files transmitted with it, is intended 
for the exclusive use of the recipient(s) to which it is addressed and may 
contain confidential, proprietary or privileged information. If you are not an 
intended recipient, you have received this transmission in error and any use, 
review, dissemination, distribution, printing or copying of this information is 
strictly prohibited. If you have received this e-mail in error, please notify 
the sender immediately of the erroneous transmission by reply e-mail, 
immediately delete this e-mail and all electronic copies of it from your system 
and destroy any hard copies of it that you may have made. Thank you.

__20060125___This posting was submitted with HTML in it___

The information contained in this email may be privileged, confidential or 
otherwise protected from disclosure.  All persons are advised that they may 
face penalties under state and federal law for sharing this information with 
unauthorized individuals.  If you received this email in error, please reply to 
the sender that you have received this information in error.  Also, please 
delete this email after replying to the sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[strauss]

Be CAREFUL about uninstalling the 7.x User tool - prior to 7.0.01.002 or
003 uninstalling the crystal executables (automatic on uninstalling the
User Tool) has a very good change of completely destroying any Microsoft
Office installation (crystal uninstaller problem).  It requires
reimaging the Windows machine to fix.  I has happened here, and it is a
known defect of the User Tool uninstaller.

Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD
Sent: Wednesday, June 20, 2007 12:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report Error

Shawn,
 
  Completely remove Windows User Tool and the Crystal XI
redistributables that get installed with it, reboot, reinstall WUT.
I've had that happen to a couple of my users here and that always fixed
it.  In my case, it seemed to be related to another version of Crystal
being installed at the same time.
 
Michael



From: Action Request System discussion list(ARSList) on behalf of
Pierson, Shawn
Sent: Wed 6/20/2007 10:47 AM
To: arslist@ARSLIST.ORG
Subject: Crystal Report Error


** 

Good morning folks, 

When attempting to run a report out of the full client in 7.0, I get the
following error: 

An error occurred while generating the Crystal report: 0x80004003 -
Invalid pointer (ARERR 1904) 

Any ideas on what this is and how to fix it?  The BMC knowledgebase is
useless for this problem. 

Thanks, 

Shawn Pierson 

The information in this e-mail, and any files transmitted with it, is
intended for the exclusive use of the recipient(s) to which it is
addressed and may contain confidential, proprietary or privileged
information. If you are not an intended recipient, you have received
this transmission in error and any use, review, dissemination,
distribution, printing or copying of this information is strictly
prohibited. If you have received this e-mail in error, please notify the
sender immediately of the erroneous transmission by reply e-mail,
immediately delete this e-mail and all electronic copies of it from your
system and destroy any hard copies of it that you may have made. Thank
you.

__20060125___This posting was submitted with HTML in
it___

The information contained in this email may be privileged, confidential
or otherwise protected from disclosure.  All persons are advised that
they may face penalties under state and federal law for sharing this
information with unauthorized individuals.  If you received this email
in error, please reply to the sender that you have received this
information in error.  Also, please delete this email after replying to
the sender.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[David Yearsley]

We have seen this error.
 
In some cases a reinstall of the user or an upgrade fixed the problem.
 
In others we renamed the folder C:\Program Files\Common Files\Business 
Objects\3.0 to C:\Program Files\Common Files\Business Objects\3.0_OLD and then 
did a reinstall. This forces the install to reinstall the crystal link.
 
** 

 Pierson, Shawn [EMAIL PROTECTED] Jun 20, 2007 10:47 AM 

Good morning folks, 
When attempting to run a report out of the full client in 7.0, I get the 
following error: 
An error occurred while generating the Crystal report: 0x80004003 - Invalid 
pointer (ARERR 1904) 
Any ideas on what this is and how to fix it?  The BMC knowledgebase is useless 
for this problem. 
Thanks, 
Shawn Pierson 
The information in this e-mail, and any files transmitted with it, is intended 
for the exclusive use of the recipient(s) to which it is addressed and may 
contain confidential, proprietary or privileged information. If you are not an 
intended recipient, you have received this transmission in error and any use, 
review, dissemination, distribution, printing or copying of this information is 
strictly prohibited. If you have received this e-mail in error, please notify 
the sender immediately of the erroneous transmission by reply e-mail, 
immediately delete this e-mail and all electronic copies of it from your system 
and destroy any hard copies of it that you may have made. Thank 
you.__20060125___This posting was submitted with HTML in 
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Evans.Randy]

49808



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of David Yearsley
Sent: Wednesday, June 20, 2007 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report Error


** 
We have seen this error.
 
In some cases a reinstall of the user or an upgrade fixed the problem.
 
In others we renamed the folder C:\Program Files\Common Files\Business
Objects\3.0 to C:\Program Files\Common Files\Business Objects\3.0_OLD
and then did a reinstall. This forces the install to reinstall the
crystal link.
 
** 

 Pierson, Shawn [EMAIL PROTECTED] Jun 20, 2007 10:47 AM 


Good morning folks, 

When attempting to run a report out of the full client in 7.0, I get the
following error: 

An error occurred while generating the Crystal report: 0x80004003 -
Invalid pointer (ARERR 1904) 

Any ideas on what this is and how to fix it?  The BMC knowledgebase is
useless for this problem. 

Thanks, 

Shawn Pierson 

The information in this e-mail, and any files transmitted with it, is
intended for the exclusive use of the recipient(s) to which it is
addressed and may contain confidential, proprietary or privileged
information. If you are not an intended recipient, you have received
this transmission in error and any use, review, dissemination,
distribution, printing or copying of this information is strictly
prohibited. If you have received this e-mail in error, please notify the
sender immediately of the erroneous transmission by reply e-mail,
immediately delete this e-mail and all electronic copies of it from your
system and destroy any hard copies of it that you may have made. Thank
you.

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with
HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Evans.Randy]

Sorry, wrong email, been one of those days.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of David Yearsley
Sent: Wednesday, June 20, 2007 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report Error


** 
We have seen this error.
 
In some cases a reinstall of the user or an upgrade fixed the problem.
 
In others we renamed the folder C:\Program Files\Common Files\Business
Objects\3.0 to C:\Program Files\Common Files\Business Objects\3.0_OLD
and then did a reinstall. This forces the install to reinstall the
crystal link.
 
** 

 Pierson, Shawn [EMAIL PROTECTED] Jun 20, 2007 10:47 AM 


Good morning folks, 

When attempting to run a report out of the full client in 7.0, I get the
following error: 

An error occurred while generating the Crystal report: 0x80004003 -
Invalid pointer (ARERR 1904) 

Any ideas on what this is and how to fix it?  The BMC knowledgebase is
useless for this problem. 

Thanks, 

Shawn Pierson 

The information in this e-mail, and any files transmitted with it, is
intended for the exclusive use of the recipient(s) to which it is
addressed and may contain confidential, proprietary or privileged
information. If you are not an intended recipient, you have received
this transmission in error and any use, review, dissemination,
distribution, printing or copying of this information is strictly
prohibited. If you have received this e-mail in error, please notify the
sender immediately of the erroneous transmission by reply e-mail,
immediately delete this e-mail and all electronic copies of it from your
system and destroy any hard copies of it that you may have made. Thank
you.

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with
HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error (Solved ?)

[patrick zandi]

I chatted to remedy concerning this issue,
The issue is the following:
Any report Previously made by any other versions to 9 is DOA.

So if you have created a report in 7 - 8 - 8.5  and then upgraded them to
9.0
and expect to use them in any way shape or Form.. Forget it. They are DOA.

New DLL's require either a Fresh 9.0 or XI CR design.  That is the Issue in
a NutShell folks..

Hope that helps.

I had the issues as well, and I never went to ARS 7.01 because once you
cross into that version of Server you can no longer use the OLDER CR's. But
if you use ARS 7.00.02 or Patch2 and Client 6.3 all is fine.  But you also
cannot use the ARS 7.X client.

Have a Great CR Rebuilding day ..   8-)



On 3/5/07, Derek Fernandes [EMAIL PROTECTED] wrote:


Hi listers,

We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk 4.03.
We have a couple of Crystal Reports that were working on ARS 6.3. Now,
when we push the button to print the report we get the following error:

An error occurred while generating the Crystal report: 0x80047e48 -
Logon failed. (ARERR 1904)

I have installed the latest version of the User Tool and checked the
active link that generates the report, and made sure on the Report
Information tab:
Report Type = Crystal
Location = Embedded
Name = \\reportname.rpt
Destination = Printer

Any help would be greatly appreciated.

Derek

--
Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta  T2N 1N4
403.210.9879


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are





--
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error (Solved ?)

[Cupp, Michael E Jr. CTR USAF AFRL/SNOD]

OK, I am using CR 9.2.2.634 and am getting Derek's error message as
well.  Thoughts?  My report was created using this version of CR.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi
Sent: Wednesday, April 25, 2007 11:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report Error (Solved ?)


** 
I chatted to remedy concerning this issue, 
The issue is the following:
Any report Previously made by any other versions to 9 is DOA.
 
So if you have created a report in 7 - 8 - 8.5  and then upgraded them
to 9.0
and expect to use them in any way shape or Form.. Forget it. They are
DOA.
 
New DLL's require either a Fresh 9.0 or XI CR design.  That is the Issue
in a NutShell folks..
 
Hope that helps.
 
I had the issues as well, and I never went to ARS 7.01 because once you
cross into that version of Server you can no longer use the OLDER CR's.
But if you use ARS 7.00.02 or Patch2 and Client 6.3 all is fine.  But
you also cannot use the ARS 7.X client.  
 
Have a Great CR Rebuilding day ..   8-)


 
On 3/5/07, Derek Fernandes [EMAIL PROTECTED] wrote: 

Hi listers,

We just moved to ARS 7.0.1 patch 1 but we are still using
HelpDesk 4.03.
We have a couple of Crystal Reports that were working on ARS
6.3. Now,
when we push the button to print the report we get the following
error:

An error occurred while generating the Crystal report:
0x80047e48 -
Logon failed. (ARERR 1904)

I have installed the latest version of the User Tool and checked
the 
active link that generates the report, and made sure on the
Report
Information tab:
Report Type = Crystal
Location = Embedded
Name = \\reportname.rpt
Destination = Printer

Any help would be greatly appreciated. 

Derek

--
Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta  T2N 1N4
403.210.9879



___ 
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:Where the Answers Are





-- 
Patrick Zandi __20060125___This posting was
submitted with HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error (Solved ?)

[patrick zandi]

Wow, not sure - maybe that was fixed on patch 2.
I was assured this was the scenario..
I am planning on rebuilding all mine in CR XI, so I should be able to test
after that..
But till then.. Contact support .. I would love to here the results.
Try to get immanual..


On 4/25/07, Cupp, Michael E Jr. CTR USAF AFRL/SNOD 
[EMAIL PROTECTED] wrote:


** OK, I am using CR 9.2.2.634 and am getting Derek's error message as
well.  Thoughts?  My report was created using this version of CR.

 --
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *patrick zandi
*Sent:* Wednesday, April 25, 2007 11:52 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Crystal Report Error (Solved ?)


** I chatted to remedy concerning this issue,
The issue is the following:
Any report Previously made by any other versions to 9 is DOA.

So if you have created a report in 7 - 8 - 8.5  and then upgraded them to
9.0
and expect to use them in any way shape or Form.. Forget it. They are DOA.

New DLL's require either a Fresh 9.0 or XI CR design.  That is the Issue
in a NutShell folks..

Hope that helps.

I had the issues as well, and I never went to ARS 7.01 because once you
cross into that version of Server you can no longer use the OLDER CR's. But
if you use ARS 7.00.02 or Patch2 and Client 6.3 all is fine.  But you also
cannot use the ARS 7.X client.

Have a Great CR Rebuilding day ..   8-)



On 3/5/07, Derek Fernandes [EMAIL PROTECTED] wrote:

 Hi listers,

 We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk 4.03.
 We have a couple of Crystal Reports that were working on ARS 6.3. Now,
 when we push the button to print the report we get the following error:

 An error occurred while generating the Crystal report: 0x80047e48 -
 Logon failed. (ARERR 1904)

 I have installed the latest version of the User Tool and checked the
 active link that generates the report, and made sure on the Report
 Information tab:
 Report Type = Crystal
 Location = Embedded
 Name = \\reportname.rpt
 Destination = Printer

 Any help would be greatly appreciated.

 Derek

 --
 Derek Fernandes
 Programmer Analyst
 U of C Information Technologies
 ES 1010, University of Calgary
 Calgary, Alberta  T2N 1N4
 403.210.9879

 
___

 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
 the Answers Are




--
Patrick Zandi __20060125___This posting was submitted
with HTML in it___
__20060125___This posting was submitted with HTML in
it___





--
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error

[patrick zandi]

Bill,
Did you try the reinstall on top of what is there ?
This would be my first approach.


On 3/20/07, Bill H [EMAIL PROTECTED] wrote:


** The issue I'm having (7.01 client - Crystal XI developed report) ,
started long after our upgrade.  No one else here is having  the problem.
I've installed other software on this machine, before the problem appeared.
That's why I think it's a dll/registry issue, at least for me.

I don't really expect Remedy support to take this on.  Even if I had tons
of faith in them, I think the issue would be difficult to replicate.  I was
just wondering if the crystal developer was present on the machines with
this problem. I am, basically, just looking for a pattern.

Bill

- Original Message -
*From:* Susan Palmer [EMAIL PROTECTED]
*Newsgroups:* public.remedy.arsystem.general
*To:* arslist@ARSLIST.ORG
 *Sent:* Tuesday, March 20, 2007 1:46 PM
*Subject:* Re: Crystal Report Error


** With this many people having the issue, what does Remedy support say?
You are clicking on a button using the odbc driver that is supplied within
the user tool.

Was it always like this or did it change recently?

Susan


On 3/20/07, Bill H [EMAIL PROTECTED] wrote:

 Mikhail,

 I'm also getting this error and it just started.  Quick question do you
 have
 the Crystal Reports Developers tool installed on that machine?  I also
 believe it's a dll/registry issue, but I haven't isolated it yet.

 Bill

 - Original Message -
 From: Mikhail [EMAIL PROTECTED]
 Newsgroups: public.remedy.arsystem.general
 To: arslist@ARSLIST.ORG
 Sent: Tuesday, March 20, 2007 12:19 PM
 Subject: Re: Crystal Report Error


 Hello Guys,
 Just a little update on the situation.
 When I login to User tool and try to print crystal reports using the
 DTP Style button, It gives me a logon error (arerr 1904). When I ask
 someone else to login to my usertool, they can print successfully!
 Interesting thing is we both have Administrator accounts...
 So now we're thinking this could be some permission issue, but we
 can't quite point our fingers at it.
 Anyone?


 On Mar 20, 12:01 pm, Ben Cantatore  [EMAIL PROTECTED] wrote:
  Kinda silly, but try fully qualifying the name of the server in the
 ODBC
  driver.
 
 
 
___­

  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
 the
  Answers Are


 
___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
 the
 Answers Are


 
___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
 the Answers Are


__20060125___This posting was submitted with HTML in
it___

__20060125___This posting was submitted with HTML in
it___





--
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error

[Bill H.]

Patrick,

Reinstalling the WUT was one of the first things I tried.  I have a few more 
things to try today including Susan's suggestion of creating a new user, and  
uninstalling the WUT and then reinstalling.  As a true sign of desperation - 
I'll reimage the machine.  I'm just kidding about that last one!

I can run the reports (my issue is with all reports) on a different machine as 
a workaround.  My goal is to to determine an effective resolution for future 
victims.  I appreciate all the help I've gotten on this topic.  It's helped 
move me closer to my goal.

Bill
  - Original Message - 
  From: patrick zandi 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Wednesday, March 21, 2007 6:11 AM
  Subject: Re: Crystal Report Error


  ** 
  Bill, 
  Did you try the reinstall on top of what is there ?
  This would be my first approach.

   
  On 3/20/07, Bill H [EMAIL PROTECTED] wrote: 
** 
The issue I'm having (7.01 client - Crystal XI developed report) , started 
long after our upgrade.  No one else here is having  the problem.  I've 
installed other software on this machine, before the problem appeared.  That's 
why I think it's a dll/registry issue, at least for me.  

I don't really expect Remedy support to take this on.  Even if I had tons 
of faith in them, I think the issue would be difficult to replicate.  I was 
just wondering if the crystal developer was present on the machines with this 
problem. I am, basically, just looking for a pattern. 

Bill
  - Original Message - 
  From: Susan Palmer 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Tuesday, March 20, 2007 1:46 PM
  Subject: Re: Crystal Report Error

   
  ** 
  With this many people having the issue, what does Remedy support say?  
You are clicking on a button using the odbc driver that is supplied within the 
user tool.

  Was it always like this or did it change recently?  

  Susan

   
  On 3/20/07, Bill H [EMAIL PROTECTED]  wrote: 
Mikhail,

I'm also getting this error and it just started.  Quick question do you 
have
the Crystal Reports Developers tool installed on that machine?  I also 
believe it's a dll/registry issue, but I haven't isolated it yet.

Bill

- Original Message -
From: Mikhail  [EMAIL PROTECTED] 
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Sent: Tuesday, March 20, 2007 12:19 PM
Subject: Re: Crystal Report Error


Hello Guys, 
Just a little update on the situation.
When I login to User tool and try to print crystal reports using the
DTP Style button, It gives me a logon error (arerr 1904). When I ask
someone else to login to my usertool, they can print successfully! 
Interesting thing is we both have Administrator accounts...
So now we're thinking this could be some permission issue, but we 
can't quite point our fingers at it.
Anyone?


On Mar 20, 12:01 pm, Ben Cantatore  [EMAIL PROTECTED]  wrote:
 Kinda silly, but try fully qualifying the name of the server in the 
ODBC
 driver.

 
___­
 
 UNSUBSCRIBE or access ARSlist Archives 
atwww.arslist.orgARSlist:Where the
 Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
ARSlist:Where the
Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
ARSlist:Where the Answers Are


  __20060125___This posting was submitted with HTML in 
it___ 
__20060125___This posting was submitted with HTML in 
it___ 



  -- 
  Patrick Zandi __20060125___This posting was submitted 
with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Heider, Stephen]

If your username is using Centralized Preferences, have you tried
deleting your record in the AR System User Preference form?
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bill H.
Sent: Wednesday, March 21, 2007 10:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report Error


** 
Patrick,
 
Reinstalling the WUT was one of the first things I tried.  I have a few
more things to try today including Susan's suggestion of creating a new
user, and  uninstalling the WUT and then reinstalling.  As a true sign
of desperation - I'll reimage the machine.  I'm just kidding about that
last one!
 
I can run the reports (my issue is with all reports) on a different
machine as a workaround.  My goal is to to determine an effective
resolution for future victims.  I appreciate all the help I've gotten on
this topic.  It's helped move me closer to my goal.
 
Bill

- Original Message - 
From: patrick zandi mailto:[EMAIL PROTECTED]  
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Sent: Wednesday, March 21, 2007 6:11 AM
Subject: Re: Crystal Report Error

** 
Bill, 
Did you try the reinstall on top of what is there ?
This would be my first approach.

 
On 3/20/07, Bill H [EMAIL PROTECTED] wrote: 

** 
The issue I'm having (7.01 client - Crystal XI developed
report) , started long after our upgrade.  No one else here is having
the problem.  I've installed other software on this machine, before the
problem appeared.  That's why I think it's a dll/registry issue, at
least for me.  
 
I don't really expect Remedy support to take this on.
Even if I had tons of faith in them, I think the issue would be
difficult to replicate.  I was just wondering if the crystal developer
was present on the machines with this problem. I am, basically, just
looking for a pattern. 

 
Bill


- Original Message - 
From: Susan Palmer
mailto:[EMAIL PROTECTED]  
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 

Sent: Tuesday, March 20, 2007 1:46 PM
Subject: Re: Crystal Report Error

 
** 
With this many people having the issue, what
does Remedy support say?  You are clicking on a button using the odbc
driver that is supplied within the user tool.
 
Was it always like this or did it change
recently?  
 
Susan

 
On 3/20/07, Bill H [EMAIL PROTECTED] 
wrote: 

Mikhail,

I'm also getting this error and it just
started.  Quick question do you have
the Crystal Reports Developers tool
installed on that machine?  I also 
believe it's a dll/registry issue, but I
haven't isolated it yet.

Bill

- Original Message -
From: Mikhail  [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  
Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Sent: Tuesday, March 20, 2007 12:19 PM
Subject: Re: Crystal Report Error


Hello Guys, 
Just a little update on the situation.
When I login to User tool and try to
print crystal reports using the
DTP Style button, It gives me a logon
error (arerr 1904). When I ask
someone else to login to my usertool,
they can print successfully! 
Interesting thing is we both have
Administrator accounts...
So now we're thinking this could be some
permission issue, but we 
can't quite point our fingers at it.
Anyone?


On Mar 20, 12:01 pm, Ben Cantatore 
[EMAIL PROTECTED]  wrote:
 Kinda silly, but try fully qualifying
the name of the server

Re: Crystal Report Error

[Susan Palmer]

But it seems so far the victims have been admins, which may be a clue.
Mikhail was successful just by creating the new user, which you sure
wouldn't want to do for alot of people.  Something is odd, but you can get
grey hair worrying about these things if it's a one-off issue.

Susan


On 3/21/07, Bill H. [EMAIL PROTECTED] wrote:


** Patrick,

Reinstalling the WUT was one of the first things I tried.  I have a few
more things to try today including Susan's suggestion of creating a new
user, and  uninstalling the WUT and then reinstalling.  As a true sign of
desperation - I'll reimage the machine.  I'm just kidding about that last
one!

I can run the reports (my issue is with all reports) on a different
machine as a workaround.  My goal is to to determine an effective resolution
for future victims.  I appreciate all the help I've gotten on this topic.
It's helped move me closer to my goal.

Bill

- Original Message -
*From:* patrick zandi [EMAIL PROTECTED]
*Newsgroups:* public.remedy.arsystem.general
*To:* arslist@ARSLIST.ORG
 *Sent:* Wednesday, March 21, 2007 6:11 AM
*Subject:* Re: Crystal Report Error


** Bill,
Did you try the reinstall on top of what is there ?
This would be my first approach.


On 3/20/07, Bill H [EMAIL PROTECTED] wrote:

 ** The issue I'm having (7.01 client - Crystal XI developed report) ,
 started long after our upgrade.  No one else here is having  the problem.
 I've installed other software on this machine, before the problem appeared.
 That's why I think it's a dll/registry issue, at least for me.

 I don't really expect Remedy support to take this on.  Even if I had
 tons of faith in them, I think the issue would be difficult to replicate.  I
 was just wondering if the crystal developer was present on the machines with
 this problem. I am, basically, just looking for a pattern.

 Bill

 - Original Message -
 *From:* Susan Palmer [EMAIL PROTECTED]
 *Newsgroups:* public.remedy.arsystem.general
 *To:* arslist@ARSLIST.ORG
  *Sent:* Tuesday, March 20, 2007 1:46 PM
 *Subject:* Re: Crystal Report Error


 ** With this many people having the issue, what does Remedy support
 say?  You are clicking on a button using the odbc driver that is supplied
 within the user tool.

 Was it always like this or did it change recently?

 Susan


 On 3/20/07, Bill H [EMAIL PROTECTED]  wrote:
 
  Mikhail,
 
  I'm also getting this error and it just started.  Quick question do
  you have
  the Crystal Reports Developers tool installed on that machine?  I also
 
  believe it's a dll/registry issue, but I haven't isolated it yet.
 
  Bill
 
  - Original Message -
  From: Mikhail  [EMAIL PROTECTED]
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG
  Sent: Tuesday, March 20, 2007 12:19 PM
  Subject: Re: Crystal Report Error
 
 
  Hello Guys,
  Just a little update on the situation.
  When I login to User tool and try to print crystal reports using the
  DTP Style button, It gives me a logon error (arerr 1904). When I ask
  someone else to login to my usertool, they can print successfully!
  Interesting thing is we both have Administrator accounts...
  So now we're thinking this could be some permission issue, but we
  can't quite point our fingers at it.
  Anyone?
 
 
  On Mar 20, 12:01 pm, Ben Cantatore  [EMAIL PROTECTED]  wrote:
   Kinda silly, but try fully qualifying the name of the server in the
  ODBC
   driver.
  
  
  
___­
 
   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
  the
   Answers Are
 
 
  
___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgARSlist:Where the
  Answers Are
 
 
  
___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgARSlist:Where the 
Answers Are
 

 __20060125___This posting was submitted with HTML in
 it___

 __20060125___This posting was submitted with HTML in
 it___




--
Patrick Zandi __20060125___This posting was submitted
with HTML in it___

__20060125___This posting was submitted with HTML in
it___



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error

[Mikhail]

Hi Susan,
One of our clients also had this problem. He got a logon failed error.
So I asked him to check his ODBC configurations, and noticed that the
ARServer field was blank. So he entered in remprod1 (which is our
server name) and it worked for him.
As for the account that I have that doesn't work, I tried logging on
to another machine and still didn't work. But when I tried logging on
with my new account (which works on MY station), worked on the other
station.
So clearly, there is something wrong with my old account.
As for the workflow differences, I couldn't find anything different
between the two, which means to me that the ALs associated with this
problem are working as they should be. It is on the back end of things
that are screwy.
I do not want to delete my old account YET, i want to compare the
differences between the bad and good accounts so I can narrow down
what's causing this to happen.
Any suggestions on how to do that?
Thanks for all your input!

On Mar 21, 8:23 am, Susan Palmer [EMAIL PROTECTED] wrote:
 But it seems so far the victims have been admins, which may be a clue.
 Mikhail was successful just by creating the new user, which you sure
 wouldn't want to do for alot of people.  Something is odd, but you can get
 grey hair worrying about these things if it's a one-off issue.

 Susan

 On 3/21/07, Bill H. [EMAIL PROTECTED] wrote:







  ** Patrick,

  Reinstalling the WUT was one of the first things I tried.  I have a few
  more things to try today including Susan's suggestion of creating a new
  user, and  uninstalling the WUT and then reinstalling.  As a true sign of
  desperation - I'll reimage the machine.  I'm just kidding about that last
  one!

  I can run the reports (my issue is with all reports) on a different
  machine as a workaround.  My goal is to to determine an effective resolution
  for future victims.  I appreciate all the help I've gotten on this topic.
  It's helped move me closer to my goal.

  Bill

  - Original Message -
  *From:* patrick zandi [EMAIL PROTECTED]
  *Newsgroups:* public.remedy.arsystem.general
  *To:* [EMAIL PROTECTED]
   *Sent:* Wednesday, March 21, 2007 6:11 AM
  *Subject:* Re: Crystal Report Error

  ** Bill,
  Did you try the reinstall on top of what is there ?
  This would be my first approach.

  On 3/20/07, Bill H [EMAIL PROTECTED] wrote:

   ** The issue I'm having (7.01 client - Crystal XI developed report) ,
   started long after our upgrade.  No one else here is having  the problem.
   I've installed other software on this machine, before the problem 
   appeared.
   That's why I think it's a dll/registry issue, at least for me.

   I don't really expect Remedy support to take this on.  Even if I had
   tons of faith in them, I think the issue would be difficult to replicate. 
I
   was just wondering if the crystal developer was present on the machines 
   with
   this problem. I am, basically, just looking for a pattern.

   Bill

   - Original Message -
   *From:* Susan Palmer [EMAIL PROTECTED]
   *Newsgroups:* public.remedy.arsystem.general
   *To:* [EMAIL PROTECTED]
*Sent:* Tuesday, March 20, 2007 1:46 PM
   *Subject:* Re: Crystal Report Error

   ** With this many people having the issue, what does Remedy support
   say?  You are clicking on a button using the odbc driver that is supplied
   within the user tool.

   Was it always like this or did it change recently?

   Susan

   On 3/20/07, Bill H [EMAIL PROTECTED]  wrote:

Mikhail,

I'm also getting this error and it just started.  Quick question do
you have
the Crystal Reports Developers tool installed on that machine?  I also

believe it's a dll/registry issue, but I haven't isolated it yet.

Bill

- Original Message -
From: Mikhail  [EMAIL PROTECTED]
Newsgroups: public.remedy.arsystem.general
To: [EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 12:19 PM
Subject: Re: Crystal Report Error

Hello Guys,
Just a little update on the situation.
When I login to User tool and try to print crystal reports using the
DTP Style button, It gives me a logon error (arerr 1904). When I ask
someone else to login to my usertool, they can print successfully!
Interesting thing is we both have Administrator accounts...
So now we're thinking this could be some permission issue, but we
can't quite point our fingers at it.
Anyone?

On Mar 20, 12:01 pm, Ben Cantatore  [EMAIL PROTECTED]  wrote:
 Kinda silly, but try fully qualifying the name of the server in the
ODBC
 driver.

___­­

 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
the
 Answers Are

___­
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where 
the
Answers

Re: Crystal Report Error

[Ben Cantatore]

Kinda silly, but try fully qualifying the name of the server in the ODBC 
driver. 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Mikhail]

Hello Guys,
Just a little update on the situation.
When I login to User tool and try to print crystal reports using the
DTP Style button, It gives me a logon error (arerr 1904). When I ask
someone else to login to my usertool, they can print successfully!
Interesting thing is we both have Administrator accounts...
So now we're thinking this could be some permission issue, but we
can't quite point our fingers at it.
Anyone?


On Mar 20, 12:01 pm, Ben Cantatore [EMAIL PROTECTED] wrote:
 Kinda silly, but try fully qualifying the name of the server in the ODBC
 driver.

 ___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the 
 Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Susan Palmer]

Well ... since administrators are 'all powerful' it does seem odd.  Make
another account for yourself and try that one.  If it works, delete the old
one and use the one that works.  There must be something different but
without being there it's really hard to troubleshoot something that is
probably simple.  And no, please don't send any logfiles !

Susan


On 3/20/07, Mikhail [EMAIL PROTECTED] wrote:


Hello Guys,
Just a little update on the situation.
When I login to User tool and try to print crystal reports using the
DTP Style button, It gives me a logon error (arerr 1904). When I ask
someone else to login to my usertool, they can print successfully!
Interesting thing is we both have Administrator accounts...
So now we're thinking this could be some permission issue, but we
can't quite point our fingers at it.
Anyone?


On Mar 20, 12:01 pm, Ben Cantatore [EMAIL PROTECTED] wrote:
 Kinda silly, but try fully qualifying the name of the server in the ODBC
 driver.


___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error (U)

[Hennigan, Sandra H CTR OSD-CIO]

UNCLASSIFIED

What about Use Underscores?  Remedy generally does on their Crystal
Reports; users generally do not.  It is a setting in the ODBC
Configuration Setting.
On your Remedy client - click Tools  Options  Advanced
Check ODBC Use Underscores and run the report again.
If it is already checked, uncheck it and run the report.

Sandra Hennigan

OSD Remedy Administrator
Office # 703-602-0980 x174
CACI - Ever Vigilant(tm)

Apparently, there is nothing that cannot happen today.  Mark Twain

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Tuesday, March 20, 2007 3:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report Error


** 
Well ... since administrators are 'all powerful' it does seem odd.  Make
another account for yourself and try that one.  If it works, delete the
old one and use the one that works.  There must be something different
but without being there it's really hard to troubleshoot something that
is probably simple.  And no, please don't send any logfiles ! 
 
Susan

 
On 3/20/07, Mikhail [EMAIL PROTECTED] wrote: 

Hello Guys,
Just a little update on the situation.
When I login to User tool and try to print crystal reports using
the 
DTP Style button, It gives me a logon error (arerr 1904). When I
ask
someone else to login to my usertool, they can print
successfully!
Interesting thing is we both have Administrator accounts...
So now we're thinking this could be some permission issue, but
we
can't quite point our fingers at it.
Anyone?


On Mar 20, 12:01 pm, Ben Cantatore [EMAIL PROTECTED] 
wrote:
 Kinda silly, but try fully qualifying the name of the server
in the ODBC
 driver.



___-
 UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgARSlist:Where the Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org  ARSlist:Where the Answers Are



__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Bill H]

The issue I'm having (7.01 client - Crystal XI developed report) , started long 
after our upgrade.  No one else here is having  the problem.  I've installed 
other software on this machine, before the problem appeared.  That's why I 
think it's a dll/registry issue, at least for me.  

I don't really expect Remedy support to take this on.  Even if I had tons of 
faith in them, I think the issue would be difficult to replicate.  I was just 
wondering if the crystal developer was present on the machines with this 
problem. I am, basically, just looking for a pattern.

Bill
  - Original Message - 
  From: Susan Palmer 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Tuesday, March 20, 2007 1:46 PM
  Subject: Re: Crystal Report Error


  ** 
  With this many people having the issue, what does Remedy support say?  You 
are clicking on a button using the odbc driver that is supplied within the user 
tool.

  Was it always like this or did it change recently?  

  Susan

   
  On 3/20/07, Bill H [EMAIL PROTECTED] wrote: 
Mikhail,

I'm also getting this error and it just started.  Quick question do you have
the Crystal Reports Developers tool installed on that machine?  I also 
believe it's a dll/registry issue, but I haven't isolated it yet.

Bill

- Original Message -
From: Mikhail [EMAIL PROTECTED] 
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Tuesday, March 20, 2007 12:19 PM
Subject: Re: Crystal Report Error


Hello Guys, 
Just a little update on the situation.
When I login to User tool and try to print crystal reports using the
DTP Style button, It gives me a logon error (arerr 1904). When I ask
someone else to login to my usertool, they can print successfully! 
Interesting thing is we both have Administrator accounts...
So now we're thinking this could be some permission issue, but we
can't quite point our fingers at it.
Anyone?


On Mar 20, 12:01 pm, Ben Cantatore  [EMAIL PROTECTED] wrote:
 Kinda silly, but try fully qualifying the name of the server in the ODBC
 driver.

 
___­
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the
 Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where 
the Answers Are


  __20060125___This posting was submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Susan Palmer]

I assume everyone with this problem that has responded above has uninstalled
the user/alert completely and reinstalled.  I had a problem running Crystal
a year or so ago but once I did that it went away.  Probably a .dll that was
changed from another software install.  But if the problem started after any
new software installs  or what about infamous windows patches.  There's
alot of wierd things going on once those are applied.

Susan


On 3/20/07, Bill H [EMAIL PROTECTED] wrote:


** The issue I'm having (7.01 client - Crystal XI developed report) ,
started long after our upgrade.  No one else here is having  the problem.
I've installed other software on this machine, before the problem appeared.
That's why I think it's a dll/registry issue, at least for me.

I don't really expect Remedy support to take this on.  Even if I had tons
of faith in them, I think the issue would be difficult to replicate.  I was
just wondering if the crystal developer was present on the machines with
this problem. I am, basically, just looking for a pattern.

Bill

- Original Message -
*From:* Susan Palmer [EMAIL PROTECTED]
*Newsgroups:* public.remedy.arsystem.general
*To:* arslist@ARSLIST.ORG
*Sent:* Tuesday, March 20, 2007 1:46 PM
*Subject:* Re: Crystal Report Error


** With this many people having the issue, what does Remedy support say?
You are clicking on a button using the odbc driver that is supplied within
the user tool.

Was it always like this or did it change recently?

Susan


On 3/20/07, Bill H [EMAIL PROTECTED] wrote:

 Mikhail,

 I'm also getting this error and it just started.  Quick question do you
 have
 the Crystal Reports Developers tool installed on that machine?  I also
 believe it's a dll/registry issue, but I haven't isolated it yet.

 Bill

 - Original Message -
 From: Mikhail [EMAIL PROTECTED]
 Newsgroups: public.remedy.arsystem.general
 To: arslist@ARSLIST.ORG
 Sent: Tuesday, March 20, 2007 12:19 PM
 Subject: Re: Crystal Report Error


 Hello Guys,
 Just a little update on the situation.
 When I login to User tool and try to print crystal reports using the
 DTP Style button, It gives me a logon error (arerr 1904). When I ask
 someone else to login to my usertool, they can print successfully!
 Interesting thing is we both have Administrator accounts...
 So now we're thinking this could be some permission issue, but we
 can't quite point our fingers at it.
 Anyone?


 On Mar 20, 12:01 pm, Ben Cantatore  [EMAIL PROTECTED] wrote:
  Kinda silly, but try fully qualifying the name of the server in the
 ODBC
  driver.
 
 
 
___­

  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
 the
  Answers Are


 
___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
 the
 Answers Are


 
___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
 the Answers Are


__20060125___This posting was submitted with HTML in
it___

__20060125___This posting was submitted with HTML in
it___



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error (U)

[Susan Palmer]

You're right Mikhail, I sure wouldn't want to recreate accounts either.  But
it seemed it was only your account having the issue.  You can only spend so
much time on an issue and then you have to cut it loose if you have a
work-around.  If it comes up again you'd certainly want to look at it
further.  I'm glad you submitted the issue to support, although I don't hold
out much hope for a solution.  But just in this short time it's amazing how
many other people have noted they have an issue too.  Seems like a bit of a
trend!

Susan


On 3/20/07, Mikhail [EMAIL PROTECTED] wrote:


Hi Sandra,
I tried what you suggested but I still get the error.

Hello Susan,
I created a new user and yes, it DID work! However, creating and
deleting accounts would be a last resort in our case because there are
a lot of other users out there that can perform DTP-style printing.
But I do wonder what the difference is between the old and the new
one. I created the new one to have the same info as the old one.


On Mar 20, 1:47 pm, Hennigan, Sandra H CTR OSD-CIO
[EMAIL PROTECTED] wrote:
 UNCLASSIFIED

 What about Use Underscores?  Remedy generally does on their Crystal
 Reports; users generally do not.  It is a setting in the ODBC
 Configuration Setting.
 On your Remedy client - click Tools  Options  Advanced
 Check ODBC Use Underscores and run the report again.
 If it is already checked, uncheck it and run the report.

 Sandra Hennigan

 OSD Remedy Administrator
 Office # 703-602-0980 x174
 CACI - Ever Vigilant(tm)

 Apparently, there is nothing that cannot happen today.  Mark Twain



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
 Sent: Tuesday, March 20, 2007 3:38 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Crystal Report Error

 **
 Well ... since administrators are 'all powerful' it does seem odd.  Make
 another account for yourself and try that one.  If it works, delete the
 old one and use the one that works.  There must be something different
 but without being there it's really hard to troubleshoot something that
 is probably simple.  And no, please don't send any logfiles !

 Susan

 On 3/20/07, Mikhail [EMAIL PROTECTED] wrote:

 Hello Guys,
 Just a little update on the situation.
 When I login to User tool and try to print crystal reports using
 the
 DTP Style button, It gives me a logon error (arerr 1904). When I
 ask
 someone else to login to my usertool, they can print
 successfully!
 Interesting thing is we both have Administrator accounts...
 So now we're thinking this could be some permission issue, but
 we
 can't quite point our fingers at it.
 Anyone?

 On Mar 20, 12:01 pm, Ben Cantatore [EMAIL PROTECTED] 
 wrote:
  Kinda silly, but try fully qualifying the name of the server
 in the ODBC
  driver.

 
 ___-
  UNSUBSCRIBE or access ARSlist Archives
 atwww.arslist.orgARSlist:Where the Answers Are

 
 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 http://www.arslist.org  ARSlist:Where the Answers Are

 __20060125___This posting was submitted with HTML in
 it___


___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
the Answers Are- Hide quoted text -

 - Show quoted text -


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error (U)

[Ben Cantatore]

Mikhail, try another workstation, logged in as yourself, see if the 
problem follows the ID or just your pc.  I don't recall what version you 
said you had, but if you have crystal reports installed, perhaps you can 
locate the report in report form and save the report to your workstation 
and try opening it up directly.  Be sure to edit the criteria so it 
doesn't try to display every ticket in your database.

In a prior email, I'd suggested turning on logging as yourself and the 
individual that works, did you notice any differences between the 2 log 
files?




Susan Palmer [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
03/20/2007 06:26 PM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Crystal Report Error (U)






** 
You're right Mikhail, I sure wouldn't want to recreate accounts either. 
But it seemed it was only your account having the issue.  You can only 
spend so much time on an issue and then you have to cut it loose if you 
have a work-around.  If it comes up again you'd certainly want to look at 
it further.  I'm glad you submitted the issue to support, although I don't 
hold out much hope for a solution.  But just in this short time it's 
amazing how many other people have noted they have an issue too.  Seems 
like a bit of a trend! 
 
Susan

 
On 3/20/07, Mikhail [EMAIL PROTECTED] wrote: 
Hi Sandra,
I tried what you suggested but I still get the error.

Hello Susan,
I created a new user and yes, it DID work! However, creating and 
deleting accounts would be a last resort in our case because there are
a lot of other users out there that can perform DTP-style printing.
But I do wonder what the difference is between the old and the new
one. I created the new one to have the same info as the old one. 


On Mar 20, 1:47 pm, Hennigan, Sandra H CTR OSD-CIO
[EMAIL PROTECTED] wrote:
 UNCLASSIFIED

 What about Use Underscores?  Remedy generally does on their Crystal 
 Reports; users generally do not.  It is a setting in the ODBC
 Configuration Setting.
 On your Remedy client - click Tools  Options  Advanced
 Check ODBC Use Underscores and run the report again. 
 If it is already checked, uncheck it and run the report.

 Sandra Hennigan

 OSD Remedy Administrator
 Office # 703-602-0980 x174
 CACI - Ever Vigilant(tm)

 Apparently, there is nothing that cannot happen today.  Mark Twain 



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer 
 Sent: Tuesday, March 20, 2007 3:38 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Crystal Report Error

 **
 Well ... since administrators are 'all powerful' it does seem odd.  Make 

 another account for yourself and try that one.  If it works, delete the
 old one and use the one that works.  There must be something different
 but without being there it's really hard to troubleshoot something that 
 is probably simple.  And no, please don't send any logfiles !

 Susan

 On 3/20/07, Mikhail [EMAIL PROTECTED] wrote:

 Hello Guys, 
 Just a little update on the situation.
 When I login to User tool and try to print crystal reports using
 the
 DTP Style button, It gives me a logon error (arerr 1904). When I 

 ask
 someone else to login to my usertool, they can print
 successfully!
 Interesting thing is we both have Administrator accounts...
 So now we're thinking this could be some permission issue, but 
 we
 can't quite point our fingers at it.
 Anyone?

 On Mar 20, 12:01 pm, Ben Cantatore [EMAIL PROTECTED] 
 wrote:
  Kinda silly, but try fully qualifying the name of the server
 in the ODBC
  driver.

  

 ___-
  UNSUBSCRIBE or access ARSlist Archives
 atwww.arslist.orgARSlist:Where the Answers Are

  

 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 http://www.arslist.org  ARSlist:Where the Answers Are 

 __20060125___This posting was submitted with HTML in
 it___

 
___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where 
the Answers Are- Hide quoted text -

 - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where 
the Answers Are

__20060125___This posting was submitted with HTML in 
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Mikhail]

I'm working with Derek on this problem. We tried recreating this
problem on someone else's computer, and it worked just fine. Now with
that given, along with the error stating An error occurred while
generating the Crystal report - Logon failed. (ARERR 1904)., tells me
that the problem must be in the client-side, probably some iffy dll's
or something. I tried uninstalling EVERYTHING on my computer that is
related to Remedy (user, admin, migrator, alert), then reinstalled
everything again  (v7.0.01 patch 001), but I still get that error.
Any thoughts?

Thank you,
Mikhail


On Mar 5, 1:23 pm, Derek Fernandes [EMAIL PROTECTED] wrote:
 Hi listers,

 We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk 4.03.
 We have a couple of Crystal Reports that were working on ARS 6.3. Now,
 when we push the button to print the report we get the following error:

 An error occurred while generating the Crystal report: 0x80047e48 -
 Logon failed. (ARERR1904)

 I have installed the latest version of the User Tool and checked the
 active link that generates the report, and made sure on the Report
 Information tab:
 Report Type = Crystal
 Location = Embedded
 Name = \\reportname.rpt
 Destination = Printer

 Any help would be greatly appreciated.

 Derek

 --
 Derek Fernandes
 Programmer Analyst
 U of C Information Technologies
 ES 1010, University of Calgary
 Calgary, Alberta  T2N 1N4
 403.210.9879

 ___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the 
 Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Luttmann, Michael W Ctr 21 SCS/SCBBN]

Sounds like a problem with the ODBC configuration on the client.  I'd
start checking there.

Michael W. Luttmann 
Senior Database Administrator 
[EMAIL PROTECTED] 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mikhail
Sent: Friday, March 16, 2007 9:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal Report Error

I'm working with Derek on this problem. We tried recreating this
problem on someone else's computer, and it worked just fine. Now with
that given, along with the error stating An error occurred while
generating the Crystal report - Logon failed. (ARERR 1904)., tells me
that the problem must be in the client-side, probably some iffy dll's
or something. I tried uninstalling EVERYTHING on my computer that is
related to Remedy (user, admin, migrator, alert), then reinstalled
everything again  (v7.0.01 patch 001), but I still get that error.
Any thoughts?

Thank you,
Mikhail


On Mar 5, 1:23 pm, Derek Fernandes [EMAIL PROTECTED] wrote:
 Hi listers,

 We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk
4.03.
 We have a couple of Crystal Reports that were working on ARS 6.3. Now,
 when we push the button to print the report we get the following
error:

 An error occurred while generating the Crystal report: 0x80047e48 -
 Logon failed. (ARERR1904)

 I have installed the latest version of the User Tool and checked the
 active link that generates the report, and made sure on the Report
 Information tab:
 Report Type = Crystal
 Location = Embedded
 Name = \\reportname.rpt
 Destination = Printer

 Any help would be greatly appreciated.

 Derek

 --
 Derek Fernandes
 Programmer Analyst
 U of C Information Technologies
 ES 1010, University of Calgary
 Calgary, Alberta  T2N 1N4
 403.210.9879



___-
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[Mikhail]

Hi Susan and Michael,

Thank you for your inputs.
The crystal report resides in a network location. And yes, it is
associated with an active link. We've already done the method you
suggested, yet we still get the same error.
After I reloaded everything, I didn't check the ODBC configuration
because I don't know what goes in there. I just checked it now.

This is what I have in my ODBC configuration:

I went to Control Panel  Administrative Tools  Data Sources (ODBC)
Under the User DSN tab, i chose AR System ODBC Data Source and
clicked Configure..
All that is setup is the Data Source Name which is set to AR System
ODBC Data Source.
The rest of the fields are blank.


On Mar 16, 12:14 pm, Luttmann, Michael W Ctr 21 SCS/SCBBN
[EMAIL PROTECTED] wrote:
 Sounds like a problem with the ODBC configuration on the client.  I'd
 start checking there.

 Michael W. Luttmann
 Senior Database Administrator
 [EMAIL PROTECTED]



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:[EMAIL PROTECTED] On Behalf Of Mikhail
 Sent: Friday, March 16, 2007 9:45 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Crystal Report Error

 I'm working with Derek on this problem. We tried recreating this
 problem on someone else's computer, and it worked just fine. Now with
 that given, along with the error stating An error occurred while
 generating the Crystal report - Logon failed. (ARERR 1904)., tells me
 that the problem must be in the client-side, probably some iffy dll's
 or something. I tried uninstalling EVERYTHING on my computer that is
 related to Remedy (user, admin, migrator, alert), then reinstalled
 everything again  (v7.0.01 patch 001), but I still get that error.
 Any thoughts?

 Thank you,
 Mikhail

 On Mar 5, 1:23 pm, Derek Fernandes [EMAIL PROTECTED] wrote:
  Hi listers,

  We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk
 4.03.
  We have a couple of Crystal Reports that were working on ARS 6.3. Now,
  when we push the button to print the report we get the following
 error:

  An error occurred while generating the Crystal report: 0x80047e48 -
  Logon failed. (ARERR1904)

  I have installed the latest version of the User Tool and checked the
  active link that generates the report, and made sure on the Report
  Information tab:
  Report Type = Crystal
  Location = Embedded
  Name = \\reportname.rpt
  Destination = Printer

  Any help would be greatly appreciated.

  Derek

  --
  Derek Fernandes
  Programmer Analyst
  U of C Information Technologies
  ES 1010, University of Calgary
  Calgary, Alberta  T2N 1N4
  403.210.9879

 
 ___-
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
 the Answers Are

 
 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
 the Answers Are

 ___­
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the 
 Answers Are- Hide quoted text -

 - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Crystal Report Error

[patrick zandi]

Sir,I
am not positive on this.. but from what I understand of this.. your issue
is your reports were built in the old version of CR .. CR XI is compatable
with this version .. I do not believe CR 7, 8, 8.5, or 9 will work anymore.
I have seen this.. on testing.. and could not find a fix.. but was told it
was fixed with  CR XI reports.
have not finish the testing to prove..
Someone else will chime in here soon on this issue I hope..


On 3/5/07, Derek Fernandes [EMAIL PROTECTED] wrote:


Hi listers,

We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk 4.03.
We have a couple of Crystal Reports that were working on ARS 6.3. Now,
when we push the button to print the report we get the following error:

An error occurred while generating the Crystal report: 0x80047e48 -
Logon failed. (ARERR 1904)

I have installed the latest version of the User Tool and checked the
active link that generates the report, and made sure on the Report
Information tab:
Report Type = Crystal
Location = Embedded
Name = \\reportname.rpt
Destination = Printer

Any help would be greatly appreciated.

Derek

--
Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta  T2N 1N4
403.210.9879


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are





--
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error

[patrick zandi]

Susan,
What did you do ?


On 3/5/07, Susan Palmer [EMAIL PROTECTED] wrote:


** Before you go to all of the work of recreating reports, try
reconfigurating the ODBC driver.  Mine are working on the dev server and
were created in 8, 8.5 and 9.  I was told they wouldn't work too, so I was
surprised when they did.

Susan


On 3/5/07, patrick zandi [EMAIL PROTECTED] wrote:

 ** Sir,I
  am not positive on this.. but from what I understand of this.. your
 issue is your reports were built in the old version of CR .. CR XI is
 compatable with this version .. I do not believe CR 7, 8, 8.5, or 9 will
 work anymore.
 I have seen this.. on testing.. and could not find a fix.. but was told
 it was fixed with  CR XI reports.
 have not finish the testing to prove..
 Someone else will chime in here soon on this issue I hope..


  On 3/5/07, Derek Fernandes [EMAIL PROTECTED]  wrote:
 
  Hi listers,
 
  We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk
  4.03.
  We have a couple of Crystal Reports that were working on ARS 6.3. Now,
  when we push the button to print the report we get the following
  error:
 
  An error occurred while generating the Crystal report: 0x80047e48 -
  Logon failed. (ARERR 1904)
 
  I have installed the latest version of the User Tool and checked the
  active link that generates the report, and made sure on the Report
  Information tab:
  Report Type = Crystal
  Location = Embedded
  Name = \\reportname.rpt
  Destination = Printer
 
  Any help would be greatly appreciated.
 
  Derek
 
  --
  Derek Fernandes
  Programmer Analyst
  U of C Information Technologies
  ES 1010, University of Calgary
  Calgary, Alberta  T2N 1N4
  403.210.9879
 
  
___
 
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgARSlist:Where the 
Answers Are
 



 --
 Patrick Zandi __20060125___This posting was
 submitted with HTML in it___


__20060125___This posting was submitted with HTML in
it___





--
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error

[Derek Fernandes]

Hi Susan,

How do I go about doing that?

When I goto the Contol Panel -- Administrative Tools -- Data Sources 
(ODBC), it shows the AR System ODBC Data Source under the User DSN tab. 
Under the Drives tab, it shows the AR System ODBC Drive (version 
7.00.01.01).


What else has to be done?

Thanks,
Derek

Susan Palmer wrote:

**
Before you go to all of the work of recreating reports, try 
reconfigurating the ODBC driver.  Mine are working on the dev server 
and were created in 8, 8.5 and 9.  I was told they wouldn't work too, 
so I was surprised when they did.
 
Susan


 
On 3/5/07, *patrick zandi* [EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED] wrote:


**
Sir,I
 am not positive on this.. but from what I understand of this..
your issue is your reports were built in the old version of CR ..
CR XI is compatable with this version .. I do not believe CR 7, 8,
8.5, or 9 will work anymore.
I have seen this.. on testing.. and could not find a fix.. but was
told it was fixed with  CR XI reports.
have not finish the testing to prove..
Someone else will chime in here soon on this issue I hope..

 
On 3/5/07, *Derek Fernandes* [EMAIL PROTECTED]

mailto:[EMAIL PROTECTED] wrote:

Hi listers,

We just moved to ARS 7.0.1 patch 1 but we are still using
HelpDesk 4.03.
We have a couple of Crystal Reports that were working on ARS
6.3. Now,
when we push the button to print the report we get the
following error:

An error occurred while generating the Crystal report:
0x80047e48 -
Logon failed. (ARERR 1904)

I have installed the latest version of the User Tool and
checked the
active link that generates the report, and made sure on the Report
Information tab:
Report Type = Crystal
Location = Embedded
Name = \\reportname.rpt
Destination = Printer

Any help would be greatly appreciated.

Derek

--
Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta  T2N 1N4
403.210.9879


___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ ARSlist:Where the Answers Are




-- 
Patrick Zandi __20060125___This posting was
submitted with HTML in it___ 



__20060125___This posting was submitted with HTML 
in it___ 


--
Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta  T2N 1N4
403.210.9879

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

Re: Crystal Report Error

[Susan Palmer]

Hi Derek,

I didn't actually have to do it, but when you said it required a log in that
was the first thing that came to mind.  But that is how to config it.

Susan


On 3/5/07, Derek Fernandes [EMAIL PROTECTED] wrote:


Hi Susan,

How do I go about doing that?

When I goto the Contol Panel -- Administrative Tools -- Data Sources
(ODBC), it shows the AR System ODBC Data Source under the User DSN tab.
Under the Drives tab, it shows the AR System ODBC Drive (version
7.00.01.01).

What else has to be done?

Thanks,
Derek

Susan Palmer wrote:
 **
 Before you go to all of the work of recreating reports, try
 reconfigurating the ODBC driver.  Mine are working on the dev server
 and were created in 8, 8.5 and 9.  I was told they wouldn't work too,
 so I was surprised when they did.

 Susan


 On 3/5/07, *patrick zandi* [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] wrote:

 **
 Sir,I
  am not positive on this.. but from what I understand of this..
 your issue is your reports were built in the old version of CR ..
 CR XI is compatable with this version .. I do not believe CR 7, 8,
 8.5, or 9 will work anymore.
 I have seen this.. on testing.. and could not find a fix.. but was
 told it was fixed with  CR XI reports.
 have not finish the testing to prove..
 Someone else will chime in here soon on this issue I hope..


 On 3/5/07, *Derek Fernandes* [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED] wrote:

 Hi listers,

 We just moved to ARS 7.0.1 patch 1 but we are still using
 HelpDesk 4.03.
 We have a couple of Crystal Reports that were working on ARS
 6.3. Now,
 when we push the button to print the report we get the
 following error:

 An error occurred while generating the Crystal report:
 0x80047e48 -
 Logon failed. (ARERR 1904)

 I have installed the latest version of the User Tool and
 checked the
 active link that generates the report, and made sure on the
Report
 Information tab:
 Report Type = Crystal
 Location = Embedded
 Name = \\reportname.rpt
 Destination = Printer

 Any help would be greatly appreciated.

 Derek

 --
 Derek Fernandes
 Programmer Analyst
 U of C Information Technologies
 ES 1010, University of Calgary
 Calgary, Alberta  T2N 1N4
 403.210.9879


___

 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 http://www.arslist.org/ ARSlist:Where the Answers Are




 --
 Patrick Zandi __20060125___This posting was
 submitted with HTML in it___


 __20060125___This posting was submitted with HTML
 in it___

--
Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta  T2N 1N4
403.210.9879


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are