Db2 Sql Error Sqlcode=-401 Sqlstate=42818 Sqlerrmc=null
Contents |
If this is your first visit, be sure to check out the FAQ by clicking the link db2 sql error sqlcode 401 sqlstate 42818 above. You may have to register before you can
Db2 Sql Error Sqlcode 302 Sqlstate 22001 Sqlerrmc Null
post: click the register link above to proceed. To start viewing messages, select the forum db2 sql error sqlcode 204 sqlstate 42704 sqlerrmc 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
Db2 Sql Error Sqlcode 104 Sqlstate 42601 Sqlerrmc
Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display 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==, db2 sql error sqlcode 803 sqlstate 23505 sqlerrmc 1 Hi i want to select the roles for a product. i am getting following exception ..and what could be reason. Please any help 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 "
WHEN TRYING TO DELETE A COMPUTER Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description environment: maximo 6.2.1 asset management for it http://www-01.ibm.com/support/docview.wss?uid=swg1IZ34260 6.2.1 DB2 steps 1. go to Assets > Deployed Assets > Computer 2. choose any record > select action > delete computer You will get an error saying: [ERROR] MboSet fetchMbos() failed with error code : -401 com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -401, SQLSTATE: 42818, SQLERRMC: = Deleting function is fine with Oracle, only happens on DB2. Local fix na Problem summary **************************************************************** * USERS AFFECTED: Maximo users who want db2 sql to delete a Deployed * * Asset Computer, Network Device, or Network * * Printer on DB2 * **************************************************************** * PROBLEM DESCRIPTION: Maximo error message "SQLCODE: -401, * * SQLSTATE: 42818, SQLERRMC: =" displays * * when trying to delete a Computer using * * a DB2 Maximo database. * * * **************************************************************** * RECOMMENDATION: Apply latest hot fix for release 6.2.01 * * * **************************************************************** When a Deployed db2 sql error Asset such as a Computer, Network Device, or Network Printer is deleted, database records from the reconciliation link table and the last scan history table (used by Integration Composer) too. In DB2 a where statement such as "where targetid = 1" is invalid syntax if targetid is defined as a database varchar. Problem conclusion Corrected the where clause construction when deleting a Deployed Asset from the last scan history table (used by Integration Composer) so that the targetid value is enclosed in single quotes: where targetid = '1' The fix for this APAR is contained in the following maintenance package: REL 6.2.01\fixes.10012008 Temporary fix Comments APAR Information APAR numberIZ34260 Reported component nameASSETS DEP ASSE Reported component ID5724R47AD Reported release621 StatusCLOSED PER PENoPE HIPERNoHIPER Special AttentionNoSpecatt Submitted date2008-10-10 Closed date2008-10-11 Last modified date2008-10-11 APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros MAXIMO Fix information Fixed component nameASSETS DEP ASSE Fixed component ID5724R47AD Applicable component levels R621 PSYUP Document information More support for: Tivoli Asset Management for IT Assets Depl Assets Software version: 621 Reference #: IZ34260 Modified date: 2008-10-11 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (