Skip to content

Instantly share code, notes, and snippets.

@jeff1985

jeff1985/msodbcsqlbug-db-structure.sql Secret

Last active April 23, 2018 11:40
Show Gist options
  • Save jeff1985/a064486a4a10c23bdc10d6d48419a332 to your computer and use it in GitHub Desktop.
Save jeff1985/a064486a4a10c23bdc10d6d48419a332 to your computer and use it in GitHub Desktop.
Download ZIP
msodbcsqlbug-db-structure.sql
Raw
msodbcsqlbug-db-structure.sql
create table salesmanager_run
(
id int identity
primary key,
startTime datetime2,
totalLines int,
processedLines int,
fileSize int,
output varchar(max),
state nvarchar(255),
fileName nvarchar(255),
importType int
)
go
create index IDX_83168591F5EA416D
on salesmanager_run (importType)
go
INSERT INTO [DSDEDS-SQL-1].dbo.salesmanager_run (id, startTime, totalLines, processedLines, fileSize, output, state, fileName, importType, progress, useBulkInsert, creator) VALUES (306, '2018-04-17 21:19:00.7921100', 8273111, 8273111, 1245587117, '[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] üüüüööööööööaeöäöüädsödöadhjasdhjfsdhjsdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf', 'finished', 'Sonder_BulkImport-UTF8.csv', 205, 100, 1, 'dev.user@example.com');
Raw
odbcinst.ini
[ODBC]
Pooling=Yes
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.1.so.0.1
UsageCount=1
Trace=Yes
TraceFile=/var/log/odbctrace.log
CPTimeout=120
Raw
odbctrace.log
[ODBC][22][1524418663.382150][SQLAllocHandle.c][375]
Entry:
Handle Type = 2
Input Handle = 0x55b5d91b6350
[ODBC][22][1524418663.382180][SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x55b5d923e500
[ODBC][22][1524418663.382226][SQLDriverConnect.c][726]
Entry:
Connection = 0x55b5d923e500
Window Hdl = (nil)
Str In = [Server={tcp:DATABASEHOST.database.windows.net,1433};UID={DATABASEUSER@DATABASEHOST};PWD=**********************;Database={DSDEDS-SQ...][length = 194 (SQL_NTS)]
Str Out = 0x7fff897b2c60
Str Out Max = 2048
Str Out Ptr = 0x7fff897b3cca
Completion = 0
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
DIAG [01000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'DSDEDS-SQL-1'.
DIAG [01000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed language setting to us_english.
[ODBC][22][1524418672.225723][SQLDriverConnect.c][1582]
Exit:[SQL_SUCCESS_WITH_INFO]
Connection Out [DRIVER=ODBC Driver 17 for SQL Server;SERVER=tcp:DATABASEHOST.data...]
DIAG [01000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'DSDEDS-SQL-1'.
DIAG [01000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed language setting to us_english.
[ODBC][22][1524418672.225849][SQLGetDiagRecW.c][508]
Entry:
Connection = 0x55b5d923e500
Rec Number = 1
SQLState = 0x7fff897b2b60
Native = 0x7f2c13c66028
Message Text = 0x7fff897b2b70
Buffer Length = 2049
Text Len Ptr = 0x7fff897b2b4e
[ODBC][22][1524418672.225873][SQLGetDiagRecW.c][550]
Exit:[SQL_SUCCESS]
SQLState = 01000
Native = 0x7f2c13c66028 -> 5701
Message Text = [[unixODBC][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'DSDEDS-SQL-1'.]
[ODBC][22][1524418672.225899][SQLGetInfo.c][554]
Entry:
Connection = 0x55b5d923e500
Info Type = SQL_DBMS_VER (18)
Info Value = 0x7fff897b3e20
Buffer Length = 256
StrLen = 0x7fff897b3d4e
[ODBC][22][1524418672.225930][SQLGetInfo.c][617]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418672.225967][SQLAllocHandle.c][540]
Entry:
Handle Type = 3
Input Handle = 0x55b5d923e500
[ODBC][22][1524418672.226065][SQLAllocHandle.c][1081]
Exit:[SQL_SUCCESS]
Output Handle = 0x55b5d923bb00
[ODBC][22][1524418672.226098][SQLPrepareW.c][165]
Entry:
Statement = 0x55b5d923bb00
SQL = [select * from salesmanager_run where ID=306][length = 43]
[ODBC][22][1524418672.226129][SQLPrepareW.c][340]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418672.226143][SQLExecute.c][187]
Entry:
Statement = 0x55b5d923bb00
[ODBC][22][1524418676.665750][SQLExecute.c][348]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.665801][SQLNumResultCols.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Count = 0x7fff897b41f8
[ODBC][22][1524418676.665825][SQLNumResultCols.c][248]
Exit:[SQL_SUCCESS]
Count = 0x7fff897b41f8 -> 12
[ODBC][22][1524418676.665836][SQLRowCount.c][173]
Entry:
Statement = 0x55b5d923bb00
Row Count = 0x7fff897b41f8
[ODBC][22][1524418676.665857][SQLRowCount.c][244]
Exit:[SQL_SUCCESS]
Row Count = 0x7fff897b41f8 -> -1
[ODBC][22][1524418676.665868][SQLNumResultCols.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Count = 0x7fff897b426e
[ODBC][22][1524418676.665887][SQLNumResultCols.c][248]
Exit:[SQL_SUCCESS]
Count = 0x7fff897b426e -> 12
[ODBC][22][1524418676.665897][SQLRowCount.c][173]
Entry:
Statement = 0x55b5d923bb00
Row Count = 0x7fff897b4270
[ODBC][22][1524418676.665916][SQLRowCount.c][244]
Exit:[SQL_SUCCESS]
Row Count = 0x7fff897b4270 -> -1
[ODBC][22][1524418676.665933][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c600aa
Column Size = 0x7f2c13c600b0
Decimal Digits = 0x7f2c13c600c0
Nullable = 0x7f2c13c600c2
[ODBC][22][1524418676.665966][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [i]
Data Type = 0x7f2c13c600aa -> 4
Column Size = 0x7f2c13c600b0 -> 10
Decimal Digits = 0x7f2c13c600c0 -> 0
Nullable = 0x7f2c13c600c2 -> 0
[ODBC][22][1524418676.665995][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c600d2
Column Size = 0x7f2c13c600d8
Decimal Digits = 0x7f2c13c600e8
Nullable = 0x7f2c13c600ea
[ODBC][22][1524418676.666026][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [s]
Data Type = 0x7f2c13c600d2 -> 93
Column Size = 0x7f2c13c600d8 -> 27
Decimal Digits = 0x7f2c13c600e8 -> 7
Nullable = 0x7f2c13c600ea -> 1
[ODBC][22][1524418676.666039][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60122
Column Size = 0x7f2c13c60128
Decimal Digits = 0x7f2c13c60138
Nullable = 0x7f2c13c6013a
[ODBC][22][1524418676.666105][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [t]
Data Type = 0x7f2c13c60122 -> 4
Column Size = 0x7f2c13c60128 -> 10
Decimal Digits = 0x7f2c13c60138 -> 0
Nullable = 0x7f2c13c6013a -> 1
[ODBC][22][1524418676.666122][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60172
Column Size = 0x7f2c13c60178
Decimal Digits = 0x7f2c13c60188
Nullable = 0x7f2c13c6018a
[ODBC][22][1524418676.666153][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [p]
Data Type = 0x7f2c13c60172 -> 4
Column Size = 0x7f2c13c60178 -> 10
Decimal Digits = 0x7f2c13c60188 -> 0
Nullable = 0x7f2c13c6018a -> 1
[ODBC][22][1524418676.666165][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c601c2
Column Size = 0x7f2c13c601c8
Decimal Digits = 0x7f2c13c601d8
Nullable = 0x7f2c13c601da
[ODBC][22][1524418676.666195][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [f]
Data Type = 0x7f2c13c601c2 -> 4
Column Size = 0x7f2c13c601c8 -> 10
Decimal Digits = 0x7f2c13c601d8 -> 0
Nullable = 0x7f2c13c601da -> 1
[ODBC][22][1524418676.666207][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60212
Column Size = 0x7f2c13c60218
Decimal Digits = 0x7f2c13c60228
Nullable = 0x7f2c13c6022a
[ODBC][22][1524418676.666236][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [o]
Data Type = 0x7f2c13c60212 -> 12
Column Size = 0x7f2c13c60218 -> 0
Decimal Digits = 0x7f2c13c60228 -> 0
Nullable = 0x7f2c13c6022a -> 1
[ODBC][22][1524418676.666248][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c6023a
Column Size = 0x7f2c13c60240
Decimal Digits = 0x7f2c13c60250
Nullable = 0x7f2c13c60252
[ODBC][22][1524418676.666278][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [s]
Data Type = 0x7f2c13c6023a -> -9
Column Size = 0x7f2c13c60240 -> 255
Decimal Digits = 0x7f2c13c60250 -> 0
Nullable = 0x7f2c13c60252 -> 1
[ODBC][22][1524418676.666290][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60262
Column Size = 0x7f2c13c60268
Decimal Digits = 0x7f2c13c60278
Nullable = 0x7f2c13c6027a
[ODBC][22][1524418676.666329][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [f]
Data Type = 0x7f2c13c60262 -> -9
Column Size = 0x7f2c13c60268 -> 255
Decimal Digits = 0x7f2c13c60278 -> 0
Nullable = 0x7f2c13c6027a -> 1
[ODBC][22][1524418676.666343][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c602b2
Column Size = 0x7f2c13c602b8
Decimal Digits = 0x7f2c13c602c8
Nullable = 0x7f2c13c602ca
[ODBC][22][1524418676.666375][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [i]
Data Type = 0x7f2c13c602b2 -> 4
Column Size = 0x7f2c13c602b8 -> 10
Decimal Digits = 0x7f2c13c602c8 -> 0
Nullable = 0x7f2c13c602ca -> 1
[ODBC][22][1524418676.666389][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60302
Column Size = 0x7f2c13c60308
Decimal Digits = 0x7f2c13c60318
Nullable = 0x7f2c13c6031a
[ODBC][22][1524418676.666421][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [p]
Data Type = 0x7f2c13c60302 -> 4
Column Size = 0x7f2c13c60308 -> 10
Decimal Digits = 0x7f2c13c60318 -> 0
Nullable = 0x7f2c13c6031a -> 1
[ODBC][22][1524418676.666434][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60352
Column Size = 0x7f2c13c60358
Decimal Digits = 0x7f2c13c60368
Nullable = 0x7f2c13c6036a
[ODBC][22][1524418676.666467][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [u]
Data Type = 0x7f2c13c60352 -> -7
Column Size = 0x7f2c13c60358 -> 1
Decimal Digits = 0x7f2c13c60368 -> 0
Nullable = 0x7f2c13c6036a -> 1
[ODBC][22][1524418676.666483][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c603a2
Column Size = 0x7f2c13c603a8
Decimal Digits = 0x7f2c13c603b8
Nullable = 0x7f2c13c603ba
[ODBC][22][1524418676.666516][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [c]
Data Type = 0x7f2c13c603a2 -> -9
Column Size = 0x7f2c13c603a8 -> 255
Decimal Digits = 0x7f2c13c603b8 -> 0
Nullable = 0x7f2c13c603ba -> 1
[ODBC][22][1524418676.666548][SQLNumResultCols.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Count = 0x7fff897b40ce
[ODBC][22][1524418676.666572][SQLNumResultCols.c][248]
Exit:[SQL_SUCCESS]
Count = 0x7fff897b40ce -> 12
[ODBC][22][1524418676.666583][SQLFetchScroll.c][159]
Entry:
Statement = 0x55b5d923bb00
Fetch Orentation = 1
Fetch Offset = 1
[ODBC][22][1524418676.666605][SQLFetchScroll.c][349]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.666624][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.666656][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.666669][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.666708][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.666723][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f1a0
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.666765][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [306](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 6
[ODBC][22][1524418676.666786][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.666814][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.666826][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.666854][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.666867][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Target Type = -8 SQL_WCHAR
Buffer Length = 56
Target Value = 0x7f2c13c68080
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.666908][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [2018-04-17 21:19:00.7921100](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 54
[ODBC][22][1524418676.666928][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.666956][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.666968][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.666993][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667004][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f1c0
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.667037][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [8273111](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 14
[ODBC][22][1524418676.667052][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.667080][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667092][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.667119][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667132][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f200
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.667165][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [8273111](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 14
[ODBC][22][1524418676.667181][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.667231][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667248][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.667276][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667290][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f220
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.667327][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [1245587117](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 20
[ODBC][22][1524418676.667348][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.667376][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667389][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.667416][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667431][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Target Type = -8 SQL_WCHAR
Buffer Length = 2050
Target Value = 0x7f2c13c58a00
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.667479][SQLGetData.c][501]
Exit:[SQL_SUCCESS_WITH_INFO]
Buffer = Indicator = -4
Strlen Or Ind = 0x7fff897b3f40 -> -4
DIAG [01004] [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
[ODBC][22][1524418676.667548][SQLGetDiagField.c][954]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
Diag Ident = 4
Diag Info Ptr = 0x7fff897b3f90
Buffer Length = 6
String Len Ptr = 0x7fff897b3f60
[ODBC][22][1524418676.667661][SQLGetDiagField.c][974]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667683][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Target Type = -8 SQL_WCHAR
Buffer Length = 2050
Target Value = 0x7f2c13c78800
StrLen Or Ind = 0x7fff897b3f70
[ODBC][22][1524418676.667725][SQLGetData.c][501]
Exit:[SQL_SUCCESS_WITH_INFO]
Buffer = Indicator = -4
Strlen Or Ind = 0x7fff897b3f70 -> -4
DIAG [01004] [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
[ODBC][22][1524418676.667776][SQLGetDiagField.c][954]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
Diag Ident = 4
Diag Info Ptr = 0x7fff897b3f90
Buffer Length = 6
String Len Ptr = 0x7fff897b3f60
[ODBC][22][1524418676.667800][SQLGetDiagField.c][974]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.667811][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Target Type = -8 SQL_WCHAR
Buffer Length = 4098
Target Value = 0x7f2c13c79000
StrLen Or Ind = 0x7fff897b3f70
[ODBC][22][1524418676.667857][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [sdafhjasdfhjasdfhjfdsahjdfshjhjdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] ������������ae�����ds�d�](unicode)
Strlen Or Ind = 0x7fff897b3f70 -> 3286
[ODBC][22][1524418676.667962][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.667993][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.668019][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Field Identifier = SQL_DESC_OCTET_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.668047][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.668060][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Target Type = -8 SQL_WCHAR
Buffer Length = 1022
Target Value = 0x7f2c13c7f000
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.668093][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [finished](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 16
[ODBC][22][1524418676.668110][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.668137][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.668148][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Field Identifier = SQL_DESC_OCTET_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.668175][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.668187][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Target Type = -8 SQL_WCHAR
Buffer Length = 1022
Target Value = 0x7f2c13c7f000
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.669754][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [Sonder_BulkImport-UTF8.csv](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 52
[ODBC][22][1524418676.669824][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.669854][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.669865][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.669890][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.669903][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f220
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.669940][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [205](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 6
[ODBC][22][1524418676.669956][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.669981][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.669992][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.670016][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.670026][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f260
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.670055][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [100](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 6
[ODBC][22][1524418676.670069][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.670105][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.670116][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.670142][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.670153][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Target Type = -8 SQL_WCHAR
Buffer Length = 4
Target Value = 0x7f2c13c5e020
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.670184][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [1](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 2
[ODBC][22][1524418676.670199][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418676.670225][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.670237][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Field Identifier = SQL_DESC_OCTET_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418676.670263][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418676.670274][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Target Type = -8 SQL_WCHAR
Buffer Length = 1022
Target Value = 0x7f2c13c7f500
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418676.670380][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [dev.user@example.com](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 40
[ODBC][22][1524418676.670424][SQLFetchScroll.c][159]
Entry:
Statement = 0x55b5d923bb00
Fetch Orentation = 1
Fetch Offset = 1
[ODBC][22][1524418676.670470][SQLFetchScroll.c][349]
Exit:[SQL_NO_DATA]
[ODBC][22][1524418676.670487][SQLRowCount.c][173]
Entry:
Statement = 0x55b5d923bb00
Row Count = 0x7fff897b40f0
[ODBC][22][1524418676.670525][SQLRowCount.c][244]
Exit:[SQL_SUCCESS]
Row Count = 0x7fff897b40f0 -> 1
[ODBC][22][1524418676.679610][SQLFreeHandle.c][381]
Entry:
Handle Type = 3
Input Handle = 0x55b5d923bb00
[ODBC][22][1524418681.590191][SQLFreeHandle.c][491]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418681.590256][SQLEndTran.c][421]
Entry:
Connection = 0x55b5d923e500
Completion Type = 1
[ODBC][22][1524418681.590282][SQLGetInfo.c][554]
Entry:
Connection = 0x55b5d923e500
Info Type = SQL_CURSOR_COMMIT_BEHAVIOR (23)
Info Value = 0x55b5d923f970
Buffer Length = 2
StrLen = 0x7fff897b582e
[ODBC][22][1524418681.590310][SQLGetInfo.c][617]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418681.590321][SQLGetInfo.c][554]
Entry:
Connection = 0x55b5d923e500
Info Type = SQL_CURSOR_ROLLBACK_BEHAVIOR (24)
Info Value = 0x55b5d923f972
Buffer Length = 2
StrLen = 0x7fff897b582e
[ODBC][22][1524418681.590346][SQLGetInfo.c][617]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418681.590357][SQLEndTran.c][574]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418681.590367][SQLDisconnect.c][208]
Entry:
Connection = 0x55b5d923e500
[ODBC][22][1524418681.590381][SQLDisconnect.c][308]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418681.590392][SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x55b5d923e500
[ODBC][22][1524418681.590403][SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418684.713052][SQLAllocHandle.c][375]
Entry:
Handle Type = 2
Input Handle = 0x55b5d91b6350
[ODBC][22][1524418684.713073][SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x55b5d923e500
[ODBC][22][1524418684.713120][SQLDriverConnect.c][726]
Entry:
Connection = 0x55b5d923e500
Window Hdl = (nil)
Str In = [Server={tcp:DATABASEHOST.database.windows.net,1433};UID={DATABASEUSER@DATABASEHOST};PWD=**********************;Database={DSDEDS-SQ...][length = 194 (SQL_NTS)]
Str Out = 0x7fff897b2c60
Str Out Max = 2048
Str Out Ptr = 0x7fff897b3cca
Completion = 0
[ODBC][22][1524418684.713136][SQLDriverConnect.c][925]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418684.713153][SQLAllocHandle.c][540]
Entry:
Handle Type = 3
Input Handle = 0x55b5d923e500
[ODBC][22][1524418684.713228][SQLAllocHandle.c][1081]
Exit:[SQL_SUCCESS]
Output Handle = 0x55b5d923bb00
[ODBC][22][1524418684.713289][SQLPrepareW.c][165]
Entry:
Statement = 0x55b5d923bb00
SQL = [select * from salesmanager_run where ID=306][length = 43]
[ODBC][22][1524418684.713312][SQLPrepareW.c][340]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418684.713321][SQLExecute.c][187]
Entry:
Statement = 0x55b5d923bb00
[ODBC][22][1524418691.168937][SQLExecute.c][348]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.169018][SQLNumResultCols.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Count = 0x7fff897b41f8
[ODBC][22][1524418691.169060][SQLNumResultCols.c][248]
Exit:[SQL_SUCCESS]
Count = 0x7fff897b41f8 -> 12
[ODBC][22][1524418691.169077][SQLRowCount.c][173]
Entry:
Statement = 0x55b5d923bb00
Row Count = 0x7fff897b41f8
[ODBC][22][1524418691.169231][SQLRowCount.c][244]
Exit:[SQL_SUCCESS]
Row Count = 0x7fff897b41f8 -> -1
[ODBC][22][1524418691.169251][SQLNumResultCols.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Count = 0x7fff897b426e
[ODBC][22][1524418691.169279][SQLNumResultCols.c][248]
Exit:[SQL_SUCCESS]
Count = 0x7fff897b426e -> 12
[ODBC][22][1524418691.169293][SQLRowCount.c][173]
Entry:
Statement = 0x55b5d923bb00
Row Count = 0x7fff897b4270
[ODBC][22][1524418691.169316][SQLRowCount.c][244]
Exit:[SQL_SUCCESS]
Row Count = 0x7fff897b4270 -> -1
[ODBC][22][1524418691.169340][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c600aa
Column Size = 0x7f2c13c600b0
Decimal Digits = 0x7f2c13c600c0
Nullable = 0x7f2c13c600c2
[ODBC][22][1524418691.169383][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [i]
Data Type = 0x7f2c13c600aa -> 4
Column Size = 0x7f2c13c600b0 -> 10
Decimal Digits = 0x7f2c13c600c0 -> 0
Nullable = 0x7f2c13c600c2 -> 0
[ODBC][22][1524418691.169408][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c600d2
Column Size = 0x7f2c13c600d8
Decimal Digits = 0x7f2c13c600e8
Nullable = 0x7f2c13c600ea
[ODBC][22][1524418691.169456][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [s]
Data Type = 0x7f2c13c600d2 -> 93
Column Size = 0x7f2c13c600d8 -> 27
Decimal Digits = 0x7f2c13c600e8 -> 7
Nullable = 0x7f2c13c600ea -> 1
[ODBC][22][1524418691.169497][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60122
Column Size = 0x7f2c13c60128
Decimal Digits = 0x7f2c13c60138
Nullable = 0x7f2c13c6013a
[ODBC][22][1524418691.169564][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [t]
Data Type = 0x7f2c13c60122 -> 4
Column Size = 0x7f2c13c60128 -> 10
Decimal Digits = 0x7f2c13c60138 -> 0
Nullable = 0x7f2c13c6013a -> 1
[ODBC][22][1524418691.169608][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60172
Column Size = 0x7f2c13c60178
Decimal Digits = 0x7f2c13c60188
Nullable = 0x7f2c13c6018a
[ODBC][22][1524418691.170953][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [p]
Data Type = 0x7f2c13c60172 -> 4
Column Size = 0x7f2c13c60178 -> 10
Decimal Digits = 0x7f2c13c60188 -> 0
Nullable = 0x7f2c13c6018a -> 1
[ODBC][22][1524418691.171024][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c601c2
Column Size = 0x7f2c13c601c8
Decimal Digits = 0x7f2c13c601d8
Nullable = 0x7f2c13c601da
[ODBC][22][1524418691.171064][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [f]
Data Type = 0x7f2c13c601c2 -> 4
Column Size = 0x7f2c13c601c8 -> 10
Decimal Digits = 0x7f2c13c601d8 -> 0
Nullable = 0x7f2c13c601da -> 1
[ODBC][22][1524418691.171078][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60212
Column Size = 0x7f2c13c60218
Decimal Digits = 0x7f2c13c60228
Nullable = 0x7f2c13c6022a
[ODBC][22][1524418691.171114][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [o]
Data Type = 0x7f2c13c60212 -> 12
Column Size = 0x7f2c13c60218 -> 0
Decimal Digits = 0x7f2c13c60228 -> 0
Nullable = 0x7f2c13c6022a -> 1
[ODBC][22][1524418691.171128][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c6023a
Column Size = 0x7f2c13c60240
Decimal Digits = 0x7f2c13c60250
Nullable = 0x7f2c13c60252
[ODBC][22][1524418691.171162][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [s]
Data Type = 0x7f2c13c6023a -> -9
Column Size = 0x7f2c13c60240 -> 255
Decimal Digits = 0x7f2c13c60250 -> 0
Nullable = 0x7f2c13c60252 -> 1
[ODBC][22][1524418691.171177][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60262
Column Size = 0x7f2c13c60268
Decimal Digits = 0x7f2c13c60278
Nullable = 0x7f2c13c6027a
[ODBC][22][1524418691.171214][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [f]
Data Type = 0x7f2c13c60262 -> -9
Column Size = 0x7f2c13c60268 -> 255
Decimal Digits = 0x7f2c13c60278 -> 0
Nullable = 0x7f2c13c6027a -> 1
[ODBC][22][1524418691.171230][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c602b2
Column Size = 0x7f2c13c602b8
Decimal Digits = 0x7f2c13c602c8
Nullable = 0x7f2c13c602ca
[ODBC][22][1524418691.171268][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [i]
Data Type = 0x7f2c13c602b2 -> 4
Column Size = 0x7f2c13c602b8 -> 10
Decimal Digits = 0x7f2c13c602c8 -> 0
Nullable = 0x7f2c13c602ca -> 1
[ODBC][22][1524418691.171283][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60302
Column Size = 0x7f2c13c60308
Decimal Digits = 0x7f2c13c60318
Nullable = 0x7f2c13c6031a
[ODBC][22][1524418691.171344][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [p]
Data Type = 0x7f2c13c60302 -> 4
Column Size = 0x7f2c13c60308 -> 10
Decimal Digits = 0x7f2c13c60318 -> 0
Nullable = 0x7f2c13c6031a -> 1
[ODBC][22][1524418691.171365][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c60352
Column Size = 0x7f2c13c60358
Decimal Digits = 0x7f2c13c60368
Nullable = 0x7f2c13c6036a
[ODBC][22][1524418691.171405][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [u]
Data Type = 0x7f2c13c60352 -> -7
Column Size = 0x7f2c13c60358 -> 1
Decimal Digits = 0x7f2c13c60368 -> 0
Nullable = 0x7f2c13c6036a -> 1
[ODBC][22][1524418691.171425][SQLDescribeColW.c][209]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Column Name = 0x7f2c13c613c0
Buffer Length = 129
Name Length = 0x7fff897b41c6
Data Type = 0x7f2c13c603a2
Column Size = 0x7f2c13c603a8
Decimal Digits = 0x7f2c13c603b8
Nullable = 0x7f2c13c603ba
[ODBC][22][1524418691.171467][SQLDescribeColW.c][460]
Exit:[SQL_SUCCESS]
Column Name = [c]
Data Type = 0x7f2c13c603a2 -> -9
Column Size = 0x7f2c13c603a8 -> 255
Decimal Digits = 0x7f2c13c603b8 -> 0
Nullable = 0x7f2c13c603ba -> 1
[ODBC][22][1524418691.171512][SQLNumResultCols.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Count = 0x7fff897b40ce
[ODBC][22][1524418691.171561][SQLNumResultCols.c][248]
Exit:[SQL_SUCCESS]
Count = 0x7fff897b40ce -> 12
[ODBC][22][1524418691.171585][SQLFetchScroll.c][159]
Entry:
Statement = 0x55b5d923bb00
Fetch Orentation = 1
Fetch Offset = 1
[ODBC][22][1524418691.171629][SQLFetchScroll.c][349]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.171669][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.171735][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.171776][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.171837][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.171896][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 1
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f1a0
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.172022][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [306](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 6
[ODBC][22][1524418691.172084][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.172129][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172144][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.172179][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172199][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 2
Target Type = -8 SQL_WCHAR
Buffer Length = 56
Target Value = 0x7f2c13c68080
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.172260][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [2018-04-17 21:19:00.7921100](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 54
[ODBC][22][1524418691.172322][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.172361][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172377][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.172411][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172427][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 3
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f1c0
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.172478][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [8273111](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 14
[ODBC][22][1524418691.172501][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.172534][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172546][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.172575][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172589][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 4
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f200
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.172625][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [8273111](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 14
[ODBC][22][1524418691.172645][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.172676][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172689][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.172720][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172733][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 5
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f220
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.172769][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [1245587117](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 20
[ODBC][22][1524418691.172811][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.172843][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.172857][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.172889][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173001][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Target Type = -8 SQL_WCHAR
Buffer Length = 2050
Target Value = 0x7f2c13c58a00
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.173074][SQLGetData.c][501]
Exit:[SQL_SUCCESS_WITH_INFO]
Buffer = Indicator = -4
Strlen Or Ind = 0x7fff897b3f40 -> -4
[ODBC][22][1524418691.173098][SQLGetDiagField.c][954]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
Diag Ident = 4
Diag Info Ptr = 0x7fff897b3f90
Buffer Length = 6
String Len Ptr = 0x7fff897b3f60
[ODBC][22][1524418691.173113][SQLGetDiagField.c][974]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173127][SQLGetDiagRecW.c][631]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
SQLState = 0x7fff897b1ca0
Native = 0x7fff897b1c6c
Message Text = 0x7fff897b1cb0
Buffer Length = 2049
Text Len Ptr = 0x7fff897b1c6a
[ODBC][22][1524418691.173142][SQLGetDiagRecW.c][673]
Exit:[SQL_SUCCESS]
SQLState = HY000
Native = 0x7fff897b1c6c -> 0
Message Text = [[unixODBC][Driver Manager]Driver returned SQL_ERROR or SQL_SUCCESS_WITH_INFO but no error reporting API found]
[ODBC][22][1524418691.173215][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3cf8
[ODBC][22][1524418691.173251][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173265][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d00
[ODBC][22][1524418691.173292][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173306][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Target Type = -8 SQL_WCHAR
Buffer Length = 2050
Target Value = 0x7f2c13c59400
StrLen Or Ind = 0x7fff897b3d10
[ODBC][22][1524418691.173350][SQLGetData.c][501]
Exit:[SQL_SUCCESS_WITH_INFO]
Buffer = Indicator = -4
Strlen Or Ind = 0x7fff897b3d10 -> -4
[ODBC][22][1524418691.173367][SQLGetDiagField.c][954]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
Diag Ident = 4
Diag Info Ptr = 0x7fff897b3d60
Buffer Length = 6
String Len Ptr = 0x7fff897b3d30
[ODBC][22][1524418691.173380][SQLGetDiagField.c][974]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173392][SQLGetDiagRecW.c][631]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
SQLState = 0x7fff897b1a70
Native = 0x7fff897b1a3c
Message Text = 0x7fff897b1a80
Buffer Length = 2049
Text Len Ptr = 0x7fff897b1a3a
[ODBC][22][1524418691.173407][SQLGetDiagRecW.c][673]
Exit:[SQL_SUCCESS]
SQLState = HY000
Native = 0x7fff897b1a3c -> 0
Message Text = [[unixODBC][Driver Manager]Driver returned SQL_ERROR or SQL_SUCCESS_WITH_INFO but no error reporting API found]
[ODBC][22][1524418691.173459][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3cf8
[ODBC][22][1524418691.173642][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173669][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d00
[ODBC][22][1524418691.173699][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173721][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Target Type = -8 SQL_WCHAR
Buffer Length = 2050
Target Value = 0x7f2c13c58a00
StrLen Or Ind = 0x7fff897b3d10
[ODBC][22][1524418691.173773][SQLGetData.c][501]
Exit:[SQL_SUCCESS_WITH_INFO]
Buffer = Indicator = -4
Strlen Or Ind = 0x7fff897b3d10 -> -4
[ODBC][22][1524418691.173806][SQLGetDiagField.c][954]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
Diag Ident = 4
Diag Info Ptr = 0x7fff897b3d60
Buffer Length = 6
String Len Ptr = 0x7fff897b3d30
[ODBC][22][1524418691.173818][SQLGetDiagField.c][974]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173877][SQLGetDiagRecW.c][631]
Entry:
Statement = 0x55b5d923bb00
Rec Number = 1
SQLState = 0x7fff897b1a70
Native = 0x7fff897b1a3c
Message Text = 0x7fff897b1a80
Buffer Length = 2049
Text Len Ptr = 0x7fff897b1a3a
[ODBC][22][1524418691.173895][SQLGetDiagRecW.c][673]
Exit:[SQL_SUCCESS]
SQLState = HY000
Native = 0x7fff897b1a3c -> 0
Message Text = [[unixODBC][Driver Manager]Driver returned SQL_ERROR or SQL_SUCCESS_WITH_INFO but no error reporting API found]
[ODBC][22][1524418691.173956][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3cf8
[ODBC][22][1524418691.173986][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.173998][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Field Identifier = SQL_DESC_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d00
[ODBC][22][1524418691.174023][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174035][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 6
Target Type = -8 SQL_WCHAR
Buffer Length = 2050
Target Value = 0x7f2c13c59400
StrLen Or Ind = 0x7fff897b3d10
[ODBC][22][1524418691.174075][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [jdfshjdfshjdfshjdfshjsdfhjsdfhjsdfhjsdfhjsdhjfjshdf
[2018-04-17 21:19:00] ������������ae�����ds�d�adhjasdhjfsdhjsdafhjasdfhjasdf](unicode)
Strlen Or Ind = 0x7fff897b3d10 -> 1238
[ODBC][22][1524418691.174099][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3cf8
[ODBC][22][1524418691.174126][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174137][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Field Identifier = SQL_DESC_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d00
[ODBC][22][1524418691.174163][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174174][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d08
[ODBC][22][1524418691.174200][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174211][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Field Identifier = SQL_DESC_OCTET_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d18
[ODBC][22][1524418691.174236][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174249][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 7
Target Type = -8 SQL_WCHAR
Buffer Length = 1022
Target Value = 0x7f2c13c7b000
StrLen Or Ind = 0x7fff897b3d10
[ODBC][22][1524418691.174281][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [finished](unicode)
Strlen Or Ind = 0x7fff897b3d10 -> 16
[ODBC][22][1524418691.174294][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3cf8
[ODBC][22][1524418691.174326][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174338][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Field Identifier = SQL_DESC_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d00
[ODBC][22][1524418691.174364][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174375][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d08
[ODBC][22][1524418691.174400][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174411][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Field Identifier = SQL_DESC_OCTET_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3d18
[ODBC][22][1524418691.174438][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.174449][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 8
Target Type = -8 SQL_WCHAR
Buffer Length = 1022
Target Value = 0x7f2c13c7b000
StrLen Or Ind = 0x7fff897b3d10
[ODBC][22][1524418691.175255][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [Sonder_BulkImport-UTF8.csv](unicode)
Strlen Or Ind = 0x7fff897b3d10 -> 52
[ODBC][22][1524418691.175308][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.175341][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175353][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.175380][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175393][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 9
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f220
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.175432][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [205](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 6
[ODBC][22][1524418691.175454][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.175481][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175492][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.175518][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175529][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 10
Target Type = -8 SQL_WCHAR
Buffer Length = 24
Target Value = 0x7f2c13c5f260
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.175559][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [100](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 6
[ODBC][22][1524418691.175574][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.175612][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175624][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.175649][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175661][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 11
Target Type = -8 SQL_WCHAR
Buffer Length = 4
Target Value = 0x7f2c13c5e000
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.175693][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [1](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 2
[ODBC][22][1524418691.175707][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f38
[ODBC][22][1524418691.175734][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175745][SQLColAttributeW.c][156]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Field Identifier = SQL_DESC_OCTET_LENGTH
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0x7fff897b3f48
[ODBC][22][1524418691.175771][SQLColAttributeW.c][518]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418691.175782][SQLGetData.c][237]
Entry:
Statement = 0x55b5d923bb00
Column Number = 12
Target Type = -8 SQL_WCHAR
Buffer Length = 1022
Target Value = 0x7f2c13c7b500
StrLen Or Ind = 0x7fff897b3f40
[ODBC][22][1524418691.175875][SQLGetData.c][501]
Exit:[SQL_SUCCESS]
Buffer = [dev.user@example.com](unicode)
Strlen Or Ind = 0x7fff897b3f40 -> 40
[ODBC][22][1524418691.175894][SQLFetchScroll.c][159]
Entry:
Statement = 0x55b5d923bb00
Fetch Orentation = 1
Fetch Offset = 1
[ODBC][22][1524418691.175918][SQLFetchScroll.c][349]
Exit:[SQL_NO_DATA]
[ODBC][22][1524418691.175930][SQLRowCount.c][173]
Entry:
Statement = 0x55b5d923bb00
Row Count = 0x7fff897b40f0
[ODBC][22][1524418691.175951][SQLRowCount.c][244]
Exit:[SQL_SUCCESS]
Row Count = 0x7fff897b40f0 -> 1
[ODBC][22][1524418691.177473][SQLFreeHandle.c][381]
Entry:
Handle Type = 3
Input Handle = 0x55b5d923bb00
[ODBC][22][1524418700.739720][SQLFreeHandle.c][491]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418700.739808][SQLEndTran.c][421]
Entry:
Connection = 0x55b5d923e500
Completion Type = 1
[ODBC][22][1524418700.739832][SQLGetInfo.c][554]
Entry:
Connection = 0x55b5d923e500
Info Type = SQL_CURSOR_COMMIT_BEHAVIOR (23)
Info Value = 0x55b5d923f970
Buffer Length = 2
StrLen = 0x7fff897b582e
[ODBC][22][1524418700.739844][SQLGetInfo.c][449]Error: IM001
[ODBC][22][1524418700.739859][SQLGetInfo.c][617]
Exit:[SQL_ERROR]
[ODBC][22][1524418700.739875][SQLEndTran.c][574]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418700.739886][SQLDisconnect.c][208]
Entry:
Connection = 0x55b5d923e500
[ODBC][22][1524418700.739898][SQLDisconnect.c][286]
Exit:[SQL_SUCCESS]
[ODBC][22][1524418700.739908][SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x55b5d923e500
[ODBC][22][1524418700.739919][SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
[ODBC][21][1524418709.849141][SQLAllocHandle.c][375]
Entry:
Handle Type = 2
Input Handle = 0x55b5d91b6350
[ODBC][21][1524418709.849177][SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x55b5d920f0e0
[ODBC][21][1524418709.849232][SQLDriverConnect.c][726]
Entry:
Connection = 0x55b5d920f0e0
Window Hdl = (nil)
Str In = [Server={tcp:DATABASEHOST.database.windows.net,1433};UID={DATABASEUSER@DATABASEHOST};PWD=**********************;Database={DSDEDS-SQ...][length = 194 (SQL_NTS)]
Str Out = 0x7fff897b2c30
Str Out Max = 2048
Str Out Ptr = 0x7fff897b3c9a
Completion = 0
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
DIAG [08001] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Timeout error [258].
DIAG [HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
DIAG [08001] [Microsoft][ODBC Driver 17 for SQL Server]Unable to complete login process due to delay in prelogin response
[ODBC][21][1524418724.855800][SQLDriverConnect.c][1507]
Exit:[SQL_ERROR]
[ODBC][21][1524418724.855828][SQLGetDiagRecW.c][508]
Entry:
Connection = 0x55b5d920f0e0
Rec Number = 1
SQLState = 0x7fff897b2b30
Native = 0x7f2c13c66028
Message Text = 0x7fff897b2b40
Buffer Length = 2049
Text Len Ptr = 0x7fff897b2b1e
[ODBC][21][1524418724.855845][SQLGetDiagRecW.c][550]
Exit:[SQL_SUCCESS]
SQLState = HYT00
Native = 0x7f2c13c66028 -> 0
Message Text = [[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired]
[ODBC][21][1524418724.855908][SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x55b5d920f0e0
[ODBC][21][1524418724.855922][SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
Raw
sqldata.log
2018-04-22 17:37:56.672436 got result(1): id='306' totalLines='8273111' state='finished'
2018-04-22 17:38:11.176791 got result(1): id='306' totalLines='8273111' state=NULL
2018-04-22 17:38:44.856734 Exception: SQLSTATE[HYT00]: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
Raw
test_incomplete_data.php
<?php
/**
* Get current date time.
* Format: YYYY-mm-dd HH:ii:ss.uuuuuu
* Microsecond precision.
*
* @return string Date time
*/
function getTime(): string
{
$microtime = microtime(true);
$microtime_formated = sprintf("%06d", ($microtime - floor($microtime) ) * 1000000);
$dt = new \DateTime(date('Y-m-d H:i:s.'.$microtime_formated, $microtime));
return $dt->format('Y-m-d H:i:s.u');
}
function myLog($s) {
// Log to file
$fh = fopen("/var/log/apache2/sqldata.log", 'a');
fputs($fh, getTime() ." ".$s."\n");
fclose($fh);
echo $s;
}
try {
$conn = new \PDO(
"sqlsrv:server = tcp:XXXX.database.windows.net,1433;TraceFile=/var/log/apache2/odbctrace.log;TraceOn=1;Database = DSDEDS-SQL-1;TraceFile=/var/log/odbctrace.log;TraceOn=1;Driver=ODBC Driver 17 for SQL Server",
"XXXX",
"XXXX"
);
$conn->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$statement = $conn->query("select * from salesmanager_run where ID=306");
$result = $statement->fetchAll();
$s = "got result(".count($result)."): ";
$s .= "id=" . var_export($result[0]["id"], true);
$s .= " totalLines=" . var_export($result[0]["totalLines"], true);
$s .= " state=" . var_export($result[0]["state"], true);
myLog($s);
} catch(\Throwable $e) {
myLog("Exception: ".$e->getMessage());
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment