Documentation Center

Troubleshooting database commands errors

The following table provides solutions for troubleshooting loaddb commands.

IssueSolution/Information
Wrong port (http protocol, local)

I 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://contentdelivery.lc.example.com/ContentDelivery'

(where lc refers to an example related to Content Delivery, and contentdelivery 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)

I 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://contentdelivery.lc.example.com/ContentDelivery'
The port number you entered must match the ports defined in $tomcat\conf\server.xml
Wrong port (https protocol, remote)

I 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://contentdelivery.lc.example.com/ContentDelivery'
The port number you entered must match the ports defined in $tomcat\conf\server.xml
Missing port (https protocol, local)

I 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://contentdelivery.lc.example.com/
LiveContent/web/util.xql?action=ping 
doesn't exist
You must specify a Dlc.port argument.

Missing cacerts from cacerts keystore

I 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 Content Delivery 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://contentdelivery.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.

I 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 Content Delivery 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://contentdelivery.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.