arthanari
asked on
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?
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?
cookre
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.
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?
Is he using the administrator account - if so why?
ASKER
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks cookre..will do and let you know
ASKER
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
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