Service Desk Practitioners Forum
cancel

unable to connect to SD repository

Highlighted
Shanker_2
Respected Contributor.

unable to connect to SD repository

Hi

I am getting this error when I try to test the connection. My machine is windows xp sp2 and I installed personal edition sql200.

This is my log file.
Fri, 11/08/2006 10:11:05 hp OpenView service desk 4.5 (v4.5.0588)
Fri, 11/08/2006 10:11:05 Copyright (c) 1998-2002 Hewlett-Packard Company. All Rights Reserved.
Fri, 11/08/2006 10:11:05 Server settings file: C:\Program Files\Hewlett-Packard\OpenView\service desk 4.5\server\server_settings.xml
Fri, 11/08/2006 10:11:05 Install folder : C:\Program Files\Hewlett-Packard\OpenView\service desk 4.5\server\
Fri, 11/08/2006 10:11:05 Data folder : C:\Program Files\Hewlett-Packard\OpenView\service desk 4.5\server\
Fri, 11/08/2006 10:11:05 Java runtime name : Java(TM) 2 Runtime Environment, Standard Edition
Fri, 11/08/2006 10:11:05 Java runtime vendor : Sun Microsystems Inc.
Fri, 11/08/2006 10:11:05 Java runtime version: 1.3.1_03-b03
Fri, 11/08/2006 10:11:05 Java runtime home : C:\Program Files\JavaSoft\JRE\1.3.1_03
Fri, 11/08/2006 10:11:05 Servername : KDK-OFF.dodgeandcox.net
Fri, 11/08/2006 10:11:05 IP Address : 192.168.121.100
Fri, 11/08/2006 10:11:05 OS name : Windows 2000
Fri, 11/08/2006 10:11:05 OS version : 5.1
Fri, 11/08/2006 10:11:05 OS architecture : x86
Fri, 11/08/2006 10:11:05 Started.
Fri, 11/08/2006 10:11:05 Started.
Fri, 11/08/2006 10:11:05 Service: SMTP Service on port 25 disabled. Error: Address in use: JVM_Bind
Fri, 11/08/2006 10:11:06 Job queue monitor starting.
Fri, 11/08/2006 10:11:06 Starting monitor for failed or expired jobs.
Fri, 11/08/2006 10:11:06 Started.
Fri, 11/08/2006 10:11:06 Starting multicast listener.
Fri, 11/08/2006 10:11:06 Started.
Fri, 11/08/2006 10:11:06 No username/password defined for account 'servicedesk' (Data user or Repository user)
Fri, 11/08/2006 10:11:06 Initialized Opta SQL Server JDBC Driver DataSource
Fri, 11/08/2006 10:11:06 Connection to service desk repository was not added to the pool because of java.lang.NullPointerException
Fri, 11/08/2006 10:11:06 Failed to open connection to service desk repository.
java.lang.NullPointerException

Please help me ASAP.

Thanks

Shanker
8 REPLIES
Mark O'Loughlin
Acclaimed Contributor.

Re: unable to connect to SD repository

Hi,

can you verify that the database is running and accessable.

Also can you verify that the ID and password used in the database settings is correct

"Fri, 11/08/2006 10:11:06 No username/password defined for account 'servicedesk' (Data user or Repository user)
"
Ramaprasad N
Outstanding Contributor.

Re: unable to connect to SD repository

EYah, check DB connectivity using the start --> programs -- hp openview service desk 4.5 --> application server --> server settings editor. You can test the connectivity there itself. Also, make that as the default, if you have multiple databases configured and then start the applciation server. If you are using a single account for both data and repo, then un-check the repo user check box in the database settings of server settings editor.

-Ram
Shanker_2
Respected Contributor.

Re: unable to connect to SD repository

Hi

The database connection fails. I installed personal edition SQL 2000. I created a database with name Service desk and I created a user and gave him admin right and DB ownership. I am trying to test the connection using same user but it says canot connect. unable to open SD repository.

Does SD application should be started for testing the connection also? when i start the SD application thd DOS window open and says booting then suddenly the windows closes. I am not sure the application is running or not.

Please help me
Ramaprasad N
Outstanding Contributor.

Re: unable to connect to SD repository

Hi Shankar,

yes your application server is not running. The DOS prompt goes away quickly because of DB connectivity issues. If it starts successfully, then the DOS prompt will be there until you stop the server again.

And yeah, just by creating the DB, you won't be able to start SD app server. You need to create all the default tabbles/views required by SD. For this, from the start --> hp openview service desk 4.5 --> applciation server --> database configuration wizard, create a new DB for SD. Select new and give the user name and password that you just created. It's a simple UI and self explanatory. Once you complete the DB confgi wizard successfully, you will be able to start the app server and logon through the client.

-Ram
Shanker_2
Respected Contributor.

Re: unable to connect to SD repository

Hi

I went to Database wizard and tried to create a new database and tried to use the user which i already created in SQL Database. But the error i got is
Error in openConnection !
Failed to open connection to service desk repository.
java.lang.NullPointerException

even if i tried to create new user i get the same error.

Please help
Ramaprasad N
Outstanding Contributor.

Re: unable to connect to SD repository

Is the SQL server running? As far as I know, you cannot install enterprise edition of SQL server on a Windows XP OS. The version you have installed will support all the connectivity features?? Please check that.

-Ram
Shanker_2
Respected Contributor.

Re: unable to connect to SD repository

Hi

It's personal edition. Morever the same setup is working fine on another XP machine. So I am curious why its not working in my machine?

Thanks

Shanker
shivamh
Valued Contributor.

Re: unable to connect to SD repository

Hi Shanker,

I am new to service desk.did u solved this problem.I am facing same problem ,if u solved this can u help me .Thanks in advance.

cheers,
Shiva