Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1d50-23a8 ENTER SQLSetEnvAttr
- SQLHENV 0x00000000
- SQLINTEGER 201 <SQL_ATTR_CONNECTION_POOLING>
- SQLPOINTER 2 <SQL_CP_ONE_PER_HENV>
- SQLINTEGER 4
- 1d50-23a8 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
- SQLHENV 0x00000000
- SQLINTEGER 201 <SQL_ATTR_CONNECTION_POOLING>
- SQLPOINTER 2 <SQL_CP_ONE_PER_HENV>
- SQLINTEGER 4
- 1d50-23a8 ENTER SQLAllocHandle
- SQLSMALLINT 1 <SQL_HANDLE_ENV>
- SQLHANDLE 0x00000000
- SQLHANDLE * 0x0727B638
- 1d50-23a8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 1 <SQL_HANDLE_ENV>
- SQLHANDLE 0x00000000
- SQLHANDLE * 0x0727B638 ( 0x027E3310)
- 1d50-23a8 ENTER SQLSetEnvAttr
- SQLHENV 0x027E3310
- SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
- SQLPOINTER 3 <SQL_OV_ODBC3>
- SQLINTEGER 4
- 1d50-23a8 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
- SQLHENV 0x027E3310
- SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
- SQLPOINTER 3 <SQL_OV_ODBC3>
- SQLINTEGER 4
- 1d50-23a8 ENTER SQLAllocHandle
- SQLSMALLINT 2 <SQL_HANDLE_DBC>
- SQLHANDLE 0x027E3310
- SQLHANDLE * 0x0082F76C
- 1d50-23a8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 2 <SQL_HANDLE_DBC>
- SQLHANDLE 0x027E3310
- SQLHANDLE * 0x0082F76C ( 0x027EA938)
- 1d50-23a8 ENTER SQLDriverConnectW
- HDBC 0x027EA938
- HWND 0x00000000
- WCHAR * 0x69852354 [ -3] "******\ 0"
- SWORD -3
- WCHAR * 0x69852354
- SWORD -3
- SWORD * 0x00000000
- UWORD 0 <SQL_DRIVER_NOPROMPT>
- 1d50-23a8 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
- HDBC 0x027EA938
- HWND 0x00000000
- WCHAR * 0x69852354 [ -3] "******\ 0"
- SWORD -3
- WCHAR * 0x69852354 <Invalid buffer length!> [-3]
- SWORD -3
- SWORD * 0x00000000
- UWORD 0 <SQL_DRIVER_NOPROMPT>
- 1d50-23a8 ENTER SQLSetConnectAttr
- SQLHDBC 0x027EA938
- SQLINTEGER 102 <SQL_ATTR_AUTOCOMMIT>
- SQLPOINTER 0 <SQL_AUTOCOMMIT_OFF>
- SQLINTEGER -5
- 1d50-23a8 EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
- SQLHDBC 0x027EA938
- SQLINTEGER 102 <SQL_ATTR_AUTOCOMMIT>
- SQLPOINTER 0 <SQL_AUTOCOMMIT_OFF>
- SQLINTEGER -5
- 1d50-23a8 ENTER SQLGetInfoW
- HDBC 0x027EA938
- UWORD 77 <SQL_DRIVER_ODBC_VER>
- PTR 0x027E04A0
- SWORD 40
- SWORD * 0x0082F718
- 1d50-23a8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
- HDBC 0x027EA938
- UWORD 77 <SQL_DRIVER_ODBC_VER>
- PTR 0x027E04A0 [ 10] "03.50"
- SWORD 40
- SWORD * 0x0082F718 (10)
- 1d50-23a8 ENTER SQLGetInfoW
- HDBC 0x027EA938
- UWORD 10002 <SQL_DESCRIBE_PARAMETER>
- PTR 0x027EADE8
- SWORD 4
- SWORD * 0x0082F718
- 1d50-23a8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
- HDBC 0x027EA938
- UWORD 10002 <SQL_DESCRIBE_PARAMETER>
- PTR 0x027EADE8 [ 2] "N"
- SWORD 4
- SWORD * 0x0082F718 (2)
- 1d50-23a8 ENTER SQLGetInfoW
- HDBC 0x027EA938
- UWORD 111 <SQL_NEED_LONG_DATA_LEN>
- PTR 0x027EADE8
- SWORD 4
- SWORD * 0x0082F718
- 1d50-23a8 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
- HDBC 0x027EA938
- UWORD 111 <SQL_NEED_LONG_DATA_LEN>
- PTR 0x027EADE8 [ 2] "Y"
- SWORD 4
- SWORD * 0x0082F718 (2)
- 1d50-23a8 ENTER SQLAllocHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6FC
- 1d50-23a8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6FC ( 0x07FC1AA0)
- 1d50-23a8 ENTER SQLGetTypeInfo
- HSTMT 0x07FC1AA0
- SWORD 12 <SQL_VARCHAR>
- 1d50-23a8 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- SWORD 12 <SQL_VARCHAR>
- 1d50-23a8 ENTER SQLFetch
- HSTMT 0x07FC1AA0
- 1d50-23a8 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- 1d50-23a8 ENTER SQLGetData
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 ENTER SQLFreeStmt
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 ENTER SQLFreeHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 ENTER SQLAllocHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6F0
- 1d50-23a8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6F0 ( 0x07FC1AA0)
- 1d50-23a8 ENTER SQLGetTypeInfo
- HSTMT 0x07FC1AA0
- SWORD -9 <SQL_WVARCHAR>
- 1d50-23a8 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- SWORD -9 <SQL_WVARCHAR>
- 1d50-23a8 ENTER SQLFetch
- HSTMT 0x07FC1AA0
- 1d50-23a8 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- 1d50-23a8 ENTER SQLGetData
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 ENTER SQLFreeStmt
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 ENTER SQLFreeHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 ENTER SQLAllocHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6E4
- 1d50-23a8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6E4 ( 0x07FC1AA0)
- 1d50-23a8 ENTER SQLGetTypeInfo
- HSTMT 0x07FC1AA0
- SWORD -3 <SQL_VARBINARY>
- 1d50-23a8 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- SWORD -3 <SQL_VARBINARY>
- 1d50-23a8 ENTER SQLFetch
- HSTMT 0x07FC1AA0
- 1d50-23a8 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- 1d50-23a8 ENTER SQLGetData
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 ENTER SQLFreeStmt
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 ENTER SQLFreeHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 ENTER SQLAllocHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6D8
- 1d50-23a8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x0082F6D8 ( 0x07FC1AA0)
- 1d50-23a8 ENTER SQLGetTypeInfo
- HSTMT 0x07FC1AA0
- SWORD 93 <SQL_TYPE_TIMESTAMP>
- 1d50-23a8 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- SWORD 93 <SQL_TYPE_TIMESTAMP>
- 1d50-23a8 ENTER SQLFetch
- HSTMT 0x07FC1AA0
- 1d50-23a8 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- 1d50-23a8 ENTER SQLGetData
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 3
- SWORD 4 <SQL_C_LONG>
- PTR <unknown type>
- SQLLEN 4
- SQLLEN * 0x00000000
- 1d50-23a8 ENTER SQLFreeStmt
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 ENTER SQLFreeHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 ENTER SQLAllocHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x06DBC66C
- 1d50-23a8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x027EA938
- SQLHANDLE * 0x06DBC66C ( 0x07FC1AA0)
- 1d50-23a8 ENTER SQLFreeStmt
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 ENTER SQLExecDirect
- HSTMT 0x07FC1AA0
- UCHAR * 0x06DCBC4C [ 1854] "SET NOCOUNT ON; declare @fim date \ 9\ 9\ 9IF (OBJECT_ID('[dbo].[fnUTCDateTB]') IS NOT NULL) \ 9\ 9\ 9\ 9SET @fim = (select dateadd(day,-4,convert(date,DataLocal)) from [dbo].[fnUTCDateTB](GETDATE())) \ 9\ 9\ 9ELSE \ 9\ 9\ 9\ 9SET @fim = dateadd(day,-4,convert(date,getdate())) \ 9\ 9\ 9 SELECT CST.service_id as service_id \ 9\ 9\ 9 , CST.ID as customer_id \ 9\ 9 \ 9 , CFG.ID as customer_config_id \ 9\ 9 \ 9 , CASE cct.frequency_type \ 9\ 9WHEN 'DAY' THEN DATEADD(DAY , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) WHEN 'MONTH' THEN DATEADD(MONTH, cct.frequency_quantity * cfg.cycle_number, cfg.birthday) WHEN 'YEAR' THEN DATEADD(YEAR , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) END as next_birthday \ 9\ 9 FROM CUSTOMER cst (NOLOCK) \ 9\ 9 JOIN CUSTOMER_CONFIG cfg (NOLOCK) \ 9\ 9 ON cfg.id = cst.customer_config_id \ 9\ 9 JOIN PROFILE prf (NOLOCK) \ 9\ 9 ON prf.id = cfg.profile_id \ 9\ 9 JOIN PROFILE_CONFIG pfg (NOLOCK) \ 9\ 9 ON pfg.id = prf.profile_config_id \ 9\ 9 JOIN CYCLE_TYPE cct (NOLOCK) \ 9\ 9 ON pfg.cycle_type_id = cct.id \ 9\ 9 where cfg.active = 1 \ 9\ 9 and cfg.created <= @fim \ 9\ 9 and CONVERT( DATE \ 9\ 9 , dateadd( day \ 9\ 9 , pfg.reattempt_limit_in_days \ 9\ 9 , CASE cct.frequency_type \ 9\ 9 WHEN 'DAY' THEN DATEADD(DAY , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) \ 9\ 9 WHEN 'MONTH' THEN DATEADD(MONTH, cct.frequency_quantity * cfg.cycle_number, cfg.birthday) \ 9\ 9 WHEN 'YEAR' THEN DATEADD(YEAR , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) \ 9\ 9 END \ 9\ 9 ) \ 9\ 9..."
- SDWORD 1854
- 1d50-23a8 EXIT SQLExecDirect with return code 100 (SQL_NO_DATA_FOUND)
- HSTMT 0x07FC1AA0
- UCHAR * 0x06DCBC4C [ 1854] "SET NOCOUNT ON; declare @fim date \ 9\ 9\ 9IF (OBJECT_ID('[dbo].[fnUTCDateTB]') IS NOT NULL) \ 9\ 9\ 9\ 9SET @fim = (select dateadd(day,-4,convert(date,DataLocal)) from [dbo].[fnUTCDateTB](GETDATE())) \ 9\ 9\ 9ELSE \ 9\ 9\ 9\ 9SET @fim = dateadd(day,-4,convert(date,getdate())) \ 9\ 9\ 9 SELECT CST.service_id as service_id \ 9\ 9\ 9 , CST.ID as customer_id \ 9\ 9 \ 9 , CFG.ID as customer_config_id \ 9\ 9 \ 9 , CASE cct.frequency_type \ 9\ 9WHEN 'DAY' THEN DATEADD(DAY , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) WHEN 'MONTH' THEN DATEADD(MONTH, cct.frequency_quantity * cfg.cycle_number, cfg.birthday) WHEN 'YEAR' THEN DATEADD(YEAR , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) END as next_birthday \ 9\ 9 FROM CUSTOMER cst (NOLOCK) \ 9\ 9 JOIN CUSTOMER_CONFIG cfg (NOLOCK) \ 9\ 9 ON cfg.id = cst.customer_config_id \ 9\ 9 JOIN PROFILE prf (NOLOCK) \ 9\ 9 ON prf.id = cfg.profile_id \ 9\ 9 JOIN PROFILE_CONFIG pfg (NOLOCK) \ 9\ 9 ON pfg.id = prf.profile_config_id \ 9\ 9 JOIN CYCLE_TYPE cct (NOLOCK) \ 9\ 9 ON pfg.cycle_type_id = cct.id \ 9\ 9 where cfg.active = 1 \ 9\ 9 and cfg.created <= @fim \ 9\ 9 and CONVERT( DATE \ 9\ 9 , dateadd( day \ 9\ 9 , pfg.reattempt_limit_in_days \ 9\ 9 , CASE cct.frequency_type \ 9\ 9 WHEN 'DAY' THEN DATEADD(DAY , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) \ 9\ 9 WHEN 'MONTH' THEN DATEADD(MONTH, cct.frequency_quantity * cfg.cycle_number, cfg.birthday) \ 9\ 9 WHEN 'YEAR' THEN DATEADD(YEAR , cct.frequency_quantity * cfg.cycle_number, cfg.birthday) \ 9\ 9 END \ 9\ 9 ) \ 9\ 9..."
- SDWORD 1854
- 1d50-23a8 ENTER SQLFreeStmt
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
- HSTMT 0x07FC1AA0
- UWORD 0 <SQL_CLOSE>
- 1d50-23a8 ENTER SQLFreeHandle
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 3 <SQL_HANDLE_STMT>
- SQLHANDLE 0x07FC1AA0
- 1d50-23a8 ENTER SQLEndTran
- SQLSMALLINT 2 <SQL_HANDLE_DBC>
- SQLHANDLE 0x027EA938
- SQLSMALLINT 1
- 1d50-23a8 EXIT SQLEndTran with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 2 <SQL_HANDLE_DBC>
- SQLHANDLE 0x027EA938
- SQLSMALLINT 1
- 1d50-23a8 ENTER SQLDisconnect
- HDBC 0x027EA938
- 1d50-23a8 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
- HDBC 0x027EA938
- 1d50-23a8 ENTER SQLFreeHandle
- SQLSMALLINT 2 <SQL_HANDLE_DBC>
- SQLHANDLE 0x027EA938
- 1d50-23a8 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
- SQLSMALLINT 2 <SQL_HANDLE_DBC>
- SQLHANDLE 0x027EA938
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement