Com.ibm.db2.jcc.a.io Db2 Sql Error Sqlcode=-206 Sqlstate=42703
Contents |
error: SQLCODE: -206, SQLSTATE:42703, SQLERRMC: is not valid in the context where it is used.. sqlcode=-206, sqlstate=42703 BF_STRING.BF_MESSAGE RATLC01313001; PM11486; Buildforge 7.1.1.4 Technote (troubleshooting) Problem(Abstract) In IBM Rational Build Forge, filtering
Sql0206n Sqlstate=42703
for System Admin and then sorting the results causes SQL Error com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE:42703, SQLERRMC: BF_STRING.BF_MESSAGE Symptom The catalina log shows: ... WARNING: Filtered query sqlcode=-727, sqlstate=56098 row count, compiled query : SELECT * FROM (SELECT bf_sysconfig.bf_param, bf_sysconfig.bf_title, bf_sysconfig.bf_value, bf_sysconfig.bf_datatype, rownumber() OVER ( ORDER BY bf_sysconfig.bf_value) bf_db2_idx FROM bf_sysconfig WHERE (bf_sysconfig.bf_public = 'Y' AND bf_strings.bf_message LIKE '%lic%' ESCAPE '\') ORDER BY bf_sysconfig.bf_value) bf_db2_rows WHERE bf_db2_rows.bf_db2_idx BETWEEN 1 AND 1000 FOR READ ONLY com.buildforge.services.common.db.DBException: Failed SQL query: [org.apache.commons.dbcp.DelegatingPreparedStatement@16a416a4] => [com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: BF_STRINGS.BF_MESSAGE] at com.buildforge.services.server.db.DBConnection.errorQueryFailed(DBConnection.java:1262) at com.buildforge.services.server.db.DBConnection.query(DBConnection.java:1104) at com.buildforge.services.server.db.DBConnection.getFilterMatchCount(DBConnection.java:685) at com.buildforge.services.server.db.DBConnection.getQueryContextForFilteredQuery(DBConnection.java:828) at com.buildforge.services.server.db.DBConnection.doFilteredQuery(DBConnection.java:718) at com.buildforge.services.server.manager.SysConfigManager.findFiltered(SysConfigManager.java:466) at com.buildforge.services.server.api.commands.SysConfigCommands.findFiltered(SysConfigCommands.java:91) at com.buildforge.services.server.api.commands.SysConfigCommands.invoke(SysConfigCommands.java:79) at com.buildforge.services.server.api.APICommandProcessor.process(APICommandProcessor.java:261) at com.buildforge.services.server.api.APIServerConnection.handleRequest(APIServerConnection.java:206) at com.buildforge.services
XMLQUERY 6 replies Latest Post - 2010-02-23T14:54:20Z by cscs010 Display:ConversationsBy Date 1-7 of 7 Previous Next cscs010 20000029BM 5 sqlcode=-5197 Posts Pinned topic sqlcode=-206 on XMLQUERY 2010-02-19T15:35:34Z | Tags:
Sqlcode=-727, Sqlstate=56098, Sqlerrmc=2;-206;42703
Answered question This question has been answered. Unanswered question This question has not been answered
Sqlcode=-203
yet. I am running DB2 EXPRESS-C v9.7 on Windows and am trying to invoke a XMLQUERY statement in a java program and keep http://www-01.ibm.com/support/docview.wss?uid=swg21426826 getting this SQLCODE=-206 error on the executeQuery(). DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=CUSTOMER2.INFO, DRIVER=3.5 7.82 -206 com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=CUS TOMER2.INFO, DRIVER=3.57.82 at com.ibm.db2.jcc.am.bd.a(bd.java:676) at com.ibm.db2.jcc.am.bd.a(bd.java:60) at com.ibm.db2.jcc.am.bd.a(bd.java:127) at com.ibm.db2.jcc.am.km.c(km.java:2506) at com.ibm.db2.jcc.am.km.d(km.java:2483) at com.ibm.db2.jcc.am.km.a(km.java:1963) at com.ibm.db2.jcc.t4.db.g(db.java:139) at com.ibm.db2.jcc.t4.db.a(db.java:39) at com.ibm.db2.jcc.t4.t.a(t.java:32) at com.ibm.db2.jcc.t4.sb.h(sb.java:135) at com.ibm.db2.jcc.am.km.eb(km.java:1934) https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014437424 at com.ibm.db2.jcc.am.lm.ic(lm.java:2798) at com.ibm.db2.jcc.am.lm.b(lm.java:3517) at com.ibm.db2.jcc.am.lm.Vb(lm.java:654) at com.ibm.db2.jcc.am.lm.executeQuery(lm.java:628) at Order2Process.isCustomer(Order2Process.java:71) at Order2Process.main(Order2Process.java:23) C:\db2e\redbook> Now, i can run the same query from the DB2 command line in Windows. C:\db2e>db2 select xmlquery('$D/CUSTOMERINFO/name' PASSING CUSTOMER2.INFO AS "D" ) from ebarkow.CUSTOMER2 1 1 record(s) selected. this is the relevant code - error is on executQuery(): public String isCustomer(int id) { String query= "select xmlquery('$d/customerinfo/name' passing customer2.info as \"d\") from ebarkow.customer2"; try { PreparedStatement stmt=con.prepareStatement(query); ResultSet rs=stmt.executeQuery(); cid=id; if(!rs.next()) return null; else return rs.getString(1); } catch (SQLException e) { System.out.println(e.getMessage()); System.out.println(e.getErrorCode()); e.printStackTrace(); return null; } } // isCustomer Log in to reply. Updated on 2010-02-23T14:54:20Z at 2010-02-23T14:54:20Z by cscs010 MatthiasNicola 120000E28R 322 Posts Re: sqlcode=-206 on XMLQUERY 2010-02-19T19:37:15Z This is the accepted answer. This is the accepted answer. Hello, the sqlcode -206 means in your case that the object "CUSTOMER2.INFO" cannot be found. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic
NOT-ALL-CAPS" Direct links to fixes 6.1.0-TIV-BSM-FP0004-zlinux 6.1.0-TIV-BSM-FP0004-windows 6.1.0-TIV-BSM-FP0004-solaris 6.1.0-TIV-BSM-FP0004-linux 6.1.0-TIV-BSM-FP0004-aix 6.1.0-TIV-NCI-FP0004-zlinux 6.1.0-TIV-NCI-FP0004-windows 6.1.0-TIV-NCI-FP0004-solaris 6.1.0-TIV-NCI-FP0004-aix 6.1.0-TIV-NCI-FP0004-linux 6.1.1-TIV-BSM-FP0004-windows 6.1.1-TIV-BSM-FP0004-zlinux 6.1.1-TIV-BSM-FP0004-solaris 6.1.1-TIV-BSM-FP0004-linux 6.1.1-TIV-BSM-FP0004-aix 6.1.1-TIV-NCI-FP0004-windows 6.1.1-TIV-NCI-FP0004-zlinux 6.1.1-TIV-NCI-FP0004-solaris 6.1.1-TIV-NCI-FP0004-aix 6.1.1-TIV-NCI-FP0004-linux 6.1.0-TIV-NCI-FP0003-zlinux 6.1.0-TIV-NCI-FP0003-windows 6.1.0-TIV-NCI-FP0003-solaris 6.1.0-TIV-NCI-FP0003-linux db2 sql 6.1.0-TIV-NCI-FP0003-aix 6.1.0-TIV-BSM-FP0003-solaris 6.1.0-TIV-BSM-FP0003-aix 6.1.0-TIV-BSM-FP0003-zlinux 6.1.0-TIV-BSM-FP0003-windows 6.1.0-TIV-BSM-FP0003-linux 5.1.1-TIV-NCI-FP0003-Linux 5.1.1-TIV-NCI-FP0003-HPUX 5.1.1-TIV-NCI-FP0003-win 5.1.1-TIV-NCI-FP0003-Solaris 5.1.1-TIV-NCI-FP0003-Linuxs390 5.1.1-TIV-NCI-FP0003-aix 6.1.1-TIV-BSM-FP0003-aix 6.1.1-TIV-NCI-FP0003-zlinux 6.1.1-TIV-NCI-FP0003-windows 6.1.1-TIV-NCI-FP0003-solaris 6.1.1-TIV-NCI-FP0003-linux 6.1.1-TIV-NCI-FP0003-aix 6.1.1-TIV-BSM-FP0003-zlinux 6.1.1-TIV-BSM-FP0003-windows 6.1.1-TIV-BSM-FP0003-solaris 6.1.1-TIV-BSM-FP0003-linux 6.1.1-TIV-BSM-FP0002-windows 6.1.1-TIV-BSM-FP0002-zlinux 6.1.1-TIV-BSM-FP0002-solaris 6.1.1-TIV-BSM-FP0002-aix 6.1.1-TIV-BSM-FP0002-linux 6.1.1-TIV-NCI-FP0002_zlinux 6.1.1-TIV-NCI-FP0002_windows 6.1.1-TIV-NCI-FP0002_solaris 6.1.1-TIV-NCI-FP0002_linux 6.1.1-TIV-NCI-FP0002_aix IBM Tivoli Netcool/Impact db2 sql error V6.1.1 Fix Pack 1 (6.1.1-TIV-NCI-FP0001) IBM Tivoli Business Service Manager V6.1.1 Fix Pack 1(6.1.1-TIV-BSM-FP0001) IBM Tivoli Business Service Manager V6.1.0 Fix Pack 2(6.1.0-TIV-BSM-FP0002) IBM Tivoli Netcool/Impact V6.1.0 Fix Pack 2(6.1.0-TIV-NCI-FP0002) IBM Tivoli Netcool/Impact V6.1.1 Fix Pack 2 (6.1.1-TIV-NCI-FP0002) IBM Tivoli Business Service Manager V6.1.1 Fix Pack 3(6.1.1-TIV-BSM-FP0003) IBM Tivoli Netcool/Impact V6.1.1 Fix Pack 3 (6.1.1-TIV-NCI-FP0003) IBM Tivoli Netcool/Impact V5.1.1 Fix Pack 3 (5.1.1-TIV-NCI-FP0003) IBM Tivoli Netcool/Impact V6.1.0 Fix Pack 3(6.1.0-TIV-NCI-FP0003) IBM Tivoli Netcool/Impact V6.1.1 Fix Pack 4 (6.1.1-TIV-NCI-FP0004) IBM Tivoli Business Service Manager V6.1.1 Fix Pack 4(6.1.1-TIV-BSM-FP0004) IBM Tivoli Netcool/Impact V6.1.0 Fix Pack 4(6.1.0-TIV-NCI-FP0004) IBM Tivoli Business Service Manager V6.1.0 Fix Pack 4(6.1.0-TIV-BSM