Logdatei > Application

# Logger SOID Control Event Funktion Zielcontrol Parameter/Text Level Zeit Exception
1 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='Company.Total_Error(1920x1080)'"
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:14.7321
2 Sql GetResultSet "SELECT * FROM Headers INNER JOIN ItemLines ON H_VTID=I_VTID AND H_ID=I_HID WHERE (H_VTID=200 AND I_Date IS NOT NULL AND (I_NUM3 IS NOT NULL AND I_NUM3 !=0 AND I_NUM3 !=Round(I_NUM1 * I_NUM2 - (ISNULL(I_NUM5, 0) * I_NUM1 * I_NUM2 / 100), 2) AND I_NUM3 !=Round(I_NUM1 * I_NUM2 - (ISNULL(I_NUM5, 0) * I_NUM1 * I_NUM2 / 100), 4))) AND (H_Int1 IS NULL OR H_INT1 != -1) ORDER BY 1, 2, 3 OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY"
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:14.5780
3 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='Company.Total_Only(1920x1080)'"
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:14.5430
4 Sql GetResultSet "SELECT * FROM Headers INNER JOIN ItemLines ON H_VTID=I_VTID AND H_ID=I_HID WHERE (I_VTID=200 AND I_Date IS NOT NULL AND ((I_NUM1 IS NOT NULL AND I_NUM1 !=0 AND I_NUM2 IS NOT NULL AND I_NUM2 !=0 AND (I_NUM3 IS NULL OR I_NUM3=0)) OR ((I_NUM1 IS NULL OR I_NUM1=0 OR I_NUM2 IS NULL OR I_NUM2=0) AND I_NUM3 IS NOT NULL AND I_NUM3 !=0))) AND (H_Int1 IS NULL OR H_INT1 != -1) ORDER BY 1, 2, 3 OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY"
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:14.3920
5 Sql Execute Exception String or binary data would be truncated.
The statement has been terminated.
Trace 13:00:14.3720
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
bei 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)
bei 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)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei Brixxbox.Data.DataAccess.SQL_Execute(Int32 SQLID, String SQLCmd, Boolean FuncCheck)
ClientConnectionId:7054fead-391a-4cd8-8361-3a7882c0f240
Fehlernummer (Error Number):8152,Status (State):4,Klasse (Class):16
6 Sql Execute "INSERT INTO Errors(Err_Level, Err_User, Err_Class, Err_Func, Err_Info, Err_ExText) VALUES (0, 'ULTRABOOK - admbb', 'DataAccess', 'GetResultSet', '0 = SELECT ITEMLINES.I_CID, ITEMLINES.I_VTID, ITEMLINES.I_HID, ITEMLINES.I_ID, ITEMLINES.I_LNG2 AS ITEM_ID, ITEM.B_KEY AS ITEM_KEY, ITEM.B_TXT1 AS DESCRIPTION, ITEMLINES.I_NUM1 AS QUANTITY_OU, (SELECT SUM(IMP_QUANTITY_AU) AS SQLVALUE FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID) AS ACTUAL_QTY_OU, ITEMLINES.I_INT1 AS ORDER_UNIT, ITEMLINES.I_NUM3 AS FACTOR_OU, ITEMLINES.I_NUM6 AS QUANTITY_BU, (SELECT SUM(IMP_QUANTITY_BU) AS SQLVALUE FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID) AS ACTUAL_QTY_BU, ITEMLINES.I_INT3 AS BASE_UNIT, ITEMLINES.I_NUM17 AS PRICE_BU, ITEMLINES.I_NUM2 AS PRICE_OU, ITEMLINES.I_NUM8 AS TAXKEY, ITEMLINES.I_NUM9 AS DISCOUNT_RATE, ITEMLINES.I_NUM7 AS TOTAL_VALUE, (CASE WHEN ISDATE(ITEMLINES.I_LNG6) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG6,112)) END) AS USE_BY_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG5) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG5,112)) END) AS SELL_BY_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG4) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG4,112)) END) AS PRODUCTION_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG1) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG1,112)) END) AS DELIVERY_DATE, ITEMLINES.I_LNG7 AS BATCH_, ITEMLINES.I_INT4 AS STATUS, ITEMLINES.I_TXT1 AS TEXT, ITEMLINES.I_INT5 AS SPECIAL_ORDER, ITEMLINES.I_TXT2 AS CUT, ITEMLINES.I_TXT3 AS SIZE, ITEMLINES.I_TXT4 AS CUSTOMER, ITEMLINES.I_TXT5 AS PHONE, ITEMLINES.I_LNG9 AS SPECIAL_OFFER, ITEMLINES.I_LNG8 AS PROD_ORDER FROM ITEMLINES LEFT JOIN BASES AS ITEM ON ITEM.B_VTID=3 AND ITEM.B_ID = ITEMLINES.I_LNG2 WHERE (I_VTID=200 AND I_Date IS NOT NULL AND I_NUM1 IS NOT NULL AND I_NUM2 IS NOT NULL AND I_NUM4 IS NULL) AND ITEMLINES.I_VTID=@VTID AND (ITEMLINES.I_CID=@CID OR ITEMLINES.I_CID=0) ORDER BY ITEMLINES.I_ID OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY', 'Info: Class: DataAccess; Func: GetResultSet

