Test Connection Fail: unable to execute test query on db
I'm installing BF v7.1.4 on AIX 5.3. DB2 Enterprise v9.5 also is already installed and configured on the other machine.
I've successfully created a BUILDDB database using the SQL commands on the v7.1.4 install guide. Stepping through installation manager, I've chosen the following: -selected database type as DB2 -selected "yes" to populate this database at install time -identified my database host as 'dbhostname' -database name is "BUILDDB" -database schema name "BUILD" -database username/passwd is correct -provided the DB2 client library and JDBC driver location Restart the AIX server done after Db2 client is installed and cataloged with the DB2 server. I can successfully log into the build database that we created from the command line with the same id/psswd/port that I put in install set up... # db2 connect to builddb user bfuser Enter current password for bfuser: Database Connection Information Database server = DB2/AIX64 9.5.4 SQL authorization ID = BFUSER Local database alias = BUILDDB Not sure exactly what I'm missing..any ideas? how to get logs? Thanks in advance, |
2 answers
There is two possible issues that I can see that may be causing the error you are seeing:
1) the BUILD schema is missing in the BUILDDB database. You can verify it exists by connecting to the database and running the following query: db2 "select schemaname from syscat.schemata" 2) The user does not have sufficient privileges for the given database. You can try to verify this by logging into the database as your BF user (BFUSER) and running the query specified above. If the user has sufficient privileges it should at least be able to query for the schema name from syscat.schemata. |
|
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.