Application gone mad

[broche]

Good morning,

CL 9.0
NT 8.22
STR 2.08

Added a GUID field as demonstrated in the User Group yesterday.  Did not do anything with it just added it fore later work.
This morning some of my users are getting very odd behaviour.

1) Customer logs in and sees other customers data even though I filter on the customer code and have not had any issues like this before.
2) Same for staff who have been assigned records.

I deleted the guid fields, re compiled and loaded the app.  Seems to have helped but some still getting this behavior.
Cannot get it to happen on my PC logged into the remote server??

Customers are complaining and alos a HIPPA issue.

Stumped how this could suddenly be happening?

Brian.

[Bruce]

>> I deleted the guid fields, re compiled and loaded the app.  Seems to have helped but some still getting this behavior.

If it's still happening, then why do you think it's related to the Guid? I think you are inferring cause and effect, and it's leading you down the wrong path.

If the browse filter seems wrong then simply debug the browse filter. Sending the filter string to Debugview (template setting) is the quickest way to see what is wrong with the Filter.

cheers
Bruce

[broche]

OK - I panicked a little.  Still happening though I cannot get it to happen on my end.  Will keep looking with debugview etc.

[broche]

OK did the following

Upgraded Nettalk to 8.23
Upgraded String Theory to 2.08

This seems top have helped, however some users still having issues.

Symptom is as as follows:

1) User logs in and a Session variable is set for their Staff ID and their User Name is captured to a Session variable.
2) On the top of the initial menu their User name shows
3) When they choose a menu choice to display a table for all assigned documents, the filter is ignored and all documents show up.
4) Their name should also appear at the top of the table but it is blank

So it seems to have lost the two session variables and just ignores the filter and shows everything.

I cannott get it to do this on my system, but had a user this morning who it did happen to.
When I log in as that user on my PC the filter is fine?

Brian.

ps - www.capesoft.com is down so can't see if Bruce has posted a further update?

[broche]

Did some further testing and on some tables I did not have a view variable set that was in the filter, so this caused some of those issues - my bad.
It is hard to break the old 32 bit thinking.

Brian.

[broche]

Still happening??

I justy logged in as one of the users that is having the issue from my PC and for the first time got the same result.

- Logged in and the username is shown on top of the menu, this means that the StaffID was obtained properly
- Chose the menu choice that uses this staffid to filter the table and the filter was ignored, showing all records
- Usually this table would have the user name on the top as well but it is blank

[broche]

OK - Here is debugview from my PC running the server locally

[1536] [st] [netTalk][thread=3] brwMTAssigned :: Filter: CVF:AssignedTo=10 AND cvf:status='ASSIGNED'

Works just fine.

Brian

[kevin plummer]

Hi Brian,

what does the debugview filter on the server look like? Also, what does your filter in code look like?

[broche]

Thanks fore the response.
Users still getting this this morning, but my PC and setup is working fine?

This is the code in the Filter Box:
'CVF:AssignedTo=' & p_web.GetSessionValue('StaffID') &' AND cvf:status=<39>ASSIGNED<39>'

In code it looks like this:
Loc:Selected = Choose(p_web.IfExistsValue('CVF:cvfsysid'),p_web.GetValue('CVF:cvfsysid'),p_web.GetSessionValue('CVF:cvfsysid'))
  ThisView{prop:order} = p_web.CleanFilter(ThisView,clip(loc:vorder))
      loc:FilterWas = 'CVF:AssignedTo=' & p_web.GetSessionValue('StaffID') &' AND cvf:status=<39>ASSIGNED<39>'
  ThisView{prop:Filter} = loc:FilterWas
  Loc:LocatorValue = p_web.GetLocatorValue(Loc:LocatorType,loc:divname,Net:Both)

I think this is what you are asking?

One thing I noticed are that the Loc:Login and password are strings whereas the table fields are CStrings, would this make a difference?

Running debugger on the server now.

Brian

[broche]

Here is the file again

[attachment deleted by admin]

[broche]

OK - I used Teamviewer to see the issue myself on the users PC
Definitely had the StaffID when they logged in but lost it for the browse - But not the ASSIGNED session variable?

Using IE 11
Clear the browser history - No Luck
Deleted passwords - it worked??

Have another user where I can try this as well later so will see if this resolves the issue, no clue why this would?

Brian.

[broche]

Next user with IE 11 deleting the passwords did  not work, however switching them to Chrome did work?
This is driving me crazy......

Brian

[broche]

Another Piece from testing - sorry for all the clutter but I have to resolve this one.

I put a small piece of code in the browse table to pop up a message if the Session Value if UserName is blank.
This works - however

As soon as I login as a user it pops this message up I don't have to even make the menu choice?? How come it is doing this immediately?

Brian.

[urayoan]

Brian, looking at the file with the debug view i see the filter is not working right

00001052   1276.17687988   [180616] [st] [netTalk][thread=3] brwMTAssigned :: Filter: CVF:AssignedTo= AND cvf:status='ASSIGNED'

CVF:AssignedTo  does not have any value so that explains why other users see everyone's data.

After you validate the login, did you assign the StaffID to use it in that session?

[broche]

Thanks urayone,

When  the user logs in I set the StaffSysID from the Staff table on sucessfull login to the session variable StaffID
I know this works as I put the users name above the menu using this session variable

When the users choose this browse most are fine, the cvf:assignedto has the StaffID session variable there and the filter works just fine.
For some users between logging in and the browse table the session variables get set to zero?  I have no idea why.

I can look at the Debug log and see the filters being set just fine.  I got it to do this on my local development environment only once.  All other times for the same users that have the issue it works just fine.

I can even login to the remote server as the problem user and not have the same issue.

I am stumped at this time.

Brian.