2023-03-06 19:30:08 : SQL: SELECT id,name FROM Users
2023-03-06 19:30:08 : Login failed for user ''.:   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at lib.DbTable.get(Dictionary`2 cols, String where, String limit, String orderby, String ordertype) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 295
2023-03-06 19:30:50 : SQL: SELECT id,name FROM Users
2023-03-06 19:37:29 : SQL: SELECT id,name FROM Users
2023-03-06 19:38:48 : SQL: SELECT id,name FROM Users
2023-03-06 19:41:09 : SQL: SELECT id,name FROM Users
2023-03-06 19:41:40 : SQL: SELECT id,name FROM Users
2023-03-06 19:54:55 : SQL: SELECT id,name FROM Users
2023-03-06 21:56:51 : SQL: SELECT id,name FROM Users
2023-03-06 21:59:47 : SQL: SELECT id,name FROM Users
2023-03-06 22:00:35 : SQL: SELECT id,name FROM Users
2023-03-06 22:02:13 : SQL: SELECT id,name FROM Users
2023-03-06 22:02:36 : SQL: SELECT id,name FROM Users
2023-03-06 22:14:46 : SQL: SELECT id,name FROM Users
2023-03-06 22:16:54 : SQL: SELECT id,name FROM Users
2023-03-06 22:31:59 : SQL: SELECT id,name FROM Users
2023-03-06 22:33:06 : SQL: SELECT id,name FROM Users
2023-03-06 22:35:41 : SQL: SELECT id,name FROM Users
2023-03-06 22:37:08 : SQL: SELECT id,name FROM Users
2023-03-06 22:37:13 : SQL: SELECT id,name FROM Users
2023-03-06 22:37:15 : SQL: SELECT id,name FROM Users
2023-03-06 22:37:52 : SQL: SELECT id,name FROM Users
2023-03-06 22:37:58 : SQL: SELECT id,name FROM Users
2023-03-06 22:38:01 : SQL: SELECT id,name FROM Users
2023-03-06 22:38:05 : SQL: SELECT id,name FROM Users
2023-03-06 22:38:10 : SQL: SELECT id,name FROM Users
2023-03-06 22:41:34 : SQL: SELECT id,name FROM Users
2023-03-06 22:41:40 : SQL: SELECT id,name FROM Users
2023-03-06 23:53:20 : Application start.
2023-03-06 23:53:20 : SQL: SELECT id,name FROM Users
2023-03-06 23:54:25 : Application start.
2023-03-06 23:54:25 : SQL: SELECT id,name FROM Users
2023-03-06 23:56:03 : Application start.
2023-03-06 23:56:03 : SQL: SELECT id,name FROM Users
2023-03-06 23:59:03 : Application start.
2023-03-06 23:59:03 : SQL: SELECT id,name FROM Users
2023-03-06 23:59:48 : Application start.
2023-03-06 23:59:48 : SQL: SELECT id,name FROM Users
2023-03-07 00:00:34 : Application start.
2023-03-07 00:00:34 : SQL: SELECT id,name FROM Users
2023-03-07 00:01:40 : Application start.
2023-03-07 00:01:40 : SQL: SELECT id,name FROM Users
2023-03-07 00:02:40 : Application start.
2023-03-07 00:02:40 : SQL: SELECT id,name FROM Users
2023-03-07 08:49:24 : Application start.
2023-03-07 08:49:24 : SQL: SELECT id,name FROM Users
2023-03-07 10:24:28 : Application start.
2023-03-07 10:24:28 : SQL: SELECT id,name FROM Users
2023-03-07 10:27:22 : Application start.
2023-03-07 10:27:22 : SQL: SELECT id,name FROM Users
2023-03-07 10:29:37 : Application start.
2023-03-07 10:29:37 : SQL: SELECT id,name FROM Users
2023-03-07 10:34:28 : Application start.
2023-03-07 10:34:28 : SQL: SELECT id,name FROM Users
2023-03-07 10:36:27 : Application start.
2023-03-07 10:36:28 : SQL: SELECT id,name FROM Users
2023-03-07 10:38:27 : Application start.
2023-03-07 10:38:27 : SQL: SELECT id,name FROM Users
2023-03-07 10:42:55 : Application start.
2023-03-07 10:42:55 : SQL: SELECT id,name FROM Users
2023-03-07 10:43:58 : Application start.
2023-03-07 10:43:58 : SQL: SELECT id,name FROM Users
2023-03-07 10:44:42 : Application start.
2023-03-07 10:44:42 : SQL: SELECT id,name FROM Users
2023-03-07 11:00:01 : Application start.
2023-03-07 11:00:01 : SQL: SELECT id,name FROM Users
2023-03-07 11:03:50 : Application start.
2023-03-07 11:03:50 : SQL: SELECT id,name FROM Users
2023-03-07 11:06:50 : Application start.
2023-03-07 11:06:50 : SQL: SELECT id,name FROM Users
2023-03-07 11:07:38 : Application start.
2023-03-07 11:07:38 : SQL: SELECT id,name FROM Users
2023-03-07 11:10:19 : Application start.
2023-03-07 11:10:20 : SQL: SELECT id,name FROM Users
2023-03-07 11:10:40 : Application start.
2023-03-07 11:10:40 : SQL: SELECT id,name FROM Users
2023-03-07 11:12:38 : Application start.
2023-03-07 11:12:38 : SQL: SELECT id,name FROM Users
2023-03-07 11:14:03 : Application start.
2023-03-07 11:14:03 : SQL: SELECT id,name FROM Users
2023-03-07 11:24:51 : Application start.
2023-03-07 11:24:51 : SQL: SELECT id,name FROM Users
2023-03-07 11:35:23 : Application start.
2023-03-07 11:35:23 : SQL: SELECT id,name FROM Users
2023-03-07 11:36:38 : Application end.
2023-03-07 11:38:24 : Application start.
2023-03-07 11:38:24 : SQL: SELECT id,name FROM Users
2023-03-07 11:39:36 : Application start.
2023-03-07 11:39:36 : SQL: SELECT id,name FROM Users
2023-03-07 11:43:14 : Application start.
2023-03-07 11:43:15 : SQL: SELECT id,name FROM Users
2023-03-07 11:43:42 : Application end.
2023-03-07 11:43:53 : Application start.
2023-03-07 11:43:53 : SQL: SELECT id,name FROM Users
2023-03-07 11:44:00 : SQL: SELECT id,name FROM Users
2023-03-07 11:44:29 : Application end.
2023-03-07 11:48:38 : Application start.
2023-03-07 11:48:38 : SQL: SELECT id,name FROM Users
2023-03-07 11:48:44 : SQL: SELECT id,name FROM Users
2023-03-07 11:48:46 : SQL: SELECT id,name FROM Users
2023-03-07 11:48:49 : SQL: SELECT id,name FROM Users
2023-03-07 11:48:54 : SQL: SELECT id,name FROM Users
2023-03-07 11:48:56 : SQL: SELECT id,name FROM Users
2023-03-07 11:48:58 : SQL: SELECT id,name FROM Users
2023-03-07 11:49:25 : Application end.
2023-03-07 11:57:48 : Application start.
2023-03-07 11:57:48 : SQL: SELECT id,name FROM Users
2023-03-07 11:59:10 : Application end.
2023-03-07 11:59:44 : Application start.
2023-03-07 11:59:44 : SQL: SELECT id,name FROM Users
2023-03-07 12:01:11 : Application end.
2023-03-07 12:03:29 : Application start.
2023-03-07 12:03:29 : SQL: SELECT id,name FROM Users
2023-03-07 12:03:41 : Application end.
2023-03-07 12:05:34 : Application start.
2023-03-07 12:05:35 : SQL: SELECT id,name FROM Users
2023-03-07 12:05:41 : Application end.
2023-03-07 12:07:20 : Application start.
2023-03-07 12:07:20 : SQL: SELECT id,name FROM Users
2023-03-07 12:07:43 : Application end.
2023-03-07 13:54:51 : Application start.
2023-03-07 13:54:51 : SQL: SELECT id,name FROM Users
2023-03-07 13:58:06 : Application start.
2023-03-07 13:58:06 : SQL: SELECT id,name FROM Users
2023-03-07 14:01:47 : Application start.
2023-03-07 14:01:47 : SQL: SELECT id,name FROM Users
2023-03-07 14:01:48 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '123123'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:08:23 : Application start.
2023-03-07 14:08:23 : SQL: SELECT id,name FROM Users
2023-03-07 14:08:24 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '123123'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:18:59 : Application start.
2023-03-07 14:18:59 : SQL: SELECT id,name FROM Users
2023-03-07 14:19:00 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '123123'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:19:00 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '4235555'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:24:13 : Application start.
2023-03-07 14:24:13 : SQL: SELECT id,name FROM Users
2023-03-07 14:24:14 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '123123'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:24:14 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '4235555'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:24:41 : Application start.
2023-03-07 14:24:41 : SQL: SELECT id,name FROM Users
2023-03-07 14:24:43 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '123123'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:25:37 : Application start.
2023-03-07 14:25:37 : SQL: SELECT id,name FROM Users
2023-03-07 14:25:38 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '123123'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:25:38 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '4235555'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:25:49 : Application end.
2023-03-07 14:32:03 : Application start.
2023-03-07 14:32:03 : SQL: SELECT id,name FROM Users
2023-03-07 14:32:05 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '123123'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:32:05 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '4235555'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:33:03 : Application end.
2023-03-07 14:41:25 : Application start.
2023-03-07 14:41:25 : SQL: SELECT id,name FROM Users
2023-03-07 14:41:27 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '1632181119140540'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:41:27 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '4235555'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:42:12 : Application end.
2023-03-07 14:42:17 : Application start.
2023-03-07 14:42:17 : SQL: SELECT id,name FROM Users
2023-03-07 14:42:19 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '4235555'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:42:19 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '1632181119140540'
                  AND LeakTest_Code IS NOT NULL
                
2023-03-07 14:42:32 : Application end.
2023-03-07 15:14:21 : Application start.
2023-03-07 15:14:22 : SQL: SELECT id,name FROM Users
2023-03-07 15:15:05 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '1632181119140540'
                  AND LeakTest_Code IS NOT NULL
                  AND TRIM(LeakTest_Code) <> ''
                
2023-03-07 15:15:32 : SQL: 
                SELECT TOP 1 LeakTest_Code
                FROM tblTraceabilityData
                WHERE 1=1
                  AND Serial_No = '4235555'
                  AND LeakTest_Code IS NOT NULL
                  AND TRIM(LeakTest_Code) <> ''
                
2023-03-07 15:15:37 : Application end.
2023-03-07 20:49:22 : Application start.
2023-03-07 20:49:22 : SQL: SELECT id,name FROM Users
2023-03-07 20:51:07 : Application start.
2023-03-07 20:51:07 : SQL: SELECT id,name FROM Users
2023-03-07 20:51:09 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 20:51:09 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = ''
                )
                ORDER BY Process_No
                
2023-03-07 20:51:51 : Application end.
2023-03-07 20:57:10 : Application start.
2023-03-07 20:57:10 : SQL: SELECT id,name FROM Users
2023-03-07 20:58:02 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 20:58:55 : Application start.
2023-03-07 20:58:55 : SQL: SELECT id,name FROM Users
2023-03-07 20:58:56 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 20:58:56 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:02:48 : Application end.
2023-03-07 21:04:08 : Application start.
2023-03-07 21:04:08 : SQL: SELECT id,name FROM Users
2023-03-07 21:04:09 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:04:09 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:04:18 : List size -> 2
2023-03-07 21:04:24 : List size -> 2
2023-03-07 21:04:44 : Application end.
2023-03-07 21:05:36 : Application start.
2023-03-07 21:05:36 : SQL: SELECT id,name FROM Users
2023-03-07 21:05:38 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:05:38 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:05:44 : List size -> 2
2023-03-07 21:05:54 : Application end.
2023-03-07 21:07:09 : Application start.
2023-03-07 21:07:09 : SQL: SELECT id,name FROM Users
2023-03-07 21:07:11 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:07:11 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:07:16 : List size -> 2
2023-03-07 21:07:17 : List size -> 2
2023-03-07 21:07:18 : List size -> 2
2023-03-07 21:07:18 : List size -> 2
2023-03-07 21:07:19 : List size -> 2
2023-03-07 21:07:19 : List size -> 2
2023-03-07 21:07:21 : Application end.
2023-03-07 21:10:17 : Application start.
2023-03-07 21:10:17 : SQL: SELECT id,name FROM Users
2023-03-07 21:10:18 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:10:22 : List size -> 2
2023-03-07 21:10:22 : 2,R0011601320D06002A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:22 : 1,R0011601320E08003A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:37 : List size -> 2
2023-03-07 21:10:37 : 2,R0011601320D06002A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:37 : 1,R0011601320E08003A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:39 : List size -> 2
2023-03-07 21:10:39 : 2,R0011601320D06002A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:39 : 1,R0011601320E08003A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:40 : List size -> 2
2023-03-07 21:10:40 : 2,R0011601320D06002A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:40 : 1,R0011601320E08003A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:41 : List size -> 2
2023-03-07 21:10:41 : 2,R0011601320D06002A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:41 : 1,R0011601320E08003A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:42 : List size -> 2
2023-03-07 21:10:42 : 2,R0011601320D06002A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:42 : 1,R0011601320E08003A4807065002,2023-03-07 21:10:18
2023-03-07 21:10:48 : Application end.
2023-03-07 21:12:20 : Application start.
2023-03-07 21:12:20 : SQL: SELECT id,name FROM Users
2023-03-07 21:12:21 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:12:21 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:12:38 : Application end.
2023-03-07 21:26:51 : Application start.
2023-03-07 21:26:51 : SQL: SELECT id,name FROM Users
2023-03-07 21:26:53 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:26:53 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:28:15 : List size -> 2
2023-03-07 21:28:15 : 2,R0011601320D06002A4807065002,2023-03-07 21:26:53
2023-03-07 21:28:15 : 1,R0011601320E08003A4807065002,2023-03-07 21:26:53
2023-03-07 21:28:16 : List size -> 2
2023-03-07 21:28:16 : 2,R0011601320D06002A4807065002,2023-03-07 21:26:53
2023-03-07 21:28:16 : 1,R0011601320E08003A4807065002,2023-03-07 21:26:53
2023-03-07 21:28:17 : List size -> 2
2023-03-07 21:28:17 : 2,R0011601320D06002A4807065002,2023-03-07 21:26:53
2023-03-07 21:28:17 : 1,R0011601320E08003A4807065002,2023-03-07 21:26:53
2023-03-07 21:28:24 : Application end.
2023-03-07 21:29:36 : Application start.
2023-03-07 21:29:36 : SQL: SELECT id,name FROM Users
2023-03-07 21:29:37 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:29:37 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:30:05 : Application end.
2023-03-07 21:30:51 : Application start.
2023-03-07 21:30:51 : SQL: SELECT id,name FROM Users
2023-03-07 21:30:53 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:30:53 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:31:05 : Application end.
2023-03-07 21:31:34 : Application start.
2023-03-07 21:31:34 : SQL: SELECT id,name FROM Users
2023-03-07 21:31:36 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:31:36 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:31:52 : Application end.
2023-03-07 21:32:30 : Application start.
2023-03-07 21:32:30 : SQL: SELECT id,name FROM Users
2023-03-07 21:32:32 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:32:32 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:32:54 : Application end.
2023-03-07 21:34:21 : Application start.
2023-03-07 21:34:21 : SQL: SELECT id,name FROM Users
2023-03-07 21:34:22 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:34:22 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 21:34:38 : Application end.
2023-03-07 22:08:08 : Application start.
2023-03-07 22:08:08 : SQL: SELECT id,name FROM Users
2023-03-07 22:08:10 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 22:08:10 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-07 22:08:36 : Application end.
2023-03-08 08:24:08 : Application start.
2023-03-08 08:24:09 : SQL: SELECT id,name FROM Users
2023-03-08 08:24:10 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 08:24:10 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320D06002A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 08:24:20 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 08:25:03 : Application end.
2023-03-08 08:45:01 : Application start.
2023-03-08 08:45:01 : SQL: SELECT id,name FROM Users
2023-03-08 08:45:03 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 08:58:08 : Application start.
2023-03-08 08:58:09 : SQL: SELECT id,name FROM Users
2023-03-08 08:58:10 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 09:01:31 : Application start.
2023-03-08 09:01:31 : SQL: SELECT id,name FROM Users
2023-03-08 09:01:33 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 09:02:00 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601320E08003A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 09:03:40 : Application end.
2023-03-08 12:07:47 : Application start.
2023-03-08 12:07:47 : SQL: SELECT id,name FROM Users
2023-03-08 12:07:53 : Application end.
2023-03-08 12:08:19 : Application start.
2023-03-08 12:08:19 : SQL: SELECT id,name FROM Users
2023-03-08 12:10:55 : Application end.
2023-03-08 12:11:14 : Application start.
2023-03-08 12:11:14 : SQL: SELECT id,name FROM Users
2023-03-08 12:11:52 : Application end.
2023-03-08 12:13:31 : Application start.
2023-03-08 12:13:31 : SQL: SELECT id,name FROM Users
2023-03-08 12:13:52 : Application end.
2023-03-08 12:14:42 : Application start.
2023-03-08 12:14:42 : SQL: SELECT id,name FROM Users
2023-03-08 12:15:13 : Application end.
2023-03-08 12:17:55 : Application start.
2023-03-08 12:17:55 : SQL: SELECT id,name FROM Users
2023-03-08 12:18:26 : Application end.
2023-03-08 12:19:38 : Application start.
2023-03-08 12:19:38 : SQL: SELECT id,name FROM Users
2023-03-08 12:19:52 : Application end.
2023-03-08 12:19:56 : Application start.
2023-03-08 12:19:56 : SQL: SELECT id,name FROM Users
2023-03-08 12:22:23 : Application start.
2023-03-08 12:22:23 : SQL: SELECT id,name FROM Users
2023-03-08 12:24:33 : Application end.
2023-03-08 12:25:39 : Application start.
2023-03-08 12:25:39 : SQL: SELECT id,name FROM Users
2023-03-08 12:25:54 : Application end.
2023-03-08 12:27:14 : Application start.
2023-03-08 12:27:14 : SQL: SELECT id,name FROM Users
2023-03-08 12:30:42 : Application end.
2023-03-08 12:30:46 : Application start.
2023-03-08 12:30:46 : SQL: SELECT id,name FROM Users
2023-03-08 12:30:50 : Application end.
2023-03-08 12:31:52 : Application start.
2023-03-08 12:31:52 : SQL: SELECT id,name FROM Users
2023-03-08 12:33:12 : Application start.
2023-03-08 12:33:12 : SQL: SELECT id,name FROM Users
2023-03-08 12:34:34 : Application end.
2023-03-08 13:22:42 : Application start.
2023-03-08 13:22:42 : SQL: SELECT id,name FROM Users
2023-03-08 13:24:19 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:24:19 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:25:48 : Application start.
2023-03-08 13:25:48 : SQL: SELECT id,name FROM Users
2023-03-08 13:25:54 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:26:23 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:29:16 : Application start.
2023-03-08 13:29:16 : SQL: SELECT id,name FROM Users
2023-03-08 13:29:26 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:30:37 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011701322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:30:50 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011801322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:31:09 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:31:12 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:31:14 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:31:15 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:31:16 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:31:17 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 13:31:59 : Application end.
2023-03-08 13:32:04 : Application start.
2023-03-08 13:32:05 : SQL: SELECT id,name FROM Users
2023-03-08 13:32:25 : Application end.
2023-03-08 14:35:09 : Application start.
2023-03-08 14:35:09 : SQL: SELECT id,name FROM Users
2023-03-08 14:36:20 : Application start.
2023-03-08 14:36:20 : SQL: SELECT id,name FROM Users
2023-03-08 14:37:32 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 14:37:40 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601322H14249A4807065003'
                )
                ORDER BY Process_No
                
2023-03-08 14:38:13 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:38:13 : add new param[@Reader_No]
2023-03-08 14:38:13 : add new param[@Pallet_No]
2023-03-08 14:38:13 : add new param[@Packing_Time]
2023-03-08 14:38:13 : add new param[@Box_Index]
2023-03-08 14:38:13 : add new param[@Serial_No]
2023-03-08 14:38:13 : add new param[@LeakTest_Code]
2023-03-08 14:38:13 : add new param[@Packing_Worker_No]
2023-03-08 14:38:13 : Operand type clash: text is incompatible with int
Statement(s) could not be prepared.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 14:38:13 : SQL: UPDATE tblPackingData SET Serial_No='1633310722181405',LeakTest_Code='R0011601322H14249A4807065002',Packing_Worker_No='1' WHERE Reader_No=50 AND Pallet_No='B W20T460' AND Packing_Time='2023-03-08 14:37:33' AND Box_Index=1
2023-03-08 14:38:13 : executed return 0
2023-03-08 14:38:13 : Data insert failed => .
2023-03-08 14:43:01 : Application start.
2023-03-08 14:43:01 : SQL: SELECT id,name FROM Users
2023-03-08 14:43:08 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:43:08 : add new param[@Reader_No] => 50
2023-03-08 14:43:08 : add new param[@Pallet_No] => B W20T460
2023-03-08 14:43:08 : add new param[@Packing_Time] => 3/8/2023 2:37:33 PM
2023-03-08 14:43:08 : add new param[@Box_Index] => 1
2023-03-08 14:43:08 : add new param[@Serial_No] => 1633310722181405
2023-03-08 14:43:08 : add new param[@LeakTest_Code] => R0011601322H14249A4807065002
2023-03-08 14:43:08 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:43:08 : Operand type clash: text is incompatible with int
Statement(s) could not be prepared.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 14:43:08 : SQL: UPDATE tblPackingData SET Serial_No='1633310722181405',LeakTest_Code='R0011601322H14249A4807065002',Packing_Worker_No='1' WHERE Reader_No=50 AND Pallet_No='B W20T460' AND Packing_Time='2023-03-08 14:37:33' AND Box_Index=1
2023-03-08 14:43:08 : executed return 0
2023-03-08 14:43:08 : Data insert failed => .
2023-03-08 14:47:04 : Application start.
2023-03-08 14:47:04 : SQL: SELECT id,name FROM Users
2023-03-08 14:47:12 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:47:12 : add new param[@Reader_No] => 50
2023-03-08 14:47:12 : add new param[@Pallet_No] => B W20T460
2023-03-08 14:47:12 : add new param[@Packing_Time] => 3/8/2023 2:37:33 PM
2023-03-08 14:47:12 : add new param[@Box_Index] => 1
2023-03-08 14:47:12 : add new param[@Serial_No] => 1633310722181405
2023-03-08 14:47:12 : add new param[@LeakTest_Code] => R0011601322H14249A4807065002
2023-03-08 14:47:12 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:47:12 : executed return 1
2023-03-08 14:47:12 : Data inserted => .
2023-03-08 14:47:26 : Application end.
2023-03-08 14:49:32 : Application start.
2023-03-08 14:49:32 : SQL: SELECT id,name FROM Users
2023-03-08 14:49:47 : Application end.
2023-03-08 14:50:31 : Application start.
2023-03-08 14:50:31 : SQL: SELECT id,name FROM Users
2023-03-08 14:50:50 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:50:50 : add new param[@Reader_No] => 50
2023-03-08 14:50:50 : add new param[@Pallet_No] => B W20T460
2023-03-08 14:50:50 : add new param[@Packing_Time] => 3/8/2023 2:37:33 PM
2023-03-08 14:50:50 : add new param[@Box_Index] => 1
2023-03-08 14:50:50 : add new param[@Serial_No] => 1633310722181405
2023-03-08 14:50:50 : add new param[@LeakTest_Code] => R0011601322H14249A4807065002
2023-03-08 14:50:50 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:50:50 : Violation of PRIMARY KEY constraint 'PK_tblPackingData'. Cannot insert duplicate key in object 'dbo.tblPackingData'. The duplicate key value is (50, B W20T460, Mar  8 2023  2:37PM, 1).
The statement has been terminated.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 14:50:50 : SQL: UPDATE tblPackingData SET Serial_No='1633310722181405',LeakTest_Code='R0011601322H14249A4807065002',Packing_Worker_No='1' WHERE Reader_No=50 AND Pallet_No='B W20T460' AND Packing_Time='2023-03-08 14:37:33' AND Box_Index=1
2023-03-08 14:50:50 : executed return 1
2023-03-08 14:50:50 : Data updated => R0011601322H14249A4807065002.
2023-03-08 14:51:46 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04006B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 14:51:52 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04002A4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 14:51:58 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04008B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 14:52:03 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04015B4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 14:52:09 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04009B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 14:52:22 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04004B4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 14:52:29 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04018C4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 14:52:34 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001A4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 14:52:39 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 14:52:44 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:51:46 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 1
2023-03-08 14:53:03 : add new param[@Serial_No] => 1728291222180717
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04006B4807039001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04006B4807039001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:51:52 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 2
2023-03-08 14:53:03 : add new param[@Serial_No] => 1728291222225555
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04002A4807039001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04002A4807039001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:51:59 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 3
2023-03-08 14:53:03 : add new param[@Serial_No] => 1728291222165910
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04008B4807039001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04008B4807039001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:52:04 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 4
2023-03-08 14:53:03 : add new param[@Serial_No] => 1834020123074602
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04015B4807065001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04015B4807065001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:52:09 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 5
2023-03-08 14:53:03 : add new param[@Serial_No] => 1728291222231436
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04009B4807039001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04009B4807039001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:52:23 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 6
2023-03-08 14:53:03 : add new param[@Serial_No] => 1833020123145340
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04004B4807065001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04004B4807065001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:52:30 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 7
2023-03-08 14:53:03 : add new param[@Serial_No] => 1833010123040359
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04018C4807065001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04018C4807065001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:52:34 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 8
2023-03-08 14:53:03 : add new param[@Serial_No] => 1728291222044957
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04001A4807039001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04001A4807039001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:52:40 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 9
2023-03-08 14:53:03 : add new param[@Serial_No] => 1833010123023023
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04012A4807065001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04012A4807065001.
2023-03-08 14:53:03 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 14:53:03 : add new param[@Reader_No] => 50
2023-03-08 14:53:03 : add new param[@Pallet_No] => BW20C0015
2023-03-08 14:53:03 : add new param[@Packing_Time] => 3/8/2023 2:52:45 PM
2023-03-08 14:53:03 : add new param[@Box_Index] => 10
2023-03-08 14:53:03 : add new param[@Serial_No] => 1728291222060912
2023-03-08 14:53:03 : add new param[@LeakTest_Code] => R0011601323A04001B4807039001
2023-03-08 14:53:03 : add new param[@Packing_Worker_No] => 1
2023-03-08 14:53:03 : executed return 1
2023-03-08 14:53:03 : Data inserted => R0011601323A04001B4807039001.
2023-03-08 15:20:02 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04006B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 15:20:07 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:20:07 : add new param[@Reader_No] => 50
2023-03-08 15:20:07 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:20:07 : add new param[@Packing_Time] => 3/8/2023 3:20:03 PM
2023-03-08 15:20:07 : add new param[@Box_Index] => 1
2023-03-08 15:20:07 : add new param[@Serial_No] => 1728291222180717
2023-03-08 15:20:07 : add new param[@LeakTest_Code] => R0011601323A04006B4807039001
2023-03-08 15:20:07 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:20:07 : Conversion failed when converting the varchar value 'R0011601323A04006B4807039001' to data type int.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 15:20:07 : SQL: UPDATE tblPackingData SET Serial_No='1728291222180717',LeakTest_Code='R0011601323A04006B4807039001',Packing_Worker_No='1' WHERE Reader_No=50 AND Pallet_No='BW20C0015' AND Packing_Time='2023-03-08 15:20:03' AND Box_Index=1
2023-03-08 15:20:07 : executed return 0
2023-03-08 15:20:07 : Data insert failed => R0011601323A04006B4807039001.
2023-03-08 15:22:42 : Application end.
2023-03-08 15:35:20 : Application start.
2023-03-08 15:35:20 : SQL: SELECT id,name FROM Users
2023-03-08 15:35:21 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=50
2023-03-08 15:35:26 : Application end.
2023-03-08 15:35:40 : Application start.
2023-03-08 15:35:41 : SQL: SELECT id,name FROM Users
2023-03-08 15:35:42 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=50
2023-03-08 15:35:54 : Application end.
2023-03-08 15:36:26 : Application start.
2023-03-08 15:36:26 : SQL: SELECT id,name FROM Users
2023-03-08 15:36:27 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=51
2023-03-08 15:36:51 : Application end.
2023-03-08 15:37:13 : Application start.
2023-03-08 15:37:13 : SQL: SELECT id,name FROM Users
2023-03-08 15:37:14 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=51
2023-03-08 15:37:56 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 15:38:00 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:38:11 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001A4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 15:38:18 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04018C4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:38:37 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04018C4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:38:46 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:38:46 : add new param[@Reader_No] => 51
2023-03-08 15:38:46 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:38:46 : add new param[@Packing_Time] => 3/8/2023 3:37:56 PM
2023-03-08 15:38:46 : add new param[@Box_Index] => 1
2023-03-08 15:38:46 : add new param[@Serial_No] => 1728291222060912
2023-03-08 15:38:46 : add new param[@LeakTest_Code] => R0011601323A04001B4807039001
2023-03-08 15:38:46 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:38:47 : Conversion failed when converting the varchar value 'R0011601323A04001B4807039001' to data type int.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 15:38:47 : SQL: UPDATE tblPackingData SET Serial_No='1728291222060912',LeakTest_Code='R0011601323A04001B4807039001',Packing_Worker_No='1' WHERE Reader_No=51 AND Pallet_No='BW20C0015' AND Packing_Time='2023-03-08 15:37:56' AND Box_Index=1
2023-03-08 15:38:47 : executed return 0
2023-03-08 15:38:47 : Data insert failed => R0011601323A04001B4807039001.
2023-03-08 15:38:47 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:38:47 : add new param[@Reader_No] => 51
2023-03-08 15:38:47 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:38:47 : add new param[@Packing_Time] => 3/8/2023 3:38:01 PM
2023-03-08 15:38:47 : add new param[@Box_Index] => 2
2023-03-08 15:38:47 : add new param[@Serial_No] => 1833010123023023
2023-03-08 15:38:47 : add new param[@LeakTest_Code] => R0011601323A04012A4807065001
2023-03-08 15:38:47 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:38:47 : Conversion failed when converting the varchar value 'R0011601323A04012A4807065001' to data type int.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 15:38:47 : SQL: UPDATE tblPackingData SET Serial_No='1833010123023023',LeakTest_Code='R0011601323A04012A4807065001',Packing_Worker_No='1' WHERE Reader_No=51 AND Pallet_No='BW20C0015' AND Packing_Time='2023-03-08 15:38:01' AND Box_Index=2
2023-03-08 15:38:47 : executed return 0
2023-03-08 15:38:47 : Data insert failed => R0011601323A04012A4807065001.
2023-03-08 15:38:47 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:38:47 : add new param[@Reader_No] => 51
2023-03-08 15:38:47 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:38:47 : add new param[@Packing_Time] => 3/8/2023 3:38:12 PM
2023-03-08 15:38:47 : add new param[@Box_Index] => 3
2023-03-08 15:38:47 : add new param[@Serial_No] => 1728291222044957
2023-03-08 15:38:47 : add new param[@LeakTest_Code] => R0011601323A04001A4807039001
2023-03-08 15:38:47 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:38:47 : Conversion failed when converting the varchar value 'R0011601323A04001A4807039001' to data type int.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 15:38:47 : SQL: UPDATE tblPackingData SET Serial_No='1728291222044957',LeakTest_Code='R0011601323A04001A4807039001',Packing_Worker_No='1' WHERE Reader_No=51 AND Pallet_No='BW20C0015' AND Packing_Time='2023-03-08 15:38:12' AND Box_Index=3
2023-03-08 15:38:47 : executed return 0
2023-03-08 15:38:47 : Data insert failed => R0011601323A04001A4807039001.
2023-03-08 15:38:47 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:38:47 : add new param[@Reader_No] => 51
2023-03-08 15:38:47 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:38:47 : add new param[@Packing_Time] => 3/8/2023 3:38:37 PM
2023-03-08 15:38:47 : add new param[@Box_Index] => 4
2023-03-08 15:38:47 : add new param[@Serial_No] => 1833010123040359
2023-03-08 15:38:47 : add new param[@LeakTest_Code] => R0011601323A04018C4807065001
2023-03-08 15:38:47 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:38:47 : Conversion failed when converting the varchar value 'R0011601323A04018C4807065001' to data type int.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 15:38:47 : SQL: UPDATE tblPackingData SET Serial_No='1833010123040359',LeakTest_Code='R0011601323A04018C4807065001',Packing_Worker_No='1' WHERE Reader_No=51 AND Pallet_No='BW20C0015' AND Packing_Time='2023-03-08 15:38:37' AND Box_Index=4
2023-03-08 15:38:47 : executed return 0
2023-03-08 15:38:47 : Data insert failed => R0011601323A04018C4807065001.
2023-03-08 15:41:43 : Application end.
2023-03-08 15:42:12 : Application start.
2023-03-08 15:42:12 : SQL: SELECT id,name FROM Users
2023-03-08 15:42:13 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=50
2023-03-08 15:42:31 : Application end.
2023-03-08 15:46:08 : Application start.
2023-03-08 15:46:08 : SQL: SELECT id,name FROM Users
2023-03-08 15:46:09 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=51
2023-03-08 15:46:42 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 15:46:47 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:46:47 : add new param[@Reader_No] => 51
2023-03-08 15:47:47 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:47:59 : add new param[@Packing_Time] => 3/8/2023 3:46:42 PM
2023-03-08 15:48:03 : add new param[@Box_Index] => 1
2023-03-08 15:48:07 : add new param[@Serial_No] => 1728291222060912
2023-03-08 15:48:11 : add new param[@LeakTest_Code] => R0011601323A04001B4807039001
2023-03-08 15:48:15 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:48:29 : Conversion failed when converting the varchar value 'R0011601323A04001B4807039001' to data type int.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at lib.DbTable.add(Dictionary`2 cols, Boolean returnId) in C:\Users\User\Documents\TomasTC\dev\Windows\ATA-TRC\Packing\Packing\lib\DbTable.cs:line 197
2023-03-08 15:48:29 : SQL: UPDATE tblPackingData SET Serial_No='1728291222060912',LeakTest_Code='R0011601323A04001B4807039001',Packing_Worker_No='1' WHERE Reader_No=51 AND Pallet_No='BW20C0015' AND Packing_Time='2023-03-08 15:46:42' AND Box_Index=1
2023-03-08 15:48:29 : executed return 0
2023-03-08 15:48:29 : Data insert failed => R0011601323A04001B4807039001.
2023-03-08 15:54:48 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 15:54:58 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:55:01 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001A4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 15:55:05 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04018C4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:55:22 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:55:22 : add new param[@Reader_No] => 51
2023-03-08 15:55:30 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:55:30 : add new param[@Packing_Time] => 3/8/2023 3:54:48 PM
2023-03-08 15:55:30 : add new param[@Box_Index] => 1
2023-03-08 15:55:30 : add new param[@Serial_No] => 1728291222060912
2023-03-08 15:55:30 : add new param[@LeakTest_Code] => R0011601323A04001B4807039001
2023-03-08 15:55:30 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:55:30 : executed return 1
2023-03-08 15:55:30 : Data inserted => R0011601323A04001B4807039001.
2023-03-08 15:55:30 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:55:30 : add new param[@Reader_No] => 51
2023-03-08 15:55:30 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:55:30 : add new param[@Packing_Time] => 3/8/2023 3:54:58 PM
2023-03-08 15:55:30 : add new param[@Box_Index] => 2
2023-03-08 15:55:30 : add new param[@Serial_No] => 1833010123023023
2023-03-08 15:55:30 : add new param[@LeakTest_Code] => R0011601323A04012A4807065001
2023-03-08 15:55:30 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:55:30 : executed return 1
2023-03-08 15:55:30 : Data inserted => R0011601323A04012A4807065001.
2023-03-08 15:55:30 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:55:30 : add new param[@Reader_No] => 51
2023-03-08 15:55:30 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:55:30 : add new param[@Packing_Time] => 3/8/2023 3:55:02 PM
2023-03-08 15:55:30 : add new param[@Box_Index] => 3
2023-03-08 15:55:30 : add new param[@Serial_No] => 1728291222044957
2023-03-08 15:55:30 : add new param[@LeakTest_Code] => R0011601323A04001A4807039001
2023-03-08 15:55:30 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:55:30 : executed return 1
2023-03-08 15:55:30 : Data inserted => R0011601323A04001A4807039001.
2023-03-08 15:55:30 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:55:30 : add new param[@Reader_No] => 51
2023-03-08 15:55:30 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:55:30 : add new param[@Packing_Time] => 3/8/2023 3:55:06 PM
2023-03-08 15:55:30 : add new param[@Box_Index] => 4
2023-03-08 15:55:30 : add new param[@Serial_No] => 1833010123040359
2023-03-08 15:55:30 : add new param[@LeakTest_Code] => R0011601323A04018C4807065001
2023-03-08 15:55:30 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:55:30 : executed return 1
2023-03-08 15:55:30 : Data inserted => R0011601323A04018C4807065001.
2023-03-08 15:56:41 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04018C4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:56:43 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04018C4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:56:52 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:56:52 : add new param[@Reader_No] => 51
2023-03-08 15:56:52 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:56:52 : add new param[@Packing_Time] => 3/8/2023 3:56:42 PM
2023-03-08 15:56:52 : add new param[@Box_Index] => 1
2023-03-08 15:56:52 : add new param[@Serial_No] => 1833010123040359
2023-03-08 15:56:52 : add new param[@LeakTest_Code] => R0011601323A04018C4807065001
2023-03-08 15:56:52 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:56:52 : executed return 1
2023-03-08 15:56:52 : Data inserted => R0011601323A04018C4807065001.
2023-03-08 15:56:52 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:56:52 : add new param[@Reader_No] => 51
2023-03-08 15:56:52 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:56:52 : add new param[@Packing_Time] => 3/8/2023 3:56:44 PM
2023-03-08 15:56:52 : add new param[@Box_Index] => 2
2023-03-08 15:56:52 : add new param[@Serial_No] => 1833010123040359
2023-03-08 15:56:52 : add new param[@LeakTest_Code] => R0011601323A04018C4807065001
2023-03-08 15:56:52 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:56:52 : executed return 1
2023-03-08 15:56:52 : Data inserted => R0011601323A04018C4807065001.
2023-03-08 15:58:15 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:58:18 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:58:20 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 15:58:26 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:58:26 : add new param[@Reader_No] => 51
2023-03-08 15:58:26 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:58:26 : add new param[@Packing_Time] => 3/8/2023 3:58:16 PM
2023-03-08 15:58:26 : add new param[@Box_Index] => 1
2023-03-08 15:58:26 : add new param[@Serial_No] => 1833010123023023
2023-03-08 15:58:26 : add new param[@LeakTest_Code] => R0011601323A04012A4807065001
2023-03-08 15:58:26 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:58:26 : executed return 1
2023-03-08 15:58:26 : Data inserted => R0011601323A04012A4807065001.
2023-03-08 15:58:26 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:58:26 : add new param[@Reader_No] => 51
2023-03-08 15:58:26 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:58:26 : add new param[@Packing_Time] => 3/8/2023 3:58:19 PM
2023-03-08 15:58:26 : add new param[@Box_Index] => 2
2023-03-08 15:58:26 : add new param[@Serial_No] => 1833010123023023
2023-03-08 15:58:26 : add new param[@LeakTest_Code] => R0011601323A04012A4807065001
2023-03-08 15:58:26 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:58:26 : executed return 1
2023-03-08 15:58:26 : Data inserted => R0011601323A04012A4807065001.
2023-03-08 15:58:26 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 15:58:26 : add new param[@Reader_No] => 51
2023-03-08 15:58:26 : add new param[@Pallet_No] => BW20C0015
2023-03-08 15:58:26 : add new param[@Packing_Time] => 3/8/2023 3:58:21 PM
2023-03-08 15:58:26 : add new param[@Box_Index] => 3
2023-03-08 15:58:26 : add new param[@Serial_No] => 1833010123023023
2023-03-08 15:58:26 : add new param[@LeakTest_Code] => R0011601323A04012A4807065001
2023-03-08 15:58:26 : add new param[@Packing_Worker_No] => 1
2023-03-08 15:58:26 : executed return 1
2023-03-08 15:58:26 : Data inserted => R0011601323A04012A4807065001.
2023-03-08 15:58:52 : Application end.
2023-03-08 16:05:53 : Application start.
2023-03-08 16:05:53 : SQL: SELECT id,name FROM Users
2023-03-08 16:05:54 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=51
2023-03-08 16:06:08 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 16:06:16 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04012A4807065002'
                )
                ORDER BY Process_No
                
