{"action":"created","issue":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/56","labels_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/56/labels{/name}","comments_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/56/comments","events_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/56/events","html_url":"https://github.com/ibmdb/node-ibm_db/issues/56","id":102208597,"number":56,"title":"IBM_DB Test Cases Failed on linux 32 bit","user":{"login":"elkorep","id":11379417,"avatar_url":"https://avatars.githubusercontent.com/u/11379417?v=3","gravatar_id":"","url":"https://api.github.com/users/elkorep","html_url":"https://github.com/elkorep","followers_url":"https://api.github.com/users/elkorep/followers","following_url":"https://api.github.com/users/elkorep/following{/other_user}","gists_url":"https://api.github.com/users/elkorep/gists{/gist_id}","starred_url":"https://api.github.com/users/elkorep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elkorep/subscriptions","organizations_url":"https://api.github.com/users/elkorep/orgs","repos_url":"https://api.github.com/users/elkorep/repos","events_url":"https://api.github.com/users/elkorep/events{/privacy}","received_events_url":"https://api.github.com/users/elkorep/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-08-20T18:58:05Z","updated_at":"2015-09-16T18:19:21Z","closed_at":"2015-09-16T18:19:21Z","body":"Node Build:  v0.12.7-IBMBuild-1.2.0.6-201508160201 (32bit)\r\n\r\nThe 64 bit versions of node on linux worked fine, but on the same systems the 32 bit versions have the following tests fail on these machines:\r\n\r\nMachine Information:\r\nRHEL 7\r\nSUSE Linux 11\r\nSLES 12\r\n\r\nRunning test for [DB2] : test-binding-statement-executeSync ... fail\r\nRunning test for [DB2] : test-binding-transaction-commit ... fail\r\nRunning test for [DB2] : test-binding-transaction-commitSync ... fail\r\nRunning test for [DB2] : test-describe-column ... fail\r\nRunning test for [DB2] : test-describe-database ... fail\r\nRunning test for [DB2] : test-describe-table ... fail\r\nRunning test for [DB2] : test-prepareSync-bad-sql ... fail\r\nRunning test for [DB2] : test-prepareSync-multiple-execution ... fail\r\nRunning test for [DB2] : test-transaction-commit-sync ... fail\r\nRunning test for [DB2] : test-transaction-commit ... fail \r\n\r\nAll these tests pass on the 64 bit node build on the same machines with the exact same database and the same ibm_db/test/config.testConnectionStrings.json configurations.\r\n\r\nHere is a breakdown of each tests issues:\r\n\r\n1) test-binding-statement-executeSync\r\nError is caught and logged at line 65 and logs:\r\n\r\n{ [Error: [IBM][CLI Driver] CLI0124E  Invalid argument value. SQLSTATE=HY009]\r\n  errors: [],\r\n  error: '[node-odbc] Error in ODBCStatement::BindSync',\r\n  message: '[IBM][CLI Driver] CLI0124E  Invalid argument value. SQLSTATE=HY009',\r\n  state: 'HY009' }\r\n\r\n2) test-binding-transaction-commit\r\n          data = result.fetchAllSync();\r\n                        ^\r\nError: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002\r\n    at Error (native)\r\n    at /home/nodebot/nodetest-V12_32/node_modules/ibm_db/test/test-binding-transaction-commit.js:34:25\r\n\r\n3) test-binding-transaction-commitSync\r\nFailed when rolling back\r\n{ [Error: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002]\r\n  errors: [],\r\n  error: '[node-odbc] Error in ODBC::GetColumnValue',\r\n  message: '[IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002',\r\n  state: '22002' }\r\nFailed when committing\r\n{ [Error: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002]\r\n  errors: [],\r\n  error: '[node-odbc] Error in ODBC::GetColumnValue',\r\n  message: '[IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002',\r\n  state: '22002' }\r\n\r\n4) test-describe-column\r\nconnected\r\n[IBM][CLI Driver][DB2/NT] SQL0204N  \"ELKOREHP.NODE_ODBC_TEST_TABLE\" is an undefined name.  SQLSTATE=42704\r\n\r\ntables dropped\r\ntables created\r\n\r\nundefined:0\r\n\r\n\r\nError: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002\r\n    at Error (native)\r\n\r\n5) test-describe-database\r\nundefined:0\r\n\r\n\r\nError: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002\r\n    at Error (native)\r\n\r\n6) test-describe-table\r\nundefined:0\r\n\r\n\r\nError: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002\r\n    at Error (native)\r\n\r\n7) test-prepareSync-bad-sql\r\nstmt.bindSync([\"hello world\", 1, null]);\r\n     ^\r\nError: [IBM][CLI Driver] CLI0124E  Invalid argument value. SQLSTATE=HY009\r\n    at Error (native)\r\n    at Object.<anonymous> (/home/nodebot/nodetest-V12_32/node_modules/ibm_db/test/test-prepareSync-bad-sql.js:13:6)\r\n    at Module._compile (module.js:460:26)\r\n    at Object.Module._extensions..js (module.js:478:10)\r\n    at Module.load (module.js:355:32)\r\n    at Function.Module._load (module.js:310:12)\r\n    at Function.Module.runMain (module.js:501:10)\r\n    at startup (node.js:129:16)\r\n    at node.js:814:3\r\n\r\n8) test-prepareSync-multilple-execution\r\n[IBM][CLI Driver] CLI0124E  Invalid argument value. SQLSTATE=HY009\r\nfinish exit value: 3\r\n\r\n9) test-transaction-commit-sync\r\nFailed when committing\r\n{ [Error: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002]\r\n  errors: [],\r\n  error: '[node-odbc] Error in ODBC::GetColumnValue',\r\n  message: '[IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002',\r\n  state: '22002' }\r\n\r\n10) test-transaction-commit\r\n  var data = result.fetchAllSync();\r\n                    ^\r\nError: [IBM][CLI Driver] CLI0110E  Invalid output or indicator buffer specified. SQLSTATE=22002\r\n    at Error (native)\r\n    at Database.querySync (/home/nodebot/nodetest-V12_32/node_modules/ibm_db/lib/odbc.js:419:21)\r\n    at /home/nodebot/nodetest-V12_32/node_modules/ibm_db/test/test-transaction-commit.js:60:19\r\n"},"comment":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/comments/140830208","html_url":"https://github.com/ibmdb/node-ibm_db/issues/56#issuecomment-140830208","issue_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/56","id":140830208,"user":{"login":"elkorep","id":11379417,"avatar_url":"https://avatars.githubusercontent.com/u/11379417?v=3","gravatar_id":"","url":"https://api.github.com/users/elkorep","html_url":"https://github.com/elkorep","followers_url":"https://api.github.com/users/elkorep/followers","following_url":"https://api.github.com/users/elkorep/following{/other_user}","gists_url":"https://api.github.com/users/elkorep/gists{/gist_id}","starred_url":"https://api.github.com/users/elkorep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elkorep/subscriptions","organizations_url":"https://api.github.com/users/elkorep/orgs","repos_url":"https://api.github.com/users/elkorep/repos","events_url":"https://api.github.com/users/elkorep/events{/privacy}","received_events_url":"https://api.github.com/users/elkorep/received_events","type":"User","site_admin":false},"created_at":"2015-09-16T18:19:21Z","updated_at":"2015-09-16T18:19:21Z","body":"I tried these machines again and all test cases are successful. Thanks Bimal."}}