17-03-2022 13:26:48:ValidationRequest(): Log:Validation Request DetailsTGMBN22076069021|001001002077 
<------------------------Started ValidationRequest CBS A/C No : 001001002077 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
Service1.svc:Exception in ValidationRequest()Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: The parameter is incorrect.
 (D:\IISPL\AXIS_INWARD_SERVICE\web.config line 14)ValidationRequest Execution Success with response :  111
<------------------------------------------------------------------------------------------------------------------------>

17-03-2022 14:39:10:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000072', 0, brlength) branch, SUBSTR ('001001000072', brlength+1, schlength) linksno, SUBSTR ('001001000072', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
ShowCBS Ac No Proce With Error  System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
   at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset)
   at System.Data.OracleClient.OCI.DetermineClientVersion()
   --- End of inner exception stack trace ---
   at System.Data.OracleClient.OCI.DetermineClientVersion()
   at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 34
   at SSLWCF.TranProcess.ShowCBSAcNo(String CbsNo) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 149ShowCBS Ac No Proce Executed  ||||

17-03-2022 14:39:10:TranProcess.cs: Exception in ValidateAcNo()System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
   at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset)
   at System.Data.OracleClient.OCI.DetermineClientVersion()
   --- End of inner exception stack trace ---
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 34
   at SSLWCF.TranProcess.ValidateAcNo(String CbsNo, String strUTR) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 80
17-03-2022 14:39:10:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001000072
ValidationAcNo.cs: Query TO Fetch()<------------------------------------------------------------------------------------------------------------------------>
System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
   at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset)
   at System.Data.OracleClient.OCI.DetermineClientVersion()
   --- End of inner exception stack trace ---
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 34
   at SSLWCF.TranProcess.ValidateAcNo(String CbsNo, String strUTR) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 80
17-03-2022 14:39:10:ValidationRequest(): Log:Validation Request DetailsAXISP00272487049|001001000072 
<------------------------Started ValidationRequest CBS A/C No : 001001000072 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
Service1.svc:Exception in ValidationRequest()Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.ValidationRequest Execution Success with response :  111
<------------------------------------------------------------------------------------------------------------------------>

17-03-2022 17:55:24:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003175|SB|1

17-03-2022 17:55:24:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
17-03-2022 17:55:24:ValidationRequest(): Log:Validation Request DetailsBKIDO22076467527|001001003175 
<------------------------Started ValidationRequest CBS A/C No : 001001003175 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

17-03-2022 18:29:01:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003576', 0, brlength) branch, SUBSTR ('001001003576', brlength+1, schlength) linksno, SUBSTR ('001001003576', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003576|SB|1

17-03-2022 18:29:01:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003576
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003576ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003576|1
17-03-2022 18:29:01:ValidationRequest(): Log:Validation Request DetailsICMS220317003LUV|001001003576 
<------------------------Started ValidationRequest CBS A/C No : 001001003576 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

17-03-2022 18:33:32:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003175|SB|1

17-03-2022 18:33:32:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
17-03-2022 18:33:32:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'BKIDO22076467527'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'BKIDO22076467527','HARISH','001001003175','HARISHA T M S O MANJUNATH', '846810310000098','BKID0000200','UTIB0SMCBL1',1,'123')TranProcess.cs: Inward_process(): 001001003175 BKIDO22076467527  Status : 000

17-03-2022 18:33:32:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDO22076467527|001001003175 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDO22076467527|001001003175 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

17-03-2022 19:00:57:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003576', 0, brlength) branch, SUBSTR ('001001003576', brlength+1, schlength) linksno, SUBSTR ('001001003576', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003576|SB|1

17-03-2022 19:00:57:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003576
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003576ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003576|1
17-03-2022 19:00:57:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'ICMS220317003LUV'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'ICMS220317003LUV','SHRILAKSHMI  SHILA','001001003576','LIC OF INDIA DO 2 BANGALURU PH A C', '0202102000026628','IBKL0000202','UTIB0SMCBL1',43778,'123')TranProcess.cs: Inward_process(): 001001003576 ICMS220317003LUV  Status : 000

17-03-2022 19:00:57:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICMS220317003LUV|001001003576 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICMS220317003LUV|001001003576 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>