Error Text : 0 = SELECT ITEMLINES.I_CID, ITEMLINES.I_VTID, ITEMLINES.I_HID, ITEMLINES.I_ID, ITEMLINES.I_LNG2 AS ITEM_ID, ITEM.B_KEY AS ITEM_KEY, ITEM.B_TXT1 AS DESCRIPTION, ITEMLINES.I_NUM1 AS QUANTITY_OU, (SELECT SUM(IMP_QUANTITY_AU) AS SQLVALUE FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID) AS ACTUAL_QTY_OU, ITEMLINES.I_INT1 AS ORDER_UNIT, ITEMLINES.I_NUM3 AS FACTOR_OU, ITEMLINES.I_NUM6 AS QUANTITY_BU, (SELECT SUM(IMP_QUANTITY_BU) AS SQLVALUE FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID) AS ACTUAL_QTY_BU, ITEMLINES.I_INT3 AS BASE_UNIT, ITEMLINES.I_NUM17 AS PRICE_BU, ITEMLINES.I_NUM2 AS PRICE_OU, ITEMLINES.I_NUM8 AS TAXKEY, ITEMLINES.I_NUM9 AS DISCOUNT_RATE, ITEMLINES.I_NUM7 AS TOTAL_VALUE, (CASE WHEN ISDATE(ITEMLINES.I_LNG6) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG6,112)) END) AS USE_BY_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG5) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG5,112)) END) AS SELL_BY_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG4) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG4,112)) END) AS PRODUCTION_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG1) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG1,112)) END) AS DELIVERY_DATE, ITEMLINES.I_LNG7 AS BATCH_, ITEMLINES.I_INT4 AS STATUS, ITEMLINES.I_TXT1 AS TEXT, ITEMLINES.I_INT5 AS SPECIAL_ORDER, ITEMLINES.I_TXT2 AS CUT, ITEMLINES.I_TXT3 AS SIZE, ITEMLINES.I_TXT4 AS CUSTOMER, ITEMLINES.I_TXT5 AS PHONE, ITEMLINES.I_LNG9 AS SPECIAL_OFFER, ITEMLINES.I_LNG8 AS PROD_ORDER FROM ITEMLINES LEFT JOIN BASES AS ITEM ON ITEM.B_VTID=3 AND ITEM.B_ID = ITEMLINES.I_LNG2 WHERE (I_VTID=200 AND I_Date IS NOT NULL AND I_NUM1 IS NOT NULL AND I_NUM2 IS NOT NULL AND I_NUM4 IS NULL) AND ITEMLINES.I_VTID=@VTID AND (ITEMLINES.I_CID=@CID OR ITEMLINES.I_CID=0) ORDER BY ITEMLINES.I_ID OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY
Must declare the scalar variable "@SQLCRIT1".
Must declare the scalar variable "@SQLCRIT1".
Invalid usage of the option NEXT in the FETCH statement.'); "
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:14.2610
7 Sql GetResultSet Exception Must declare the scalar variable "@SQLCRIT1".
Must declare the scalar variable "@SQLCRIT1".
Invalid usage of the option NEXT in the FETCH statement.
Trace 13:00:14.2410
System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@SQLCRIT1".
Must declare the scalar variable "@SQLCRIT1".
Invalid usage of the option NEXT in the FETCH statement.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
bei System.Data.SqlClient.SqlDataReader.get_MetaData()
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
bei 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)
bei 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)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
bei System.Data.Common.DbDataAdapter.Fill(Int32 startRecord, Int32 maxRecords, DataTable[] dataTables)
bei Brixxbox.Data.DataAccess.GetResultSet(Int32 SQLID, String F_SQLCmd, Int32 RecordCount)
ClientConnectionId:7054fead-391a-4cd8-8361-3a7882c0f240
Fehlernummer (Error Number):137,Status (State):2,Klasse (Class):15
8 Sql GetResultSet "SELECT ITEMLINES.I_CID, ITEMLINES.I_VTID, ITEMLINES.I_HID, ITEMLINES.I_ID, ITEMLINES.I_LNG2 AS ITEM_ID, ITEM.B_KEY AS ITEM_KEY, ITEM.B_TXT1 AS DESCRIPTION, ITEMLINES.I_NUM1 AS QUANTITY_OU, (SELECT SUM(IMP_QUANTITY_AU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID) AS ACTUAL_QTY_OU, ITEMLINES.I_INT1 AS ORDER_UNIT, ITEMLINES.I_NUM3 AS FACTOR_OU, ITEMLINES.I_NUM6 AS QUANTITY_BU, (SELECT SUM(IMP_QUANTITY_BU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID) AS ACTUAL_QTY_BU, ITEMLINES.I_INT3 AS BASE_UNIT, ITEMLINES.I_NUM17 AS PRICE_BU, ITEMLINES.I_NUM2 AS PRICE_OU, ITEMLINES.I_NUM8 AS TAXKEY, ITEMLINES.I_NUM9 AS DISCOUNT_RATE, ITEMLINES.I_NUM7 AS TOTAL_VALUE, (CASE WHEN ISDATE(ITEMLINES.I_LNG6) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG6,112)) END) AS USE_BY_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG5) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG5,112)) END) AS SELL_BY_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG4) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG4,112)) END) AS PRODUCTION_DATE, (CASE WHEN ISDATE(ITEMLINES.I_LNG1) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), ITEMLINES.I_LNG1,112)) END) AS DELIVERY_DATE, ITEMLINES.I_LNG7 AS BATCH_, ITEMLINES.I_INT4 AS STATUS, ITEMLINES.I_TXT1 AS TEXT, ITEMLINES.I_INT5 AS SPECIAL_ORDER, ITEMLINES.I_TXT2 AS CUT, ITEMLINES.I_TXT3 AS SIZE, ITEMLINES.I_TXT4 AS CUSTOMER, ITEMLINES.I_TXT5 AS PHONE, ITEMLINES.I_LNG9 AS SPECIAL_OFFER, ITEMLINES.I_LNG8 AS PROD_ORDER FROM ITEMLINES LEFT JOIN BASES AS ITEM ON ITEM.B_VTID=3 AND ITEM.B_ID = ITEMLINES.I_LNG2 WHERE (I_VTID=200 AND I_Date IS NOT NULL AND I_NUM1 IS NOT NULL AND I_NUM2 IS NOT NULL AND I_NUM4 IS NULL) AND ITEMLINES.I_VTID=@VTID AND (ITEMLINES.I_CID=@CID OR ITEMLINES.I_CID=0) ORDER BY ITEMLINES.I_ID OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY"
"'@VTID'='200'", "'@CID'='1'", "'@SOID'='SOItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 13:00:14.1890
9 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_TXT2 FROM BASES WHERE B_VTID=@VTID AND (@MID IS NULL OR B_MID=@MID) AND (@RECID IS NULL OR B_ID=@RECID) AND (@STRKEY IS NULL OR B_KEY=@STRKEY)"
"'@VTID'='16'", "'@STRKEY'=''", "'@RECID'='5'", "'@MID'=''", "'@USER'='0'", "'@CID'='1'"
Trace 13:00:11.3829
10 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_TXT2, B_TXT3, B_TXT4, B_TXT5, B_TXT6, B_TXT7, B_LNG2, B_TXT8, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=1) AS 'BR_TXT1', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=2) AS 'BR_TXT2', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=3) AS 'BR_TXT3', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=4) AS 'BR_TXT4', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=5) AS 'BR_TXT5', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=6) AS 'BR_TXT6' FROM BASES WHERE B_VTID=@VTID AND (@MID IS NULL OR B_MID=@MID) AND (@RECID IS NULL OR B_ID=@RECID) AND (@STRKEY IS NULL OR B_KEY=@STRKEY) AND (B_CID=@CID OR B_CID=0)"
"'@VTID'='1'", "'@RECID'='1'", "'@CID'='1'", "'@MID'=''", "'@STRKEY'=''", "'@SOID'='Company'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 13:00:10.6108
11 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='Company(1920x1059)'"
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:10.5748
12 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='CompanyList.ListGrid(1920x1080)'"
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:08.2987
13 Sql GetResultSet "SELECT BASES.B_CID, BASES.B_VTID, BASES.B_ID, BASES.B_ID AS COMPANY_ID, BASES.B_KEY AS KEY_, BASES.B_TXT1 AS TITLE, BASES.B_TXT2 AS NAME, BASES.B_TXT3 AS STREET, BASES.B_TXT4 AS ZIP_CITY, BASES.B_TXT5 AS TAX_CITY, BASES.B_TXT6 AS TAX_NO, BASES.B_TXT7 AS EU_TAX_NO, BASES.B_LNG2 AS ILN, BASES.B_TXT8 AS CURRENCY_ID, CURRENCY.B_KEY AS CURRENCY, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=BASES.B_VTID AND BR_RECID=BASES.B_ID AND BR_ID=1) AS PHONE, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=BASES.B_VTID AND BR_RECID=BASES.B_ID AND BR_ID=2) AS FAX, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=BASES.B_VTID AND BR_RECID=BASES.B_ID AND BR_ID=3) AS MOBILE, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=BASES.B_VTID AND BR_RECID=BASES.B_ID AND BR_ID=4) AS EMAIL, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=BASES.B_VTID AND BR_RECID=BASES.B_ID AND BR_ID=5) AS WEB, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=BASES.B_VTID AND BR_RECID=BASES.B_ID AND BR_ID=6) AS DODAAC FROM BASES LEFT JOIN BASES AS CURRENCY ON CURRENCY.B_VTID=16 AND CURRENCY.B_ID = BASES.B_TXT8 WHERE BASES.B_VTID=@VTID AND (BASES.B_CID=@CID OR BASES.B_CID=0) ORDER BY BASES.B_KEY OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY"
"'@VTID'='1'", "'@CID'='1'", "'@SOID'='Company'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 13:00:08.2087
14 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='CompanyList(1920x1059)'"
"'@USER'='0'", "'@CID'='1'"
Trace 13:00:08.1347
15 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_BU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1078'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:54.2284
16 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_BU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1078'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:54.1814
17 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_AU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1078'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:54.1354
18 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_AU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1078'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:54.0964
19 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_AU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1078'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:54.0354
20 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_TXT2, B_TXT3, B_INT1, B_INT2, B_INT4, B_INT3, B_INT5, B_INT7, B_INT9, B_INT8, B_NUM7, B_INT13, B_LNG8, B_INT11, B_INT6, B_INT10, B_NUM1, B_NUM2, B_NUM6, B_LNG3, B_LNG7, B_LNG6, B_INT12, B_NUM3, B_NUM4, B_NUM5, B_TXT4, B_LNG1, B_LNG2, B_TXT5, B_TXT6, B_LNG4, B_LNG5 FROM BASES WHERE B_VTID=@VTID AND (@MID IS NULL OR B_MID=@MID) AND (@RECID IS NULL OR B_ID=@RECID) AND (@STRKEY IS NULL OR B_KEY=@STRKEY)"
"'@VTID'='3'", "'@STRKEY'=''", "'@RECID'='1078'", "'@MID'=''", "'@USER'='0'", "'@CID'='1'"
Trace 12:58:53.9944
21 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_BU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1699'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:53.8714
22 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_BU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1699'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:53.8244
23 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_AU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1699'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:53.7834
24 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_AU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1699'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:53.7134
25 Sql GetResultSet "SELECT SUM(IMP_QUANTITY_AU) AS 'SQLVALUE' FROM IMPOSTING JOIN INVENTORY ON IMP_INVENTORY_ID = INV_B_ID WHERE IMP_ITEM_ID = @SQLCRIT1 AND IMP_ORDER_NO = @SQLCRIT2 AND IMP_POSTING_TYPE = @SQLCRIT3 AND (INV_NO_STOCK IS NULL OR INV_NO_STOCK = 0) GROUP BY IMP_ORDER_NO, IMP_POSTING_TYPE, IMP_ITEM_ID"
"'@CID'='1'", "'@SOID'='POItemLine'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='1699'", "'@SQLCRIT2'='11074'", "'@SQLCRIT3'='1'", "'@USER'='0'"
Trace 12:58:53.5984
26 Sql GetResultSet "DECLARE @ILN_NO int = null; DECLARE @UNIT_FLAG int = null; SELECT @UNIT_FLAG=FL_Crit4 FROM Floors WHERE FL_VTID=@SQLCRIT1 AND FL_RecID=@SQLCRIT2 AND FL_Crit2=@SQLCRIT3 AND (FL_Crit4<10 OR FL_Crit4 IS NULL); SELECT @ILN_NO=B_Lng2 FROM Bases WHERE B_VTID=1 AND B_ID=@CID; SELECT FORMAT(ISNULL(@UNIT_FLAG, 0), '0') + FORMAT(@ILN_NO,'0000000') + FORMAT(13739, '000000000') + dbo.gln_chkdigit(FORMAT(ISNULL(@UNIT_FLAG, 0), '0') + FORMAT(@ILN_NO,'0000000') + FORMAT(13739, '0000000000')); "
"'@CID'='1'", "'@SOID'=''", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='10'", "'@SQLCRIT2'='1699'", "'@SQLCRIT3'='14'", "'@USER'='0'"
Trace 12:58:52.6994
27 Sql Execute "UPDATE COUNTERS SET C_Value = 13739 WHERE C_Name = 'sscc' AND C_Value = 13738"
"'@USER'='0'", "'@CID'='1'"
Trace 12:58:52.6654
28 Sql GetResultSet "SELECT * FROM COUNTERS WHERE C_Name = 'sscc'"
"'@USER'='0'", "'@CID'='1'"
Trace 12:58:52.6254
29 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_TXT2, B_TXT3, B_INT1, B_INT2, B_INT4, B_INT3, B_INT5, B_INT7, B_INT9, B_INT8, B_NUM7, B_INT13, B_LNG8, B_INT11, B_INT6, B_INT10, B_NUM1, B_NUM2, B_NUM6, B_LNG3, B_LNG7, B_LNG6, B_INT12, B_NUM3, B_NUM4, B_NUM5, B_TXT4, B_LNG1, B_LNG2, B_TXT5, B_TXT6, B_LNG4, B_LNG5 FROM BASES WHERE B_VTID=@VTID AND (@MID IS NULL OR B_MID=@MID) AND (@RECID IS NULL OR B_ID=@RECID) AND (@STRKEY IS NULL OR B_KEY=@STRKEY)"
"'@VTID'='3'", "'@STRKEY'=''", "'@RECID'='1699'", "'@MID'=''", "'@USER'='0'", "'@CID'='1'"
Trace 12:58:52.4093
30 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='POReceiving.ItemLines(1920x1080)'"
"'@USER'='0'", "'@CID'='1'"
Trace 12:58:51.8153
31 Sql GetResultSet "SELECT BRL_Txt, CAST(BRL_ID AS SMALLINT) AS BRL_ID FROM BrickList INNER JOIN Floors ON BRL_ID = FL_Crit2 WHERE BRL_BRPID = @SQLCRIT1 AND FL_Crit1 = @SQLCRIT2 AND FL_RecID = @SQLCRIT3"
"'@CID'='1'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='3'", "'@SQLCRIT2'='9'", "'@SQLCRIT3'='1078'", "'@USER'='0'"
Trace 12:58:51.2043
32 Sql GetResultSet "SELECT BRL_Txt, CAST(BRL_ID AS SMALLINT) AS BRL_ID FROM BrickList INNER JOIN Floors ON BRL_ID = FL_Crit2 WHERE BRL_BRPID = @SQLCRIT1 AND FL_Crit1 = @SQLCRIT2 AND FL_RecID = @SQLCRIT3"
"'@CID'='1'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='3'", "'@SQLCRIT2'='9'", "'@SQLCRIT3'='1699'", "'@USER'='0'"
Trace 12:58:51.1493
33 Sql GetResultSet "SELECT BRL_Txt, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_Lng AS SMALLINT) AS BRL_Lng FROM BrickList WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='25'", "'@USER'='0'"
Trace 12:58:50.9573
34 Sql GetResultSet "SELECT BRL_Txt, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_Lng AS SMALLINT) AS BRL_Lng FROM BrickList WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='8'", "'@USER'='0'"
Trace 12:58:50.8893
35 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_LNG1, B_INT2, B_INT3, B_INT4, B_INT5, B_INT6 FROM BASES WHERE B_VTID=31 ORDER BY B_KEY"
"'@CID'='1'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:50.8483
36 Sql GetResultSet "SELECT BRL_Txt, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_Lng AS SMALLINT) AS BRL_Lng FROM BrickList WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='3'", "'@USER'='0'"
Trace 12:58:50.8092
37 Sql GetResultSet "SELECT I_CID, I_VTID, I_HID, I_ID, I_LNG2, I_NUM1, I_INT1, I_NUM2, I_NUM3, I_NUM6, I_INT3, I_NUM7, I_NUM8, I_LNG3, I_LNG1, I_INT4, I_TXT1, I_MID, I_LNG5, I_LNG6, I_INT7 FROM ITEMLINES WHERE (I_HID=@HID) AND I_VTID=@VTID AND (I_CID=@CID OR I_CID=0) ORDER BY I_ID OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY"
"'@VTID'='300'", "'@CID'='1'", "'@HID'='11074'", "'@SOID'='POItemline'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:50.6442
38 Sql GetResultSet "SELECT COUNT(1) FROM IMPOSTING WHERE IMP_BARCODE like @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'=''", "'@USER'='0'"
Trace 12:58:50.3562
39 Sql GetResultSet "SELECT BRL_TXT, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_LNG AS SMALLINT) AS BRL_LNG FROM BRICKLIST WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='3'", "'@USER'='0'"
Trace 12:58:50.3152
40 Sql GetResultSet "SELECT BRL_TXT, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_LNG AS SMALLINT) AS BRL_LNG FROM BRICKLIST WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='3'", "'@USER'='0'"
Trace 12:58:50.2822
41 Sql GetResultSet "SELECT EIM_ITEM_ID FROM ADDRESS RIGHT JOIN EXTITEMMATCHING ON ADDRESS.ADR_ADDRESS_NO = EXTITEMMATCHING.EIM_ADR_ID WHERE (EXTITEMMATCHING.EIM_EXTERNAL_ITEM_AI01 = @SQLCRIT1) OR (ADDRESS.ADR_ILN = @SQLCRIT2) AND (EXTITEMMATCHING.EIM_EXTERNAL_ITEM_NO = @SQLCRIT3)"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'=''", "'@SQLCRIT2'=''", "'@SQLCRIT3'=''", "'@USER'='0'"
Trace 12:58:50.2132
42 Sql GetResultSet "SELECT EIM_ITEM_ID FROM ADDRESS RIGHT JOIN EXTITEMMATCHING ON ADDRESS.ADR_ADDRESS_NO = EXTITEMMATCHING.EIM_ADR_ID WHERE (EXTITEMMATCHING.EIM_EXTERNAL_ITEM_AI01 = @SQLCRIT1) OR (ADDRESS.ADR_ILN = @SQLCRIT2) AND (EXTITEMMATCHING.EIM_EXTERNAL_ITEM_NO = @SQLCRIT3)"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'=''", "'@SQLCRIT2'=''", "'@SQLCRIT3'=''", "'@USER'='0'"
Trace 12:58:50.1792
43 Sql GetResultSet "SELECT EIM_ITEM_ID FROM ADDRESS RIGHT JOIN EXTITEMMATCHING ON ADDRESS.ADR_ADDRESS_NO = EXTITEMMATCHING.EIM_ADR_ID WHERE (EXTITEMMATCHING.EIM_EXTERNAL_ITEM_AI01 = @SQLCRIT1) OR (ADDRESS.ADR_ILN = @SQLCRIT2) AND (EXTITEMMATCHING.EIM_EXTERNAL_ITEM_NO = @SQLCRIT3)"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'=''", "'@SQLCRIT2'=''", "'@SQLCRIT3'=''", "'@USER'='0'"
Trace 12:58:50.1052
44 Sql GetResultSet "SELECT H_CID, H_VTID, H_ID, H_LNG1, H_LNG4, H_TXT2, H_TXT1, H_LNG6, H_LNG7, H_INT2, H_INT1, H_LNG2, H_LNG3, H_INT6, H_INT4 FROM HEADERS WHERE H_VTID=@VTID AND H_ID=@HID"
"'@VTID'='350'", "'@HID'='10121'", "'@USER'='0'", "'@CID'='1'"
Trace 12:58:49.9652
45 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT10, B_TXT1, B_LNG1, B_TXT2, B_TXT3, B_TXT4, B_LNG2, B_TXT5, B_TXT6, B_TXT8, B_TXT7, B_TXT9, B_INT1, B_INT2, B_INT3, B_INT4, B_LNG4, B_LNG3, B_NUM1, B_NUM2, B_LNG5, B_LNG6 FROM BASES WHERE B_VTID=@VTID AND (@MID IS NULL OR B_MID=@MID) AND (@RECID IS NULL OR B_ID=@RECID) AND (@STRKEY IS NULL OR B_KEY=@STRKEY)"
"'@VTID'='2'", "'@STRKEY'=''", "'@RECID'='4001'", "'@MID'=''", "'@USER'='0'", "'@CID'='1'"
Trace 12:58:49.7632
46 Sql GetResultSet "SELECT H_CID, H_VTID, H_ID, H_LNG2, H_LNG6, H_LNG9, H_INT3, H_LNG1, H_LNG3, H_LNG5, H_INT4, H_INT5, H_INT6, H_LNG7, H_LNG8, H_INT1, H_TXT1 FROM HEADERS WHERE H_VTID=@VTID AND H_ID=@HID AND (H_CID=@CID OR H_CID=0)"
"'@VTID'='300'", "'@CID'='1'", "'@HID'='11074'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:49.4272
47 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='POReceivingList.POrderGrid(1920x1080)'"
"'@USER'='0'", "'@CID'='1'"
Trace 12:58:46.2180
48 Sql GetResultSet "SELECT BRL_Txt, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_Lng AS SMALLINT) AS BRL_Lng FROM BrickList WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'=''", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='8'", "'@USER'='0'"
Trace 12:58:44.7069
49 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_LNG1, B_INT2, B_INT3, B_INT4, B_INT5, B_INT6 FROM BASES WHERE B_VTID=31 ORDER BY B_KEY"
"'@CID'='1'", "'@SOID'=''", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:44.6559
50 Sql GetResultSet "SELECT BRL_Txt, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_Lng AS SMALLINT) AS BRL_Lng FROM BrickList WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'=''", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='7'", "'@USER'='0'"
Trace 12:58:44.5779
51 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_MID, B_KEY, B_TXT1, B_TXT2, B_INT1, B_TXT3, B_TXT4, B_INT2, B_TXT5 FROM BASES WHERE (B_MID=NULL) AND B_VTID=11 ORDER BY B_KEY"
"'@CID'='1'", "'@SOID'=''", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:44.5339
52 Sql GetResultSet "SELECT HEADERS.H_CID, HEADERS.H_VTID, HEADERS.H_ID, HEADERS.H_ID AS ORDER_NO, HEADERS.H_LNG2 AS SUPPLIER_ID, ADDRESS.B_KEY AS SUPPLIER, ADDRESS.B_TXT2 AS SUPPLIER_NAME, HEADERS.H_LNG4 AS CONTACT, HEADERS.H_INT3 AS ORDER_TYPE, HEADERS.H_LNG9 AS CONTRACT_ID, PCONTRACTS.H_ID AS CONTRACT_NO, PCONTRACTS.H_TXT1 AS CONTRACT_DESCRIPTION, (CASE WHEN ISDATE(HEADERS.H_LNG1) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), HEADERS.H_LNG1,112)) END) AS DELIVERY_DATE, HEADERS.H_LNG3 AS DELIVERY_POINT, HEADERS.H_TXT2 AS CALL_NO, HEADERS.H_INT4 AS STATUS, (CASE WHEN ISDATE(HEADERS.H_LNG6) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), HEADERS.H_LNG6,112)) END) AS ORDER_DATE, (CASE WHEN ISDATE(PCONTRACTS.H_LNG6) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), PCONTRACTS.H_LNG6,112)) END) AS CONTRACT_DATE_FROM, (CASE WHEN ISDATE(PCONTRACTS.H_LNG7) = 1 THEN CONVERT(DATE, CONVERT(NVARCHAR(8), PCONTRACTS.H_LNG7,112)) END) AS CONTRACT_DATE_TO, HEADERS.H_LNG7 AS INVOICE_NO, HEADERS.H_LNG8 AS INVOICE_DATE, HEADERS.H_INT1 AS PAID, HEADERS.H_TXT1 AS REFERENCE, HEADERS.H_INT5 AS SUPPLIERCURRENCY, HEADERS.H_INT6 AS BASECURRENCY, HEADERS.H_NUM1 AS EXCHANGE_RATE FROM HEADERS LEFT JOIN BASES AS ADDRESS ON ADDRESS.B_VTID=2 AND ADDRESS.B_ID = HEADERS.H_LNG2 LEFT JOIN HEADERS AS PCONTRACTS ON PCONTRACTS.H_VTID=350 AND PCONTRACTS.H_ID = HEADERS.H_LNG9 WHERE ((Headers.H_Lng1>=20180929 OR 20180929 IS NULL) AND (Headers.H_Lng3=NULL OR NULL IS NULL) AND (Headers.H_Lng2=NULL OR NULL IS NULL) AND (Headers.H_Int4=NULL OR NULL IS NULL) AND (Headers.H_Int4 >10 AND Headers.H_Int4<90)) AND HEADERS.H_VTID=@VTID AND (HEADERS.H_CID=@CID OR HEADERS.H_CID=0) ORDER BY HEADERS.H_LNG1 OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY"
"'@VTID'='300'", "'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:40.6967
53 Sql GetResultSet "SELECT BRL_TXT, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_LNG AS SMALLINT) AS BRL_LNG FROM BRICKLIST WHERE (BRL_Lng >10 AND BRL_Lng <90) AND BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'=''", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='8'", "'@USER'='0'"
Trace 12:58:40.1996
54 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_LNG1, B_INT2, B_INT3, B_INT4, B_INT5, B_INT6 FROM BASES WHERE (BASES.B_INT3 = -1) AND B_VTID=31 ORDER BY B_KEY"
"'@CID'='1'", "'@SOID'='Inventory'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:40.1576
55 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT10, B_TXT1, B_LNG1, B_TXT2, B_TXT3, B_TXT4, B_LNG2, B_TXT5, B_TXT6, B_TXT8, B_TXT7, B_TXT9, B_INT1, B_INT2, B_INT3, B_INT4, B_LNG4, B_LNG3, B_NUM1, B_NUM2, B_LNG5, B_LNG6 FROM BASES WHERE (BASES.B_INT2 = -1) AND B_VTID=2 ORDER BY B_KEY"
"'@CID'='1'", "'@SOID'='Address'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:40.0966
56 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='POReceivingList(1920x1059)'"
"'@USER'='0'", "'@CID'='1'"
Trace 12:58:40.0396
57 Sql Execute "INSERT INTO Errors(Err_Level, Err_User, Err_Class, Err_Func, Err_Info, Err_ExText) VALUES (0, 'ULTRABOOK - admbb', 'EventFunctions', 'port_cmd', 'POReceiving', 'Info: Class: EventFunctions; Func: port_cmd

