on 07-07-2008 2:39 PM
Hi,
Basically I am trying to perform a data centre migration for a customer of mine.
As a result we have to move the Bugseye catalog from one SAPDB/Bugseye installation to a new install.
So far we have installed the SAPDB successfully and linked the Jrun 4.0 to the IIS as per the previous installation.
But when we try to install the Bugseye the install seems to complete successfully but when you look at the log it show an error.
I have enclosed the log if you would have a look at it and see if you can determine any possible causes.
TIA
Chris K
***********************************Installation Log************************************
**************************************************************************
Requisite Technology Installer version: 2.1.0.33
**************************************************************************
15:04:44:98 : BEFORE INITIALIZATION: {FILE=installer.ini, INSTALL_TYPE=sap, USE_SEPARATE_THREADS=TRUE, CHANGESFILE=sqlserver=sqlserverchanges.sql|sapdb=sapdbchanges.sql, DEBUG_LEVEL=0, MOVE_JARS=F, SHOW_DB=sapdb, CONFIG_NAME=sapcomb}
15:04:44:98 : AFTER INITIALIZATION: {FILE=installer.ini, INSTALL_TYPE=sap, USE_SEPARATE_THREADS=TRUE, CHANGESFILE=sqlserver=sqlserverchanges.sql|sapdb=sapdbchanges.sql, DEBUG_LEVEL=0, MOVE_JARS=F, SHOW_DB=sapdb, CONFIG_NAME=sapcomb}
15:05:23:45 : Mode chosen: 'Complete Installation'
15:19:40:10 : Mode chosen: 'Complete Installation'
15:19:40:10 : Called setOracle8, status: false 8i?: false
15:19:40:10 : Called setSQLServer7, status: false
15:19:40:10 : Called setSapDB, status: true
15:19:40:12 : softExtract = false completeInstall = true
15:19:43:60 : softExtract = false completeInstall = true
15:19:43:60 : Installer message: Writing log to: F:\Install\Bugseye\Requisiteinstall\BugsEye_SAPDB3.5.3.29_2.1.0.31\requisite_install.log
15:19:43:62 : Args: {LOCALE=en-US, INSTALL_DIR=F:\requisite, 8I=FALSE, WEBROOTPATH=F:\requisite, COPY_LANG_FILES=, FILE=installer.ini, INSTALL_TYPE=sap, USE_SEPARATE_THREADS=TRUE, WEBSERVER=http://www.webserver.domain, DB=SAPDB, CHANGESFILE=sqlserver=sqlserverchanges.sql|sapdb=sapdbchanges.sql, LICENSED_TO_COMPANY=, DEBUG_LEVEL=0, MOVE_JARS=F, LICENSED_USER_NAME=, WEBSERVER_PORT=80, SHOW_DB=sapdb, WEBSERVER_VIRDIR=/requisite, CONFIG_NAME=sapcomb}
15:19:43:62 : Verifying parameters for module: MiscModule
15:19:43:62 : Installer message: SAP installation detected. SAP directory structure will be used.
15:19:43:62 : Verify is : true
15:19:43:62 : MiscModule: Copying language specific files.
15:19:43:62 : Reading file into gigantic string
15:19:43:62 : Closing output file...
15:19:43:62 : Returning...
15:19:43:62 : Installer message: Successfully substituted values from F:\requisite\sap\en-US\home.htm to new file F:\requisite\sap\home.htm
15:19:43:62 : Reading file into gigantic string
15:19:43:65 : Matched key: WEBROOTURL
15:19:43:65 : Found Token: WEBROOTURL
15:19:43:65 : Matched key: WEBSERVER
15:19:43:65 : Found Token: WEBSERVER
15:19:43:65 : Closing output file...
15:19:43:65 : Returning...
15:19:43:65 : Installer message: Successfully substituted values from F:\requisite\sap\en-US\login.htm to new file F:\requisite\sap\login.htm
15:19:43:65 : Installer message: Static file substitutions complete.
15:19:46:85 : Chosen system: SAPDB
15:19:46:85 : Switching to SapDBAddCatalogInputPanel
15:19:46:85 : My name: SapDBAddCatalogInputPanel
15:19:46:85 : Use me?: true
15:21:29:90 : My name: SapDBAddCatalogInputPanel
15:21:29:90 : Use me?: true
15:21:29:93 : Args during verify: {LOCALE=en-US, INSTALL_DIR=F:\requisite, SQLOBJECTCLASS=com.requisite.bugsi.engine.SapDbSql, VERSION_INFO_FILE=updateversioninfo.sql, HOSTNAME=gb02app800sccx, 8I=FALSE, DB_URL=jdbc:sapdb://gb02app800sccx/REQ?sqlmode=internal&timeout=0&transport=socket, WEBROOTPATH=F:\requisite, NonCatSpace=noncat_data, COPY_LANG_FILES=, FILE=installer.ini, TEXTSEARCHCLASS=com.requisite.bugsi.engine.DrFuzzyObject, SYS_ADMIN_PASSWORD=password, CHANGES_FILE=sapdbchanges.sql, INSTALL_TYPE=sap, USE_SEPARATE_THREADS=TRUE, WEBSERVER=http://www.webserver.domain, DBA_USER=requsr, DB_DRIVER=com.sap.dbtech.jdbc.DriverSapDB, CatSpace=cat_data, DB=SAPDB, SCHEMA_FILE=schema.sql, CHANGESFILE=sqlserver=sqlserverchanges.sql|sapdb=sapdbchanges.sql, IndexSpace=indx, LICENSED_TO_COMPANY=, DEBUG_LEVEL=0, MOVE_JARS=F, LICENSED_USER_NAME=, SYS_ADMIN_USER=superdba, DB_PATH=REQ, WEBSERVER_PORT=80, DB_NAME=REQ, DBA_PASSWORD=password, SHOW_DB=sapdb, WEBSERVER_VIRDIR=/requisite, ADDCONFIG_FILE=addconfig.sql, DBA_TABLES_FILE=sapdbtables.sql, CONFIG_NAME=sapcomb}
15:21:29:93 : I am about to verify connection params.
15:21:29:93 : Still about to verify connection params.
15:21:29:93 : DB_URL is jdbc:sapdb://gb02app800sccx/REQ?sqlmode=internal&timeout=0&transport=socket
15:21:29:93 : Installer message: Testing connection with user: SUPERDBA password: ********
15:21:30:00 : Connecting to database...
15:21:30:00 : dbUrl: jdbc:sapdb://gb02app800sccx/REQ?sqlmode=internal&timeout=0&transport=socket dbUser: superdba dbPassword: password
15:21:32:28 : Error while connecting to database: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
15:21:32:28 : SQLException while setting up database connection.
15:21:32:28 :
15:21:32:28 : *** SQLException caught BEGIN ***
15:21:32:28 : SQLState:
15:21:32:28 : Message: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
15:21:32:28 : Error Code: -1
com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:150)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.requisite.install.DatabaseMgr.getConnection(DatabaseMgr.java:472)
at com.requisite.install.DatabaseMgr.verifyConnectionParams(DatabaseMgr.java:1422)
at com.requisite.install.CommonInstall.verifyConnection(CommonInstall.java:649)
at com.requisite.install.sapdb.SapDBAddCatalogModule.verifyArgs(SapDBAddCatalogModule.java:516)
at com.requisite.install.sapdb.SapDBAddCatalogModule.execute(SapDBAddCatalogModule.java:87)
at com.requisite.install.jexpress.sapdb.SapDBAddCatalogStatusPanel.setActive(SapDBAddCatalogStatusPanel.java:61)
at com.denova.ui.WizardActiveThread.setActive(WizardActiveThread.java)
at com.denova.ui.WizardActiveThread.run(WizardActiveThread.java)
at javax.swing.SystemEventQueueUtilities.processRunnableEvent(Unknown Source)
at javax.swing.SystemEventQueueUtilities.access$0(Unknown Source)
at javax.swing.SystemEventQueueUtilities$RunnableTarget.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForComponent(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForComponent(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
15:21:32:28 : *** SQLException caught END ***
15:21:32:28 :
15:21:32:28 : JDBC Driver returned error code: -1
15:21:32:28 : JDBC Driver returned error message: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
15:21:32:28 : _con is null
15:21:32:29 : Cannot close connection, connection null!
15:21:32:29 : This is the last error code: 0
15:21:32:29 : Installer message: A general database error occured. Check the install log for details.
15:21:45:04 : My name: SapDBAddCatalogInputPanel
15:21:45:04 : Use me?: true
15:21:53:01 : My name: SapDBAddCatalogInputPanel
15:21:53:01 : Use me?: true
15:21:53:04 : Args during verify: {LOCALE=en-US, INSTALL_DIR=F:\requisite, SQLOBJECTCLASS=com.requisite.bugsi.engine.SapDbSql, VERSION_INFO_FILE=updateversioninfo.sql, HOSTNAME=gb02app800sccx, 8I=FALSE, DB_URL=jdbc:sapdb://gb02app800sccx/REQ?sqlmode=internal&timeout=0&transport=socket, WEBROOTPATH=F:\requisite, NonCatSpace=noncat_data, COPY_LANG_FILES=, FILE=installer.ini, TEXTSEARCHCLASS=com.requisite.bugsi.engine.DrFuzzyObject, SYS_ADMIN_PASSWORD=password, CHANGES_FILE=sapdbchanges.sql, INSTALL_TYPE=sap, USE_SEPARATE_THREADS=TRUE, WEBSERVER=http://www.webserver.domain, DBA_USER=reqadm, DB_DRIVER=com.sap.dbtech.jdbc.DriverSapDB, CatSpace=cat_data, DB=SAPDB, SCHEMA_FILE=schema.sql, CHANGESFILE=sqlserver=sqlserverchanges.sql|sapdb=sapdbchanges.sql, IndexSpace=indx, LICENSED_TO_COMPANY=, DEBUG_LEVEL=0, MOVE_JARS=F, LICENSED_USER_NAME=, SYS_ADMIN_USER=superdba, DB_PATH=REQ, WEBSERVER_PORT=80, DB_NAME=REQ, DBA_PASSWORD=password, SHOW_DB=sapdb, WEBSERVER_VIRDIR=/requisite, ADDCONFIG_FILE=addconfig.sql, DBA_TABLES_FILE=sapdbtables.sql, CONFIG_NAME=sapcomb}
15:21:53:06 : I am about to verify connection params.
15:21:53:06 : Still about to verify connection params.
15:21:53:06 : DB_URL is jdbc:sapdb://gb02app800sccx/REQ?sqlmode=internal&timeout=0&transport=socket
15:21:53:06 : Installer message: Testing connection with user: SUPERDBA password: ********
15:21:53:06 : Connecting to database...
15:21:53:06 : dbUrl: jdbc:sapdb://gb02app800sccx/REQ?sqlmode=internal&timeout=0&transport=socket dbUser: superdba dbPassword: password
15:21:53:06 : _con is null
15:21:53:06 : Cannot close connection, connection null!
15:21:53:06 : _con is null
15:21:53:06 : Cannot close connection, connection null!
15:21:53:06 : Error while connecting to database: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
15:21:53:06 : SQLException while setting up database connection.
15:21:53:06 :
15:21:53:06 : *** SQLException caught BEGIN ***
15:21:53:06 : SQLState:
15:21:53:06 : Message: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
15:21:53:06 : Error Code: -1
com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:150)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.requisite.install.DatabaseMgr.getConnection(DatabaseMgr.java:472)
at com.requisite.install.DatabaseMgr.verifyConnectionParams(DatabaseMgr.java:1422)
at com.requisite.install.CommonInstall.verifyConnection(CommonInstall.java:649)
at com.requisite.install.sapdb.SapDBAddCatalogModule.verifyArgs(SapDBAddCatalogModule.java:516)
at com.requisite.install.sapdb.SapDBAddCatalogModule.execute(SapDBAddCatalogModule.java:87)
at com.requisite.install.jexpress.sapdb.SapDBAddCatalogStatusPanel.setActive(SapDBAddCatalogStatusPanel.java:61)
at com.denova.ui.WizardActiveThread.setActive(WizardActiveThread.java)
at com.denova.ui.WizardActiveThread.run(WizardActiveThread.java)
at javax.swing.SystemEventQueueUtilities.processRunnableEvent(Unknown Source)
at javax.swing.SystemEventQueueUtilities.access$0(Unknown Source)
at javax.swing.SystemEventQueueUtilities$RunnableTarget.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForComponent(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForComponent(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
15:21:53:06 : *** SQLException caught END ***
15:21:53:06 :
15:21:53:06 : JDBC Driver returned error code: -1
15:21:53:06 : JDBC Driver returned error message: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://gb02app800sccx/REQ [Unknown host gb02app800sccx [gb02app800sccx]]
15:21:53:06 : _con is null
15:21:53:06 : Cannot close connection, connection null!
15:21:53:06 : This is the last error code: 0
15:21:53:06 : Installer message: A general database error occured. Check the install log for details.
15:22:02:57 : My name: SapDBAddCatalogInputPanel
15:22:02:57 : Use me?: true
15:23:49:07 : My name: SapDBAddCatalogInputPanel
15:23:49:07 : Use me?: true
15:23:49:09 : Args during verify: {LOCALE=en-US, INSTALL_DIR=F:\requisite, SQLOBJECTCLASS=com.requisite.bugsi.engine.SapDbSql, VERSION_INFO_FILE=updateversioninfo.sql, HOSTNAME=gb02ap810scca, 8I=FALSE, DB_URL=jdbc:sapdb://gb02ap810scca/REQ?sqlmode=internal&timeout=0&transport=socket, WEBROOTPATH=F:\requisite, NonCatSpace=noncat_data, COPY_LANG_FILES=, FILE=installer.ini, TEXTSEARCHCLASS=com.requisite.bugsi.engine.DrFuzzyObject, SYS_ADMIN_PASSWORD=password, CHANGES_FILE=sapdbchanges.sql, INSTALL_TYPE=sap, USE_SEPARATE_THREADS=TRUE, WEBSERVER=http://www.webserver.domain, DBA_USER=reqadm, DB_DRIVER=com.sap.dbtech.jdbc.DriverSapDB, CatSpace=cat_data, DB=SAPDB, SCHEMA_FILE=schema.sql, CHANGESFILE=sqlserver=sqlserverchanges.sql|sapdb=sapdbchanges.sql, IndexSpace=indx, LICENSED_TO_COMPANY=, DEBUG_LEVEL=0, MOVE_JARS=F, LICENSED_USER_NAME=, SYS_ADMIN_USER=superdba, DB_PATH=REQ, WEBSERVER_PORT=80, DB_NAME=REQ, DBA_PASSWORD=password, SHOW_DB=sapdb, WEBSERVER_VIRDIR=/requisite, ADDCONFIG_FILE=addconfig.sql, DBA_TABLES_FILE=sapdbtables.sql, CONFIG_NAME=sapcomb}
15:23:49:09 : I am about to verify connection params.
15:23:49:09 : Still about to verify connection params.
15:23:49:09 : DB_URL is jdbc:sapdb://gb02ap810scca/REQ?sqlmode=internal&timeout=0&transport=socket
15:23:49:09 : Installer message: Testing connection with user: SUPERDBA password: ********
15:23:49:09 : Connecting to database...
15:23:49:09 : dbUrl: jdbc:sapdb://gb02ap810scca/REQ?sqlmode=internal&timeout=0&transport=socket dbUser: superdba dbPassword: password
15:23:49:15 : _con is null
15:23:49:15 : Cannot close connection, connection null!
15:23:49:15 : _con is null
15:23:49:15 : Cannot close connection, connection null!
15:23:49:17 : Connected to: jdbc:sapdb://gb02ap810scca/REQ
15:23:49:17 : Connected to jdbc:sapdb://gb02ap810scca/REQ
15:23:49:17 : Driver SAP DB
15:23:49:17 : Version package com.sap.dbtech.jdbc, "SAP DB JDBC Driver", "SAP AG", "7.3.0 Build 023-000-085-111"
15:23:49:17 :
15:23:49:17 : Closing connection.
15:23:49:17 : Installer message: Database connection successful.
15:23:49:17 : _con is null
15:23:49:17 : Cannot close connection, connection null!
15:23:49:17 : This is the last error code: 0
15:23:49:17 : Verify returned true.
15:23:49:17 : Installer message: One moment... rewriting schema.
15:23:49:17 : Installer message: SAP DB AddCatalog process initializing...
15:23:49:17 : Installer message: Creating user: reqadm password: password
15:23:49:17 : Installer message: Creating User: reqadm Password: password
15:23:49:17 : Connection invalid. Recreating connection.
15:23:49:17 : Connecting to database...
15:23:49:17 : dbUrl: jdbc:sapdb://gb02ap810scca/REQ?sqlmode=internal&timeout=0&transport=socket dbUser: superdba dbPassword: password
15:23:49:18 : Connected to: jdbc:sapdb://gb02ap810scca/REQ
15:23:49:18 : Connected to jdbc:sapdb://gb02ap810scca/REQ
15:23:49:18 : Driver SAP DB
15:23:49:18 : Version package com.sap.dbtech.jdbc, "SAP DB JDBC Driver", "SAP AG", "7.3.0 Build 023-000-085-111"
15:23:49:18 :
15:23:49:18 : Executing statement: create user reqadm password password dba not exclusive
15:23:49:18 : Offending statement: create user reqadm password password dba not exclusive
15:23:49:18 : Message: SAP DBTech SQL: [-7017] (at 13) Message not available [Error Code: -7017]
com.sap.dbtech.jdbc.exceptions.DatabaseException: SAP DBTech SQL: [-7017] (at 13) Message not available
at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:51)
at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:656)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:338)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:273)
at com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:578)
at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:619)
at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:172)
at com.sap.dbtech.jdbc.StatementSapDB.executeUpdate(StatementSapDB.java:323)
at com.requisite.install.DatabaseMgr.executeUpdate(DatabaseMgr.java:291)
at com.requisite.install.DatabaseMgr.executeUpdate(DatabaseMgr.java:254)
at com.requisite.install.sapdb.SapDBAddCatalogModule.createUser(SapDBAddCatalogModule.java:300)
at com.requisite.install.sapdb.SapDBAddCatalogModule.run(SapDBAddCatalogModule.java:127)
at java.lang.Thread.run(Unknown Source)
com.sap.dbtech.jdbc.exceptions.DatabaseException: SAP DBTech SQL: [-7017] (at 13) Message not available
at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:51)
at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:656)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:338)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:273)
at com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:578)
at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:619)
at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:172)
at com.sap.dbtech.jdbc.StatementSapDB.executeUpdate(StatementSapDB.java:323)
at com.requisite.install.DatabaseMgr.executeUpdate(DatabaseMgr.java:291)
at com.requisite.install.DatabaseMgr.executeUpdate(DatabaseMgr.java:254)
at com.requisite.install.sapdb.SapDBAddCatalogModule.createUser(SapDBAddCatalogModule.java:300)
at com.requisite.install.sapdb.SapDBAddCatalogModule.run(SapDBAddCatalogModule.java:127)
at java.lang.Thread.run(Unknown Source)
15:23:49:20 : Closing connection.
15:23:49:20 : Create user error code: -7017
15:23:49:20 : Failed creating user.
Hi,
The log says "Unknown host gb02app800sccx". Please check your host name and IP.
Regards,
Masa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Masa,
You are absolutely right and I noticed that right after I posted the question, I reran the installation with the correct parameters.
Unfortunately it did not solve the user creation issue seen at the bottom of the log.
Also I am having difficulty in testing the servlet with JRun4, I have altered the logon page and pointed it to the servlet. But when I log in, I get a message saying that my page cannot be found.
So I am not getting the servlet to work correctly, I have followed the installation guide but obviously it leaves out some of the configuration related to the webserver and jrun.
Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.