Mr

Start Time : 7/16/2024 4:38:49 PM Saving Data Cross checking field value xml length sent from client and received xml length Call to SaveData Web Service ASB XE3/32/64 DLL running [Compiled on 29/05/2024 10:32:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(290324)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 3 SET SEARCH_PATH TO trustlineuat,trustlineuat,public uXDS\dexecsql\ Check intransaction Time elapsed = 2 Select nextval('connectnoseq') uXDS\dopen\ Check intransaction Time elapsed = 3 uXDS\dopen\ Check intransaction Time elapsed = 4 uXDS\dexecsql\ Check intransaction Time elapsed = 2 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 3 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 2 Db Manager Connection ends Connection to DB Successful Executing Savedata webservice ----------------------------- Received XML : 1746990000000717117469900000001MrT K Govinda Rajan1T K Govinda RajanTruvenkatachari KrishnamachariRajashree GovindarajanMaleAALPG7512L28/05/1965FProfessionalIndiaDummyIndianIndianResident IndianNew KYC Validated40085773792017SingleIndividual Resident92821794780FFsomatcs1@gmail.comsomatcs1@gmail.com29/04/2024Profusion Capitaltest5@gmail.com9999999995D Palanipalani@trustlineindia.com98841522221tkgovind@yahoo.comTTAML Checked\\10.16.248.2\UAT_Attachment\UAT_TLReports29946702F115318800000081746990000001PMSIntrinsicYesTLAX000717114/08/2009IN3004842994670214/08/20090.00\\10.16.248.2\UAT_Attachment\UAT_TLReportsPMSIntrinsic299467021746990000003SBHDFC000008214F008210500254321HDFC Bank LtdNo.40, Nungambakkam High Road N.H.Road Chennai Tamilnadu600034Chennai - Nungambakkam600240006HDFC000008200821050025432\\10.16.248.2\UAT_Attachment\UAT_TLReports1746990000002Flat No 8 III Floor Manikam 17/24 Soundarapandian Salai Ashok NagarChennai600083Tamil NaduIndia600600Flat No 8 III Floor Manikam 17/24 Soundarapandian Salai Ashok Nagar Chennai-600083 Tamil Nadu IndiaFlat No 8 III Floor Manikam 17/24 Soundarapandian Salai Ashok Nagar Chennai-600083 Tamil Nadu IndiaTFlat No 8 III Floor Manikam 17/24 Soundarapandian Salai Ashok NagarChennai600083Tamil Nadu600600IndiaFlat No 8 III Floor Manikam 17/24 Soundarapandian Salai Ashok Nagar Chennai-600083 Tamil Nadu IndiaFlat No 8 III Floor Manikam 17/24 Soundarapandian Salai Ashok Nagar Chennai-600083 Tamil Nadu India\\10.16.248.2\UAT_Attachment\UAT_TLReports174699000000000.000F0.000dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuatdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1026110000000FsomatrustlineadmintrustlineadminFtvycatqp5rrltbbkxwruvu1ptrustlineadmin~100trustlineuattrustlineuat0trustlineadminhttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*7/16/2024 4:33:50 pm*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*7/16/2024 4:33:50 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=tvycatqp5rrltbbkxwruvu1p ax_evalcopy=F rolename=trustlineadmin responsibilies=trustlineadmin millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1026110000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group trustlineadmin User Roles trustlineadmin Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 4 Creating DbCall select ' '::varchar(250) as lval Time elapsed = 2 select ' '::varchar(250) as lval Time elapsed = 3 select * from client_details where client_detailsid=0 Time elapsed = 7 Evaluating client_code Result = Evaluating recordid Result = Evaluating IIF(client_name_check =1,{T},{ cannot be only numeric}) Result = Evaluating IIF(recordid = 0, client_name) Result = Evaluating IIF(dob_doi > Date(), { Future date not allowed},{T}) Result = Evaluating {F} Result = Evaluating {India} Result = Evaluating temp_nationality Result = Evaluating {Single} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating iif( logincount # 0 & FieldChanged({primary_emailid},1) = {T},{ cannot be changed. Login exists for }+primary_emailid, {T}) Result = Evaluating date() Result = Evaluating {F} Result = Evaluating {T} Result = Evaluating AxpAttachmentPath Result = Evaluating getallvalues({account_client_id},{,}) Result = Evaluating IIF(primary_emailid = duplicate_primarymail_id, {F},{T}) Result = Evaluating {India} Result = Evaluating AxpAttachmentPath Result = Evaluating {Yes} Result = Evaluating IIF(date_of_agreement > Date(),{ Future date not allowed},{T}) Result = Evaluating IIF(poa_agreement_date > Date(),{ Future date not allowed},{T}) Result = Evaluating AxpAttachmentPath Result = Evaluating fund_code + scheme_code + account_client_id Result = Evaluating {F} Result = Evaluating iif(accountno_length <> 0, (IIF(GetLength(trim(bank_account_number)) = accountno_length, {T}, {Account Length has to be } + str(accountno_length))),{T}) Result = Evaluating IIF(bank_accountnumber_check =1,{T},{ cannot contain alphabets}) Result = Evaluating bank_ifsc_code + bank_account_number Result = Evaluating AxpAttachmentPath Result = Evaluating IIF(joint_dob > Date(),{ Future date not allowed},{T}) Result = Evaluating IIF((activerow > 0) & (joint_pan_number = pan_number),{ should not be same as Primary holder's PAN#},{T}) Result = Evaluating activerow Result = Evaluating AxpAttachmentPath Result = Evaluating SubStr(permanent_pin_zip,1,3) Result = Evaluating IIF(ISEmpty(permanent_pin_zip)={F},IIF(per_substring_pincode = perpincode_start_digit,{T},{:Invalid Pincode}),{T}) Result = Evaluating permanent_temp_address Result = Evaluating {T} Result = Evaluating iif(same_aspermanent_address={T},permanent_house_number,{}) Result = Evaluating iif(same_aspermanent_address={T},permanent_locality_sublocality,{}) Result = Evaluating iif(same_aspermanent_address={T},permanent_city,{}) Result = Evaluating iif(same_aspermanent_address={T},permanent_pin_zip,{}) Result = Evaluating SubStr(communication_pin_zip,1,3) Result = Evaluating IIF((ISEmpty(communication_pin_zip)={F}), IIF(comm_substring_pincode = comm_pincode_startdigit,{T},{: Invalid Pincode})) Result = Evaluating communication_temp_address Result = Evaluating AxpAttachmentPath Result = Evaluating IIF(nominee_date_of_birth > Date(),{Future date not allowed},{T}) Result = Evaluating {No} Result = Evaluating IIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardianname_isminor) = {T},{ Cannot be left empty if nominee is minor},{T})) Result = Evaluating IIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_relationship) = {T},{ Cannot be left empty if nominee is minor},{T})) Result = Evaluating IIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_mobileno) = {T},{ Cannot be left empty if nominee is minor},{T})) Result = Evaluating IIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_pan_number) = {T},{ Cannot be left empty if nominee is minor},{T})) Result = Evaluating IIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_ckyc_number) = {T},{ Cannot be left empty if nominee is minor},{T})) Result = Evaluating IIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_kyc_status) = {T},{ Cannot be left empty if nominee is minor},{T})) Result = Evaluating AxpAttachmentPath Result = Evaluating IIF(ubo_dateofbirth > Date(),{ Future date not allowed},{T}) Result = Evaluating AxpAttachmentPath Result = Evaluating GetRowCount({joint_name}) Result = Evaluating IIF( lower(holding_status) = {joint} & jointholder_rowcount = 0, { Details cannot be left blank}, {T}) Result = Evaluating Total({nominee_share}) Result = Evaluating GetRowCount({nominee_name}) Result = Evaluating IIF(nominee = {T},IIF(nominee_dcrowcount > 0,IIF(nominee_share_total = 100,{T},{Total share of Nominee(s) must be 100%}),{One or more Nominees are mandatory}),{T}) Result = Evaluating iif( client_logincount = 0, {T}, {F}) Result = Evaluating Total({ubo_percentage}) Result = Evaluating GetRowCount({ubo_name}) Result = select * from AxAttachWorkflow where lower(transid) = 'trcln' Time elapsed = 3 Loading genmaps Creating Action object Submitting data to dbcall Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over DB Call Validate and save >>Validating trcln >>Frame No 1 client_code = 71 S=71 Select client_code from client_details where lower(client_code) = :S and client_detailsID <> 1746990000000 S=71 Time elapsed = 2 docid = 71 Evaluating - client_code client_code = 71 S=71 Select docid from client_details where lower(docid) = :S and client_detailsID <> 1746990000000 S=71 Time elapsed = 2 recid = 1746990000000 logincount = 1 client_code=71 select count(1) as cnt from axusers a, client_details b where b.primary_emailid = a.pusername and b.client_code = :client_code client_code=71 Time elapsed = 6 Query opened , Record count : 1 title = Mr client_name = T K Govinda Rajan S=t k govinda rajan Select client_name from client_details where lower(client_name) = :S and client_detailsID <> 1746990000000 S=t k govinda rajan Time elapsed = 2 client_name_check = 1 client_name=T K Govinda Rajan SELECT 1 FROM dual WHERE ( :client_name !~ '^[0-9]+$' AND :client_name ~ '[A-Za-z]+') client_name=T K Govinda Rajan client_name=T K Govinda Rajan Time elapsed = 4 Query opened , Record count : 1 Evaluating - IIF(client_name_check =1,{T},{ cannot be only numeric}) client_name_check = 1 Result of iif = T client_display_name = T K Govinda Rajan father_name = Truvenkatachari Krishnamachari spouse_name = Rajashree Govindarajan gender = Male select lov_description from list_of_values a where lower(a.lov_category) = 'gender' and a.cancel = 'F' and a.active = 'T' order by 1 Time elapsed = 4 Query opened , Record count : 4 pan_number = AALPG7512L dob_doi = 28/05/1965 Evaluating - IIF(dob_doi > Date(), { Future date not allowed},{T}) Result of date = 16/07/2024 dob_doi = 28/05/1965 Result of iif = T politically_exp_person = F occupation = Professional recordid=1746990000000 select lov_description from list_of_values a where lower(a.lov_category) = 'occupation' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 1 recordid=1746990000000 Time elapsed = 3 Query opened , Record count : 8 country_of_birth = India Id = 1527770000003 Select a1.global_mst_countryid,a1.n_country_name,a1.nationality from global_mst_country a1 where a1.active = 'T' and a1.cancel = 'F' order by a1.n_country_name Time elapsed = 5 Query opened , Record count : 89 place_of_birth = Dummy temp_nationality = Indian Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function nationality = Indian recordid=1746990000000 select a.nationality from global_mst_country a where a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 1 recordid=1746990000000 Time elapsed = 3 Query opened , Record count : 89 resident_status = Resident Indian recordid=1746990000000 nationality=Indian select lov_description from list_of_values a where lower(a.lov_category) = 'resident status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) and ( (lower( :nationality) = 'indian' and lower(a.lov_description) !='foreign national') or (lower( :nationality) != 'indian' and lower(a.lov_description) ='foreign national') ) order by 1 recordid=1746990000000 nationality=Indian nationality=Indian Time elapsed = 5 Query opened , Record count : 4 kyc_status = New KYC Validated recordid=1746990000000 select lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 1 recordid=1746990000000 Time elapsed = 3 Query opened , Record count : 8 ckyc_number = 40085773792017 holding_status = Single recordid=1746990000000 select lov_description from list_of_values a where lower(a.lov_category) = 'holding status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 1 recordid=1746990000000 Time elapsed = 3 Query opened , Record count : 4 tax_status = Individual Resident recordid=1746990000000 select lov_description from list_of_values a where lower(a.lov_category) = 'tax status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 1 recordid=1746990000000 Time elapsed = 3 Query opened , Record count : 13 country_code = recordid=1746990000000 select a.calling_code from global_mst_country a where ( a.active = 'T' or :recordid > 0 ) and a.cancel = 'F' order by 1 recordid=1746990000000 Time elapsed = 3 Query opened , Record count : 89 primary_mobileno = 9282179478 secondary_mobileno = 0 ubo = F nominee = F primary_emailid = somatcs1@gmail.com Evaluating - iif( logincount # 0 & FieldChanged({primary_emailid},1) = {T},{ cannot be changed. Login exists for }+primary_emailid, {T}) Result of fieldchanged = T logincount = 1 primary_emailid = somatcs1@gmail.com Result of iif = cannot be changed. Login exists for somatcs1@gmail.com Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com Validate error msg : Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com Validate error msg1 : Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com Validate error msg2 : Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com DB Call error msg : Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com Error : Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com" , "errfld" : "primary_emailid,1 insert into axerrorlog values('soma',to_timestamp('16/07/2024 16:38:49','dd/mm/yyyy hh24:mi:ss'),'trcln','SaveData','Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com" , "errfld" : "primary_emailid,1') Time elapsed = 5 Constraint Name = Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com select msg from axconstraints where lower(constraint_name) = 'primary email id* cannot be changed. login exists for somatcs1@gmail.com' Time elapsed = 2 Savedata webservice completed Freeing DbCall Resources Freeing Store data Freeing DD Map Freeing Provide Link Freeing Validate Freeing Parser Freeing Poststr Freeing Maxrows Freeing Fnames Freeing NewMaxRows Freeing tlines Freeing workquery Freeing Struct Freeing EventList Freeing Tree Obj Freeing Workflow Obj Done - Workflow Obj Freeing DbCall Completed Freeing Action Obj Resources # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('tvycatqp5rrltbbkxwruvu1p','soma',to_timestamp('16/07/2024 16:38:49','dd/mm/yyyy hh24:mi:ss'),to_timestamp('16/07/2024 16:38:49','dd/mm/yyyy hh24:mi:ss'),'trcln',0,'Saving data','Primary Email ID* cannot be changed. Login exists for somatcs1@gmail.com',585,93,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Destroying License Manager Destroying License Manager XDS Destroying License Manager Completed Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF End Time : 7/16/2024 4:38:49 PM