Error Text : POReceiving
Der Anschluss COM8 ist nicht vorhanden.'); "
"'@USER'='0'", "'@CID'='1'"
Trace 12:58:05.4487
58 Sql GetResultSet "SELECT BRL_TXT, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_LNG AS SMALLINT) AS BRL_LNG FROM BRICKLIST WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='3'", "'@USER'='0'"
Trace 12:58:03.4935
59 Sql GetResultSet "SELECT BRL_TXT, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_LNG AS SMALLINT) AS BRL_LNG FROM BRICKLIST WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='3'", "'@USER'='0'"
Trace 12:58:03.4495
60 Sql GetResultSet "SELECT BRL_TXT, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_LNG AS SMALLINT) AS BRL_LNG FROM BRICKLIST WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='8'", "'@USER'='0'"
Trace 12:58:02.4125
61 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_LNG1, B_INT2, B_INT3, B_INT4, B_INT5, B_INT6 FROM BASES WHERE (BASES.B_INT3 = -1) AND B_VTID=31 ORDER BY B_KEY"
"'@CID'='1'", "'@SOID'='Inventory'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:02.3095
62 Sql GetResultSet "SELECT BRL_TXT, CAST(BRL_ID AS SMALLINT) AS BRL_ID, CAST(BRL_LNG AS SMALLINT) AS BRL_LNG FROM BRICKLIST WHERE BRL_BRPID = @SQLCRIT1"
"'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='7'", "'@USER'='0'"
Trace 12:58:02.2585
63 Sql GetResultSet "SELECT H_CID, H_VTID, H_ID, H_LNG2, H_LNG6, H_LNG9, H_INT3, H_LNG1, H_LNG3, H_LNG5, H_INT4, H_INT5, H_INT6, H_LNG7, H_LNG8, H_INT1, H_TXT1 FROM HEADERS WHERE H_VTID=@VTID AND H_ID=@HID AND (H_CID=@CID OR H_CID=0)"
"'@VTID'='300'", "'@CID'='1'", "'@HID'=''", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:58:01.6084
64 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_VTID=3 AND R_MID=0 AND R_BID=0 AND R_Key='POReceiving(1920x1059)'"
"'@USER'='0'", "'@CID'='1'"
Trace 12:58:01.4854
65 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_CID=0 AND R_VTID=1 AND R_MID=0 AND R_BID=0 AND R_Lng1>0"
"'@USER'='0'", "'@CID'='1'"
Trace 12:56:05.9948
66 Sql GetResultSet "SELECT Count(*) FROM Headers WHERE H_VTID=@VTID "
"'@VTID'='350'", "'@CID'='1'", "'@SOID'='PContracts'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:05.0808
67 Sql GetResultSet "SELECT Count(*) FROM Headers WHERE H_VTID=@VTID "
"'@VTID'='300'", "'@CID'='1'", "'@SOID'='POReceiving'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:04.9168
68 Sql GetResultSet "SELECT Count(*) FROM Headers WHERE (Headers.H_Int4 < 40 OR Headers.H_Int4 IS NULL) AND H_VTID=@VTID "
"'@VTID'='300'", "'@CID'='1'", "'@SOID'='POrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:04.7408
69 Sql GetResultSet "SELECT Count(*) FROM Headers WHERE H_VTID=@VTID "
"'@VTID'='200'", "'@CID'='1'", "'@SOID'='SPayment'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:03.9697
70 Sql GetResultSet "SELECT Count(*) FROM Headers WHERE (Headers.H_Lng7 IS NULL) AND H_VTID=@VTID "
"'@VTID'='200'", "'@CID'='1'", "'@SOID'='SOrder'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:03.6267
71 Sql GetResultSet "SELECT Count(*) FROM Bases WHERE B_VTID=@VTID "
"'@VTID'='16'", "'@CID'='1'", "'@SOID'='Currency'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:03.4947
72 Sql GetResultSet "SELECT Count(*) FROM Bases WHERE B_VTID=@VTID "
"'@VTID'='15'", "'@CID'='1'", "'@SOID'='Country'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:03.3787
73 Sql GetResultSet "SELECT Count(*) FROM Bases WHERE B_VTID=@VTID "
"'@VTID'='6'", "'@CID'='1'", "'@SOID'='User'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:03.0967
74 Sql GetResultSet "SELECT Count(*) FROM Bases WHERE B_VTID=@VTID "
"'@VTID'='3'", "'@CID'='1'", "'@SOID'='Item'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:02.7986
75 Sql GetResultSet "SELECT Count(*) FROM Bases WHERE B_VTID=@VTID "
"'@VTID'='2'", "'@CID'='1'", "'@SOID'='Address'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:02.6096
76 Sql GetResultSet "SELECT * FROM REGISTRY WHERE R_CID=0 AND R_MID=0 AND R_BID=0"
"'@USER'='0'", "'@CID'='1'"
Trace 12:56:01.9236
77 Sql GetResultSet "SELECT B_CID, B_VTID, B_ID, B_KEY, B_TXT1, B_TXT2, B_TXT3, B_TXT4, B_TXT5, B_TXT6, B_TXT7, B_LNG2, B_TXT8, (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=1) AS 'BR_TXT1', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=2) AS 'BR_TXT2', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=3) AS 'BR_TXT3', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=4) AS 'BR_TXT4', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=5) AS 'BR_TXT5', (SELECT BR_TXT FROM BRICKS WHERE BR_VTID=B_VTID AND BR_RECID=B_ID AND BR_ID=6) AS 'BR_TXT6' FROM BASES WHERE B_VTID=@VTID AND (@MID IS NULL OR B_MID=@MID) AND (@RECID IS NULL OR B_ID=@RECID) AND (@STRKEY IS NULL OR B_KEY=@STRKEY)"
"'@VTID'='1'", "'@RECID'=''", "'@CID'='0'", "'@MID'=''", "'@STRKEY'=''", "'@SOID'='Company'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@USER'='0'"
Trace 12:56:01.7036
78 Sql GetResultSet "SELECT B_KEY, B_ID, BR_LNG FROM BASES INNER JOIN BRICKS ON B_CID=BR_CID AND B_ID=BR_RECID AND B_VTID=@VTID AND BR_VTID=@SQLCRIT1 WHERE BR_MID=@USRID ORDER BY BR_LNG DESC, B_KEY"
"'@VTID'='9'", "'@CID'='0'", "'@SOID'='Role'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='17'", "'@USER'='0'"
Trace 12:56:01.4716
79 Sql GetResultSet "SELECT B_KEY, B_ID, BR_LNG FROM BASES INNER JOIN BRICKS ON B_CID=BR_CID AND B_ID=BR_RECID AND B_VTID=@VTID AND BR_VTID=@SQLCRIT1 WHERE BR_MID=@USRID ORDER BY BR_LNG DESC, B_KEY"
"'@VTID'='9'", "'@CID'='0'", "'@SOID'='Role'", "'@COMPUTER'='ULTRABOOK'", "'@USRID'='0'", "'@ROLE'='0'", "'@SQLCRIT1'='17'", "'@USER'='0'"
Trace 12:55:15.3869
80 Sql GetResultSet "SELECT * FROM sys_Controls WHERE CT_SOID NOT LIKE 'sys%' ORDER BY CT_SOID, CT_Position"
"'@USER'='0'", "'@CID'='0'"
Trace 12:55:01.2281
81 Sql GetResultSet "SELECT * FROM sys_CtrlEvents ORDER BY CE_SOID, CE_CTName, CE_Position"
"'@USER'='0'", "'@CID'='0'"
Trace 12:55:01.0191
82 Sql GetResultSet "SELECT * FROM sys_Controls WHERE CT_TypeChr LIKE 'event%' ORDER BY CT_SOID, CT_Name, CT_Position"
"'@USER'='0'", "'@CID'='0'"
Trace 12:55:00.9641
83 Sql GetResultSet "SELECT * FROM sys_Controls WHERE CT_TypeChr LIKE 'menu%' AND CT_SOID != 'sys_menu' ORDER BY CT_Position"
"'@USER'='0'", "'@CID'='0'"
Trace 12:55:00.9121
84 Sql GetResultSet "SELECT * FROM sys_DESCRIPTIONS ORDER BY DP_SOID DESC, DP_CTRID"
"'@USER'='0'", "'@CID'='0'"
Trace 12:55:00.2051
85 Sql GetResultSet "SELECT * FROM sys_Controls WHERE CT_SOID LIKE 'sys%' ORDER BY CT_SOID, CT_Position"
"'@USER'='0'", "'@CID'='0'"
Trace 12:55:00.1151
86 Sql GetResultSet "SELECT * FROM sys_TblDefs WHERE TD_PTID > 0"
"'@USER'='0'", "'@CID'='0'"
Trace 12:54:59.9060
87 Sql GetResultSet "SELECT * FROM sys_TblDefs WHERE TD_PTID = 0"
"'@USER'='0'", "'@CID'='0'"
Trace 12:54:59.8400
88 Sql GetResultSet "SELECT * FROM FILES WHERE FILE_VTID=-1 AND FILE_OPERATION <> 9"
"'@USER'='0'", "'@CID'='0'"
Trace 12:54:58.7980
89 Sql GetResultSet "SELECT * FROM sys_TblDefs WHERE TD_PTID=1 AND TD_SOID='client'"
"'@USER'='0'", "'@CID'='0'"
Trace 12:54:58.5690
90 Sql GetResultSet "SELECT COUNT(*) FROM sys_Controls"
"'@USER'='0'", "'@CID'='0'"
Trace 12:54:58.4590