[2100-0.000]globals.extra_systable_prefixes = 'dd_;' [2100-0.000]exe name=vb6 plaformId=2 [2100-0.000][[SQLAllocHandle]][2100-0.000]**** in PGAPI_AllocEnv ** [2100-0.016]** exit PGAPI_AllocEnv: phenv = 039120B0 ** [2100-0.016][[SQLSetEnvAttr]] att=200,2 [2100-0.016][[SQLAllocHandle]][2100-0.016]PGAPI_AllocConnect: entering... [2100-0.016]**** PGAPI_AllocConnect: henv = 039120B0, conn = 03913FE0 [2100-0.016]EN_add_connection: self = 039120B0, conn = 03913FE0 [2100-0.016] added at 0, conn->henv = 039120B0, conns[0]->henv = 039120B0 [2100-0.032][SQLGetInfo(30)][2100-0.032]PGAPI_GetInfo: entering...fInfoType=77 [2100-0.032]PGAPI_GetInfo: p='03.50', len=0, value=0, cbMax=12 [2100-0.032][[SQLSetConnectAttr]] 103 [2100-0.032]PGAPI_SetConnectAttr for 03913FE0: 103 0000000F [2100-0.032]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15 [2100-0.047][SQLDriverConnect][2100-0.047]PGAPI_DriverConnect: entering... [2100-0.047]**** PGAPI_DriverConnect: fDriverCompletion=0, connStrIn='DRIVER={PostgreSQL ANSI};UID=postgres;PWD=xxxxxxxx;DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT=5432;ByteaAsLongVarBinary=1;MaxLongVarcharSize=-4;' [2100-0.047]our_connect_string = 'DRIVER={PostgreSQL ANSI};UID=postgres;PWD=xxxxxxxx;DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT=5432;ByteaAsLongVarBinary=1;MaxLongVarcharSize=-4;' [2100-0.063]attribute = 'DRIVER', value = '{PostgreSQL ANSI}' [2100-0.063]copyAttributes: DSN='',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.063]attribute = 'UID', value = 'postgres' [2100-0.079]copyAttributes: DSN='',server='',dbase='',user='postgres',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.079]attribute = 'PWD', value = 'xxxxx' [2100-0.079]copyAttributes: DSN='',server='',dbase='',user='postgres',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.079]attribute = 'DATABASE', value = 'test-medsql-alder' [2100-0.079]copyAttributes: DSN='',server='',dbase='test-medsql-alder',user='postgres',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.094]attribute = 'SERVER', value = '192.168.100.77' [2100-0.094]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',user='postgres',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.094]attribute = 'PORT', value = '5432' [2100-0.094]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',user='postgres',passwd='xxxxx',port='5432',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.110]attribute = 'ByteaAsLongVarBinary', value = '1' [2100-0.110]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',user='postgres',passwd='xxxxx',port='5432',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.110]attribute = 'MaxLongVarcharSize', value = '-4' [2100-0.110]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',user='postgres',passwd='xxxxx',port='5432',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [2100-0.110]getDSNinfo: DSN= overwrite=0 [2100-0.125]our_connect_string = 'DRIVER={PostgreSQL ANSI};UID=postgres;PWD=xxxxxxxx;DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT=5432;ByteaAsLongVarBinary=1;MaxLongVarcharSize=-4;' [2100-0.125]attribute = 'DRIVER', value = '{PostgreSQL ANSI}' [2100-0.125]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.125]attribute = 'UID', value = 'postgres' [2100-0.125]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.141]attribute = 'PWD', value = 'xxxxx' [2100-0.141]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.141]attribute = 'DATABASE', value = 'test-medsql-alder' [2100-0.141]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.141]attribute = 'SERVER', value = '192.168.100.77' [2100-0.141]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.157]attribute = 'PORT', value = '5432' [2100-0.157]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.157]attribute = 'ByteaAsLongVarBinary', value = '1' [2100-0.157]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.157]attribute = 'MaxLongVarcharSize', value = '-4' [2100-0.157]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=-4;B2=1;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.172]calling getDSNdefaults [2100-0.172]CC_connect: entering... [2100-0.172]sslmode=disable [2100-0.172]original_CC_connect: entering... [2100-0.172]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library [2100-0.172]original_CC_connect: DSN = '', server = '192.168.100.77', port = '5432', database = 'test-medsql-alder', username = 'postgres', password='xxxxx' [2100-0.172]connecting to the server socket... [2100-0.204](0)(null) ERRNO=0 [2100-0.204]connection to the server socket succeeded. [2100-0.204]sizeof startup packet = 89 [2100-0.204]sent the authentication block successfully. [2100-0.204]gonna do authentication [2100-0.204]read 13, global_socket_buffersize=4096 [2100-0.204]auth got 'R' [2100-0.204]areq = 5 salt=4377c37100 [2100-0.204]in AUTH_REQ_MD5 [2100-0.204]read -1, global_socket_buffersize=4096 [2100-0.219]Lasterror=10035 [2100-0.219]read 290, global_socket_buffersize=4096 [2100-0.219]auth got 'R' [2100-0.219]areq = 0 salt=0000000000 [2100-0.219]auth got 'S' [2100-0.219]auth got 'S' [2100-0.219]auth got 'S' [2100-0.219]auth got 'S' [2100-0.219]auth got 'S' [2100-0.219]auth got 'S' [2100-0.219]Got the PostgreSQL version string: '8.1.5' [2100-0.219]Extracted PostgreSQL version number: '8.1' [2100-0.219]auth got 'S' [2100-0.219]auth got 'S' [2100-0.235]standard_conforming_strings=off [2100-0.235]auth got 'S' [2100-0.235]auth got 'K' [2100-0.235]auth got 'Z' [2100-0.235]CC_send_settings: entering... [2100-0.235]PGAPI_AllocStmt: entering... [2100-0.235]**** PGAPI_AllocStmt: hdbc = 03913FE0, stmt = 03918FA8 [2100-0.235]CC_add_statement: self=03913FE0, stmt=03918FA8 [2100-0.235]PGAPI_FreeStmt: entering...hstmt=03918FA8, fOption=1 [2100-0.235]QResult: enter DESTRUCTOR [2100-0.235]SC_init_Result(3918fa8)[2100-0.235]SC_Destructor: self=03918FA8, self->result=00000000, self->hdbc=03913FE0 [2100-0.250]APD_free_params: ENTER, self=039190A8 [2100-0.250]IPD_free_params: ENTER, self=039190E8 [2100-0.250]PDATA_free_params: ENTER, self=0391914C [2100-0.250]SC_Destructor: EXIT [2100-0.250]CC_lookup_lo: entering... [2100-0.250]CC_send_query: conn=03913FE0, query='select oid, typbasetype from pg_type where typname = 'lo'' [2100-0.250]send_query: done sending query 63bytes flushed [2100-0.250]in QR_Constructor [2100-0.250]exit QR_Constructor [2100-0.250]read -1, global_socket_buffersize=4096 [2100-0.250]Lasterror=10035 [2100-0.266]read 77, global_socket_buffersize=4096 [2100-0.266]send_query: got id = 'T' [2100-0.266]QR_fetch_tuples: cursor = '', self->cursor=00000000 [2100-0.266]num_fields = 2 [2100-0.266]READING ATTTYPMOD [2100-0.266]CI_read_fields: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,65534) [2100-0.266]READING ATTTYPMOD [2100-0.266]CI_read_fields: fieldname='typbasetype', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,19) [2100-0.282]QR_fetch_tuples: past CI_read_fields: num_fields = 2 [2100-0.282]MALLOC: tuple_size = 100, size = 1600 [2100-0.282]QR_next_tuple: inTuples = true, falling through: fcount = 0, fetch_number = 0 [2100-0.282]end of tuple list -- setting inUse to false: this = 039191D8 SELECT [2100-0.282]_QR_next_tuple: 'C' fetch_total = 0 & this_fetch = 0 [2100-0.282]QR_next_tuple: backend_rows < CACHE_SIZE: brows = 0, cache_size = 0 [2100-0.282]QR_next_tuple: reached eof now [2100-0.282]_QR_next_tuple: 'C': DONE (fcount == 0) [2100-0.282]send_query: got id = 'Z' [2100-0.297]QResult: enter DESTRUCTOR [2100-0.297]QResult: in QR_close_result [2100-0.297]QResult: free memory in, fcount=0 [2100-0.297]QResult: free memory out [2100-0.297]QResult: enter DESTRUCTOR [2100-0.297]QResult: exit close_result [2100-0.297]QResult: exit DESTRUCTOR [2100-0.297]Got the large object oid: -999 [2100-0.297]CC_lookup_characterset: entering... [2100-0.297]conn->unicode=0 [2100-0.297]CC_connect: returning...1 [2100-0.297]szConnStrOut = 'DRIVER={PostgreSQL ANSI};DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT=5432;UID=postgres;PWD=xxxxxxxx;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=-4;Debug=1;CommLog=0;Optimizer=0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=0;LowerCaseIdentifier=0;XaOpt=1' len=624,1024 [2100-0.329]PGAPI_DriverConnect: returning 0 [2100-0.329][[SQLGetDiagRec]] [2100-0.329]PGAPI_GetDiagRec entering type=2 rec=1 [2100-0.329]**** PGAPI_ConnectError: hdbc=03913FE0 <0> [2100-0.329]enter CC_get_error [2100-0.329]enter CC_create_errormsg [2100-0.329]msg = '' [2100-0.329]exit CC_create_errormsg [2100-0.329]exit CC_get_error [2100-0.329]CC_Get_error returned nothing. [2100-0.329]PGAPI_GetDiagRec exiting 100 [2100-0.329][SQLGetFunctions][2100-0.329][SQLGetInfo(30)][2100-0.329]PGAPI_GetInfo: entering...fInfoType=23 [2100-0.344]PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=24 [2100-0.344]PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=79 [2100-0.344]PGAPI_GetInfo: p='', len=4, value=31, cbMax=4 [2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=83 [2100-0.344]PGAPI_GetInfo: p='', len=4, value=7, cbMax=4 [2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=78 [2100-0.360]PGAPI_GetInfo: p='', len=4, value=1, cbMax=4 [2100-0.360][SQLGetInfo(30)][2100-0.360]PGAPI_GetInfo: entering...fInfoType=81 [2100-0.360]PGAPI_GetInfo: p='', len=4, value=15, cbMax=4 [2100-0.360][SQLGetInfo(30)][2100-0.360]PGAPI_GetInfo: entering...fInfoType=72 [2100-0.360]PGAPI_GetInfo: p='', len=4, value=10, cbMax=4 [2100-0.360][SQLGetInfo(30)][2100-0.360]PGAPI_GetInfo: entering...fInfoType=82 [2100-0.360]PGAPI_GetInfo: p='', len=4, value=90, cbMax=4 [2100-0.360][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=44 [2100-0.375]PGAPI_GetInfo: p='', len=4, value=19, cbMax=4 [2100-0.375][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=43 [2100-0.375]PGAPI_GetInfo: p='', len=4, value=5, cbMax=4 [2100-0.375][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=144 [2100-0.375]CC_error_statements: self=03913FE0 [2100-0.375]PGAPI_GetInfo30: p='', len=4, value=0, cbMax=4 [2100-0.375][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=150 [2100-0.375]CC_error_statements: self=03913FE0 [2100-0.391]PGAPI_GetInfo30: p='', len=4, value=990799, cbMax=4 [2100-0.391][SQLGetInfo(30)][2100-0.391]PGAPI_GetInfo: entering...fInfoType=167 [2100-0.391]CC_error_statements: self=03913FE0 [2100-0.391]PGAPI_GetInfo30: p='', len=4, value=990799, cbMax=4 [2100-0.391][SQLGetInfo(30)][2100-0.391]PGAPI_GetInfo: entering...fInfoType=146 [2100-0.391]CC_error_statements: self=03913FE0 [2100-0.391]PGAPI_GetInfo30: p='', len=4, value=1, cbMax=4 [2100-0.391][SQLGetInfo(30)][2100-0.391]PGAPI_GetInfo: entering...fInfoType=151 [2100-0.407]CC_error_statements: self=03913FE0 [2100-0.407]PGAPI_GetInfo30: p='', len=4, value=4213, cbMax=4 [2100-0.407][SQLGetInfo(30)][2100-0.407]PGAPI_GetInfo: entering...fInfoType=168 [2100-0.407]CC_error_statements: self=03913FE0 [2100-0.407]PGAPI_GetInfo30: p='', len=4, value=4213, cbMax=4 [2100-0.407][SQLGetInfo(30)][2100-0.407]PGAPI_GetInfo: entering...fInfoType=111 [2100-0.407]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=512 [2100-0.407][SQLGetInfo(30)][2100-0.407]PGAPI_GetInfo: entering...fInfoType=16 [2100-0.422]PGAPI_GetInfo: p='test-medsql-alder', len=0, value=0, cbMax=0 [2100-0.422][SQLGetInfo(30)][2100-0.422]PGAPI_GetInfo: entering...fInfoType=23 [2100-0.422]PGAPI_GetInfo: p='', len=2, value=2, cbMax=4 [2100-0.422][SQLGetInfo(30)][2100-0.422]PGAPI_GetInfo: entering...fInfoType=24 [2100-0.422]PGAPI_GetInfo: p='', len=2, value=2, cbMax=4 [2100-0.422][SQLGetInfo(30)][2100-0.422]PGAPI_GetInfo: entering...fInfoType=46 [2100-0.422]PGAPI_GetInfo: p='', len=2, value=2, cbMax=4 [2100-0.422][[SQLSetConnectAttr]] 1 [2100-0.438]PGAPI_SetConnectAttr for 03913FE0: 1 00000000 [2100-0.438]PGAPI_SetConnectOption: entering fOption = 1 vParam = 0 [2100-0.438]SetStmtOption(): SQL_MAX_ROWS, vParam = 0 [2100-0.438][[SQLSetConnectAttr]] 0 [2100-0.438]PGAPI_SetConnectAttr for 03913FE0: 0 00000000 [2100-0.438]PGAPI_SetConnectOption: entering fOption = 0 vParam = 0 [2100-0.438]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 0 [2100-0.438][SQLGetInfo(30)][2100-0.438]PGAPI_GetInfo: entering...fInfoType=6 [2100-0.438]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52 [2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=6 [2100-0.454]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52 [2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=6 [2100-0.454]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52 [2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=6 [2100-0.454]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=48 [2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=1 [2100-0.454]PGAPI_GetInfo: p='', len=2, value=0, cbMax=4 [2100-0.469][[SQLGetConnectAttr]] 109 [2100-0.469]PGAPI_GetConnectAttr 109 [2100-0.469]PGAPI_GetConnectOption: entering... [2100-0.469][SQLGetInfo(30)][2100-0.469]PGAPI_GetInfo: entering...fInfoType=26 [2100-0.469]PGAPI_GetInfo: p='', len=4, value=2, cbMax=4 [2100-0.469][[SQLAllocHandle]][2100-0.469]PGAPI_AllocStmt: entering... [2100-0.469]**** PGAPI_AllocStmt: hdbc = 03913FE0, stmt = 03918FA8 [2100-0.469]CC_add_statement: self=03913FE0, stmt=03918FA8 [2100-0.469][[SQLGetStmtAttr]] Handle=59871144 10010 [2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10010 [2100-0.485][[SQLGetStmtAttr]] Handle=59871144 10011 [2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10011 [2100-0.485][[SQLGetStmtAttr]] Handle=59871144 10012 [2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10012 [2100-0.485][[SQLGetStmtAttr]] Handle=59871144 10013 [2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10013 [2100-0.500][[SQLSetStmtAttr]] Handle=03918FA8 18,10 [2100-0.500]PGAPI_SetStmtAttr Handle=03918FA8 18,10(0000000A) [2100-0.500][[SQLSetStmtAttr]] Handle=03918FA8 18,0 [2100-0.500]PGAPI_SetStmtAttr Handle=03918FA8 18,0(00000000) [2100-0.500][[SQLSetStmtAttr]] Handle=03918FA8 17,1306612 [2100-0.500]PGAPI_SetStmtAttr Handle=03918FA8 17,1306612(0013EFF4) [2100-0.516][[SQLSetStmtAttr]] Handle=03918FA8 17,0 [2100-0.516]PGAPI_SetStmtAttr Handle=03918FA8 17,0(00000000) [2100-0.516][[SQLSetDescField]] h=03919088 rec=1 field=1004 val=0013EFF4 [2100-0.516]PGAPI_SetDescField h=03919088(10011) rec=1 field=1004 val=0013EFF4,0 [2100-0.516]extend_parameter_bindings: entering ... self=039190A8, parameters_allocated=0, num_params=1,00000000 [2100-0.532]exit extend_parameter_bindings=039195B8 [2100-0.532][[SQLSetDescField]] h=03919088 rec=1 field=1004 val=00000000 [2100-0.532]PGAPI_SetDescField h=03919088(10011) rec=1 field=1004 val=00000000,0 [2100-0.532][SQLGetInfo(30)][2100-0.532]PGAPI_GetInfo: entering...fInfoType=36 [2100-0.547]PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4 [2100-0.547][[SQLGetStmtAttr]] Handle=59871144 6 [2100-0.547]PGAPI_GetStmtAttr Handle=03918FA8 6 [2100-0.547]PGAPI_GetStmtOption: entering... [2100-0.547]GetStmtOption(): SQL_CURSOR_TYPE 0 [2100-0.547][[SQLGetStmtAttr]] Handle=59871144 7 [2100-0.547]PGAPI_GetStmtAttr Handle=03918FA8 7 [2100-0.563]PGAPI_GetStmtOption: entering... [2100-0.563]GetStmtOption(): SQL_CONCURRENCY 1 [2100-0.563][[SQLGetConnectAttr]] 108 [2100-0.563]PGAPI_GetConnectAttr 108 [2100-0.563]PGAPI_GetConnectOption: entering... [2100-0.563][[SQLSetStmtAttr]] Handle=03918FA8 0,30 [2100-0.563]PGAPI_SetStmtAttr Handle=03918FA8 0,30(0000001E) [2100-0.563]PGAPI_SetStmtOption: entering... [2100-0.579]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30 [2100-0.579][[SQLSetStmtAttr]] Handle=03918FA8 22,1 [2100-0.579]PGAPI_SetStmtAttr Handle=03918FA8 22,1(00000001) [2100-0.579][[SQLSetStmtAttr]] Handle=03918FA8 21,0 [2100-0.579]PGAPI_SetStmtAttr Handle=03918FA8 21,0(00000000) [2100-0.579][SQLExecDirect][2100-0.579]PGAPI_ExecDirect: entering...1 [2100-0.594]SC_recycle_statement: self= 03918FA8 [2100-0.594]**** PGAPI_ExecDirect: hstmt=03918FA8, statement='SELECT * FROM select_patient_all_visit_data(77.00,'') ' [2100-0.594]PGAPI_ExecDirect: calling PGAPI_Execute... [2100-0.594]PGAPI_Execute: entering...1 [2100-0.594]PGAPI_Execute: clear errors... [2100-0.594]PGAPI_NumParams: entering... [2100-0.594]SC_scanQueryAndCountParams: entering... [2100-0.610]prepareParameters was not called, prepare state:2 [2100-0.610]SC_recycle_statement: self= 03918FA8 [2100-0.610]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=54, stmt='SELECT * FROM select_patient_all_visit_data(77.00,'') ' [2100-0.610] stmt_with_params = 'SELECT * FROM select_patient_all_visit_data(77.00,'') ' [2100-0.625]about to begin SC_execute [2100-0.625] Sending SELECT statement on stmt=03918FA8, cursor_name='SQL_CUR03918FA8' qflag=0,1 [2100-0.625]CC_send_query: conn=03913FE0, query='SELECT * FROM select_patient_all_visit_data(77.00,'') ' [2100-0.625]send_query: done sending query 60bytes flushed [2100-0.641]in QR_Constructor [2100-0.641]exit QR_Constructor [2100-0.641]read -1, global_socket_buffersize=4096 [2100-0.641]Lasterror=10035 [2100-0.641]read 1202, global_socket_buffersize=4096 [2100-0.641]send_query: got id = 'T' [2100-0.641]QR_fetch_tuples: cursor = '', self->cursor=00000000 [2100-0.657]num_fields = 37 [2100-0.657]READING ATTTYPMOD [2100-0.657]CI_read_fields: fieldname='vis_pat_id', adtid=1700, adtsize=-1, atttypmod=524290 (rel,att)=(0,0) [2100-0.657]READING ATTTYPMOD [2100-0.657]CI_read_fields: fieldname='vis_detail_id', adtid=20, adtsize=8, atttypmod=-1 (rel,att)=(0,0) [2100-0.657]READING ATTTYPMOD [2100-0.657]CI_read_fields: fieldname='vis_date', adtid=1082, adtsize=4, atttypmod=-1 (rel,att)=(0,0) [2100-0.657]READING ATTTYPMOD [2100-0.657]CI_read_fields: fieldname='vis_soap_code', adtid=1042, adtsize=-1, atttypmod=5 (rel,att)=(0,0) [2100-0.672]READING ATTTYPMOD [2100-0.672]CI_read_fields: fieldname='vis_comments', adtid=1042, adtsize=-1, atttypmod=50 (rel,att)=(0,0) [2100-0.672]READING ATTTYPMOD [2100-0.672]CI_read_fields: fieldname='vis_scan_type', adtid=1042, adtsize=-1, atttypmod=3 (rel,att)=(0,0) [2100-0.672]READING ATTTYPMOD [2100-0.672]CI_read_fields: fieldname='pat_init_name', adtid=1042, adtsize=-1, atttypmod=1 (rel,att)=(0,0) [2100-0.672]READING ATTTYPMOD [2100-0.672]CI_read_fields: fieldname='pat_mid_name', adtid=1042, adtsize=-1, atttypmod=20 (rel,att)=(0,0) [2100-0.688]READING ATTTYPMOD [2100-0.688]CI_read_fields: fieldname='pat_last_name', adtid=1042, adtsize=-1, atttypmod=20 (rel,att)=(0,0) [2100-0.688]READING ATTTYPMOD [2100-0.688]CI_read_fields: fieldname='pat_first_name', adtid=1042, adtsize=-1, atttypmod=20 (rel,att)=(0,0) [2100-0.688]READING ATTTYPMOD [2100-0.688]CI_read_fields: fieldname='pat_id', adtid=1700, adtsize=-1, atttypmod=524290 (rel,att)=(0,0) [2100-0.688]READING ATTTYPMOD [2100-0.688]CI_read_fields: fieldname='pat_phn_no', adtid=1042, adtsize=-1, atttypmod=12 (rel,att)=(0,0) [2100-0.704]READING ATTTYPMOD [2100-0.704]CI_read_fields: fieldname='pat_pin_no', adtid=1700, adtsize=-1, atttypmod=393216 (rel,att)=(0,0) [2100-0.704]READING ATTTYPMOD [2100-0.704]CI_read_fields: fieldname='pat_birthdate', adtid=1082, adtsize=4, atttypmod=-1 (rel,att)=(0,0) [2100-0.704]READING ATTTYPMOD [2100-0.704]CI_read_fields: fieldname='pat_tel_home', adtid=1042, adtsize=-1, atttypmod=14 (rel,att)=(0,0) [2100-0.704]READING ATTTYPMOD [2100-0.719]CI_read_fields: fieldname='pat_tel_buss', adtid=1042, adtsize=-1, atttypmod=14 (rel,att)=(0,0) [2100-0.719]READING ATTTYPMOD [2100-0.719]CI_read_fields: fieldname='pat_blood_type', adtid=1042, adtsize=-1, atttypmod=14 (rel,att)=(0,0) [2100-0.719]READING ATTTYPMOD [2100-0.719]CI_read_fields: fieldname='pat_address1', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0) [2100-0.719]READING ATTTYPMOD [2100-0.719]CI_read_fields: fieldname='pat_address2', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0) [2100-0.719]READING ATTTYPMOD [2100-0.735]CI_read_fields: fieldname='pat_address3', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0) [2100-0.735]READING ATTTYPMOD [2100-0.735]CI_read_fields: fieldname='pat_city', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0) [2100-0.735]READING ATTTYPMOD [2100-0.735]CI_read_fields: fieldname='pat_zip', adtid=1042, adtsize=-1, atttypmod=10 (rel,att)=(0,0) [2100-0.735]READING ATTTYPMOD [2100-0.735]CI_read_fields: fieldname='pat_sex', adtid=1042, adtsize=-1, atttypmod=1 (rel,att)=(0,0) [2100-0.735]READING ATTTYPMOD [2100-0.735]CI_read_fields: fieldname='pro_desc', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0) [2100-0.750]READING ATTTYPMOD [2100-0.750]CI_read_fields: fieldname='pro_country', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0) [2100-0.750]READING ATTTYPMOD [2100-0.750]CI_read_fields: fieldname='ldetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0) [2100-0.750]READING ATTTYPMOD [2100-0.750]CI_read_fields: fieldname='adetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0) [2100-0.750]READING ATTTYPMOD [2100-0.750]CI_read_fields: fieldname='cdetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0) [2100-0.766]READING ATTTYPMOD [2100-0.766]CI_read_fields: fieldname='xdetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0) [2100-0.766]READING ATTTYPMOD [2100-0.766]CI_read_fields: fieldname='detail_lab_code', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0) [2100-0.766]READING ATTTYPMOD [2100-0.766]CI_read_fields: fieldname='detail_results', adtid=1042, adtsize=-1, atttypmod=50 (rel,att)=(0,0) [2100-0.766]READING ATTTYPMOD [2100-0.766]CI_read_fields: fieldname='detail_comments', adtid=1042, adtsize=-1, atttypmod=66 (rel,att)=(0,0) [2100-0.782]READING ATTTYPMOD [2100-0.782]CI_read_fields: fieldname='lab_range_male', adtid=1042, adtsize=-1, atttypmod=15 (rel,att)=(0,0) [2100-0.782]READING ATTTYPMOD [2100-0.782]CI_read_fields: fieldname='lab_range_female', adtid=1042, adtsize=-1, atttypmod=15 (rel,att)=(0,0) [2100-0.782]READING ATTTYPMOD [2100-0.782]CI_read_fields: fieldname='lab_range_child', adtid=1042, adtsize=-1, atttypmod=15 (rel,att)=(0,0) [2100-0.782]READING ATTTYPMOD [2100-0.782]CI_read_fields: fieldname='grp_desc', adtid=1042, adtsize=-1, atttypmod=40 (rel,att)=(0,0) [2100-0.797]READING ATTTYPMOD [2100-0.797]CI_read_fields: fieldname='lab_seq_code', adtid=23, adtsize=4, atttypmod=-1 (rel,att)=(0,0) [2100-0.797]QR_fetch_tuples: past CI_read_fields: num_fields = 37 [2100-0.797]MALLOC: tuple_size = 100, size = 29600 [2100-0.797]QR_next_tuple: inTuples = true, falling through: fcount = 0, fetch_number = 0 [2100-0.797]next_tuple: 'N' - SNOTICE [2100-0.797]next_tuple: 'N' - C00000 [2100-0.797]next_tuple: 'N' - MALL [2100-0.813]next_tuple: 'N' - Fpl_exec.c [2100-0.813]next_tuple: 'N' - L2110 [2100-0.813]next_tuple: 'N' - Rexec_stmt_raise [2100-0.813]read 4096, global_socket_buffersize=4096 [2100-0.813]next_tuple: 'N' - SNOTICE [2100-0.813]next_tuple: 'N' - C00000 [2100-0.813]read 1093, global_socket_buffersize=4096 [2100-0.813]next_tuple: 'N' - MSELECT visit.vis_pat_id, vis_detail_id, visit.vis_date, visit.vis_soap_code, visit.vis_comments, visit.vis_scan_type, patient.pat_init_name, patient.pat_mid_name, patient.pat_last_name, patient.pat_first_name, patient.pat_id, patient.pat_phn_no, patient.pat_pin_no, patient.pat_birthdate, patient.pat_tel_home, patient.pat_tel_buss, patient.pat_blood_type, patient.pat_address1, patient.pat_address2, patient.pat_address3, patient.pat_city, patient.pat_zip, patient.pat_sex, province.pro_desc, province.pro_country, ldetail.detail_text as ldetail_text, adetail.detail_text as adetail_text, cdetail.detail_text as cdetail_text, xdetail.detail_text as xdetail_text, '' as detail_lab_code, '' as detail_results, '' as detail_comments, '' as lab_range_male, '' as lab_range_female, '' as lab_range_child, '' as grp_desc, 999999999 as lab_seq_code FROM public.visit visit LEFT OUTER JOIN public.patient patient ON visit.vis_pat_id = patient.pat_id LEFT OUTER JOIN public.ldetail ldetail ON visit.vis_detail_id = ldetail.detail_id LEFT OUTER JOIN public.adetail adetail ON visit.vis_detail_id = adetail.detail_id LEFT OUTER JOIN public.cdetail cdetail ON visit.vis_detail_id = cdetail.detail_id LEFT OUTER JOIN public.xdetail xdetail ON visit.vis_detail_id = xdetail.detail_id LEFT OUTER JOIN public.province province ON patient.pat_mail_pro_id = province.pro_id LEFT OUTER JOIN public.scan_h scan_h ON scan_h.scan_id = visit.vis_detail_id WHERE (trim(both '' from coalesce(ldetail.detail_text,''))<>'' or trim(both '' from coalesce(adetail.detail_text,''))<>'' or trim(both '' from coalesce(cdetail.detail_text,''))<>'' or trim(both '' from coalesce(xdetail.detail_text,''))<>'' or trim(both '' from coalesce(visit.vis_scan_type,'')) ='HTM' or trim(both '' from coalesce(visit.vis_scan_type,'')) ='TIF' and scan_pg_cnt <> 0) AND vis_detail_id NOT IN (SELECT detail_id FROM select_inr_data_only(77.00)) AND visit.vis_pat_id = 77.00 UNION SELECT visit.vis_pat_id, vis_detail_id, visit.vis_date, visit.vis_soap_code, visit.vis_comments, visit.vis_scan_type, patient.pat_init_name, patient.pat_mid_name, patient.pat_last_name, patient.pat_first_name, patient.pat_id, patient.pat_phn_no, patient.pat_pin_no, patient.pat_birthdate, patient.pat_tel_home, patient.pat_tel_buss, patient.pat_blood_type, patient.pat_address1, patient.pat_address2, patient.pat_address3, patient.pat_city, patient.pat_zip, patient.pat_sex, province.pro_desc, province.pro_country, '' as ldetail_text, '' as adetail_text, '' as cdetail_text, '' as xdetail_text, lrdetail.detail_lab_code, lrdetail.detail_results, lrdetail.detail_comments, lab.lab_range_male, lab.lab_range_female, lab.lab_range_child, labgroup.grp_desc, lab.lab_seq_code FROM public.visit visit LEFT OUTER JOIN public.patient patient ON visit.vis_pat_id = patient.pat_id LEFT OUTER JOIN public.lrdetail lrdetail ON visit.vis_detail_id = lrdetail.detail_id LEFT OUTER JOIN public.lab lab ON lrd