Documentation Center

Troubleshooting database command errors

The following table provides solutions for troubleshooting loaddb commands.

IssueSolution/Information
Wrong port (http protocol, local)

You get the following error message when running loaddb CHECKDB from a non-secure system.

loaddb -Dlc.port=8081 -Dlc.zip=yes -Dlc.backup=yes CHECKDB

BUILD FAILED
C:\Program Files\Apache Software
Foundation\Tomcat 7.0\webapps\LiveContent\
WEB-INF\build.xml:119:ERROR: Cannot connect 
to 'http://delivery.lc.example.com/CollaborativeReview'

(where lc refers to an example related to output, and delivery specifies it further as a delivery server)

The port number you entered must match the port defined in $tomcat\conf\server.xml
Wrong port (https protocol, local)

You get the following error message when running loaddb CHECKDB from a secure system.

loaddb -Dlc.port=8444 -Dlc.protocol=https -Dlc.host=companyserver.corp -Dlc.zip=yes -Dlc.backup=yes CHECKDB

BUILD FAILED
C:\Program Files\Apache Software Foundation\
Tomcat 7.0\webapps\LiveContent\WEB-INF\
build.xml:119: ERROR: Cannot connect to 
'https://delivery.lc.example.com/CollaborativeReview'
The port number you entered must match the ports defined in $tomcat\conf\server.xml
Wrong port (https protocol, remote)

You get the following error message when running loaddb CHECKDB from a secure system.

loaddb -Dlc.port=8444 -Dlc.protocol=https -Dlc.host=example.com -Dlc.zip=yes -Dlc.backup=yes CHECKDB

LOAD:
Wait for LiveContent webapp running

BUILD FAILED
C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\LiveContent\WEB-INF\build
.xml:119: ERROR: Cannot connect to 
'https://delivery.lc.example.com/CollaborativeReview'
The port number you entered must match the ports defined in $tomcat\conf\server.xml
Missing port (https protocol, local)

You get the following error message when running loaddb CHECKDB from a secure system.

loaddb -Dlc.protocol=https -Dlc.host=companyserver.corp -Dlc.zip=yes -Dlc.backup=yes CHECKDB
LOAD:
Wait for LiveContent webapp running javax.net.ssl.SSLException: Unrecognized 
SSL message, plaintext connection?

BUILD FAILED
C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\LiveContent\WEB-INF\
build.xml:120: https://delivery.lc.example.com/
LiveContent/web/util.xql?action=ping 
doesn't exist
You must specify a Dlc.port argument.

Missing cacerts from cacerts keystore

You get the following error message when running : loaddb CHECKDB from a secure system.

loaddb -Dlc.port=8443 -Dlc.protocol=https -Dlc.host=example.com -Dlc.zip=yes -Dlc.backup=yes CHECKDB
LOAD:
Wait for Collaborative Review webapp running
javax.net.ssl.SSLHandshakeException: 
sun.security.validator.ValidatorException: 
PKIX path building failed: 
sun.security.provider.certpath. 
SunCertPathBuilderException: unable to find 
valid certification path to requested target.

BUILD FAILED
C:\Program Files\Apache Software Foundation
\Tomcat 7.0\webapps\LiveContent\
WEB-INF\build.xml:120: 
https://delivery.lc.example.com/LiveContent/web/
util.xql?action=ping doesn't exist.
You must specify a valid cert path. The cert must exist in Java's cacerts keystore from where you initiate loaddb.
Missing CAcert from cacerts keystore when backing up remotely.

You get the following error message when running from a secure system.

loaddb -Dlc.port=8443 -Dlc.protocol=https -Dlc.host=example.com -Dlc.zip=yes -Dlc.backup=yes CHECKDB
LOAD: 
Wait for Collaborative Review webapp running 
javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: 
PKIX path building failed: 
sun.security.provider.certpath.
SunCertPathBuilderException:unable to find 
valid certification path to requested target.

BUILD FAILED 
C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\LiveContent\
WEB-INF\build.xml:120: https://delivery.lc.example.com/
LiveContent/web/util.xql?action=ping doesn't exist. 
You must specify a valid cert path. The cert must exist in Java's cacerts keystore from where you initiate loaddb.