Db2 Sql Error Sqlcode=-204 Sqlstate=42704 Sqlerrmc= Driver=3.50.152
ITIM reports TCR tivoli common reporting ITIM TIM ISIM SIM report reports CTGTRE040W SQLCODE=-204 SQLSTATE=42704 Technote (troubleshooting) Problem(Abstract) When trying to use the Tivoli Identity Manager canned reports for Tivoli Common Reporting (TCR), the reports do not return any data. Symptom Looking at the SystemOut.log for TCR, the following is found: [10/29/11 5:18:20:187 YEKST] 00000033 impl W com.ibm.tivoli.reporting.reportEngine.impl.BIRTReportEngineRunRenderHandler generateSnapshot(UserContext,ReportRun,Map) CTGTRE040W An error [ reference id = SNAPSHOTID_100005 ] occurred attempting to run the report [ 100005 ] with design [ /itim/services.rptdesign ] . The error message received from the report engine is [ Cannot get the result set metadata. SQL statement does not return a ResultSet object. SQL error #1: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.SERVICE, DRIVER=3.50.152 Cause One possible cause is that the schema name being used by TCR when executing the reports is wrong. Resolving the problem To correct the issue, the JDBC URL needs to have the currentSchema parameter added that specifies the schema that should be used when connecting to DB2 via the data source defined for the reports. The format of the JDBC URL would be: jdbc:db2://
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for AIX 7.0.0.15: Java SDK 1.6 SR9 Cumulative Fix for WebSphere Application Server 7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for HP-UX 7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for IBM i 7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Linux 7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Solaris 7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Windows http://www.ibm.com/support/docview.wss?uid=swg21570900 7.0.0.17: WebSphere Application Server V7.0 Fix Pack 17 7.0.0.17: Java SDK 1.6 SR9 FP1 Cumulative Fix for WebSphere Application Server 7.0.0.19: WebSphere Application Server V7.0 Fix Pack 19 7.0.0.21: WebSphere Application Server V7.0 Fix Pack 21 7.0.0.23: WebSphere Application Server V7.0 Fix Pack 23 7.0.0.25: WebSphere Application Server V7.0 Fix Pack 25 7.0.0.27: WebSphere Application Server http://www.ibm.com/support/docview.wss?uid=swg1PM18530 V7.0 Fix Pack 27 7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29 7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31 7.0.0.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server 7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33 7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35 7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37 7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39 Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description If uploading a file as Input stream, it fails with the following exception:
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before http://www.dbforums.com/showthread.php?1648915-com-ibm-db2-jcc-b-nm-DB2-SQL-Error-SQLCODE-401-SQLSTATE-42818-SQLERRMC you can post: click the register link above to proceed. To https://sourceforge.net/p/tpox/discussion/650154/thread/90ee88f2/ start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display db2 sql Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-13-09,03:07 #1 ramesh.ibm View Profile View Forum Posts Registered User Join Date Oct 2009 Posts 16 Unanswered: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, Hi i want to select the roles for a product. i am getting following exception ..and what could be reason. Please any help db2 sql error will be appreciated com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [/AdminRoleProduct.jsp]: Initialization successful. [10/13/09 12:30:22:695 IST] 0000003e application E com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.50.152 javax.faces.el.EvaluationException: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.50.152 Thanks in advance Ramesh Reply With Quote 10-13-09,08:09 #2 ARWinner View Profile View Forum Posts Registered User Join Date Jan 2003 Posts 4,286 Provided Answers: 5 SQL0401N The data types of the operands for the operation "
over XML (TPoX) Discussion Transaction Processing over XML (TPoX) Brought to you by: afichter, agustin_g, irina_kogan, matthiasnicola, and 4 others Summary Files Reviews Support Wiki Mailing Lists Tickets ▾ Patches Bugs Feature Requests News Discussion Code Create Topic Stats Graph Forums Help 3 Open Discussion 20 Help Formatting Help DB2 schema validated and mixed queries Forum: Help Creator: Ryszardo Created: 2011-01-26 Updated: 2013-05-02 Ryszardo - 2011-01-26 Hi, inserting data without schema validation (like "insNoValidcustacc.xml") works fine but when I try to execute data with schema validation I get an error: C:\TPoX2\WorkloadDriver>java WorkloadDriver -d tpox -w properties/insValidcustac c.xml -u 1 -tr 1 The WorkloadDriver program is running… The following arguments are used (user id/password omitted): -d tpox -u 1 -w properties/insValidcustacc.xml -tr 1 com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=B051 510.CUSTACC, DRIVER=3.50.152 at com.ibm.db2.jcc.b.wc.a(wc.java:579) at com.ibm.db2.jcc.b.wc.a(wc.java:57) at com.ibm.db2.jcc.b.wc.a(wc.java:126) at com.ibm.db2.jcc.b.tk.c(tk.java:1901) at com.ibm.db2.jcc.b.tk.d(tk.java:1889) at com.ibm.db2.jcc.b.tk.a(tk.java:1416) at com.ibm.db2.jcc.t4.db.g(db.java:138) at com.ibm.db2.jcc.t4.db.a(db.java:38) at com.ibm.db2.jcc.t4.t.a(t.java:32) at com.ibm.db2.jcc.t4.sb.h(sb.java:141) at com.ibm.db2.jcc.b.tk.N(tk.java:1387) at com.ibm.db2.jcc.b.uk.Kb(uk.java:2461) at com.ibm.db2.jcc.b.uk.Pb(uk.java:2561) at com.ibm.db2.jcc.b.uk.Eb(uk.java:2127) at com.ibm.db2.jcc.b.uk.getParameterMetaData(uk.java:2101) at DatabaseOperations.prepareStatements(DatabaseOperations.java:261) at ConcurrentUser.run(ConcurrentUser.java:269) The statement that caused an exception: insert into custacc(cadoc) values(xmlvalidate( ? according to xmlschema id custa cc)) I also get an error when I try to execute sampleMixed.xml file, that covers mixed types of queries ( insert, upda