FoxInCloud
SessionID not found
Gravatar is a globally recognized avatar based on your email address. SessionID not found
  Vincent H.
  All
  Oct 17, 2020 @ 02:06am

Hi Thierry,

For several weeks, I have been getting this message when launching a procedure from xxxServer.prg (webhook). An idea ?

Error:       1734
Message: Propriété SESSIONID introuvable.
Code: 
Program: newsession
Line No:        264
Client: 5.39.7.129
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 20, 2020 @ 04:30am

Can you reproduce in development?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 20, 2020 @ 06:14am

Please try this fix:

modify command abTxt.prg
…
function lBotSpider
…
  or 'voilabot' $ m.tcUA;
  or 'alexa.com' $ m.tcUA;
  or 'webhook' $ m.tcUA; && insert this line
  or 'ccbot' $ m.tcUA;
…
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 20, 2020 @ 06:28am

Thanks Thierry, I try and feedback

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 20, 2020 @ 08:01am

Please note it’s a workaround to prevent opening a session on webhook requests

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 27, 2020 @ 07:57am

Hi Thierry,

I have this message again, today from https://dooxi.fr/FoxInCloud-Status.doo

This request cannot be served at the moment due to technical difficulties.
Error Number: 1734
Error: Propri?t? SESSIONID introuvable.
Running Method: newsession
Current Code:
Current Code Line: 264
Exception Handled by: Dooprocess.Error()
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 28, 2020 @ 11:16am

Hi Vincent,

Did you post the full message or do you also have the IP and User Agent?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 28, 2020 @ 11:24am

I have also the IP and User.

I send to you by email.

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 28, 2020 @ 11:34am

You're the only user with this issue, I guess your wwSession table must have something wrong.

Can you try to pack the wwSession table, and/or repair it?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 28, 2020 @ 12:31pm

I did it, but no message during the PACK

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 28, 2020 @ 12:55pm

pack does not provide a particular message… What did you expect?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 28, 2020 @ 01:27pm

an error message when the table is damaged

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Tore Bleken
  Vincent H.
  Oct 28, 2020 @ 10:29pm

AFAIK that will depend on your Set TableValidate value. If it's 0, don't expect an error, instead expect other problems...

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 29, 2020 @ 12:57am

PACK writes a new table on disk

According to SET TABLEVALIDATE values, USE may gives some messages about table integrity.

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 29, 2020 @ 01:13am

Yes, thanks, but I haven't any problem with this table

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 29, 2020 @ 01:19am

This error happens in wwSession.newSession(), in this piece of code:

SCATTER NAME THIS.oData MEMO BLANK
WITH THIS.oData
	.SessionId = lcSessionID && error happens here
	.FirstOn = DATETIME()
	.LastOn = DATETIME()
	.userID = lcUserID
	.Browser = lcBrowser
	.IP = lcIP
	.Hits = 1
ENDWITH

If the table structure is OK, this code should also execute OK:

THIS.OpenTable() is called in the beginning of this method, and does select wwSession, I can see no reason why Alias() would change, so SCATTER NAME THIS.oData MEMO BLANK should succeed.

Double checked in WC7, this code is unchanged.

UPDATE: maybe you can temporarily log Alias() into a text file and double check when error occurs:

…
strtofile(cl(datetime()) + " - Alias(): " + Alias(), 'newSession.log') && add this instruction
SCATTER NAME THIS.oData MEMO BLANK
…
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 29, 2020 @ 01:28am

So, the problem is maybe in THIS.oData ?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 29, 2020 @ 01:29am

Please add any debugging log you may find useful.

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 29, 2020 @ 01:42am

Noting more than this:

Processing Error - http://dooxi.fr/Accespart.doo?email=vincent@dooxi.fr&mdp=007

<PRE>
      Error:       1734
    Message: Propriété SESSIONID introuvable.
       Code: 
    Program: newsession
    Line No:        264
     Client: 86.229.xxx.xxx
Post Buffer: 
</PRE>
Exception Handled by: Dooprocess.Error()

------------------------------------------------
Query String     : email=vincent@dooxi.fr&mdp=007
DLL or Script    : /Accespart.doo
                 : C:\inetpub\wwwroot\dooComp\Accespart.doo
Host Server Name : dooxi.fr
Machine Name     : doocompsrv1
Referring Link   : 
Client IP Address: 86.229.xxx.xxx
Client Browser   : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36
Username         : 
Form Variables ---------------------------------

But as I told you before, in this example the user was immediately logged out on the 1st login attempt

In AccesPart() of xxxServer.prg, I have:

THIS.wUserSet(Partners.Id_Partner)

Where Id_Partner is an unique 10 characters expression

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 29, 2020 @ 01:53am

I did my best to support you, I explained earlier that I see no rational reason why this error could happen.

