[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Administrator User Profile in a Terminal Services session keeps getting errors when trying to preview crystal Reports through a Crystal.Net Viewer invoked via a Powerbuilder application.

All the remaining users on the local network are able to preview and run the crystal reports succesfully. The Reports, the Crystal Viewer Exe and the PB Exe that invokes it are all located on the Terminal Server system.

Client user session are able to preview the reports from all other machines. But when this one user with administrator user profile tries to preview them from his machine or through any other machine/client session he keeps getting these erratic errors. Other users with their client sessions are able to log on to his machine and able to preview the reports without any problem.

The Crystal Viewer exe is a .NET exe that is invoked by a Powerbuilder application and requires .NET framwork 1.1 at a minimum to be installed. User confirms that he has all the Trust rights and permissions to the Viewer exe.

This problem happens only with his user id and everyone else is okay.
Whats interesting is that all the error messages show up as having a conversion to date time taking place, when there is no such thing needed by the Crystal Reports Record selection formula. The Report starts to load, and then the error messages of Crystal Reports load failed gets kicked out.

Why would one user alone with Administrator rights in the Terminal server enviornment have this problem of getting erratic error messages,after the report has started being previewed?
0
arthanari
Asked:
arthanari
  • 4
  • 2
1 Solution
 
cookreCommented:
My first thought is that the admin's PATH is different from the other users and some needed file with a wrong version is being found in a different directory.
0
 
Julian HansenCommented:
Check his date/time settings in the control panel and compare to other users - you may find there is a discrepency.

Is he using the administrator account - if so why?

0
 
arthanariAuthor Commented:
Thanks you guys. I am contacting the user now. I will try your solutions and keep ypu posted. the datetime thing is really weird. Thanks
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
arthanariAuthor Commented:
Hi JulianH.

I worked with the user on this date timestamp thing in Control Panel, but all seems well there.

Hi Cookre,

I will try your suggestion about the PATH for the admin. Whats the best way to look this up.
Thanks,

Ram

Also following are the sample errors he is getting:

Crystal Viewer Report load failed (Could not determine the order of year, month, and date from m/dd/yyyy)
Crystal Viewer Report load failed (Error Converting data type nvarchar to datetime)

Whats puzzling is this error comes up even for reports which have no date time stamp parameter in the Crystal record selection formula.

Any suggestions will be appreciated greatly.

Thanks,

Ram
0
 
cookreCommented:
For both user and admin, have them type at a command line:

path >c:\path.txt

and send you their generated path.txt
0
 
arthanariAuthor Commented:
Thanks cookre..will do and let you know
0
 
arthanariAuthor Commented:
Hi Cookre,

Sorry for the delay in getting back to you. Your idea worked, and they found a difference in the path and that did the trick.
Thanks so much,

Ram
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now