2024-09-12T19:47:06.844-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: firewallpassword = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: kerberoskeytabfile = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcerttype = USER
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshserverfingerprint = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: user = prxDataLake
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxyautodetect = True
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxyssltype = AUTO
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: kerberosticketcache = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthtokentimestamp = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshuser = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: tables = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: kerberosspn = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: azuretenant = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: ntlmversion = 1
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: firewalltype = NONE
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: useconnectionpooling = False
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxyexceptions = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: maxrows = -1
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxyserver = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthgranttype = CODE
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: kerberoskdc = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: server = 10.15.66.24
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthrefreshtoken = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthaccesstoken = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: timeout = 30
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: logfile = D:\LogFiles\jobAimiClone_S_2024-09-12-19-47-06.log
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcertpassword = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sslclientcerttype = USER
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshauthmode = Password
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: other = azuretenant='';cdataapp=DataSync
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: usessh = False
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: applicationname = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: firewallserver = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: initiateoauth = OFF
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: authscheme = Password
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: azureenvironment = GLOBAL
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshclientcert = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxyport = 80
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sslclientcertpassword = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: verbosity = 2
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshport = 22
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: encrypt = False
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: includetabletypes = True
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sslservercert = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: browsableschemas = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshclientcertsubject = *
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: applicationintent = ReadWrite
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcert = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: domain = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: location = C:\ProgramData\CData\sync\connections\srcAimi
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: firewallport = 0
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: firewalluser = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: password = *****
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshserver = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: port = 1433
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sslclientcertsubject = *
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthexpiresin = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthsettingslocation = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: kerberosservicerealm = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: maxlogfilesize = 100M
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: database = AIMINXT
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshpassword = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: includesystemschemas = True
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthclientsecret = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: querypassthrough = False
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: kerberosservicekdc = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshclientcerttype = PEMKEY_FILE
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: views = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sshclientcertpassword = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthclientid = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: kerberosrealm = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: sslclientcert = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcertsubject = *
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: logmodules = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxypassword = 
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxyauthscheme = BASIC
2024-09-12T19:47:06.846-06:00	2	[12|Q-Id]	[INFO|Connec] Connection Property: proxyuser = 
2024-09-12T19:47:06.882-06:00	2	[12|Q-Id]	[TCP ] ConnectionStatus: Remote host connection complete. (0 - OK)
2024-09-12T19:47:06.882-06:00	2	[12|Q-Id]	[TCP |Receiv] Connected (0 - OK)
2024-09-12T19:47:07.022-06:00	0	[Connection: 12]SSL|Tls error with code 280, Error verifying Server certificate: 800B0109 A certification chain processed correctly but terminated in a root certificate not trusted by the trust provider.
2024-09-12T19:47:07.022-06:00	0	[Connection: 12]SSL|Tls error with code 280, Error verifying Server certificate: 800B0109 A certification chain processed correctly but terminated in a root certificate not trusted by the trust provider.
2024-09-12T19:47:07.022-06:00	2	[Connection: 12]SSLServerAuthentication
2024-09-12T19:47:07.132-06:00	1	[12|Q-Id]	[INFO|Connec] Opened SQL connection. Version: 23.0.8839.0. Edition: [ADO.NET Provider .NET 4.0].
2024-09-12T19:47:07.132-06:00	1	[12|Q-Id]	[INFO|Connec] Connection String: applicationintent=ReadWrite;applicationname='';authscheme=Password;autocache=False;azureenvironment=GLOBAL;azuretenant='';batchsize=0;browsableschemas='';cacheconnection='';cachelocation="%APPDATA%\CData\SQL Data Provider";cachemetadata=False;cacheprovider='';cachetolerance=600;callbackurl='';catalog=AIMINXT;cdataapp=DataSync;connectionlifetime=0;database=AIMINXT;domain='';encrypt=False;firewallpassword='';firewallport=0;firewallserver='';firewalltype=NONE;firewalluser='';includesystemschemas=True;includetabletypes=True;initiateoauth=OFF;integratedsecurity=False;kerberoskdc='';kerberoskeytabfile='';kerberosrealm='';kerberosservicekdc='';kerberosservicerealm='';kerberosspn='';kerberosticketcache='';location=C:\ProgramData\CData\sync\connections\srcAimi;logfile=D:\LogFiles\jobAimiClone_S_2024-09-12-19-47-06.log;logmodules='';maxlogfilecount=-1;maxlogfilesize=100M;maxrows=-1;ntlmversion=1;oauthaccesstoken='';oauthclientid='';oauthclientsecret='';oauthencryptkey='';oauthexpiresin='';oauthgranttype=CODE;oauthjwtcert='';oauthjwtcertpassword='';oauthjwtcertsubject=*;oauthjwtcerttype=USER;oauthrefreshtoken='';oauthsettingslocation='';oauthtokentimestamp='';oauthverifier='';offline=False;other="azuretenant='';cdataapp=DataSync";password=*****;poolidletimeout=60;poolmaxsize=100;poolminsize=1;poolwaittime=60;port=1433;proxyauthscheme=BASIC;proxyautodetect=True;proxyexceptions='';proxypassword='';proxyport=80;proxyserver='';proxyssltype=AUTO;proxyuser='';querypassthrough=False;readonly=False;server=10.15.66.24;sshauthmode=Password;sshclientcert='';sshclientcertpassword='';sshclientcertsubject=*;sshclientcerttype=PEMKEY_FILE;sshpassword='';sshport=22;sshserver='';sshserverfingerprint='';sshuser='';sslclientcert='';sslclientcertpassword='';sslclientcertsubject=*;sslclientcerttype=USER;sslservercert='';tables='';timeout=30;useconnectionpooling=False;user=prxDataLake;usessh=False;verbosity=2;views=''
2024-09-12T19:47:07.132-06:00	2	[12|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM SYS_SQLINFO]
2024-09-12T19:47:07.132-06:00	2	[12|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM SYS_SQLINFO] Success: (0 ms)
2024-09-12T19:47:07.132-06:00	2	[12|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM sys_tabletypes]
2024-09-12T19:47:07.132-06:00	2	[12|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM sys_tabletypes] Success: (0 ms)
2024-09-12T19:47:07.187-06:00	2	[Connection: 12]Connection tested successfully, version: Microsoft SQL Server 2019 (RTM-CU28) (KB5039747) - 15.0.4385.2 (X64) 
	Jul 25 2024 21:32:40 
	Copyright (C) 2019 Microsoft Corporation
	Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)