2023-03-08 16:06:32 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04001B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 16:06:49 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04015B4807065001'
                )
                ORDER BY Process_No
                
2023-03-08 16:06:55 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04008B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 16:07:07 : Application end.
2023-03-08 16:07:11 : Application start.
2023-03-08 16:07:11 : SQL: SELECT id,name FROM Users
2023-03-08 16:07:12 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=51
2023-03-08 16:07:16 : Application end.
2023-03-08 16:07:21 : Application start.
2023-03-08 16:07:21 : SQL: SELECT id,name FROM Users
2023-03-08 16:07:22 : SQL: SELECT Packing_Pcs FROM tblReaderMst WHERE Reader_No=51
2023-03-08 16:07:24 : SQL: SELECT id,name FROM Users
2023-03-08 16:07:31 : SQL: 
                SELECT Serial_No, Process_No FROM tblTraceabilityData
                WHERE Serial_No IN (
                 SELECT top 1 Serial_No
                   FROM tblTraceabilityData
                  WHERE 1=1
                    AND LeakTest_Code = 'R0011601323A04008B4807039001'
                )
                ORDER BY Process_No
                
2023-03-08 16:07:35 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 16:07:35 : add new param[@Reader_No] => 51
2023-03-08 16:07:35 : add new param[@Pallet_No] => BW20C0015
2023-03-08 16:07:35 : add new param[@Packing_Time] => 3/8/2023 4:06:09 PM
2023-03-08 16:07:35 : add new param[@Box_Index] => 1
2023-03-08 16:07:35 : add new param[@Serial_No] => 1833010123023023
2023-03-08 16:07:35 : add new param[@LeakTest_Code] => R0011601323A04012A4807065001
2023-03-08 16:07:35 : add new param[@Packing_Worker_No] => 10
2023-03-08 16:07:35 : executed return 1
2023-03-08 16:07:35 : Data inserted => R0011601323A04012A4807065001.
2023-03-08 16:07:35 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 16:07:35 : add new param[@Reader_No] => 51
2023-03-08 16:07:35 : add new param[@Pallet_No] => BW20C0015
2023-03-08 16:07:35 : add new param[@Packing_Time] => 3/8/2023 4:06:32 PM
2023-03-08 16:07:35 : add new param[@Box_Index] => 2
2023-03-08 16:07:35 : add new param[@Serial_No] => 1728291222060912
2023-03-08 16:07:35 : add new param[@LeakTest_Code] => R0011601323A04001B4807039001
2023-03-08 16:07:35 : add new param[@Packing_Worker_No] => 10
2023-03-08 16:07:35 : executed return 1
2023-03-08 16:07:35 : Data inserted => R0011601323A04001B4807039001.
2023-03-08 16:07:35 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 16:07:35 : add new param[@Reader_No] => 51
2023-03-08 16:07:35 : add new param[@Pallet_No] => BW20C0015
2023-03-08 16:07:35 : add new param[@Packing_Time] => 3/8/2023 4:06:50 PM
2023-03-08 16:07:35 : add new param[@Box_Index] => 3
2023-03-08 16:07:35 : add new param[@Serial_No] => 1834020123074602
2023-03-08 16:07:35 : add new param[@LeakTest_Code] => R0011601323A04015B4807065001
2023-03-08 16:07:35 : add new param[@Packing_Worker_No] => 10
2023-03-08 16:07:35 : executed return 1
2023-03-08 16:07:35 : Data inserted => R0011601323A04015B4807065001.
2023-03-08 16:07:35 : SQL: INSERT INTO tblPackingData
                    (Reader_No,Pallet_No,Packing_Time,Box_Index,Serial_No,LeakTest_Code,Packing_Worker_No) VALUES (@Reader_No,@Pallet_No,@Packing_Time,@Box_Index,@Serial_No,@LeakTest_Code,@Packing_Worker_No); 
                    
2023-03-08 16:07:35 : add new param[@Reader_No] => 51
2023-03-08 16:07:35 : add new param[@Pallet_No] => BW20C0015
2023-03-08 16:07:35 : add new param[@Packing_Time] => 3/8/2023 4:07:31 PM
2023-03-08 16:07:35 : add new param[@Box_Index] => 4
2023-03-08 16:07:35 : add new param[@Serial_No] => 1728291222165910
2023-03-08 16:07:35 : add new param[@LeakTest_Code] => R0011601323A04008B4807039001
2023-03-08 16:07:35 : add new param[@Packing_Worker_No] => 10
2023-03-08 16:07:35 : executed return 1
2023-03-08 16:07:35 : Data inserted => R0011601323A04008B4807039001.
2023-03-08 16:12:45 : Application start.
2023-03-08 16:12:45 : SQL: SELECT id,name FROM Users
2023-03-08 16:13:37 : Application start.
2023-03-08 16:13:37 : SQL: SELECT id,name FROM Users
