API tools faq
paste
Advertisement
keith_shannon

Oracle Trace #1

keith_shannon
Jul 13th, 2012
506
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 59.92 KB | None | 0 0
raw download clone embed print report
  1. Oracle Corporation --- FRIDAY    JUL 13 2012 07:57:44.730
  2.  
  3.  
  4. Heterogeneous Agent RELEASE
  5. 11.2.0.3.0
  6.  
  7.  
  8.  
  9.  
  10. Oracle Corporation --- FRIDAY    JUL 13 2012 07:57:44.730
  11.  
  12.     Version 11.2.0.3.0
  13.  
  14. Entered hgogprd
  15. HOSGIP FOR "HS_FDS_TRACE_LEVEL" returned "255"
  16. Entered hgosdip
  17.  setting HS_OPEN_CURSORS TO DEFAULT OF 50
  18.  setting HS_FDS_RECOVERY_ACCOUNT TO DEFAULT OF "RECOVER"
  19.  setting HS_FDS_RECOVERY_PWD TO DEFAULT VALUE
  20.  setting HS_FDS_TRANSACTION_LOG TO DEFAULT OF HS_TRANSACTION_LOG
  21.  setting HS_IDLE_TIMEOUT TO DEFAULT OF 0
  22.  setting HS_FDS_TRANSACTION_ISOLATION TO DEFAULT OF "READ_COMMITTED"
  23.  setting HS_NLS_NCHAR TO DEFAULT OF "AL32UTF8"
  24.  setting HS_FDS_TIMESTAMP_MAPPING TO DEFAULT OF "DATE"
  25.  setting HS_FDS_DATE_MAPPING TO DEFAULT OF "DATE"
  26.  setting HS_RPC_FETCH_REBLOCKING TO DEFAULT OF "ON"
  27.  setting HS_FDS_FETCH_ROWS TO DEFAULT OF "100"
  28.  setting HS_FDS_RESULTSET_SUPPORT TO DEFAULT OF "FALSE"
  29.  setting HS_FDS_RSET_RETURN_ROWCOUNT TO DEFAULT OF "FALSE"
  30.  setting HS_FDS_PROC_IS_FUNC TO DEFAULT OF "FALSE"
  31.  setting HS_FDS_MAP_NCHAR TO DEFAULT OF "TRUE"
  32.  setting HS_NLS_DATE_FORMAT TO DEFAULT OF "YYYY-MM-DD HH24:MI:SS"
  33.  setting HS_FDS_REPORT_REAL_AS_DOUBLE TO DEFAULT OF "FALSE"
  34.  setting HS_LONG_PIECE_TRANSFER_SIZE TO DEFAULT OF "65536"
  35.  setting HS_SQL_HANDLE_STMT_REUSE TO DEFAULT OF "FALSE"
  36.  setting HS_FDS_QUERY_DRIVER TO DEFAULT OF "TRUE"
  37.  setting HS_FDS_SUPPORT_STATISTICS TO DEFAULT OF "FALSE"
  38.  setting HS_FDS_QUOTE_IDENTIFIER TO DEFAULT OF "TRUE"
  39.  setting HS_KEEP_REMOTE_COLUMN_SIZE TO DEFAULT OF "OFF"
  40.  setting HS_FDS_GRAPHIC_TO_MBCS TO DEFAULT OF "FALSE"
  41.  setting HS_FDS_MBCS_TO_GRAPHIC TO DEFAULT OF "FALSE"
  42.  HOSGIP returned VALUE OF "32" FOR HS_FDS_SQLLEN_INTERPRETATION
  43.  setting HS_CALL_NAME_ISP TO "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
  44.  setting HS_FDS_DELAYED_OPEN TO DEFAULT OF "TRUE"
  45.  setting HS_FDS_WORKAROUNDS TO DEFAULT OF "0"
  46. Exiting hgosdip, rc=0
  47.  ORACLE_SID IS "VDP_acme_DSN"
  48.  Product-Info:
  49.   Port Rls/Upd:3/0 PrdStat:0
  50.   Agent:Oracle DATABASE Gateway FOR ODBC
  51.   Facility:hsa
  52.   Class:ODBC, ClassVsn:11.2.0.3.0_0011, Instance:VDP_acme_DSN
  53. Exiting hgogprd, rc=0
  54. hostmstr:          0:   HOA After hoagprd
  55. hostmstr:          0:   HOA Before hoainit
  56. Entered hgoinit
  57. HOCXU_COMP_CSET=1
  58. HOCXU_DRV_CSET=178
  59. HOCXU_DRV_NCHAR=873
  60. HOCXU_DB_CSET=873
  61. HS_LANGUAGE IS american_america.we8mswin1252
  62. LANG=en_US.UTF-8
  63. HOCXU_SEM_VER=112000
  64. Entered hgolofn AT 2012/07/13-07:57:44
  65. HOSGIP FOR "HS_FDS_SHAREABLE_NAME" returned "/usr/local/lib/libodbc.so"
  66. Entered hgolofns AT 2012/07/13-07:57:44
  67.  libname=/usr/local/lib/libodbc.so, funcname=SQLAllocHandle
  68.  symbol_peflctx=0xaaad6350
  69.  hoaerr:0
  70. Exiting hgolofns AT 2012/07/13-07:57:44
  71. Entered hgolofns AT 2012/07/13-07:57:44
  72.  libname=/usr/local/lib/libodbc.so, funcname=SQLBindCol
  73.  symbol_peflctx=0xaaad6480
  74.  hoaerr:0
  75. Exiting hgolofns AT 2012/07/13-07:57:44
  76. Entered hgolofns AT 2012/07/13-07:57:44
  77.  libname=/usr/local/lib/libodbc.so, funcname=SQLBindParameter
  78.  symbol_peflctx=0xaaad6c60
  79.  hoaerr:0
  80. Exiting hgolofns AT 2012/07/13-07:57:44
  81. Entered hgolofns AT 2012/07/13-07:57:44
  82.  libname=/usr/local/lib/libodbc.so, funcname=SQLCancel
  83.  symbol_peflctx=0xaaad7f10
  84.  hoaerr:0
  85. Exiting hgolofns AT 2012/07/13-07:57:44
  86. Entered hgolofns AT 2012/07/13-07:57:44
  87.  libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeParam
  88.  symbol_peflctx=0xaaadf5e0
  89.  hoaerr:0
  90. Exiting hgolofns AT 2012/07/13-07:57:44
  91. Entered hgolofns AT 2012/07/13-07:57:44
  92.  libname=/usr/local/lib/libodbc.so, funcname=SQLDisconnect
  93.  symbol_peflctx=0xaaadfa20
  94.  hoaerr:0
  95. Exiting hgolofns AT 2012/07/13-07:57:44
  96. Entered hgolofns AT 2012/07/13-07:57:44
  97.  libname=/usr/local/lib/libodbc.so, funcname=SQLEndTran
  98.  symbol_peflctx=0xaaae2020
  99.  hoaerr:0
  100. Exiting hgolofns AT 2012/07/13-07:57:44
  101. Entered hgolofns AT 2012/07/13-07:57:44
  102.  libname=/usr/local/lib/libodbc.so, funcname=SQLExecute
  103.  symbol_peflctx=0xaaae33b0
  104.  hoaerr:0
  105. Exiting hgolofns AT 2012/07/13-07:57:44
  106. Entered hgolofns AT 2012/07/13-07:57:44
  107.  libname=/usr/local/lib/libodbc.so, funcname=SQLFetch
  108.  symbol_peflctx=0xaaae3b20
  109.  hoaerr:0
  110. Exiting hgolofns AT 2012/07/13-07:57:44
  111. Entered hgolofns AT 2012/07/13-07:57:44
  112.  libname=/usr/local/lib/libodbc.so, funcname=SQLFreeHandle
  113.  symbol_peflctx=0xaaae5420
  114.  hoaerr:0
  115. Exiting hgolofns AT 2012/07/13-07:57:44
  116. Entered hgolofns AT 2012/07/13-07:57:44
  117.  libname=/usr/local/lib/libodbc.so, funcname=SQLFreeStmt
  118.  symbol_peflctx=0xaaae5440
  119.  hoaerr:0
  120. Exiting hgolofns AT 2012/07/13-07:57:44
  121. Entered hgolofns AT 2012/07/13-07:57:44
  122.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetData
  123.  symbol_peflctx=0xaaae69f0
  124.  hoaerr:0
  125. Exiting hgolofns AT 2012/07/13-07:57:44
  126. Entered hgolofns AT 2012/07/13-07:57:44
  127.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetEnvAttr
  128.  symbol_peflctx=0xaaae99b0
  129.  hoaerr:0
  130. Exiting hgolofns AT 2012/07/13-07:57:44
  131. Entered hgolofns AT 2012/07/13-07:57:44
  132.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetFunctions
  133.  symbol_peflctx=0xaaae9d10
  134.  hoaerr:0
  135. Exiting hgolofns AT 2012/07/13-07:57:44
  136. Entered hgolofns AT 2012/07/13-07:57:44
  137.  libname=/usr/local/lib/libodbc.so, funcname=SQLMoreResults
  138.  symbol_peflctx=0xaaaeb660
  139.  hoaerr:0
  140. Exiting hgolofns AT 2012/07/13-07:57:44
  141. Entered hgolofns AT 2012/07/13-07:57:44
  142.  libname=/usr/local/lib/libodbc.so, funcname=SQLNumResultCols
  143.  symbol_peflctx=0xaaaec1a0
  144.  hoaerr:0
  145. Exiting hgolofns AT 2012/07/13-07:57:44
  146. Entered hgolofns AT 2012/07/13-07:57:44
  147.  libname=/usr/local/lib/libodbc.so, funcname=SQLParamData
  148.  symbol_peflctx=0xaaaec450
  149.  hoaerr:0
  150. Exiting hgolofns AT 2012/07/13-07:57:44
  151. Entered hgolofns AT 2012/07/13-07:57:44
  152.  libname=/usr/local/lib/libodbc.so, funcname=SQLPutData
  153.  symbol_peflctx=0xaaaee160
  154.  hoaerr:0
  155. Exiting hgolofns AT 2012/07/13-07:57:44
  156. Entered hgolofns AT 2012/07/13-07:57:44
  157.  libname=/usr/local/lib/libodbc.so, funcname=SQLRowCount
  158.  symbol_peflctx=0xaaaee4f0
  159.  hoaerr:0
  160. Exiting hgolofns AT 2012/07/13-07:57:44
  161. Entered hgolofns AT 2012/07/13-07:57:44
  162.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetEnvAttr
  163.  symbol_peflctx=0xaaaeff50
  164.  hoaerr:0
  165. Exiting hgolofns AT 2012/07/13-07:57:44
  166. Entered hgolofns AT 2012/07/13-07:57:44
  167.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescRec
  168.  symbol_peflctx=0xaaaefda0
  169.  hoaerr:0
  170. Exiting hgolofns AT 2012/07/13-07:57:44
  171. Entered hgolofns AT 2012/07/13-07:57:44
  172.  libname=/usr/local/lib/libodbc.so, funcname=SQLColAttribute
  173.  symbol_peflctx=0xaaad84a0
  174.  hoaerr:0
  175. Exiting hgolofns AT 2012/07/13-07:57:44
  176. Entered hgolofns AT 2012/07/13-07:57:44
  177.  libname=/usr/local/lib/libodbc.so, funcname=SQLColumns
  178.  symbol_peflctx=0xaaad9ba0
  179.  hoaerr:0
  180. Exiting hgolofns AT 2012/07/13-07:57:44
  181. Entered hgolofns AT 2012/07/13-07:57:44
  182.  libname=/usr/local/lib/libodbc.so, funcname=SQLConnect
  183.  symbol_peflctx=0xaaadd390
  184.  hoaerr:0
  185. Exiting hgolofns AT 2012/07/13-07:57:44
  186. Entered hgolofns AT 2012/07/13-07:57:44
  187.  libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeCol
  188.  symbol_peflctx=0xaaadeef0
  189.  hoaerr:0
  190. Exiting hgolofns AT 2012/07/13-07:57:44
  191. Entered hgolofns AT 2012/07/13-07:57:44
  192.  libname=/usr/local/lib/libodbc.so, funcname=SQLDriverConnect
  193.  symbol_peflctx=0xaaae03e0
  194.  hoaerr:0
  195. Exiting hgolofns AT 2012/07/13-07:57:44
  196. Entered hgolofns AT 2012/07/13-07:57:44
  197.  libname=/usr/local/lib/libodbc.so, funcname=SQLExecDirect
  198.  symbol_peflctx=0xaaae2e80
  199.  hoaerr:0
  200. Exiting hgolofns AT 2012/07/13-07:57:44
  201. Entered hgolofns AT 2012/07/13-07:57:44
  202.  libname=/usr/local/lib/libodbc.so, funcname=SQLForeignKeys
  203.  symbol_peflctx=0xaaae43b0
  204.  hoaerr:0
  205. Exiting hgolofns AT 2012/07/13-07:57:44
  206. Entered hgolofns AT 2012/07/13-07:57:44
  207.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetConnectAttr
  208.  symbol_peflctx=0xaaae5750
  209.  hoaerr:0
  210. Exiting hgolofns AT 2012/07/13-07:57:44
  211. Entered hgolofns AT 2012/07/13-07:57:44
  212.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDescField
  213.  symbol_peflctx=0xaaae7060
  214.  hoaerr:0
  215. Exiting hgolofns AT 2012/07/13-07:57:44
  216. Entered hgolofns AT 2012/07/13-07:57:44
  217.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDescRec
  218.  symbol_peflctx=0xaaae74e0
  219.  hoaerr:0
  220. Exiting hgolofns AT 2012/07/13-07:57:44
  221. Entered hgolofns AT 2012/07/13-07:57:44
  222.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagField
  223.  symbol_peflctx=0xaaae8630
  224.  hoaerr:0
  225. Exiting hgolofns AT 2012/07/13-07:57:44
  226. Entered hgolofns AT 2012/07/13-07:57:44
  227.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagRec
  228.  symbol_peflctx=0xaaae9230
  229.  hoaerr:0
  230. Exiting hgolofns AT 2012/07/13-07:57:44
  231. Entered hgolofns AT 2012/07/13-07:57:44
  232.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetInfo
  233.  symbol_peflctx=0xaaae9f00
  234.  hoaerr:0
  235. Exiting hgolofns AT 2012/07/13-07:57:44
  236. Entered hgolofns AT 2012/07/13-07:57:44
  237.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetStmtAttr
  238.  symbol_peflctx=0xaaaea8f0
  239.  hoaerr:0
  240. Exiting hgolofns AT 2012/07/13-07:57:44
  241. Entered hgolofns AT 2012/07/13-07:57:44
  242.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetTypeInfo
  243.  symbol_peflctx=0xaaaeb300
  244.  hoaerr:0
  245. Exiting hgolofns AT 2012/07/13-07:57:44
  246. Entered hgolofns AT 2012/07/13-07:57:44
  247.  libname=/usr/local/lib/libodbc.so, funcname=SQLPrepare
  248.  symbol_peflctx=0xaaaecb80
  249.  hoaerr:0
  250. Exiting hgolofns AT 2012/07/13-07:57:44
  251. Entered hgolofns AT 2012/07/13-07:57:44
  252.  libname=/usr/local/lib/libodbc.so, funcname=SQLPrimaryKeys
  253.  symbol_peflctx=0xaaaed060
  254.  hoaerr:0
  255. Exiting hgolofns AT 2012/07/13-07:57:44
  256. Entered hgolofns AT 2012/07/13-07:57:44
  257.  libname=/usr/local/lib/libodbc.so, funcname=SQLProcedureColumns
  258.  symbol_peflctx=0xaaaed5d0
  259.  hoaerr:0
  260. Exiting hgolofns AT 2012/07/13-07:57:44
  261. Entered hgolofns AT 2012/07/13-07:57:44
  262.  libname=/usr/local/lib/libodbc.so, funcname=SQLProcedures
  263.  symbol_peflctx=0xaaaedc00
  264.  hoaerr:0
  265. Exiting hgolofns AT 2012/07/13-07:57:44
  266. Entered hgolofns AT 2012/07/13-07:57:44
  267.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetConnectAttr
  268.  symbol_peflctx=0xaaaee790
  269.  hoaerr:0
  270. Exiting hgolofns AT 2012/07/13-07:57:44
  271. Entered hgolofns AT 2012/07/13-07:57:44
  272.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetStmtAttr
  273.  symbol_peflctx=0xaaaf1250
  274.  hoaerr:0
  275. Exiting hgolofns AT 2012/07/13-07:57:44
  276. Entered hgolofns AT 2012/07/13-07:57:44
  277.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescField
  278.  symbol_peflctx=0xaaaefa60
  279.  hoaerr:0
  280. Exiting hgolofns AT 2012/07/13-07:57:44
  281. Entered hgolofns AT 2012/07/13-07:57:44
  282.  libname=/usr/local/lib/libodbc.so, funcname=SQLStatistics
  283.  symbol_peflctx=0xaaaf2a60
  284.  hoaerr:0
  285. Exiting hgolofns AT 2012/07/13-07:57:44
  286. Entered hgolofns AT 2012/07/13-07:57:44
  287.  libname=/usr/local/lib/libodbc.so, funcname=SQLTables
  288.  symbol_peflctx=0xaaaf3650
  289.  hoaerr:0
  290. Exiting hgolofns AT 2012/07/13-07:57:44
  291. Exiting hgolofn, rc=0 AT 2012/07/13-07:57:44
  292. HOSGIP FOR "HS_OPEN_CURSORS" returned "50"
  293. HOSGIP FOR "HS_FDS_FETCH_ROWS" returned "100"
  294. HOSGIP FOR "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
  295. HOSGIP FOR "HS_NLS_NUMERIC_CHARACTER" returned ".,"
  296. HOSGIP FOR "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
  297. HOSGIP FOR "HS_FDS_DELAYED_OPEN" returned "TRUE"
  298. HOSGIP FOR "HS_FDS_WORKAROUNDS" returned "0"
  299. HOSGIP FOR "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
  300. HOSGIP FOR "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
  301. treat_SQLLEN_as_compiled = 0
  302. Exiting hgoinit, rc=0 AT 2012/07/13-07:57:44
  303. hostmstr:          0:   HOA After hoainit
  304. hostmstr:          0:   HOA Before hoalgon
  305. Entered hgolgon AT 2012/07/13-07:57:44
  306.  reco:0, name:ADMIN, tflag:0
  307. Entered hgosuec AT 2012/07/13-07:57:44
  308. Exiting hgosuec, rc=0 AT 2012/07/13-07:57:44
  309. HOSGIP FOR "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
  310. HOSGIP FOR "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
  311. HOSGIP FOR "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
  312. HOSGIP FOR "HS_FDS_DATE_MAPPING" returned "DATE"
  313. HOSGIP FOR "HS_FDS_MAP_NCHAR" returned "TRUE"
  314. HOSGIP FOR "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
  315. HOSGIP FOR "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
  316. HOSGIP FOR "HS_FDS_PROC_IS_FUNC" returned "FALSE"
  317. HOSGIP FOR "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
  318.  USING ADMIN AS DEFAULT VALUE FOR "HS_FDS_DEFAULT_OWNER"
  319. HOSGIP FOR "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
  320. Entered hgocont AT 2012/07/13-07:57:44
  321.  HS_FDS_CONNECT_INFO = "VDP_acme_DSN"
  322.  RC=-1 FROM HOSGIP FOR "HS_FDS_CONNECT_STRING"
  323. Entered hgogenconstr AT 2012/07/13-07:57:44
  324.  dsn:VDP_acme_DSN, name:ADMIN
  325.  optn:
  326. Entered hgocip AT 2012/07/13-07:57:44
  327.  dsn:VDP_acme_DSN
  328. Exiting hgocip, rc=0 AT 2012/07/13-07:57:44
  329. ##>CONNECT Parameters (len=36)<##
  330. ## DSN=VDP_acme_DSN;
  331. #! UID=ADMIN;
  332. #! PWD=*
  333. Exiting hgogenconstr, rc=0 AT 2012/07/13-07:57:44
  334. Entered hgolosf AT 2012/07/13-07:57:44
  335. ODBC Function-Available-ARRAY 0xFFFE 0x00FF 0xFF00 0xFA7F 0x03FF 0x0000
  336.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  337.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  338.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  339.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  340.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  341.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  342.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  343.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  344.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  345.                               0x0000 0x0000 0xFE00 0x3B5D
  346. Exiting hgolosf, rc=0 AT 2012/07/13-07:57:44
  347. DriverName:psqlodbcw.so, DriverVer:09.01.0100
  348. DBMS Name:PostgreSQL, DBMS Version:8.1.4
  349. Exiting hgocont, rc=0 AT 2012/07/13-07:57:44
  350. SQLGetInfo returns Y FOR SQL_CATALOG_NAME
  351. SQLGetInfo returns 0 FOR SQL_MAX_CATALOG_NAME_LEN
  352. Exiting hgolgon, rc=0 AT 2012/07/13-07:57:44
  353. hostmstr:          0:   HOA After hoalgon
  354. RPC Calling nscontrol(0), rc=0
  355. hostmstr:          0: RPC Before Upload Caps
  356. hostmstr:          0:   HOA Before hoaulcp
  357. Entered hgoulcp AT 2012/07/13-07:57:44
  358. Entered hgowlst AT 2012/07/13-07:57:44
  359. Exiting hgowlst, rc=0 AT 2012/07/13-07:57:44
  360. SQLGetInfo returns 0x1d FOR SQL_OWNER_USAGE
  361. TXN Capable:2, ISOLATION OPTION:0xa
  362. SQLGetInfo returns 64 FOR SQL_MAX_SCHEMA_NAME_LEN
  363. SQLGetInfo returns 64 FOR SQL_MAX_TABLE_NAME_LEN
  364. SQLGetInfo returns 0 FOR SQL_MAX_PROCEDURE_NAME_LEN
  365.  HOSGIP returned VALUE OF "TRUE" FOR HS_FDS_QUOTE_IDENTIFIER
  366. SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
  367. 2 instance capabilities will be uploaded
  368.  capno:1989, context:0x00000000, add-info:        0
  369.  capno:1992, context:0x0001ffff, add-info:        0
  370. Exiting hgoulcp, rc=0 at 2012/07/13-07:57:44
  371. hostmstr:          0:   HOA After hoaulcp
  372. hostmstr:          0: RPC After Upload Caps
  373. hostmstr:          0: RPC Before Upload DDTR
  374. hostmstr:          0:   HOA Before hoauldt
  375. Entered hgouldt at 2012/07/13-07:57:44
  376. NO instance DD translations were uploaded
  377. Exiting hgouldt, rc=0 at 2012/07/13-07:57:44
  378. hostmstr:          0:   HOA After hoauldt
  379. hostmstr:          0: RPC After Upload DDTR
  380. hostmstr:          0: RPC Before Begin Trans
  381. hostmstr:          0:   HOA Before hoabegn
  382. Entered hgobegn at 2012/07/13-07:57:44
  383. tflag:0 , initial:1
  384. hoi:0x2025b2a8, ttid (len 22) is ...
  385.  00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  386.  10: 382E3237 3833                        [8.2783]
  387.                 tbid (len 19) is ...
  388.  00: 45544C44 5B392E38 2E323738 335D5B31  [ETLD[9.8.2783][1]
  389.  10: 2E345D                               [.4]]
  390. Exiting hgobegn, rc=0 at 2012/07/13-07:57:44
  391. hostmstr:          0:   HOA After hoabegn
  392. hostmstr:          0: RPC After Begin Trans
  393. hostmstr:          0: RPC Before Describe Table
  394. hostmstr:          0:   HOA Before hoadtab
  395. Entered hgodtab at 2012/07/13-07:57:44
  396. count:1
  397.  table: ETLAPI_SFDC__STG_EMPLOYEE
  398. Allocate hoada[0] @ 0x3a4d2c0
  399. Entered hgopcda at 2012/07/13-07:57:44
  400. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  401. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  402. Entered hgopcda at 2012/07/13-07:57:44
  403. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  404. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  405. Entered hgopcda at 2012/07/13-07:57:44
  406. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  407. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  408. Entered hgopcda at 2012/07/13-07:57:44
  409. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  410. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  411. Entered hgopcda at 2012/07/13-07:57:44
  412. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  413. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  414. Entered hgopcda at 2012/07/13-07:57:44
  415. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  416. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  417. Entered hgopcda at 2012/07/13-07:57:44
  418. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  419. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  420. Entered hgopcda at 2012/07/13-07:57:44
  421. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  422. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  423. Entered hgopcda at 2012/07/13-07:57:44
  424. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  425. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  426. Entered hgopcda at 2012/07/13-07:57:44
  427. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  428. Exiting hgopcda, rc=0 at 2012/07/13-07:57:44
  429. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  430. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  431. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  432. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  433. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  434. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  435.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  436. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  437. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  438. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  439. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  440. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  441. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  442. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  443. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  444. Exiting hgodtab, rc=0 at 2012/07/13-07:57:44
  445. hostmstr:          0:   HOA After hoadtab
  446. hostmstr:          0:   HOA Before hoadafr
  447. Entered hgodafr, cursor id 0 at 2012/07/13-07:57:44
  448. Free hoada @ 0x3a4d2c0
  449. Exiting hgodafr, rc=0 at 2012/07/13-07:57:44
  450. hostmstr:          0:   HOA After hoadafr
  451. hostmstr:          0: RPC After Describe Table
  452. hostmstr:          0: RPC Before Commit Trans
  453. hostmstr:          0:   HOA Before hoacomm
  454. Entered hgocomm at 2012/07/13-07:57:45
  455. keepinfo:0, tflag:1
  456.   00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  457.   10: 382E3237 3833                        [8.2783]
  458.                 tbid (len 19) is ...
  459.   00: 45544C44 5B392E38 2E323738 335D5B31  [ETLD[9.8.2783][1]
  460.   10: 2E345D                               [.4]]
  461. cmt(0):
  462. Entered hgocpctx at 2012/07/13-07:57:45
  463. Exiting hgocpctx, rc=0 at 2012/07/13-07:57:45
  464. Exiting hgocomm, rc=0 at 2012/07/13-07:57:45
  465. hostmstr:          0:   HOA After hoacomm
  466. hostmstr:          0: RPC After Commit Trans
  467. hostmstr:          0: RPC Before Begin Trans
  468. hostmstr:          0:   HOA Before hoabegn
  469. Entered hgobegn at 2012/07/13-07:57:45
  470. tflag:0 , initial:0
  471. hoi:0x2025b2a8, ttid (len 23) is ...
  472.  00: 45544C44 2E636663 62656563 362E362E  [ETLD.cfcbeec6.6.]
  473.  10: 33322E31 383535                      [32.1855]
  474.                 tbid (len 20) is ...
  475.  00: 45544C44 5B362E33 322E3138 35355D5B  [ETLD[6.32.1855][]
  476.  10: 312E345D                             [1.4]]
  477. Exiting hgobegn, rc=0 at 2012/07/13-07:57:45
  478. hostmstr:          0:   HOA After hoabegn
  479. hostmstr:          0: RPC After Begin Trans
  480. hostmstr:          0: RPC Before Describe Table
  481. hostmstr:          0:   HOA Before hoadtab
  482. Entered hgodtab at 2012/07/13-07:57:45
  483. count:1
  484.  table: ETLAPI_SFDC__STG_EMPLOYEE
  485. Allocate hoada[0] @ 0x3a4d2c0
  486. Entered hgopcda at 2012/07/13-07:57:45
  487. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  488. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  489. Entered hgopcda at 2012/07/13-07:57:45
  490. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  491. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  492. Entered hgopcda at 2012/07/13-07:57:45
  493. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  494. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  495. Entered hgopcda at 2012/07/13-07:57:45
  496. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  497. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  498. Entered hgopcda at 2012/07/13-07:57:45
  499. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  500. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  501. Entered hgopcda at 2012/07/13-07:57:45
  502. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  503. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  504. Entered hgopcda at 2012/07/13-07:57:45
  505. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  506. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  507. Entered hgopcda at 2012/07/13-07:57:45
  508. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  509. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  510. Entered hgopcda at 2012/07/13-07:57:45
  511. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  512. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  513. Entered hgopcda at 2012/07/13-07:57:45
  514. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  515. Exiting hgopcda, rc=0 at 2012/07/13-07:57:45
  516. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  517. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  518. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  519. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  520. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  521. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  522.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  523. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  524. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  525. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  526. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  527. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  528. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  529. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  530. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  531. Exiting hgodtab, rc=0 at 2012/07/13-07:57:45
  532. hostmstr:          0:   HOA After hoadtab
  533. hostmstr:          0:   HOA Before hoadafr
  534. Entered hgodafr, cursor id 0 at 2012/07/13-07:57:45
  535. Free hoada @ 0x3a4d2c0
  536. Exiting hgodafr, rc=0 at 2012/07/13-07:57:45
  537. hostmstr:          0:   HOA After hoadafr
  538. hostmstr:          0: RPC After Describe Table
  539. hostmstr:          0: RPC Before Commit Trans
  540. hostmstr:          0:   HOA Before hoacomm
  541. Entered hgocomm at 2012/07/13-07:59:51
  542. keepinfo:0, tflag:1
  543.   00: 45544C44 2E636663 62656563 362E362E  [ETLD.cfcbeec6.6.]
  544.   10: 33322E31 383535                      [32.1855]
  545.                 tbid (len 20) is ...
  546.   00: 45544C44 5B362E33 322E3138 35355D5B  [ETLD[6.32.1855][]
  547.   10: 312E345D                             [1.4]]
  548. cmt(0):
  549. Entered hgocpctx at 2012/07/13-07:59:51
  550. Exiting hgocpctx, rc=0 at 2012/07/13-07:59:51
  551. Exiting hgocomm, rc=0 at 2012/07/13-07:59:51
  552. hostmstr:          0:   HOA After hoacomm
  553. hostmstr:          0: RPC After Commit Trans
  554. hostmstr:          0: RPC Before Begin Trans
  555. hostmstr:          0:   HOA Before hoabegn
  556. Entered hgobegn at 2012/07/13-07:59:51
  557. tflag:0 , initial:0
  558. hoi:0x2025b2a8, ttid (len 23) is ...
  559.  00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  560.  10: 31342E32 383231                      [14.2821]
  561.                 tbid (len 20) is ...
  562.  00: 45544C44 5B392E31 342E3238 32315D5B  [ETLD[9.14.2821][]
  563.  10: 312E345D                             [1.4]]
  564. Exiting hgobegn, rc=0 at 2012/07/13-07:59:51
  565. hostmstr:          0:   HOA After hoabegn
  566. hostmstr:          0: RPC After Begin Trans
  567. hostmstr:          0: RPC Before Describe Table
  568. hostmstr:          0:   HOA Before hoadtab
  569. Entered hgodtab at 2012/07/13-07:59:51
  570. count:1
  571.  table: ETLAPI_SFDC__STG_EMPLOYEE
  572. Allocate hoada[0] @ 0x3a4d2c0
  573. Entered hgopcda at 2012/07/13-07:59:51
  574. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  575. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  576. Entered hgopcda at 2012/07/13-07:59:51
  577. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  578. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  579. Entered hgopcda at 2012/07/13-07:59:51
  580. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  581. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  582. Entered hgopcda at 2012/07/13-07:59:51
  583. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  584. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  585. Entered hgopcda at 2012/07/13-07:59:51
  586. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  587. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  588. Entered hgopcda at 2012/07/13-07:59:51
  589. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  590. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  591. Entered hgopcda at 2012/07/13-07:59:51
  592. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  593. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  594. Entered hgopcda at 2012/07/13-07:59:51
  595. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  596. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  597. Entered hgopcda at 2012/07/13-07:59:51
  598. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  599. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  600. Entered hgopcda at 2012/07/13-07:59:51
  601. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  602. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  603. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  604. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  605. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  606. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  607. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  608. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  609.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  610. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  611. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  612. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  613. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  614. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  615. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  616. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  617. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  618. Exiting hgodtab, rc=0 at 2012/07/13-07:59:51
  619. hostmstr:          0:   HOA After hoadtab
  620. hostmstr:          0:   HOA Before hoadafr
  621. Entered hgodafr, cursor id 0 at 2012/07/13-07:59:51
  622. Free hoada @ 0x3a4d2c0
  623. Exiting hgodafr, rc=0 at 2012/07/13-07:59:51
  624. hostmstr:          0:   HOA After hoadafr
  625. hostmstr:          0: RPC After Describe Table
  626. hostmstr:          0: RPC Before Commit Trans
  627. hostmstr:          0:   HOA Before hoacomm
  628. Entered hgocomm at 2012/07/13-07:59:51
  629. keepinfo:0, tflag:1
  630.   00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  631.   10: 31342E32 383231                      [14.2821]
  632.                 tbid (len 20) is ...
  633.   00: 45544C44 5B392E31 342E3238 32315D5B  [ETLD[9.14.2821][]
  634.   10: 312E345D                             [1.4]]
  635. cmt(0):
  636. Entered hgocpctx at 2012/07/13-07:59:51
  637. Exiting hgocpctx, rc=0 at 2012/07/13-07:59:51
  638. Exiting hgocomm, rc=0 at 2012/07/13-07:59:51
  639. hostmstr:          0:   HOA After hoacomm
  640. hostmstr:          0: RPC After Commit Trans
  641. hostmstr:          0: RPC Before Begin Trans
  642. hostmstr:          0:   HOA Before hoabegn
  643. Entered hgobegn at 2012/07/13-07:59:51
  644. tflag:0 , initial:0
  645. hoi:0x2025b2a8, ttid (len 23) is ...
  646.  00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  647.  10: 31352E32 383234                      [15.2824]
  648.                 tbid (len 20) is ...
  649.  00: 45544C44 5B392E31 352E3238 32345D5B  [ETLD[9.15.2824][]
  650.  10: 312E345D                             [1.4]]
  651. Exiting hgobegn, rc=0 at 2012/07/13-07:59:51
  652. hostmstr:          0:   HOA After hoabegn
  653. hostmstr:          0: RPC After Begin Trans
  654. hostmstr:          0: RPC Before Describe Table
  655. hostmstr:          0:   HOA Before hoadtab
  656. Entered hgodtab at 2012/07/13-07:59:51
  657. count:1
  658.  table: ETLAPI_SFDC__STG_EMPLOYEE
  659. Allocate hoada[0] @ 0x3a4d2c0
  660. Entered hgopcda at 2012/07/13-07:59:51
  661. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  662. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  663. Entered hgopcda at 2012/07/13-07:59:51
  664. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  665. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  666. Entered hgopcda at 2012/07/13-07:59:51
  667. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  668. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  669. Entered hgopcda at 2012/07/13-07:59:51
  670. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  671. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  672. Entered hgopcda at 2012/07/13-07:59:51
  673. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  674. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  675. Entered hgopcda at 2012/07/13-07:59:51
  676. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  677. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  678. Entered hgopcda at 2012/07/13-07:59:51
  679. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  680. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  681. Entered hgopcda at 2012/07/13-07:59:51
  682. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  683. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  684. Entered hgopcda at 2012/07/13-07:59:51
  685. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  686. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  687. Entered hgopcda at 2012/07/13-07:59:51
  688. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  689. Exiting hgopcda, rc=0 at 2012/07/13-07:59:51
  690. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  691. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  692. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  693. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  694. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  695. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  696.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  697. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  698. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  699. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  700. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  701. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  702. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  703. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  704. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  705. Exiting hgodtab, rc=0 at 2012/07/13-07:59:51
  706. hostmstr:          0:   HOA After hoadtab
  707. hostmstr:          0:   HOA Before hoadafr
  708. Entered hgodafr, cursor id 0 at 2012/07/13-07:59:51
  709. Free hoada @ 0x3a4d2c0
  710. Exiting hgodafr, rc=0 at 2012/07/13-07:59:51
  711. hostmstr:          0:   HOA After hoadafr
  712. hostmstr:          0: RPC After Describe Table
  713. hostmstr:          0: RPC Before Commit Trans
  714. hostmstr:          0:   HOA Before hoacomm
  715. Entered hgocomm at 2012/07/13-08:00:48
  716. keepinfo:0, tflag:1
  717.   00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  718.   10: 31352E32 383234                      [15.2824]
  719.                 tbid (len 20) is ...
  720.   00: 45544C44 5B392E31 352E3238 32345D5B  [ETLD[9.15.2824][]
  721.   10: 312E345D                             [1.4]]
  722. cmt(0):
  723. Entered hgocpctx at 2012/07/13-08:00:48
  724. Exiting hgocpctx, rc=0 at 2012/07/13-08:00:48
  725. Exiting hgocomm, rc=0 at 2012/07/13-08:00:48
  726. hostmstr:          0:   HOA After hoacomm
  727. hostmstr:          0: RPC After Commit Trans
  728. hostmstr:          0: RPC Before Begin Trans
  729. hostmstr:          0:   HOA Before hoabegn
  730. Entered hgobegn at 2012/07/13-08:00:48
  731. tflag:0 , initial:0
  732. hoi:0x2025b2a8, ttid (len 23) is ...
  733.  00: 45544C44 2E636663 62656563 362E352E  [ETLD.cfcbeec6.5.]
  734.  10: 32372E31 363730                      [27.1670]
  735.                 tbid (len 20) is ...
  736.  00: 45544C44 5B352E32 372E3136 37305D5B  [ETLD[5.27.1670][]
  737.  10: 312E345D                             [1.4]]
  738. Exiting hgobegn, rc=0 at 2012/07/13-08:00:48
  739. hostmstr:          0:   HOA After hoabegn
  740. hostmstr:          0: RPC After Begin Trans
  741. hostmstr:          0: RPC Before Describe Table
  742. hostmstr:          0:   HOA Before hoadtab
  743. Entered hgodtab at 2012/07/13-08:00:48
  744. count:1
  745.  table: ETLAPI_SFDC__STG_EMPLOYEE
  746. Allocate hoada[0] @ 0x3a4d2c0
  747. Entered hgopcda at 2012/07/13-08:00:48
  748. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  749. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  750. Entered hgopcda at 2012/07/13-08:00:48
  751. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  752. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  753. Entered hgopcda at 2012/07/13-08:00:48
  754. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  755. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  756. Entered hgopcda at 2012/07/13-08:00:48
  757. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  758. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  759. Entered hgopcda at 2012/07/13-08:00:48
  760. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  761. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  762. Entered hgopcda at 2012/07/13-08:00:48
  763. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  764. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  765. Entered hgopcda at 2012/07/13-08:00:48
  766. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  767. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  768. Entered hgopcda at 2012/07/13-08:00:48
  769. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  770. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  771. Entered hgopcda at 2012/07/13-08:00:48
  772. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  773. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  774. Entered hgopcda at 2012/07/13-08:00:48
  775. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  776. Exiting hgopcda, rc=0 at 2012/07/13-08:00:48
  777. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  778. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  779. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  780. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  781. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  782. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  783.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  784. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  785. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  786. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  787. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  788. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  789. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  790. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  791. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  792. Exiting hgodtab, rc=0 at 2012/07/13-08:00:48
  793. hostmstr:          0:   HOA After hoadtab
  794. hostmstr:          0:   HOA Before hoadafr
  795. Entered hgodafr, cursor id 0 at 2012/07/13-08:00:48
  796. Free hoada @ 0x3a4d2c0
  797. Exiting hgodafr, rc=0 at 2012/07/13-08:00:48
  798. hostmstr:          0:   HOA After hoadafr
  799. hostmstr:          0: RPC After Describe Table
  800. hostmstr:          0: RPC Before Commit Trans
  801. hostmstr:          0:   HOA Before hoacomm
  802. Entered hgocomm at 2012/07/13-08:00:49
  803. keepinfo:0, tflag:1
  804.   00: 45544C44 2E636663 62656563 362E352E  [ETLD.cfcbeec6.5.]
  805.   10: 32372E31 363730                      [27.1670]
  806.                 tbid (len 20) is ...
  807.   00: 45544C44 5B352E32 372E3136 37305D5B  [ETLD[5.27.1670][]
  808.   10: 312E345D                             [1.4]]
  809. cmt(0):
  810. Entered hgocpctx at 2012/07/13-08:00:49
  811. Exiting hgocpctx, rc=0 at 2012/07/13-08:00:49
  812. Exiting hgocomm, rc=0 at 2012/07/13-08:00:49
  813. hostmstr:          0:   HOA After hoacomm
  814. hostmstr:          0: RPC After Commit Trans
  815. hostmstr:          0: RPC Before Begin Trans
  816. hostmstr:          0:   HOA Before hoabegn
  817. Entered hgobegn at 2012/07/13-08:00:49
  818. tflag:0 , initial:0
  819. hoi:0x2025b2a8, ttid (len 23) is ...
  820.  00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  821.  10: 32392E32 383234                      [29.2824]
  822.                 tbid (len 20) is ...
  823.  00: 45544C44 5B392E32 392E3238 32345D5B  [ETLD[9.29.2824][]
  824.  10: 312E345D                             [1.4]]
  825. Exiting hgobegn, rc=0 at 2012/07/13-08:00:49
  826. hostmstr:          0:   HOA After hoabegn
  827. hostmstr:          0: RPC After Begin Trans
  828. hostmstr:          0: RPC Before Describe Table
  829. hostmstr:          0:   HOA Before hoadtab
  830. Entered hgodtab at 2012/07/13-08:00:49
  831. count:1
  832.  table: ETLAPI_SFDC__STG_EMPLOYEE
  833. Allocate hoada[0] @ 0x3a4d2c0
  834. Entered hgopcda at 2012/07/13-08:00:49
  835. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  836. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  837. Entered hgopcda at 2012/07/13-08:00:49
  838. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  839. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  840. Entered hgopcda at 2012/07/13-08:00:49
  841. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  842. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  843. Entered hgopcda at 2012/07/13-08:00:49
  844. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  845. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  846. Entered hgopcda at 2012/07/13-08:00:49
  847. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  848. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  849. Entered hgopcda at 2012/07/13-08:00:49
  850. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  851. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  852. Entered hgopcda at 2012/07/13-08:00:49
  853. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  854. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  855. Entered hgopcda at 2012/07/13-08:00:49
  856. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  857. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  858. Entered hgopcda at 2012/07/13-08:00:49
  859. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  860. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  861. Entered hgopcda at 2012/07/13-08:00:49
  862. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  863. Exiting hgopcda, rc=0 at 2012/07/13-08:00:49
  864. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  865. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  866. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  867. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  868. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  869. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  870.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  871. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  872. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  873. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  874. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  875. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  876. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  877. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  878. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  879. Exiting hgodtab, rc=0 at 2012/07/13-08:00:49
  880. hostmstr:          0:   HOA After hoadtab
  881. hostmstr:          0:   HOA Before hoadafr
  882. Entered hgodafr, cursor id 0 at 2012/07/13-08:00:49
  883. Free hoada @ 0x3a4d2c0
  884. Exiting hgodafr, rc=0 at 2012/07/13-08:00:49
  885. hostmstr:          0:   HOA After hoadafr
  886. hostmstr:          0: RPC After Describe Table
  887. hostmstr:          0: RPC Before Commit Trans
  888. hostmstr:          0:   HOA Before hoacomm
  889. Entered hgocomm at 2012/07/13-08:04:59
  890. keepinfo:0, tflag:1
  891.   00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  892.   10: 32392E32 383234                      [29.2824]
  893.                 tbid (len 20) is ...
  894.   00: 45544C44 5B392E32 392E3238 32345D5B  [ETLD[9.29.2824][]
  895.   10: 312E345D                             [1.4]]
  896. cmt(0):
  897. Entered hgocpctx at 2012/07/13-08:04:59
  898. Exiting hgocpctx, rc=0 at 2012/07/13-08:04:59
  899. Exiting hgocomm, rc=0 at 2012/07/13-08:04:59
  900. hostmstr:          0:   HOA After hoacomm
  901. hostmstr:          0: RPC After Commit Trans
  902. hostmstr:          0: RPC Before Begin Trans
  903. hostmstr:          0:   HOA Before hoabegn
  904. Entered hgobegn at 2012/07/13-08:04:59
  905. tflag:0 , initial:0
  906. hoi:0x2025b2a8, ttid (len 22) is ...
  907.  00: 45544C44 2E636663 62656563 362E322E  [ETLD.cfcbeec6.2.]
  908.  10: 392E3136 3533                        [9.1653]
  909.                 tbid (len 19) is ...
  910.  00: 45544C44 5B322E39 2E313635 335D5B31  [ETLD[2.9.1653][1]
  911.  10: 2E345D                               [.4]]
  912. Exiting hgobegn, rc=0 at 2012/07/13-08:04:59
  913. hostmstr:          0:   HOA After hoabegn
  914. hostmstr:          0: RPC After Begin Trans
  915. hostmstr:          0: RPC Before Describe Table
  916. hostmstr:          0:   HOA Before hoadtab
  917. Entered hgodtab at 2012/07/13-08:04:59
  918. count:1
  919.  table: ETLAPI_SFDC__STG_EMPLOYEE
  920. Allocate hoada[0] @ 0x3a4d2c0
  921. Entered hgopcda at 2012/07/13-08:04:59
  922. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  923. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  924. Entered hgopcda at 2012/07/13-08:04:59
  925. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  926. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  927. Entered hgopcda at 2012/07/13-08:04:59
  928. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  929. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  930. Entered hgopcda at 2012/07/13-08:04:59
  931. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  932. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  933. Entered hgopcda at 2012/07/13-08:04:59
  934. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  935. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  936. Entered hgopcda at 2012/07/13-08:04:59
  937. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  938. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  939. Entered hgopcda at 2012/07/13-08:04:59
  940. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  941. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  942. Entered hgopcda at 2012/07/13-08:04:59
  943. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  944. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  945. Entered hgopcda at 2012/07/13-08:04:59
  946. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  947. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  948. Entered hgopcda at 2012/07/13-08:04:59
  949. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  950. Exiting hgopcda, rc=0 at 2012/07/13-08:04:59
  951. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  952. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  953. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  954. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  955. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  956. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  957.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  958. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  959. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  960. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  961. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  962. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  963. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  964. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  965. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  966. Exiting hgodtab, rc=0 at 2012/07/13-08:04:59
  967. hostmstr:          0:   HOA After hoadtab
  968. hostmstr:          0:   HOA Before hoadafr
  969. Entered hgodafr, cursor id 0 at 2012/07/13-08:04:59
  970. Free hoada @ 0x3a4d2c0
  971. Exiting hgodafr, rc=0 at 2012/07/13-08:04:59
  972. hostmstr:          0:   HOA After hoadafr
  973. hostmstr:          0: RPC After Describe Table
  974. hostmstr:          0: RPC Before Commit Trans
  975. hostmstr:          0:   HOA Before hoacomm
  976. Entered hgocomm at 2012/07/13-08:05:00
  977. keepinfo:0, tflag:1
  978.   00: 45544C44 2E636663 62656563 362E322E  [ETLD.cfcbeec6.2.]
  979.   10: 392E3136 3533                        [9.1653]
  980.                 tbid (len 19) is ...
  981.   00: 45544C44 5B322E39 2E313635 335D5B31  [ETLD[2.9.1653][1]
  982.   10: 2E345D                               [.4]]
  983. cmt(0):
  984. Entered hgocpctx at 2012/07/13-08:05:00
  985. Exiting hgocpctx, rc=0 at 2012/07/13-08:05:00
  986. Exiting hgocomm, rc=0 at 2012/07/13-08:05:00
  987. hostmstr:          0:   HOA After hoacomm
  988. hostmstr:          0: RPC After Commit Trans
  989. hostmstr:          0: RPC Before Begin Trans
  990. hostmstr:          0:   HOA Before hoabegn
  991. Entered hgobegn at 2012/07/13-08:05:00
  992. tflag:0 , initial:0
  993. hoi:0x2025b2a8, ttid (len 23) is ...
  994.  00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  995.  10: 32312E32 383234                      [21.2824]
  996.                 tbid (len 20) is ...
  997.  00: 45544C44 5B392E32 312E3238 32345D5B  [ETLD[9.21.2824][]
  998.  10: 312E345D                             [1.4]]
  999. Exiting hgobegn, rc=0 at 2012/07/13-08:05:00
  1000. hostmstr:          0:   HOA After hoabegn
  1001. hostmstr:          0: RPC After Begin Trans
  1002. hostmstr:          0: RPC Before Describe Table
  1003. hostmstr:          0:   HOA Before hoadtab
  1004. Entered hgodtab at 2012/07/13-08:05:00
  1005. count:1
  1006.  table: ETLAPI_SFDC__STG_EMPLOYEE
  1007. Allocate hoada[0] @ 0x3a4d2c0
  1008. Entered hgopcda at 2012/07/13-08:05:00
  1009. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  1010. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1011. Entered hgopcda at 2012/07/13-08:05:00
  1012. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  1013. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1014. Entered hgopcda at 2012/07/13-08:05:00
  1015. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1016. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1017. Entered hgopcda at 2012/07/13-08:05:00
  1018. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1019. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1020. Entered hgopcda at 2012/07/13-08:05:00
  1021. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1022. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1023. Entered hgopcda at 2012/07/13-08:05:00
  1024. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1025. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1026. Entered hgopcda at 2012/07/13-08:05:00
  1027. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1028. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1029. Entered hgopcda at 2012/07/13-08:05:00
  1030. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1031. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1032. Entered hgopcda at 2012/07/13-08:05:00
  1033. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  1034. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1035. Entered hgopcda at 2012/07/13-08:05:00
  1036. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  1037. Exiting hgopcda, rc=0 at 2012/07/13-08:05:00
  1038. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  1039. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  1040. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  1041. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  1042. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  1043. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  1044.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  1045. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  1046. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  1047. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  1048. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  1049. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  1050. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  1051. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  1052. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  1053. Exiting hgodtab, rc=0 at 2012/07/13-08:05:00
  1054. hostmstr:          0:   HOA After hoadtab
  1055. hostmstr:          0:   HOA Before hoadafr
  1056. Entered hgodafr, cursor id 0 at 2012/07/13-08:05:00
  1057. Free hoada @ 0x3a4d2c0
  1058. Exiting hgodafr, rc=0 at 2012/07/13-08:05:00
  1059. hostmstr:          0:   HOA After hoadafr
  1060. hostmstr:          0: RPC After Describe Table
  1061. hostmstr:          0: RPC Before Commit Trans
  1062. hostmstr:          0:   HOA Before hoacomm
  1063. Entered hgocomm at 2012/07/13-08:08:07
  1064. keepinfo:0, tflag:1
  1065.   00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  1066.   10: 32312E32 383234                      [21.2824]
  1067.                 tbid (len 20) is ...
  1068.   00: 45544C44 5B392E32 312E3238 32345D5B  [ETLD[9.21.2824][]
  1069.   10: 312E345D                             [1.4]]
  1070. cmt(0):
  1071. Entered hgocpctx at 2012/07/13-08:08:07
  1072. Exiting hgocpctx, rc=0 at 2012/07/13-08:08:07
  1073. Exiting hgocomm, rc=0 at 2012/07/13-08:08:07
  1074. hostmstr:          0:   HOA After hoacomm
  1075. hostmstr:          0: RPC After Commit Trans
  1076. hostmstr:          0: RPC Before Begin Trans
  1077. hostmstr:          0:   HOA Before hoabegn
  1078. Entered hgobegn at 2012/07/13-08:08:07
  1079. tflag:0 , initial:0
  1080. hoi:0x2025b2a8, ttid (len 23) is ...
  1081.  00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  1082.  10: 32332E32 383231                      [23.2821]
  1083.                 tbid (len 20) is ...
  1084.  00: 45544C44 5B392E32 332E3238 32315D5B  [ETLD[9.23.2821][]
  1085.  10: 312E345D                             [1.4]]
  1086. Exiting hgobegn, rc=0 at 2012/07/13-08:08:07
  1087. hostmstr:          0:   HOA After hoabegn
  1088. hostmstr:          0: RPC After Begin Trans
  1089. hostmstr:          0: RPC Before Describe Table
  1090. hostmstr:          0:   HOA Before hoadtab
  1091. Entered hgodtab at 2012/07/13-08:08:07
  1092. count:1
  1093.  table: ETLAPI_SFDC__STG_EMPLOYEE
  1094. Allocate hoada[0] @ 0x3a4d2c0
  1095. Entered hgopcda at 2012/07/13-08:08:07
  1096. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  1097. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1098. Entered hgopcda at 2012/07/13-08:08:07
  1099. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  1100. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1101. Entered hgopcda at 2012/07/13-08:08:07
  1102. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1103. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1104. Entered hgopcda at 2012/07/13-08:08:07
  1105. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1106. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1107. Entered hgopcda at 2012/07/13-08:08:07
  1108. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1109. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1110. Entered hgopcda at 2012/07/13-08:08:07
  1111. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1112. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1113. Entered hgopcda at 2012/07/13-08:08:07
  1114. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1115. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1116. Entered hgopcda at 2012/07/13-08:08:07
  1117. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1118. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1119. Entered hgopcda at 2012/07/13-08:08:07
  1120. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  1121. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1122. Entered hgopcda at 2012/07/13-08:08:07
  1123. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  1124. Exiting hgopcda, rc=0 at 2012/07/13-08:08:07
  1125. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  1126. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  1127. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  1128. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  1129. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  1130. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  1131.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  1132. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  1133. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  1134. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  1135. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  1136. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  1137. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  1138. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  1139. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  1140. Exiting hgodtab, rc=0 at 2012/07/13-08:08:07
  1141. hostmstr:          0:   HOA After hoadtab
  1142. hostmstr:          0:   HOA Before hoadafr
  1143. Entered hgodafr, cursor id 0 at 2012/07/13-08:08:07
  1144. Free hoada @ 0x3a4d2c0
  1145. Exiting hgodafr, rc=0 at 2012/07/13-08:08:07
  1146. hostmstr:          0:   HOA After hoadafr
  1147. hostmstr:          0: RPC After Describe Table
  1148. hostmstr:          0: RPC Before Commit Trans
  1149. hostmstr:          0:   HOA Before hoacomm
  1150. Entered hgocomm at 2012/07/13-08:08:08
  1151. keepinfo:0, tflag:1
  1152.   00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  1153.   10: 32332E32 383231                      [23.2821]
  1154.                 tbid (len 20) is ...
  1155.   00: 45544C44 5B392E32 332E3238 32315D5B  [ETLD[9.23.2821][]
  1156.   10: 312E345D                             [1.4]]
  1157. cmt(0):
  1158. Entered hgocpctx at 2012/07/13-08:08:08
  1159. Exiting hgocpctx, rc=0 at 2012/07/13-08:08:08
  1160. Exiting hgocomm, rc=0 at 2012/07/13-08:08:08
  1161. hostmstr:          0:   HOA After hoacomm
  1162. hostmstr:          0: RPC After Commit Trans
  1163. hostmstr:          0: RPC Before Begin Trans
  1164. hostmstr:          0:   HOA Before hoabegn
  1165. Entered hgobegn at 2012/07/13-08:08:08
  1166. tflag:0 , initial:0
  1167. hoi:0x2025b2a8, ttid (len 23) is ...
  1168.  00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  1169.  10: 33332E32 383233                      [33.2823]
  1170.                 tbid (len 20) is ...
  1171.  00: 45544C44 5B392E33 332E3238 32335D5B  [ETLD[9.33.2823][]
  1172.  10: 312E345D                             [1.4]]
  1173. Exiting hgobegn, rc=0 at 2012/07/13-08:08:08
  1174. hostmstr:          0:   HOA After hoabegn
  1175. hostmstr:          0: RPC After Begin Trans
  1176. hostmstr:          0: RPC Before Describe Table
  1177. hostmstr:          0:   HOA Before hoadtab
  1178. Entered hgodtab at 2012/07/13-08:08:08
  1179. count:1
  1180.  table: ETLAPI_SFDC__STG_EMPLOYEE
  1181. Allocate hoada[0] @ 0x3a4d2c0
  1182. Entered hgopcda at 2012/07/13-08:08:08
  1183. Column:1(sfdc_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:0
  1184. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1185. Entered hgopcda at 2012/07/13-08:08:08
  1186. Column:2(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:-1, sign:1, radix:10
  1187. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1188. Entered hgopcda at 2012/07/13-08:08:08
  1189. Column:3(employee_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1190. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1191. Entered hgopcda at 2012/07/13-08:08:08
  1192. Column:4(empl_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1193. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1194. Entered hgopcda at 2012/07/13-08:08:08
  1195. Column:5(spvr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1196. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1197. Entered hgopcda at 2012/07/13-08:08:08
  1198. Column:6(mngr_nt_id): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1199. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1200. Entered hgopcda at 2012/07/13-08:08:08
  1201. Column:7(empl_name): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1202. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1203. Entered hgopcda at 2012/07/13-08:08:08
  1204. Column:8(is_active): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:1, radix:10
  1205. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1206. Entered hgopcda at 2012/07/13-08:08:08
  1207. Column:9(load_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  1208. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1209. Entered hgopcda at 2012/07/13-08:08:08
  1210. Column:10(sfdc_date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:-1, sign:1, radix:10
  1211. Exiting hgopcda, rc=0 at 2012/07/13-08:08:08
  1212. The hoada for table ETLAPI_SFDC__STG_EMPLOYEE follows...
  1213. hgodtab, line 1092: Printing hoada @ 0x3a4d2c0
  1214. MAX:10, ACTUAL:10, BRC:1, WHT=6 (TABLE_DESCRIBE)
  1215. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  1216. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  1217. 12 VARCHAR Y        255        255   0/  0    0   0 200 sfdc_id
  1218.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  1219. 12 VARCHAR Y        255        255   0/  0    0   0 200 employee_id
  1220. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_nt_id
  1221. 12 VARCHAR Y        255        255   0/  0    0   0 200 spvr_nt_id
  1222. 12 VARCHAR Y        255        255   0/  0    0   0 200 mngr_nt_id
  1223. 12 VARCHAR Y        255        255   0/  0    0   0 200 empl_name
  1224. 12 VARCHAR Y        255        255   0/  0    0   0 200 is_active
  1225. 91 DATE    Y         16         16   0/  0    0   0   0 load_date
  1226. 91 DATE    Y         16         16   0/  0    0   0   0 sfdc_date
  1227. Exiting hgodtab, rc=0 at 2012/07/13-08:08:08
  1228. hostmstr:          0:   HOA After hoadtab
  1229. hostmstr:          0:   HOA Before hoadafr
  1230. Entered hgodafr, cursor id 0 at 2012/07/13-08:08:08
  1231. Free hoada @ 0x3a4d2c0
  1232. Exiting hgodafr, rc=0 at 2012/07/13-08:08:08
  1233. hostmstr:          0:   HOA After hoadafr
  1234. hostmstr:          0: RPC After Describe Table
  1235. hostmstr:          0: RPC Before Exit Agent
  1236. hostmstr:          0:   HOA Before hoaroll
  1237. Entered hgoroll at 2012/07/13-08:49:01
  1238. tflag:0 , cmt(38):Unexpected EOF from Oracle - Rollback
  1239. hoi:0x3a2eaa0, ttid (len 23) is ...
  1240.   00: 45544C44 2E636663 62656563 362E392E  [ETLD.cfcbeec6.9.]
  1241.   10: 33332E32 383233                      [33.2823]
  1242.                 tbid (len 20) is ...
  1243.   00: 45544C44 5B392E33 332E3238 32335D5B  [ETLD[9.33.2823][]
  1244.   10: 312E345D                             [1.4]]
  1245. Entered hgocpctx at 2012/07/13-08:49:01
  1246. Exiting hgocpctx, rc=0 at 2012/07/13-08:49:01
  1247. Exiting hgoroll, rc=0 at 2012/07/13-08:49:01
  1248. hostmstr:          0:   HOA After hoaroll
  1249. hostmstr:          0:   HOA Before hoalgof
  1250. Entered hgolgof at 2012/07/13-08:49:01
  1251. tflag:0
  1252. Exiting hgolgof, rc=0 at 2012/07/13-08:49:01
  1253. hostmstr:          0:   HOA After hoalgof
  1254. hostmstr:          0:   HOA Before hoaexit
  1255. Entered hgoexit at 2012/07/13-08:49:01
  1256. Exiting hgoexit, rc=0
  1257. hostmstr:          0:   HOA After hoaexit
  1258. hostmstr:          0: RPC After Exit Agent
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!