2024-09-12T19:47:07.224-06:00	2	[12|Q-Id]	[TCP ] ConnectionStatus: Remote host disconnected. (0 - OK)
2024-09-12T19:47:07.224-06:00	2	[12|Q-Id]	[TCP ] Disconnected (0 - OK)
2024-09-12T19:47:07.224-06:00	1	[12|Q-Id]	[INFO|Connec] Closed SQL connection
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: firewallpassword = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: kerberoskeytabfile = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcerttype = USER
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshserverfingerprint = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: user = prxDataLake
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxyautodetect = True
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxyssltype = AUTO
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: kerberosticketcache = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthtokentimestamp = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshuser = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: tables = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: kerberosspn = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: azuretenant = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: ntlmversion = 1
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: firewalltype = NONE
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: useconnectionpooling = False
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxyexceptions = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: maxrows = -1
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxyserver = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthgranttype = CODE
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: kerberoskdc = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: server = 10.15.66.24
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthrefreshtoken = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthaccesstoken = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: timeout = 30
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcertpassword = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sslclientcerttype = USER
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshauthmode = Password
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: other = azuretenant='';cdataapp=DataSync;logfile=D:\LogFiles\jobAimiClone_S_2024-09-12-19-47-06.log;maxlogfilesize=100M;verbosity=2
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: usessh = False
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: applicationname = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: firewallserver = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: initiateoauth = OFF
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: authscheme = Password
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: azureenvironment = GLOBAL
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshclientcert = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxyport = 80
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sslclientcertpassword = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshport = 22
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: encrypt = False
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: includetabletypes = True
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sslservercert = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: browsableschemas = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshclientcertsubject = *
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: applicationintent = ReadWrite
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcert = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: domain = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: location = C:\ProgramData\CData\sync\connections\srcAimi
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: firewallport = 0
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: firewalluser = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: password = *****
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshserver = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: port = 1433
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sslclientcertsubject = *
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthexpiresin = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthsettingslocation = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: kerberosservicerealm = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: database = AIMINXT
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshpassword = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: includesystemschemas = True
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthclientsecret = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: querypassthrough = true
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: kerberosservicekdc = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshclientcerttype = PEMKEY_FILE
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: views = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sshclientcertpassword = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthclientid = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: kerberosrealm = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: sslclientcert = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: oauthjwtcertsubject = *
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: logmodules = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxypassword = 
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxyauthscheme = BASIC
2024-09-12T19:47:07.721-06:00	2	[13|Q-Id]	[INFO|Connec] Connection Property: proxyuser = 
2024-09-12T19:47:07.752-06:00	2	[13|Q-Id]	[TCP ] ConnectionStatus: Remote host connection complete. (0 - OK)
2024-09-12T19:47:07.752-06:00	2	[13|Q-Id]	[TCP |Receiv] Connected (0 - OK)
2024-09-12T19:47:07.877-06:00	0	[Connection: 13]SSL|Tls error with code 280, Error verifying Server certificate: 800B0109 A certification chain processed correctly but terminated in a root certificate not trusted by the trust provider.
2024-09-12T19:47:07.877-06:00	0	[Connection: 13]SSL|Tls error with code 280, Error verifying Server certificate: 800B0109 A certification chain processed correctly but terminated in a root certificate not trusted by the trust provider.
2024-09-12T19:47:07.877-06:00	2	[Connection: 13]SSLServerAuthentication
2024-09-12T19:47:07.969-06:00	1	[13|Q-Id]	[INFO|Connec] Opened SQL connection. Version: 23.0.8839.0. Edition: [ADO.NET Provider .NET 4.0].
2024-09-12T19:47:07.969-06:00	1	[13|Q-Id]	[INFO|Connec] Connection String: applicationintent=ReadWrite;applicationname='';authscheme=Password;autocache=False;azureenvironment=GLOBAL;azuretenant='';batchsize=0;browsableschemas='';cacheconnection='';cachelocation="%APPDATA%\CData\SQL Data Provider";cachemetadata=False;cacheprovider='';cachetolerance=600;callbackurl='';catalog=AIMINXT;cdataapp=DataSync;connectionlifetime=0;database=AIMINXT;domain='';encrypt=False;firewallpassword='';firewallport=0;firewallserver='';firewalltype=NONE;firewalluser='';includesystemschemas=True;includetabletypes=True;initiateoauth=OFF;integratedsecurity=False;kerberoskdc='';kerberoskeytabfile='';kerberosrealm='';kerberosservicekdc='';kerberosservicerealm='';kerberosspn='';kerberosticketcache='';location=C:\ProgramData\CData\sync\connections\srcAimi;logfile=D:\LogFiles\jobAimiClone_S_2024-09-12-19-47-06.log;logmodules='';maxlogfilecount=-1;maxlogfilesize=100M;maxrows=-1;ntlmversion=1;oauthaccesstoken='';oauthclientid='';oauthclientsecret='';oauthencryptkey='';oauthexpiresin='';oauthgranttype=CODE;oauthjwtcert='';oauthjwtcertpassword='';oauthjwtcertsubject=*;oauthjwtcerttype=USER;oauthrefreshtoken='';oauthsettingslocation='';oauthtokentimestamp='';oauthverifier='';offline=False;other="azuretenant='';cdataapp=DataSync;logfile=D:\LogFiles\jobAimiClone_S_2024-09-12-19-47-06.log;maxlogfilesize=100M;verbosity=2";password=*****;poolidletimeout=60;poolmaxsize=100;poolminsize=1;poolwaittime=60;port=1433;proxyauthscheme=BASIC;proxyautodetect=True;proxyexceptions='';proxypassword='';proxyport=80;proxyserver='';proxyssltype=AUTO;proxyuser='';querypassthrough=true;readonly=False;server=10.15.66.24;sshauthmode=Password;sshclientcert='';sshclientcertpassword='';sshclientcertsubject=*;sshclientcerttype=PEMKEY_FILE;sshpassword='';sshport=22;sshserver='';sshserverfingerprint='';sshuser='';sslclientcert='';sslclientcertpassword='';sslclientcertsubject=*;sslclientcerttype=USER;sslservercert='';tables='';timeout=30;useconnectionpooling=False;user=prxDataLake;usessh=False;verbosity=2;views=''
2024-09-12T19:47:09.630-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM SYS_SQLINFO]
2024-09-12T19:47:09.630-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM SYS_SQLINFO] Success: (0 ms)
2024-09-12T19:47:09.645-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM sys_tabletypes]
2024-09-12T19:47:09.645-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM sys_tabletypes] Success: (0 ms)
2024-09-12T19:47:09.645-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM SYS_SQLINFO]
2024-09-12T19:47:09.645-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM SYS_SQLINFO] Success: (0 ms)
2024-09-12T19:47:09.645-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM sys_tabletypes]
2024-09-12T19:47:09.645-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM sys_tabletypes] Success: (0 ms)
2024-09-12T19:47:09.661-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM sys_tables  WHERE  SchemaName = @schema AND  TableName = @table]
2024-09-12T19:47:09.661-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: schema = dbo, table = App_History
2024-09-12T19:47:09.677-06:00	2	[13|Q-Id]	[META|Schema] Executing table schema query: [<NULL>]
2024-09-12T19:47:09.968-06:00	1	[13|Q-Id]	[META|Schema] Executed  table schema query: Table: [<NULL>] Success: 584 results (291 ms)
2024-09-12T19:47:09.968-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM sys_tables  WHERE  SchemaName = @schema AND  TableName = @table] Success: (307 ms)
2024-09-12T19:47:10.015-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM sys_procedureparameters  WHERE SchemaName LIKE @p1 AND ProcedureName LIKE @p2]
2024-09-12T19:47:10.015-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: p1 = sys, p2 = sp_cdc_help_change_data_capture
2024-09-12T19:47:10.031-06:00	2	[13|Q-Id]	[META|Schema] Executing procedure parameters schema query: [sp_cdc_help_change_data_capture]
2024-09-12T19:47:10.109-06:00	1	[13|Q-Id]	[META|Schema] Executed  procedure parameters schema query: [sp_cdc_help_change_data_capture] Success: 3 results (78 ms)
2024-09-12T19:47:10.109-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM sys_procedureparameters  WHERE SchemaName LIKE @p1 AND ProcedureName LIKE @p2] Success: (94 ms)
2024-09-12T19:47:10.140-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT * FROM sys_procedureparameters  WHERE SchemaName LIKE @p1 AND ProcedureName LIKE @p2]
2024-09-12T19:47:10.140-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: p1 = sys, p2 = sp_cdc_help_change_data_capture
2024-09-12T19:47:10.140-06:00	2	[13|Q-Id]	[META|Schema] Executing procedure parameters schema query: [sp_cdc_help_change_data_capture]
2024-09-12T19:47:10.203-06:00	1	[13|Q-Id]	[META|Schema] Executed  procedure parameters schema query: [sp_cdc_help_change_data_capture] Success: 3 results (63 ms)
2024-09-12T19:47:10.203-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT * FROM sys_procedureparameters  WHERE SchemaName LIKE @p1 AND ProcedureName LIKE @p2] Success: (63 ms)
2024-09-12T19:47:10.203-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [[sys].[sp_cdc_help_change_data_capture]]
2024-09-12T19:47:10.203-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: source_schema = dbo, source_name = App_History
2024-09-12T19:47:10.234-06:00	2	[13|Q-Id]	[META|Schema] Executing procedure parameters schema query: [sp_cdc_help_change_data_capture]
2024-09-12T19:47:10.281-06:00	1	[13|Q-Id]	[META|Schema] Executed  procedure parameters schema query: [sp_cdc_help_change_data_capture] Success: 3 results (47 ms)
2024-09-12T19:47:10.343-06:00	1	[13|Q-Id]	[SQL |Messag] Query Failed: [[sys].[sp_cdc_help_change_data_capture]]. Error: The SQL Error Number is 22901, State is 1, Severity is 16, Error is 'The database 'AIMINxt' is not enabled for Change Data Capture. Ensure that the correct database context is set and retry the operation. To report on the databases enabled for Change Data Capture, query the is_cdc_enabled column in the sys.databases catalog view.', Server name is AWDAPPINDB3, Line number is 19.The Token Type is 170
2024-09-12T19:47:10.796-06:00	2	[13|Q-Id]	The SQL Error Number is 22901, State is 1, Severity is 16, Error is 'The database 'AIMINxt' is not enabled for Change Data Capture. Ensure that the correct database context is set and retry the operation. To report on the databases enabled for Change Data Capture, query the is_cdc_enabled column in the sys.databases catalog view.', Server name is AWDAPPINDB3, Line number is 19.The Token Type is 170
ruo230q.yt
   at ruo230q.vbk.V(Int32 , RkF`1 )
   at ruo230q.vyy.w(SqlTable , vta , QueryParameterCollection )
   at ruo230q.vyy.ExecuteQuery(IDataStatement , QueryParameterCollection , Int32 )
   at ruo230q.Iv.ExecuteQuery(IDataStatement , QueryParameterCollection , Int32 )
   at ruo230q.RDq.ExecuteQuery(IDataStatement , QueryParameterCollection , Int32 )
   at ruo230q.RkH.Oe()
   at ruo230q.Ne.Wc(QueryParameterCollection )
2024-09-12T19:47:10.868-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT [object_id] FROM [sys].[change_tracking_tables] WHERE [object_id] = OBJECT_ID('dbo.App_History')]
2024-09-12T19:47:10.923-06:00	2	[13-sub|Q-Id]	[TCP ] ConnectionStatus: Remote host connection complete. (0 - OK)
2024-09-12T19:47:10.923-06:00	2	[13-sub|Q-Id]	[TCP |Receiv] Connected (0 - OK)
2024-09-12T19:47:11.036-06:00	0	[Connection: 13-sub]SSL|Tls error with code 280, Error verifying Server certificate: 800B0109 A certification chain processed correctly but terminated in a root certificate not trusted by the trust provider.
2024-09-12T19:47:11.036-06:00	0	[Connection: 13-sub]SSL|Tls error with code 280, Error verifying Server certificate: 800B0109 A certification chain processed correctly but terminated in a root certificate not trusted by the trust provider.
2024-09-12T19:47:11.036-06:00	2	[Connection: 13-sub]SSLServerAuthentication
2024-09-12T19:47:11.186-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT [object_id] FROM [sys].[change_tracking_tables] WHERE [object_id] = OBJECT_ID('dbo.App_History')] Success: (318 ms)
2024-09-12T19:47:11.263-06:00	2	[13-sub|Q-Id]	[TCP ] ConnectionStatus: Remote host disconnected. (0 - OK)
2024-09-12T19:47:11.263-06:00	2	[13-sub|Q-Id]	[TCP ] Disconnected (0 - OK)
2024-09-12T19:47:11.302-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE  SchemaName = @schema AND  TableName = @table]
2024-09-12T19:47:11.302-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: schema = dbo, table = App_History
2024-09-12T19:47:11.303-06:00	2	[13|Q-Id]	[META|Schema] Executing column schema query: [App_History]
2024-09-12T19:47:11.548-06:00	1	[13|Q-Id]	[META|Schema] Executed  column schema query: [App_History] Success: 4 results (245 ms)
2024-09-12T19:47:11.548-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE  SchemaName = @schema AND  TableName = @table] Success: (246 ms)
2024-09-12T19:47:11.580-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT [object_id] FROM [sys].[change_tracking_tables] WHERE [object_id] = OBJECT_ID('dbo.App_History')]
2024-09-12T19:47:11.626-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT [object_id] FROM [sys].[change_tracking_tables] WHERE [object_id] = OBJECT_ID('dbo.App_History')] Success: (46 ms)
2024-09-12T19:47:11.673-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT [min_valid_version] AS [MINIMUM_VERSION], CHANGE_TRACKING_CURRENT_VERSION() AS [CURRENT_VERSION] FROM [sys].[change_tracking_tables] WHERE [object_id] = @p1]
2024-09-12T19:47:11.673-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: p1 = 1623845743
2024-09-12T19:47:11.720-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT [min_valid_version] AS [MINIMUM_VERSION], CHANGE_TRACKING_CURRENT_VERSION() AS [CURRENT_VERSION] FROM [sys].[change_tracking_tables] WHERE [object_id] = @p1] Success: (47 ms)
2024-09-12T19:47:11.783-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table]
2024-09-12T19:47:11.783-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: schema = dbo, table = App_History
2024-09-12T19:47:11.845-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table] Success: (62 ms)
2024-09-12T19:47:11.861-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT [NAME], [VALUE] FROM [SYS_SQLINFO] WHERE [Name] = 'REPLICATION_TIMECHECK_COLUMNS']
2024-09-12T19:47:11.861-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT [NAME], [VALUE] FROM [SYS_SQLINFO] WHERE [Name] = 'REPLICATION_TIMECHECK_COLUMNS'] Success: (0 ms)
2024-09-12T19:47:11.876-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table]
2024-09-12T19:47:11.876-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: schema = dbo, table = App_History
2024-09-12T19:47:11.923-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table] Success: (47 ms)
2024-09-12T19:47:11.970-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE  SchemaName = @schema AND  TableName = @table]
2024-09-12T19:47:11.970-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: schema = dbo, table = App_History
2024-09-12T19:47:11.970-06:00	2	[13|Q-Id]	[META|Schema] Executing column schema query: [App_History]
2024-09-12T19:47:12.205-06:00	1	[13|Q-Id]	[META|Schema] Executed  column schema query: [App_History] Success: 4 results (235 ms)
2024-09-12T19:47:12.205-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE  SchemaName = @schema AND  TableName = @table] Success: (235 ms)
2024-09-12T19:47:12.220-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] ORDER BY [ID] ASC]
2024-09-12T19:47:12.251-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] ORDER BY [ID] ASC] Success: (31 ms)
2024-09-12T19:47:26.136-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table]
2024-09-12T19:47:26.136-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: schema = dbo, table = App_History
2024-09-12T19:47:26.183-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table] Success: (47 ms)
2024-09-12T19:47:26.183-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table]
2024-09-12T19:47:26.183-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: schema = dbo, table = App_History
2024-09-12T19:47:26.230-06:00	2	[13|Q-Id]	[EXEC|Messag] Executed query: [SELECT CatalogName, SchemaName, TableName, ColumnName, KeySeq, KeyName FROM sys_primarykeys WHERE  SchemaName = @schema AND  TableName = @table] Success: (47 ms)
2024-09-12T19:47:26.230-06:00	2	[13|Q-Id]	[EXEC|Parsed] Executing query: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]
2024-09-12T19:47:26.230-06:00	2	[13|Q-Id]	[EXEC|Parsed] Parameter: pk_b0 = be0bb408-7d18-401f-934d-0d949d27824a
2024-09-12T19:47:26.277-06:00	1	[13|Q-Id]	[SQL |Messag] Query Failed: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]. Error: The SQL Error Number is 102, State is 1, Severity is 15, Error is 'Incorrect syntax near 'd18'.', Server name is AWDAPPINDB3, Line number is 1.The Token Type is 170
2024-09-12T19:47:26.277-06:00	2	[13|Q-Id]	The SQL Error Number is 102, State is 1, Severity is 15, Error is 'Incorrect syntax near 'd18'.', Server name is AWDAPPINDB3, Line number is 1.The Token Type is 170
ruo230q.yt
   at ruo230q.vbk.V(Int32 , RkF`1 )
   at ruo230q.vUo.Ay()
   at ruo230q.vyy.ExecuteQuery(IDataStatement , QueryParameterCollection , Int32 )
   at ruo230q.Iv.ExecuteQuery(IDataStatement , QueryParameterCollection , Int32 )
   at ruo230q.RDq.ExecuteQuery(IDataStatement , QueryParameterCollection , Int32 )
   at ruo230q.RbZ.Ni()
   at ruo230q.RbS.Oe()
   at ruo230q.Ne.Wc(QueryParameterCollection )
2024-09-12T19:47:28.211-06:00	2	[13|Q-Id]	[TCP ] ConnectionStatus: Remote host disconnected. (0 - OK)
2024-09-12T19:47:28.211-06:00	2	[13|Q-Id]	[TCP ] Disconnected (0 - OK)
2024-09-12T19:47:28.212-06:00	1	[13|Q-Id]	[INFO|Connec] Closed SQL connection