Here's part of the error log produced during installation: (Anyone
encountered this before?)
THROWABLE EVENT {Description=[Failed to validate AR DB user exists]},
Throwable=[java.lang.NullPointerException
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.validateARDBUserExists(ARSer
verSybaseDatabaseFileInputValidationTask.java:1255)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.performValidation(ARServerSy
baseDatabaseFileInputValidationTask.java:137)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:52)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:81)
java.lang.Thread.run(Unknown Source)]
(Jul 10 2009 01:43:59.467 PM
+1000),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers
.arserver.ARServerSybaseDatabaseFileInputValidationTask,
PROGRESS EVENT
{Description=[arservervalidation.databaseFileInput.description],Progress
=[35],Detail=[arservervalidation.databaseFileInput.fetchDatabases]}
(Jul 10 2009 01:44:00.480 PM
+1000),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemserve
rs.arserver.ARServerSybaseDatabaseFileInputValidationTask,
THROWABLE EVENT {Description=[Failed to fetch tablespaces]},
Throwable=[java.sql.SQLException: JZ0R2: No result set for this query.
com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown
Source)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.fetchDatabases(ARServerSybas
eDatabaseFileInputValidationTask.java:531)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.performValidation(ARServerSy
baseDatabaseFileInputValidationTask.java:141)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:52)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:81)
java.lang.Thread.run(Unknown Source)]
(Jul 10 2009 01:44:00.484 PM
+1000),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers
.arserver.ARServerSybaseDatabaseFileInputValidationTask,
PROGRESS EVENT
{Description=[arservervalidation.databaseFileInput.description],Progress
=[40],Detail=[arservervalidation.databaseFileInput.validateUserPrivilege
s]}
(Jul 10 2009 01:44:01.501 PM
+1000),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemserve
rs.arserver.ARServerSybaseDatabaseFileInputValidationTask,
THROWABLE EVENT {Description=[Failed to validate user
Privileges],Detail=[java.sql.SQLException: JZ0R2: No result set for this
query.]},
Throwable=[java.sql.SQLException: JZ0R2: No result set for this query.
com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown
Source)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.validateUserPrivileges(ARSer
verSybaseDatabaseFileInputValidationTask.java:1472)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.performValidation(ARServerSy
baseDatabaseFileInputValidationTask.java:146)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:52)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:81)
java.lang.Thread.run(Unknown Source)]
(Jul 10 2009 01:44:01.505 PM
+1000),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers
.arserver.ARServerSybaseDatabaseFileInputValidationTask,
PROGRESS EVENT
{Description=[arservervalidation.databaseFileInput.description],Progress
=[45],Detail=[arservervalidation.databaseFileInput.validateDatabaseExist
s]}
(Jul 10 2009 01:44:02.515 PM
+1000),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,
LOG EVENT {Description=[SET PROPERTY
BMC_DATABASE_TABLESPACE_ALREADY_EXISTS],Detail=[true]}
(Jul 10 2009 01:44:02.516 PM
+1000),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers
.arserver.ARServerSybaseDatabaseFileInputValidationTask,
LOG EVENT {Description=[Validating database exists],Detail=[Database
already exists]}
(Jul 10 2009 01:44:02.519 PM
+1000),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers
.arserver.ARServerSybaseDatabaseFileInputValidationTask,
PROGRESS EVENT
{Description=[arservervalidation.databaseFileInput.description],Progress
=[50],Detail=[arservervalidation.databaseFileInput.validateUserRole]}
(Jul 10 2009 01:44:03.531 PM
+1000),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemserve
rs.arserver.ARServerSybaseDatabaseFileInputValidationTask,
THROWABLE EVENT {Description=[Failed to validate user
role],Detail=[java.sql.SQLException: JZ0R2: No result set for this
query.]},
Throwable=[java.sql.SQLException: JZ0R2: No result set for this query.
com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown
Source)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.validateUserRole(ARServerSyb
aseDatabaseFileInputValidationTask.java:1336)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.performValidation(ARServerSy
baseDatabaseFileInputValidationTask.java:155)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:52)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:81)
java.lang.Thread.run(Unknown Source)]
(Jul 10 2009 01:44:03.535 PM
+1000),INFO,com.bmc.install.builder.installanywhere.InstallationTaskActi
on,
LOG EVENT {Description=[INFO],Detail=[Unable to localize
[arservervalidation.databaseFileInput.validateRoleExists]]}
(Jul 10 2009 01:44:03.537 PM
+1000),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers
.arserver.ARServerSybaseDatabaseFileInputValidationTask,
PROGRESS EVENT
{Description=[arservervalidation.databaseFileInput.description],Progress
=[50],Detail=[arservervalidation.databaseFileInput.validateRoleExists]}
(Jul 10 2009 01:44:03.555 PM
+1000),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemserve
rs.arserver.ARServerSybaseDatabaseFileInputValidationTask,
THROWABLE EVENT {Description=[Failed to validate role
exists],Detail=[java.sql.SQLException: JZ0R2: No result set for this
query.]},
Throwable=[java.sql.SQLException: JZ0R2: No result set for this query.
com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown
Source)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.validateRoleExists(ARServerS
ybaseDatabaseFileInputValidationTask.java:1416)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.performValidation(ARServerSy
baseDatabaseFileInputValidationTask.java:158)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:52)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:81)
java.lang.Thread.run(Unknown Source)]
(Jul 10 2009 01:44:03.559 PM
+1000),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers
.arserver.ARServerSybaseDatabaseFileInputValidationTask,
PROGRESS EVENT
{Description=[arservervalidation.databaseFileInput.description],Progress
=[55],Detail=[arservervalidation.databaseFileInput.validateTableExists]}
(Jul 10 2009 01:44:04.586 PM
+1000),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemserve
rs.arserver.ARServerSybaseDatabaseFileInputValidationTask,
THROWABLE EVENT {Description=[Failed to validate table exists in
default tablespace]},
Throwable=[java.sql.SQLException: JZ0R2: No result set for this query.
com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown
Source)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.validateTableExists(ARServer
SybaseDatabaseFileInputValidationTask.java:1522)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.AR
ServerSybaseDatabaseFileInputValidationTask.performValidation(ARServerSy
baseDatabaseFileInputValidationTask.java:167)
com.bmc.install.task.ValidationTask.execute(ValidationTask.java:52)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:81)
java.lang.Thread.run(Unknown Source)]
Regards,
Kali
________________________________
From: Kali Obsum
Sent: Friday, 10 July 2009 4:40 PM
To: [email protected]
Subject: Remedy 7.5 Installation Error - Preparing Sybase Database
Hi,
Our Remedy 7.5 Installation fails. Seems like the error is related to
the database. I'm wondering if it's related to the following:
In the Installation Guide -> Pre-creating your Sybase Database, it lists
the following steps:
5 Create the user pointing to the created login and group, for example:
sp_adduser 'ARAdmin', 'ARAdmin', db_owner
go
use master
go
7 Change the owner of the database to be the created user, for example:
sp_changedbowner 'ARAdmin'
go
use master
go
However, our DBA says that he encounters an error performing the above
steps. He says that the two are mutually exclusive, meaning if you add a
user, you can't make that user a dbowner and vice versa. Therefore, I
just asked him to make ARAdmin the dbowner and not add it as a user.
Could this be possible causing the error? Can anyone confirm that the
above steps are indeed mutually exclusive?
Thanks!
Regards,
Kali
NOTICE
The information contained in this email is confidential. If you are not the
intended recipient, you must not disclose or use the information in this email
in any way. If you received it in error, please tell us immediately by return
email and delete the document. We do not guarantee the integrity of any
e-mails or attached files and are not responsible for any changes made to them
by any other person.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
