Error Code 4214
Contents |
Omnibus; TCR reports; cognos; BIRT Technote (troubleshooting) Problem(Abstract) When running the OMNIbus TCR report such as reason: local security service non-retryable error. errorcode=-4214, sqlstate=28000 Events Details or Events Summary, receive the error Connection authorization failure
Db2 Reason Userid Or Password Invalid. Errorcode=-4214 Sqlstate=28000
occurred. Reason: User ID or Password invalid. However, when I test the database connection, the test
Reason Password Expired Errorcode 4214 Sqlstate 28000
is successful. Symptom The successful testing of a TDW datasource within TCR does not confirm a BIRT based report will run correctly. The following error is received http://www.ibm.com/support/knowledgecenter/SS4LQ8_4.1.0/com.ibm.datatools.aqt.doc/installmanual/trouble/trbl_idaa_error_4214.html when running the report - + Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc Failed to get connection. SQL error #1: [jcc][t4][2013][11249][3.50.152] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000 Cause BIRT based reports require additional configuration in TCR 2.1 Resolving the problem There is a set of OMNIbus Cognos http://www-01.ibm.com/support/docview.wss?uid=swg21664078 based reports built for TCR 2.1 which can be used instead. These reports are available at http://www-304.ibm.com/software/brandcatalog/ismlibrary/details?catalog.label=1TW10NC8I The Cognos based reports will be installed in the Netcool_OMNIbus report folder. The BIRT based reports installed in the Omnibus Reports folder require 2 additional configuration steps to connect to the database. Note, these reports are designed only for a connection to DB2. 1) Copy DB2 jar files to the BIRT runtime directory. The procedure to copy the files is documented at this URL: http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/index.jsp?topic=%2Fcom.ibm.tivoli.tcr.doc_21%2Fttcr_jdbc_direct.html Copy the required JDBC driver files to the following directory: TCR_component_dir\lib\birt-runtime-2_2_2\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.2.r22x_v20071206\drivers (Replace tcr_install_dir with the name of the Tivoli Common Reporting installation directory.) For a DB2 data source, copy the DB2 JDBC drivers as well as the license jar file to the same location. You can copy db2jcc.jar and db2jcc_licence_cu.jar file on the DB2 server system from location: C:\%Program Files%\IBM\SQLLIB\java 2) Set the data source for the BIRT reports using the 'trcmd -modify' command To confirm the data
Ubuntu Posted on May 4, 2009 by Graham Updated 28th October, 2010 Newer versions of DB2 address http://www.torkwrench.com/2009/05/04/errorcode-4214-sqlstate28000-from-db2-on-ubuntu/ this problem. Read about it here. Two posts in one day, wow. It's all part of our special series: how to install and http://forums.pentaho.com/showthread.php?173149-Having-issue-in-configuring-DB2-as-data-source configure WebSphere Portal 6.1 on Ubuntu. This isn't a Portal only issue, rather it's a DB2+Ubuntu issue. After getting Portal installed on this Ubuntu machine, code 4214 you're probably going to want to transfer the default Derby database to something more robust like DB2. So you edit wkplc_comp.properties and wkplc_dbtype.properties, and start to run: ./ConfigEngine.sh create-database And you get this in the ConfigTrace.log [sqlproc] action: execute-sql-scripts [sqlproc] _________________________________________________________ [sqlproc] Database autocommit parameter true error code 4214 [sqlproc] No delimiter has been specified, using [;] to separate the SQL statements. [sqlproc] Reading file /opt/WebSphere/wp_profile/ConfigEngine/config/database/work/db2/createBufferpools.run [sqlproc] Could not connect to database [sqlproc] com.ibm.db2.jcc.b.ao: [jcc][t4][2010][11246][3.53.70] Connection authorization failure occurred. Reason: Local security service non-retryable error. ERRORCODE=-4214, SQLSTATE=28000 BUILD FAILED Hmm, ok, I thought db2 was working. A good habit when debugging these things is to take the piece that ConfigEngine is trying run and run it independently. So right now I want ConfigEngine to create an empty db2 database that I can run database-transfer against. Try this: su - db2inst1 db2 create db WP610 using codeset UTF8 territory au pagesize 8192 And that comes back successfully. However, that command sequence is not an accurate representation of what ConfigEngine is actually doing. We're running ConfigEngine as root. But the ConfigEngine script is using the "user db2inst1 using " modifiers on the end of
View Site Leaders Advanced Search Forum Pentaho Users Pentaho Data Integration [Kettle] Having issue in configuring DB2 as data source. If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Having issue in configuring DB2 as data source. 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-14-2014,06:37 AM #1 senthil.retnaraj View Profile View Forum Posts Private Message Junior Member Join Date Oct 2014 Posts 3 Having issue in configuring DB2 as data source. IBM DB2 database is a source for us to extract the data. When tried to configure the connection,Am getting the below error. Error connecting to database [erer] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The application server rejected establishment of the connection. An attempt was made to access a database, ABC956, which was not found. Placed the db2jcc.jar,db2jcc_javax.jar,db2jcc_license_cu.jar files in data-integration\lib and data-integration\libswt folder. Need help in resolving the above issue and also need clarification on whether any db2 client tools needs to be installed to connect to the DB2 database. Reply With Quote 10-15-2014,02:59 AM #2 blijblijblij View Profile View Forum Posts Private Message Junior Member Join Date Dec 2011 Posts 7 Originally Posted by senthil.retnaraj IBM DB2 database is a source for us to extract the data. When tried to configure the connection,Am getting the below error. Error connecting to database [erer] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The application server rejected establishment of the connection. An attempt was made to access a database, ABC956, which was not found. Placed the db2jcc.jar,db2jcc_javax.jar,db2jcc_license_cu.jar files in data-integration\lib and data-integration\libswt folder. Need help in resolving the above issue and also need clarification