Unable to start derby server

[#1]

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.

[#2]

@ali khawaja

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

[#3 · Accepted solution]

@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.

[#4]

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!