[0.063]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library [0.063]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [0.063] disable_optimizer=0, ksqo=0, unique_index=1, use_declarefetch=0 [0.063] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [0.078] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [0.344] [ PostgreSQL version string = '8.1.4' ] [0.344] [ PostgreSQL version number = '8.1' ] [0.360]conn=03B34FD8, query='select oid, typbasetype from pg_type where typname = 'lo'' [0.563] [ fetched 1 rows ] [0.578] [ Large Object oid = 14939 ] [0.578] [ Client encoding = 'UTF-8' (code = -1) ] [0.578]CONN ERROR: func=CC_lookup_characterset, desc='', errnum=-1, errmsg='would handle the encoding 'UTF-8' like ASCII' [0.578] ------------------------------------------------------------ [0.578] henv=03B34FA8, conn=03B34FD8, status=0, num_stmts=16 [0.578] sock=03B37B38, stmts=03B39C10, lobj_type=14939 [0.578] ---------------- Socket Info ------------------------------- [0.594] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [0.594] buffer_in=62094336, buffer_out=62098440 [0.594] buffer_filled_in=39, buffer_filled_out=0, buffer_read_in=39 [0.594]conn=03B34FD8, query='set client_encoding to 'UTF8'' [0.781] [ fetched 1 rows ] [0.797]conn=03B34FD8, PGAPI_DriverConnect(out)='DSN=PostgreSQL35W-1;DATABASE=test;SERVER=lonrs09064;PORT=35432;UID=admin;PWD=xxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b3051cbb;A1=7.4-1' [0.844]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [0.844] ------------------------------------------------------------ [0.844] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [0.844] sock=03B37B38, stmts=03B39C10, lobj_type=14939 [0.844] ---------------- Socket Info ------------------------------- [0.844] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [0.844] buffer_in=62094336, buffer_out=62098440 [0.860] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.860]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=1852365868', errnum=205, errmsg='Unknown connect option (Set)' [0.860] ------------------------------------------------------------ [0.860] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [0.860] sock=03B37B38, stmts=03B39C10, lobj_type=14939 [0.860] ---------------- Socket Info ------------------------------- [0.860] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [0.860] buffer_in=62094336, buffer_out=62098440 [0.860] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.875]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [0.875] ------------------------------------------------------------ [0.875] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [0.875] sock=03B37B38, stmts=03B39C10, lobj_type=14939 [0.875] ---------------- Socket Info ------------------------------- [0.875] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [0.875] buffer_in=62094336, buffer_out=62098440 [0.891] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.891]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=1852365840', errnum=205, errmsg='Unknown connect option (Set)' [0.891] ------------------------------------------------------------ [0.891] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [0.891] sock=03B37B38, stmts=03B39C10, lobj_type=14939 [0.891] ---------------- Socket Info ------------------------------- [0.891] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [0.891] buffer_in=62094336, buffer_out=62098440 [0.891] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.969]conn=03B34FD8, PGAPI_Disconnect [2.485]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library [2.485]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [2.485] disable_optimizer=0, ksqo=0, unique_index=1, use_declarefetch=0 [2.485] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [2.485] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [2.750] [ PostgreSQL version string = '8.1.4' ] [2.750] [ PostgreSQL version number = '8.1' ] [2.766]conn=03B34FD8, query='select oid, typbasetype from pg_type where typname = 'lo'' [2.969] [ fetched 1 rows ] [2.985] [ Large Object oid = 14939 ] [2.985] [ Client encoding = 'UTF-8' (code = -1) ] [2.985]CONN ERROR: func=CC_lookup_characterset, desc='', errnum=-1, errmsg='would handle the encoding 'UTF-8' like ASCII' [2.985] ------------------------------------------------------------ [2.985] henv=03B34FA8, conn=03B34FD8, status=0, num_stmts=16 [2.985] sock=03B37B38, stmts=03B39C58, lobj_type=14939 [2.985] ---------------- Socket Info ------------------------------- [3.000] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [3.000] buffer_in=62094336, buffer_out=62098440 [3.000] buffer_filled_in=39, buffer_filled_out=0, buffer_read_in=39 [3.000]conn=03B34FD8, query='set client_encoding to 'UTF8'' [3.188] [ fetched 1 rows ] [3.203]conn=03B34FD8, PGAPI_DriverConnect(out)='DSN=PostgreSQL35W-1;DATABASE=test;SERVER=lonrs09064;PORT=35432;UID=admin;PWD=xxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b3051cbb;A1=7.4-1' [3.250]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [3.250] ------------------------------------------------------------ [3.250] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [3.250] sock=03B37B38, stmts=03B39C58, lobj_type=14939 [3.250] ---------------- Socket Info ------------------------------- [3.250] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [3.266] buffer_in=62094336, buffer_out=62098440 [3.266] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [3.266]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=1852365868', errnum=205, errmsg='Unknown connect option (Set)' [3.266] ------------------------------------------------------------ [3.266] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [3.266] sock=03B37B38, stmts=03B39C58, lobj_type=14939 [3.266] ---------------- Socket Info ------------------------------- [3.266] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [3.266] buffer_in=62094336, buffer_out=62098440 [3.266] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [3.281]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [3.281] ------------------------------------------------------------ [3.281] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [3.281] sock=03B37B38, stmts=03B39C58, lobj_type=14939 [3.281] ---------------- Socket Info ------------------------------- [3.281] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [3.281] buffer_in=62094336, buffer_out=62098440 [3.281] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [3.297]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=1852365840', errnum=205, errmsg='Unknown connect option (Set)' [3.297] ------------------------------------------------------------ [3.297] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [3.297] sock=03B37B38, stmts=03B39C58, lobj_type=14939 [3.297] ---------------- Socket Info ------------------------------- [3.297] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [3.297] buffer_in=62094336, buffer_out=62098440 [3.297] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [3.391]conn=03B34FD8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [3.656] [ fetched 9 rows ] [5.781]conn=03B34FD8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like E'%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [6.063] [ fetched 9 rows ] [7.610]conn=03B34FD8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like E'New_Generic_JDBC_0_' and relname like E'%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [7.797] [ fetched 6 rows ] [9.344]conn=03B34FD8, query='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [9.375]ERROR from backend during send_query: 'SERROR' [9.375]ERROR from backend during send_query: 'C50000' [9.375]ERROR from backend during send_query: 'MLexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [9.375]ERROR from backend during send_query: 'Dorg.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [9.531]STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query' [9.531] ------------------------------------------------------------ [9.531] hdbc=03B34FD8, stmt=03B3A288, result=03B3DD78 [9.547] prepare=8, internal=0 [9.547] bindings=03B3DAA0, bindings_allocated=5 [9.547] parameters=00000000, parameters_allocated=0 [9.547] statement_type=0, statement='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [9.563] stmt_with_params='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [9.563] data_at_exec=-1, current_exec_param=-1, put_data=0 [9.563] currTuple=-1, current_col=-1, lobj_fd=-1 [9.563] maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 [9.578] cursor_name='SQL_CUR03B3A288' [9.578] ----------------QResult Info ------------------------------- [9.578] fields=03B328B0, backend_tuples=00000000, tupleField=0, conn=00000000 [9.578] fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)' [9.578] message='ERROR: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : "" org.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""', command='(NULL)', notice='(NULL)' [9.578] status=7, inTuples=0 [9.578]CONN ERROR: func=SC_execute, desc='(null)', errnum=110, errmsg='ERROR: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : "" org.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [9.594] ------------------------------------------------------------ [9.594] henv=03B34FA8, conn=03B34FD8, status=1, num_stmts=16 [9.594] sock=03B37B38, stmts=03B39C58, lobj_type=14939 [9.594] ---------------- Socket Info ------------------------------- [9.594] socket=440, reverse=0, errornumber=0, errormsg='(NULL)' [9.594] buffer_in=62094336, buffer_out=62098440 [9.594] buffer_filled_in=6, buffer_filled_out=0, buffer_read_in=6 [13.250]conn=03B34FD8, PGAPI_Disconnect [0.015]conn=02A64FD8, PGAPI_DriverConnect( in)='DSN=PostgreSQL30-1;UID=admin;PWD=;', fDriverCompletion=0 [0.047]DSN info: DSN='PostgreSQL30-1',server='lonrs09064',port='35432',dbase='test',user='admin',passwd='xxxxx' [0.047] onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0' [0.047] conn_settings='', conn_encoding='(null)' [0.047] translation_dll='',translation_option='' [0.062]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library [0.062]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [0.062] disable_optimizer=0, ksqo=0, unique_index=1, use_declarefetch=0 [0.062] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [0.062] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [0.328] [ PostgreSQL version string = '8.1.4' ] [0.328] [ PostgreSQL version number = '8.1' ] [0.359]conn=02A64FD8, query='select oid, typbasetype from pg_type where typname = 'lo'' [0.547] [ fetched 1 rows ] [0.562] [ Large Object oid = 14939 ] [0.562]conn=02A64FD8, query='set client_encoding to 'WIN1252'' [0.765] [ fetched 1 rows ] [0.781]conn=02A64FD8, PGAPI_DriverConnect(out)='DSN=PostgreSQL30-1;DATABASE=test;SERVER=lonrs09064;PORT=35432;UID=admin;PWD=xxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b3051cbb;A1=7.4-1' [0.797]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [0.812] ------------------------------------------------------------ [0.812] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [0.812] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [0.812] ---------------- Socket Info ------------------------------- [0.812] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [0.812] buffer_in=44465152, buffer_out=44469256 [0.812] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.812]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=1852365868', errnum=205, errmsg='Unknown connect option (Set)' [0.812] ------------------------------------------------------------ [0.828] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [0.828] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [0.828] ---------------- Socket Info ------------------------------- [0.828] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [0.828] buffer_in=44465152, buffer_out=44469256 [0.828] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.828]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [0.828] ------------------------------------------------------------ [0.843] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [0.843] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [0.843] ---------------- Socket Info ------------------------------- [0.843] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [0.843] buffer_in=44465152, buffer_out=44469256 [0.843] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.843]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=1852365840', errnum=205, errmsg='Unknown connect option (Set)' [0.843] ------------------------------------------------------------ [0.843] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [0.859] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [0.859] ---------------- Socket Info ------------------------------- [0.859] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [0.859] buffer_in=44465152, buffer_out=44469256 [0.859] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [0.922]conn=02A64FD8, PGAPI_Disconnect [1.890]conn=02A64FD8, PGAPI_DriverConnect( in)='DSN=PostgreSQL30-1;UID=admin;PWD=;', fDriverCompletion=0 [1.906]DSN info: DSN='PostgreSQL30-1',server='lonrs09064',port='35432',dbase='test',user='admin',passwd='xxxxx' [1.906] onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0' [1.922] conn_settings='', conn_encoding='(null)' [1.922] translation_dll='',translation_option='' [1.937]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library [1.937]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [1.937] disable_optimizer=0, ksqo=0, unique_index=1, use_declarefetch=0 [1.937] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [1.937] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [2.187] [ PostgreSQL version string = '8.1.4' ] [2.187] [ PostgreSQL version number = '8.1' ] [2.203]conn=02A64FD8, query='select oid, typbasetype from pg_type where typname = 'lo'' [2.297] [ fetched 1 rows ] [2.312] [ Large Object oid = 14939 ] [2.312]conn=02A64FD8, query='set client_encoding to 'WIN1252'' [2.515] [ fetched 1 rows ] [2.531]conn=02A64FD8, PGAPI_DriverConnect(out)='DSN=PostgreSQL30-1;DATABASE=test;SERVER=lonrs09064;PORT=35432;UID=admin;PWD=xxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b3051cbb;A1=7.4-1' [2.562]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [2.562] ------------------------------------------------------------ [2.562] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [2.562] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [2.562] ---------------- Socket Info ------------------------------- [2.562] socket=692, reverse=0, errornumber=0, errormsg='(NULL)' [2.562] buffer_in=44465152, buffer_out=44469256 [2.562] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [2.562]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=1852365868', errnum=205, errmsg='Unknown connect option (Set)' [2.578] ------------------------------------------------------------ [2.578] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [2.578] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [2.578] ---------------- Socket Info ------------------------------- [2.578] socket=692, reverse=0, errornumber=0, errormsg='(NULL)' [2.578] buffer_in=44465152, buffer_out=44469256 [2.578] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [2.578]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [2.593] ------------------------------------------------------------ [2.593] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [2.593] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [2.593] ---------------- Socket Info ------------------------------- [2.593] socket=692, reverse=0, errornumber=0, errormsg='(NULL)' [2.593] buffer_in=44465152, buffer_out=44469256 [2.593] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [2.593]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=1852365840', errnum=205, errmsg='Unknown connect option (Set)' [2.609] ------------------------------------------------------------ [2.609] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [2.609] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [2.609] ---------------- Socket Info ------------------------------- [2.609] socket=692, reverse=0, errornumber=0, errormsg='(NULL)' [2.609] buffer_in=44465152, buffer_out=44469256 [2.609] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [2.703]conn=02A64FD8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [2.875] [ fetched 9 rows ] [4.578]conn=02A64FD8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like E'%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [4.843] [ fetched 9 rows ] [7.078]conn=02A64FD8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like E'New_Generic_JDBC_0_' and relname like E'%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [7.234] [ fetched 6 rows ] [8.828]conn=02A64FD8, query='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [8.859]ERROR from backend during send_query: 'SERROR' [8.859]ERROR from backend during send_query: 'C50000' [8.859]ERROR from backend during send_query: 'MLexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [8.875]ERROR from backend during send_query: 'Dorg.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [9.078]STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query' [9.078] ------------------------------------------------------------ [9.078] hdbc=02A64FD8, stmt=02A62720, result=02A6B4C0 [9.093] prepare=8, internal=0 [9.093] bindings=02A6BC78, bindings_allocated=5 [9.093] parameters=00000000, parameters_allocated=0 [9.093] statement_type=0, statement='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [9.093] stmt_with_params='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [9.109] data_at_exec=-1, current_exec_param=-1, put_data=0 [9.109] currTuple=-1, current_col=-1, lobj_fd=-1 [9.109] maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 [9.109] cursor_name='SQL_CUR02A62720' [9.109] ----------------QResult Info ------------------------------- [9.109] fields=02A6BA58, backend_tuples=00000000, tupleField=0, conn=00000000 [9.125] fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)' [9.125] message='ERROR: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : "" org.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""', command='(NULL)', notice='(NULL)' [9.125] status=7, inTuples=0 [9.125]CONN ERROR: func=SC_execute, desc='(null)', errnum=110, errmsg='ERROR: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : "" org.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [9.140] ------------------------------------------------------------ [9.140] henv=02A64FA8, conn=02A64FD8, status=1, num_stmts=16 [9.140] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [9.140] ---------------- Socket Info ------------------------------- [9.140] socket=692, reverse=0, errornumber=0, errormsg='(NULL)' [9.140] buffer_in=44465152, buffer_out=44469256 [9.140] buffer_filled_in=6, buffer_filled_out=0, buffer_read_in=6 [12.562]conn=02A64FD8, PGAPI_Disconnect [110.187]conn=02A64FA8, PGAPI_DriverConnect( in)='DSN=PostgreSQL30-1;UID=admin;PWD=;', fDriverCompletion=0 [110.203]DSN info: DSN='PostgreSQL30-1',server='lonrs09064',port='35432',dbase='test',user='admin',passwd='xxxxx' [110.203] onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0' [110.218] conn_settings='', conn_encoding='(null)' [110.218] translation_dll='',translation_option='' [110.218]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library [110.234]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [110.234] disable_optimizer=0, ksqo=0, unique_index=1, use_declarefetch=0 [110.234] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [110.234] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [110.468] [ PostgreSQL version string = '8.1.4' ] [110.468] [ PostgreSQL version number = '8.1' ] [110.484]conn=02A64FA8, query='select oid, typbasetype from pg_type where typname = 'lo'' [110.687] [ fetched 1 rows ] [110.703] [ Large Object oid = 14939 ] [110.703]conn=02A64FA8, query='set client_encoding to 'WIN1252'' [110.906] [ fetched 1 rows ] [110.922]conn=02A64FA8, PGAPI_DriverConnect(out)='DSN=PostgreSQL30-1;DATABASE=test;SERVER=lonrs09064;PORT=35432;UID=admin;PWD=xxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b3051cbb;A1=7.4-1' [110.953]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [110.953] ------------------------------------------------------------ [110.953] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [110.953] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [110.953] ---------------- Socket Info ------------------------------- [110.953] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [110.953] buffer_in=44475576, buffer_out=44465152 [110.953] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [110.953]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=1852365868', errnum=205, errmsg='Unknown connect option (Set)' [110.968] ------------------------------------------------------------ [110.968] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [110.968] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [110.968] ---------------- Socket Info ------------------------------- [110.968] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [110.968] buffer_in=44475576, buffer_out=44465152 [110.968] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [110.984]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [110.984] ------------------------------------------------------------ [110.984] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [110.984] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [110.984] ---------------- Socket Info ------------------------------- [110.984] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [110.984] buffer_in=44475576, buffer_out=44465152 [110.984] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [110.984]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=1852365840', errnum=205, errmsg='Unknown connect option (Set)' [111.000] ------------------------------------------------------------ [111.000] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [111.000] sock=02A67B38, stmts=02A69C10, lobj_type=14939 [111.000] ---------------- Socket Info ------------------------------- [111.000] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [111.000] buffer_in=44475576, buffer_out=44465152 [111.000] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [111.062]conn=02A64FA8, PGAPI_Disconnect [117.437]conn=02A64FA8, PGAPI_DriverConnect( in)='DSN=PostgreSQL30-1;UID=admin;PWD=;', fDriverCompletion=0 [117.468]DSN info: DSN='PostgreSQL30-1',server='lonrs09064',port='35432',dbase='test',user='admin',passwd='xxxxx' [117.468] onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0' [117.468] conn_settings='', conn_encoding='(null)' [117.468] translation_dll='',translation_option='' [117.484]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library [117.484]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [117.484] disable_optimizer=0, ksqo=0, unique_index=1, use_declarefetch=0 [117.484] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64 [117.484] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='' [117.687] [ PostgreSQL version string = '8.1.4' ] [117.687] [ PostgreSQL version number = '8.1' ] [117.703]conn=02A64FA8, query='select oid, typbasetype from pg_type where typname = 'lo'' [117.906] [ fetched 1 rows ] [117.922] [ Large Object oid = 14939 ] [117.922]conn=02A64FA8, query='set client_encoding to 'WIN1252'' [118.125] [ fetched 1 rows ] [118.140]conn=02A64FA8, PGAPI_DriverConnect(out)='DSN=PostgreSQL30-1;DATABASE=test;SERVER=lonrs09064;PORT=35432;UID=admin;PWD=xxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1b3051cbb;A1=7.4-1' [118.156]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [118.172] ------------------------------------------------------------ [118.172] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [118.172] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [118.172] ---------------- Socket Info ------------------------------- [118.172] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [118.172] buffer_in=44475576, buffer_out=44465152 [118.172] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [118.172]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=1852365868', errnum=205, errmsg='Unknown connect option (Set)' [118.172] ------------------------------------------------------------ [118.187] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [118.187] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [118.187] ---------------- Socket Info ------------------------------- [118.187] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [118.187] buffer_in=44475576, buffer_out=44465152 [118.187] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [118.187]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)' [118.187] ------------------------------------------------------------ [118.203] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [118.203] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [118.203] ---------------- Socket Info ------------------------------- [118.203] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [118.203] buffer_in=44475576, buffer_out=44465152 [118.203] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [118.203]CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=1852365840', errnum=205, errmsg='Unknown connect option (Set)' [118.203] ------------------------------------------------------------ [118.203] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [118.203] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [118.218] ---------------- Socket Info ------------------------------- [118.218] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [118.218] buffer_in=44475576, buffer_out=44465152 [118.218] buffer_filled_in=32, buffer_filled_out=0, buffer_read_in=32 [118.312]conn=02A64FA8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [118.484] [ fetched 9 rows ] [123.578]conn=02A64FA8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like E'%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [123.843] [ fetched 9 rows ] [126.656]conn=02A64FA8, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like E'New_Generic_JDBC_0_' and relname like E'%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname' [126.890] [ fetched 6 rows ] [128.609]conn=02A64FA8, query='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [128.640]ERROR from backend during send_query: 'SERROR' [128.640]ERROR from backend during send_query: 'C50000' [128.640]ERROR from backend during send_query: 'MLexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [128.640]ERROR from backend during send_query: 'Dorg.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [128.843]STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query' [128.843] ------------------------------------------------------------ [128.843] hdbc=02A64FA8, stmt=02A62720, result=02A6B4C0 [128.859] prepare=8, internal=0 [128.859] bindings=02A6BC78, bindings_allocated=5 [128.859] parameters=00000000, parameters_allocated=0 [128.859] statement_type=0, statement='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [128.875] stmt_with_params='select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'MI_PROD_DWH_CORT_O.WH_DAY_DIM' AND n.nspname = E'New_Generic_JDBC_0_' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum' [128.875] data_at_exec=-1, current_exec_param=-1, put_data=0 [128.875] currTuple=-1, current_col=-1, lobj_fd=-1 [128.875] maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 [128.890] cursor_name='SQL_CUR02A62720' [128.890] ----------------QResult Info ------------------------------- [128.890] fields=02A62A50, backend_tuples=00000000, tupleField=0, conn=00000000 [128.890] fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)' [128.890] message='ERROR: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : "" org.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""', command='(NULL)', notice='(NULL)' [128.890] status=7, inTuples=0 [128.890]CONN ERROR: func=SC_execute, desc='(null)', errnum=110, errmsg='ERROR: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : "" org.teiid.jdbc.TeiidSQLException: Lexical error: Lexical error at line 1, column 473. Encountered: "[" (91), after : ""' [128.906] ------------------------------------------------------------ [128.906] henv=02A6B978, conn=02A64FA8, status=1, num_stmts=16 [128.906] sock=02A67B38, stmts=02A69C58, lobj_type=14939 [128.906] ---------------- Socket Info ------------------------------- [128.906] socket=700, reverse=0, errornumber=0, errormsg='(NULL)' [128.906] buffer_in=44475576, buffer_out=44465152 [128.906] buffer_filled_in=6, buffer_filled_out=0, buffer_read_in=6 [150.453]conn=02A64FA8, PGAPI_Disconnect