To all,

Noticed that below API call is no more working with latest PB2021 deployment(developer license):

http://<localhost>:5000/api/Custom/GetAllSessions

any idea how to get session information with PS2021 GA version?

Regards, 

JX

Hi all,

One more Session Id related question for help: How to re-connect/re-activate "Running application" either re-use or re-create a session ID on PS?

On yesterday's testing, I hit 2 errors:

1) Error Number 2, Error text = Null object reference, which script: sqlca.of_begin()

2) Error number 224, Error text = The session does not exist at line13 in function....

Which caused by session timeout and no more DB connection already.

Reason of session timeout:
1. When running inventory planning report for the ERP system, it took around 2 hours to process data, while session timeout setting is 1 hour.

2. User attended to other matter and left the application there more than 1 hour, when backing to the application interface, corresponded session is not exist already.

I knew it is not a PB/PS related bug, while exploring the possibility to re-activate the application with a new session on PS service ==> like what we did for client/server to re-connect DB when losing DB connectivity in-between.

For now, seems that have to ignore the error or handle the message, close the application and re-launch it.

Thank you.

Best Regards.

JX

Hi Zhang JX,

Thanks for reporting ticket 6549. And we will handle this issue as an enhancement.

For the other issue: the SQLErrtxt is "Get IE auto proxy failed" or "Get response encoding failed".

Based on our analysis, this is a bug. We suggest that you open a new ticket in our support portal for us to better track the issue. Thanks in advance.

Regards,

Hi Jianxin/Mike/Chris, 

It is not documented yet (we will add into the Release Bulletin right away), but the beta version already allows you to get all sessions or kill a session. 

1，Call the /api/custom/getAllsessions to get all sessions; 

2，Call the /api/custom/KillSession to kill a session of a given sessionid; 

3，The session information returned from PowerServer is as below:

[{"sessionid":"85b78052-8692-4281-82e9-dbbefed31055","sessionstate":2,"createtime":"2021-05-06T03:35:30.7323321Z","lastvisittime":"2021-05-06T03:39:25.4715132Z"},{"sessionid":"ca54aa7d-5fd6-429a-a2c0-494eb3be820d","sessionstate":2,"createtime":"2021-05-06T03:35:21.0329275Z","lastvisittime":"2021-05-06T03:35:24.5604784Z"}]

Here are the sample scripts.

//-------------------------------------getSession-----------------------------------------

httpclient  lhc_client

string ls_url

string ls_json

lhc_client = create httpclient

//GetSessions

ls_url = "http://localhost:5000/api/custom/getAllsessions"

//You may need to change to the actual ipaddress:port

//If there are multiple PowerServers, you can get the sessions separately for each server.

//lhc_client.SetRequestHeader("Authorization", $token, true)  //If authorization is enabled

lhc_client.sendrequest("Get",ls_url)

if lhc_client.getresponsestatuscode() = 200 then

                lhc_client.getresponsebody(ls_json)

                //parse the json

                wf_getsessions(ls_json)

end if

//-------------------------------------------------------------------------------------------------

//-------------------------------------killSession-----------------------------------------------

httpclient  lhc_client

string ls_url

string ls_sessionid

lhc_client = create httpclient

//GetSessions

//lhc_client.SetRequestHeader("Authorization", $token, true)  //If authorization is enabled

ls_url = "http://localhost:5000/api/custom/KillSession"

ls_sessionid = lb_sessionlist.selecteditem()

ls_url += "/"+ls_sessionid

lhc_client.sendrequest("post",ls_url)

if lhc_client.getresponsestatuscode() = 200 then

                messagebox("succeed",ls_sessionid +" was killed")

end if

//-------------------------------------------------------------------------------------------------------------------

Best regards, Julie

To all, FYI.

I have solved this issue by amending the session_id from UID to be nchar(36), will leave it to Appeon team to trace on UID(or possible other issue).

Thanks

JX

Hi JX;

1. FYI: We already have an enhancement suggestion for access to the Session ID from the PS2021 "Preview". AFAIK: No Session ID access yet in the 1st Beta.
2. Did adding the USING clause make it work OK?

Regards ... Chris