Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Unable to start derby server

avatar
New Contributor

i have installed hdp 2.3.4 on windows 2012 server. when i run the file start_local_hdp_services.cmd, everything starts fine except derbyserver. to debug the issue, i executed derbyserver.cmd that i sitting under hdp\hive directory and got the following error:

Error: Could not find or load main class org.apache.derby.drda.NetworkServerControl

i used @echo to print out the classpath and got the following output:

c:\hdp\hadoop-2.7.1.2.3.4.0-3485\etc\hadoop;c:\hdp\hadoop-2.7.1.2.3.4.0-3485\share\hadoop\common\lib\*;c:\hdp\hadoop-2.7 .1.2.3.4.0-3485\share\hadoop\common\*;c:\hdp\hadoop-2.7.1.2.3.4.0-3485\share\hadoop\hdfs;c:\hdp\hadoop-2.7.1.2.3.4.0-348 5\share\hadoop\hdfs\lib\*;c:\hdp\hadoop-2.7.1.2.3.4.0-3485\share\hadoop\hdfs\*;c:\hdp\hadoop-2.7.1.2.3.4.0-3485\share\ha doop\yarn\lib\*;c:\hdp\hadoop-2.7.1.2.3.4.0-3485\share\hadoop\yarn\*;c:\hdp\hadoop-2.7.1.2.3.4.0-3485\share\hadoop\mapre duce\lib\*;c:\hdp\hadoop-2.7.1.2.3.4.0-3485\share\hadoop\mapreduce\*;c:\hdp\tez-0.7.0.2.3.4.0-3485\conf\;c:\hdp\tez-0.7. 0.2.3.4.0-3485\*;c:\hdp\tez-0.7.0.2.3.4.0-3485\lib\*;;c:\hdp\hive-1.2.1.2.3.4.0-3485\lib\derby-10.10.2.0.jar

then i did jar -tf derby-10.10.2.0.jar to see if it contains the NetworkServerControl and it does not; this is the class that its trying to start and it does not exist, at least in the derby-10.10.20.0.jar file.

on searching online, the above class sits in derbynet.jar file. maybe its named as derby-10.10.20.0.jar file, but issue is that the NetworkServerControl is missing and derbyserver is not starting.

i'll really appreciate any help with this.

1 ACCEPTED SOLUTION

avatar

@ali khawaja have you tried to explicitly set the PATH to the derby home? Try doing this through the Windows environment variables. You can also try to set them in the CLI as shown here: https://db.apache.org/derby/docs/10.4/adminguide/tadmincbdjhhfd.html.

Also, make sure you have rights to execute the jar file. You could try the command java org.apache.derby.drda.NetworkServerControl start -h myhost -p 1621 and see the results.

View solution in original post

3 REPLIES 3

avatar
Master Mentor

@ali khawaja

Take a look at this thread as it may be related. Link and this Link

avatar

@ali khawaja have you tried to explicitly set the PATH to the derby home? Try doing this through the Windows environment variables. You can also try to set them in the CLI as shown here: https://db.apache.org/derby/docs/10.4/adminguide/tadmincbdjhhfd.html.

Also, make sure you have rights to execute the jar file. You could try the command java org.apache.derby.drda.NetworkServerControl start -h myhost -p 1621 and see the results.

avatar
New Contributor

i reinstalled with SQL Server and it worked fine. i'll do another install and see if i can get it to work. i do have admin rights and i was able to start the derby server manually, but the service wont start. i'll try setting the path and see if i can get it to work. Thanks!