The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
user gets wrong data
Posted: 16 Oct 06 1:25 PM
|
fiogf49gjkf0d I have a user who runs a call report and is not seeing the same data as everyone else.
The user is not running a remote database they are in a citrix client. When we test the report it is correct when another user test they are getting the right data. The user has been walked through getting to the right place so it isn't user error (although I am not totally convinced of this).
Any ideas what would cause this?
Thanks for the help ML |
|
|
|
Re: user gets wrong data
Posted: 16 Oct 06 2:48 PM
|
fiogf49gjkf0d Is it a matter that the user is missing calls for some accounts/contacts? If so you should check the user's security and account ownership.
If this is not the case can you provide more details?
|
|
|
|
Re: user gets wrong data
Posted: 16 Oct 06 3:55 PM
|
fiogf49gjkf0d the user is missing to meetings that he completed and are not showing on the call report.
More info: We run 6.2.3.1092. No remotes we use citrix. User is a citrix user. The users call a custom call report that gives some detail of the activitys that the users has completed between dates that the users sets when they open the report. We just upgraded from 6.1 to 6.2.3 this is when the user started to report the missing activities on the call report.
Q: when a user picks a date as a parameter at the beginning of a report does the user have to select today and if they don't change it it comes back with the first day of the month or some other random date? I ask because this is the one place I would think that the user could be causing the error and it just feels like a user error.
Thanks for the help ML |
|
|
|
Re: user gets wrong data
Posted: 17 Oct 06 7:41 AM
|
fiogf49gjkf0d the user is missing to meetings that he completed and are not showing on the call report.
Just to verify, are those two meetings associated with a contact and account? We ran into a similar report issue here where it turned out that it was meetings that were imported from outlook which default to no contact or account links. Since the report joined history based on contactid it would not pull the recrods that had no contact associated with them. Once associated to a contact (and account) the history records showed up in the report.
John G. |
|
|
|
Re: user gets wrong data
Posted: 17 Oct 06 8:45 AM
|
fiogf49gjkf0d The meetings have the correct associated contact and account.
It is just this user that is seeing the wrong results. I would ilke to have someone else run the report on his machine but he lives in another state .
I am convinced this is pilot error unless anyone can think of a reason way a single machine would filter out just these two records. Thanks ML |
|
|
|
Re: user gets wrong data
Posted: 17 Oct 06 9:04 AM
|
fiogf49gjkf0d Didn't you say you have no remote and are using Citrix? Just log onto the Citrix server as the user and run the report. |
|
|
|
Re: user gets wrong data
Posted: 17 Oct 06 9:07 AM
|
fiogf49gjkf0d Originally posted by Michael Litman
I am convinced this is pilot error unless anyone can think of a reason way a single machine would filter out just these two records. Thanks ML |
|
Check the user's regional settings to make sure he has the correct date setting. |
|
|
|
Re: user gets wrong data
Posted: 17 Oct 06 9:10 AM
|
fiogf49gjkf0d This has been done and the correct data is displayed it is just on the users machine that the data is incorrect. we are going to try netmeeting and run the report for him on his machine. Thanks ML |
|
|
|
Re: user gets wrong data
Posted: 17 Oct 06 9:16 AM
|
fiogf49gjkf0d The report is not being run on his machine. It is being run on the Citrix server. The users sPC is just a display device.
Sounds like a Citrix user profile issue. |
|
|
|
Re: user gets wrong data
Posted: 17 Oct 06 11:18 AM
|
fiogf49gjkf0d Micheal,
I didn't see if you answered Frank's question about ownership? Did you verify that the missing information (with associated seccodeid) is available to your user? Can the user view these contacts and accounts?
Sometimes it is better to review this via backend rather than through the Administrator tool. SLX Administrator tool has a couple of bugs when viewing security tress etc.
Run the following statement:
Select * from secrights where accessid = 'USERID' and seccodeid = ' MissingInfoSECcodeid '
If you get a record, user does have access. If you do not get a result set; user is not allowed to view that data.
Carla
|
|
|
|
Re: user gets wrong data
Posted: 18 Oct 06 8:28 AM
|
fiogf49gjkf0d Thanks Carla,
I get a result set, any other suggestions? Thx ML |
|
|
|
Re: user gets wrong data
Posted: 19 Oct 06 12:11 PM
|
fiogf49gjkf0d Micheal,
When the users pull this particular report; is it individualized by the userid?
If so; the next troubleshooting I would perform would be ro review the Tabel Joins set up in the Crystal report. Make sure there are left joins as opposed to inner joins on the main tables. That way is one piece of silly information is missing, there will still be an entry for the meetings, etc.
i.e.
History --Left join -->Activities All history (closed Activities) show regardless. History --Left join --> Contact/Account/Userinfo All History shows even if associated information is not available.
Activities --Left join --> Contact All activities show even if a contact has been deleted. No information for the Contact, but you get the Activity information
Activities --Left join --> UserInformation - All activities show weather the userid is good or not
Hope this helps. 
Carla |
|
|
|