Can't finish upgrading RepositoryManager, Driver and ConnectionManager: org.apache.sqoop.common.SqoopException: JDBCREPO_0007:Unable to lease link (CDH Sqoop2)

When you are trying to install Sqoop2 in Cloudera CDH, sometimes you will endup with "Can't finish upgrading RepositoryManager, Driver and ConnectionManager: org.apache.sqoop.common.SqoopException: JDBCREPO_0007:Unable to lease link" error. Here i am explaing how to fix this error

Solution:
1. Download db-derby-10.12.1.1-bin.tar.gz and extract the files
2. Copy derby.jar and derbyclient.jar files from above extracted directory to /var/lib/sqoop2/

                    sudo cp derby.jar derbyclient.jar /var/lib/sqoop2/

3. And Copy derby.jar into /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/jars/

                   sudo cp derby.jar /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/jars/

4. Delete /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/lib/sqoop2/webapps/sqoop/WEB-INF/lib/derby-*.jar softlink

                     sudo rm derby-10.8.2.2.jar

5. Make soft link /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/lib/sqoop2/webapps/sqoop/WEB-INF/lib/derby.jar to /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/jars/derby.jar

sudo ln -s /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/jars/derby.jar /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/lib/sqoop2/webapps/sqoop/WEB-INF/lib/derby.jar

6. Now start Sqoop2 installation

Note: Don't forget to change ownership after Step: 2 to sqoop2 user

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email