ASB XE3/32/64 DLL running
[Compiled on 08/12/2015 7:42:08 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
Received JSON : {"login":{"axpapp":"dmis","username":"14245","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","other":""}}
Executing Login webservice
--------------------------
select username from AxmConnections where username = '14245'

Time elapsed = 31
delete from AxmConnections where sessionid = '712005.875322.142174'

Time elapsed = 0
select sessionid from axmaudit where NoLogout = 'T' and username = '14245'

Time elapsed = 16
Updating axmaudit
Param Type = c
nologout=C
update axmaudit set nologout=:nologout
 where NoLogout='T' and username = '14245'

Verifying username and password
User Name : 14245
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE a.USERNAME = :U and b.name = 'app'
U=14245
Result : ORA-00904: "B"."MAXLOGINTRY": invalid identifier
User Name : 14245
Select * from AXUSERS WHERE USERNAME =:U 
U=14245
Time elapsed = 0
Password checking
Result : 
Verifying completed...
Page Access Category : 
User Name : 14245
Select sysdate as sdt from dual
Time elapsed = 0
dt=28/11/2022 10:13:42
Select sysdate as sdt from dual
Time elapsed = 0
Select usergroup from AXUSERLEVELGROUPS WHERE (USERNAME =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=14245
dt=28/11/2022 10:13:42
dt=28/11/2022 10:13:42
Time elapsed = 0
User Groups: Patwari
select userroles from axusergroups where groupname in ( 'Patwari' )
Time elapsed = 0
User Roles : Patwari
Loading App/User vars
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

select props from axprops where lower(name)= :name  order by blobno

Time elapsed = 0
Step5
   Evaluating firesql({m2},{select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode})
   Calling function firesql
username=14245
select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode
username=14245
Time elapsed = 16
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{valuecode})
   Calling function sqlget
   Result of sqlget = Patwari
   Result = Patwari
   Evaluating firesql({m3},{select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and  A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username })
   Calling function firesql
username=14245
select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and  A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username
username=14245
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{patwar})
   Calling function sqlget
   Result of sqlget = Loona Kalan
   Result = Loona Kalan
   Evaluating firesql({x},{Select distnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
username=14245
Select distnm from VW_USRDTL where usrnm = :username and rownum=1
username=14245
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{distnm})
   Calling function sqlget
   Result of sqlget = Jaisalmer
   Result = Jaisalmer
   Evaluating firesql({x},{Select tehnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select tehnm from VW_USRDTL where usrnm = :username and rownum=1
username=14245
Time elapsed = 15
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{tehnm})
   Calling function sqlget
   Result of sqlget = Pokaran
   Result = Pokaran
   Evaluating firesql({x},{Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1
username=14245
Time elapsed = 16
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{ilrnm})
   Calling function sqlget
   Result of sqlget = Bhainsara
   Result = Bhainsara
   Evaluating firesql({x},{Select patnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select patnm from VW_USRDTL where usrnm = :username and rownum=1
username=14245
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{patnm})
   Calling function sqlget
   Result of sqlget = Loona Kalan
   Result = Loona Kalan
   Evaluating firesql({d1},{Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1})
   Calling function firesql
username=14245
Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1
username=14245
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({d1},{distid})
   Calling function sqlget
   Result of sqlget = 16
   Result = 16
   Evaluating firesql({A1},{select nvl(A2.DEPTNAME,'0') DEPTNAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})
   Calling function firesql
username=14245
select nvl(A2.DEPTNAME,'0') DEPTNAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1
username=14245
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{DEPTNAME})
   Calling function sqlget
   Result of sqlget = 0
   Result = 0
   Evaluating firesql({A1},{select nvl(A2.OFFICENAME,'0') OFFICENAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})
   Calling function firesql
select nvl(A2.OFFICENAME,'0') OFFICENAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1
username=14245
Time elapsed = 16
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{OFFICENAME})
   Calling function sqlget
   Result of sqlget = 0
   Result = 0
   Evaluating firesql({A1},{select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME   from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username })
   Calling function firesql
select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME   from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username
username=14245
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{DEPTNAME})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({A1},{Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc})
   Calling function firesql
usrofc=0
Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc
usrofc=0
usrofc=0
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{OFCNAME})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({m2},{Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username})
   Calling function firesql
Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username
username=14245
Time elapsed = 16
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{usergroup})
   Calling function sqlget
   Result of sqlget = Patwari
   Result = Patwari
   Evaluating firesql({x},{Select PATID from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select PATID from VW_USRDTL where usrnm = :username and rownum=1
username=14245
Time elapsed = 0
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{PATID})
   Calling function sqlget
   Result of sqlget = 5384
   Result = 5384
Password validation done successfully
Opening Session
Param Type = c
sessionid=712005.875322.142174
Param Type = c
logintime=28/11/2022 10:13:42
Param Type = c
username=14245
Param Type = c
usergroup=Patwari
Param Type = c
project=dmis
Param Type = n
groupno=0
Param Type = c
userroles=Patwari
Param Type = c
appvars=usrrole=Patwari
usrpatwar=Loona Kalan
usrdistnm=Jaisalmer
usrtehnm=Pokaran
usrilrnm=Bhainsara
usrpatnm=Loona Kalan
usrdistid=16
usrdept=0
usrofc=0
usrdeptnm=ALL
usrofcnm=ALL
urole=Patwari
usrpatid=5384
responsibilies=Patwari
rolename=Patwari
ax_evalcopy=F

insert into Axmconnections (sessionid,logintime,username,usergroup,project,groupno,userroles,pageaccess,appvars) values (:sessionid,to_date(:logintime,'dd/mm/yyyy hh24:mi:ss'),:username,:usergroup,:project,:groupno,:userroles,null,:appvars)

delete from axmtranscontrol where username = '14245'

Time elapsed = 0
TransControl checking done
Before saving the login record
Param Type = c
sessionid=712005.875322.142174
Param Type = c
username=14245
Param Type = c
logintime=28/11/2022 10:13:42
Param Type = c
status=Success
Param Type = c
nologout=T
insert into AxmAudit (sessionid,username,logintime,status,reason,other,nologout) values (:sessionid,:username,to_date(:logintime,'dd/mm/yyyy hh24:mi:ss'),:status,null,null,:nologout)

login record saved
Fetching menu details
Script for Menu fetching : select a.AXMPAGEHDRid, a.menu_caption, a.sname, a.struct_type, a.modifiedon, a.html_view, a.button_param, a.mapview, a.forcecamera, a.geo from axmPageHdr a , (select DISTINCT SNAME FROM axuseraccess WHERE RNAME IN ('Patwari') and STYPE in ('t','i')) b where A.SNAME = B.SNAME  order by a.sname 
select a.AXMPAGEHDRid, a.menu_caption, a.sname, a.struct_type, a.modifiedon, a.html_view, a.button_param, a.mapview, a.forcecamera, a.geo from axmPageHdr a , (select DISTINCT SNAME FROM axuseraccess WHERE RNAME IN ('Patwari') and STYPE in ('t','i')) b where A.SNAME = B.SNAME  order by a.sname 
Time elapsed = 16
CDS Record Count : 0
Fetched the menu
output result : {"result":{"status":"Success","s":"712005.875322.142174","ugroup":"Patwari","uroles":"Patwari","USERNAME":"14245","AUSERNAME":"14245","NICKNAME":"RAKESH KUMAR","ISFRMAPRV":"19710000000056","SSOID":"RJBM201705026329","USERTYPE":"10265000000000","EMAIL":"rakeshvishnoi18@gmail.com","MOBILE":"8107678954","BUILD":"F","MANAGE":"F","TOOLS":"F","WORKFLOW":"F","SEND":"F","IMPORTSTRUCT":"F","ISFIRSTTIME":"F","ACTIVE":"T","ACTFLAG":"T","LASTLOGINTIME":"","LASTLOGINIP":"","PAGEACCESS":"","EXPORTSTRUCT":"","LANGUAGE_ACCESS":"","LANGUAGE":"","LOGINTRY":"","PWDEXPDAYS":"","APPPARAMS":"","APPMANAGER":"","WEBSKIN":"","USERGROUP":"","GROUPNO":"0","DEBUG":"","ACTIVELMS":"F","axmmenu":{}}}
Login webservice completed


Closing connection
# 1#Saving to log
Param Type = c
sessionid=712005.875322.142174
Param Type = c
username=14245
Param Type = c
calledon=28/11/2022 10:13:42
Param Type = c
callfinished=28/11/2022 10:13:42
Param Type = n
recordid=0
Param Type = c
servicename=Login
Param Type = c
serviceresult=success
Param Type = n
timetaken=532
Param Type = n
dbtimetaken=360
insert into axmwslog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (:sessionid,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),null,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken)

Freeing AxProvider Resources
Freeing DbManager Resources