When reading code doesn't help find an error, I know only 2 solutions:

  1. reproduce in development IDE -- If I understand well, impossible in this case
  2. add debugging information such I those I proposed, and/or any you may find useful
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 29, 2020 @ 04:09am

I did my best to support you

I know, thanks.

I no longer have the name of the users connected in the dashboard:

Can I ZAP the wwsession.dbf ?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Oct 29, 2020 @ 05:27am

Can I ZAP the wwsession.dbf ?

You can ZAP or just delete wwsession.*. Your users will loose any preference stored in wwSession.vars.

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Oct 29, 2020 @ 06:19am

I deleted the table (which was created successfully) but my dashboard is still anonymous

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 10, 2020 @ 03:26am

Thierry, where is this code please ?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Dec 10, 2020 @ 03:51am

This thread is 2 months old… which code de you refer to?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 10, 2020 @ 04:26am

Sorry, this one:

This error happens in wwSession.newSession(), in this piece of code:

SCATTER NAME THIS.oData MEMO BLANK
WITH THIS.oData
	.SessionId = lcSessionID && error happens here
	.FirstOn = DATETIME()
	.LastOn = DATETIME()
	.userID = lcUserID
	.Browser = lcBrowser
	.IP = lcIP
	.Hits = 1
ENDWITH
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Dec 10, 2020 @ 05:04am
modify command wwSession.prg

almost all wConnect classes live in a prg named the same; eg. wwServer > wwServer.prg

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 10, 2020 @ 08:13am

OK. I added that and we'll see:

...
THIS.OpenTable()
IF VARTYPE (SessionId) = "U"
   * Provisoire - 10/12/2020
   strtofile(cl(datetime()) + " - Alias(): " + Alias(), 'c:\temporaire\newSession.log')
ENDIF

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  Vincent H.
  Dec 11, 2020 @ 05:55am

And the log is:

{^2020-12-11 14:34:43} - Alias(): CGILOG

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Dec 12, 2020 @ 04:33am

OK, thanks for this precious information, I'll investigate

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 12, 2020 @ 04:44am

Thanks in advance

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 19, 2020 @ 01:01am

It continues, of course.

{^2020-12-18 22:00:05} - Alias(): CGILOG

This happened from a "webhook" contained in xxxServer.prg

Processing Error - http://xxxxx.fr/youxxxxwebhook.doo?

Error:       1734
Message: Propriété SESSIONID introuvable.
Code: 
Program: newsession
Line No:        269
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  Vincent H.
  Dec 19, 2020 @ 05:17am

Another error, from another function in xxxServer.prg:

{^2020-12-19 12:34:06} - Alias(): CGILOG

Processing Error - http://xxxxx.fr/Acces.doo?D1224519-KIUO-4A8A-AKO8-EA3C9B1B9A23
Error:       1734
Message: Propriété SESSIONID introuvable.
Code: 
Program: newsession
Line No:        269
Client: 88.120.49.228
Post Buffer:
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Dec 22, 2020 @ 06:12am

It continues, of course … This happened from a "webhook" contained in xxxServer.prg

Not 'of course', since we should no longer open a session when User Agent contains webhook, this method should no longer execute in this case.

Please add the call stack in your log:

strtofile(cL(datetime()) + " - Alias(): " + Alias() + " - call stack: " + cCallingModules(), 'c:\temporaire\newSession.log')

thanks

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 22, 2020 @ 07:49am

The new spy is in place !

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  Vincent H.
  Dec 30, 2020 @ 09:09am

A new one, more explicit for you I hope:

{^2020-12-30 17:38:09} - Alias(): CGILOG - call stack: 1&#160;processhit > 2&#160;process > 3&#160;routerequest > 4&#160;dooprocess.process > 5&#160;dooprocess.newsession
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Dec 30, 2020 @ 09:37am

Can you please provide the request details? URL, user agent, etc.?

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 31, 2020 @ 12:11am

Thierry, I send it to you by email

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Jan 2, 2021 @ 04:39am

Hi Vincent,

Happy new year

Next release should fix the technical issue (incorrect Alias())

As these errors mostly occur on search engine robot requests, you can add to your site a robots.txt file:

strtofile("User-agent: *" + chr(13) + "Disallow: *.xxx", addBS(<path to your site>) + "robots.txt")
Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  Vincent H.
  FoxInCloud Support - Thierry N.
  Jan 2, 2021 @ 05:22am

OK, thanks.
Done. I read that this does not prevent the indexing of pages by Google

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Jan 2, 2021 @ 06:22am

I read that this does not prevent the indexing of pages by Google

Where?
whenever possible, please provide your source reference(s)

Gravatar is a globally recognized avatar based on your email address. re: SessionID not found
  FoxInCloud Support - Thierry N.
  Vincent H.
  Jan 2, 2021 @ 06:33am

All major search robots such as Google, Bing, etc. respect the robots.txt spec.
Only malicious search robots don't.

© 1996-2021