Common Issues & Workarounds

This help page contains a list of common installation / update problems as well as troubleshooting steps and work arounds. 

Patch Install Failures

Patch Fails with message: Use the above command to remove the dbex.lck files

This failure is a preventative failure to keep the patch from being installed if the DTS Service is running on Linux installations.  The DTS can sometimes leave lock files so the error can occur even if the DTS has been shut down.  To work around, verify that the DTS and Staging DTS services are shutdown by running the <InstallDir>/TomcatShutdown.sh and <InstallDir>/Staging/TomcatShutdown.sh command, then copy,paste, and run the delete / find command in the error message to the console.  After the command is run you can run the patch install.sh again.  This failure may happen twice in installations with both production and staging DTS instances installed in the Installation tree. 

Patch fails to install with a database connection / database permission error

This error usually occurs on installations that have been migrated between servers or between databases.  It can also happen if the database username or password has changed since the product was originally installed.  To resolve follow the steps to verify / updated the <InstallDir>/rxconfig/Installer/rxrepository.properties file in Appendix A of the Migrating Percussion Environments page to correct the file.  Once that is complete, uninstall the failed patch by running ./uninstall.sh or uninstall.bat, and then run the patch install again. 

Patch fails to install with a mysql repository database error on foreign key / index

This error can be caused by an incorrect database collation on the mysql server.  To correct this, make sure that the database collation is correct on the database.  Run the following SQL:

ALTER DATABASE yourdb CHARACTER SET utf8 COLLATE utf8_general_ci;

Once completed, uninstall and then install the patch again. 

Post Installation Issues

DTS Fails to start with com.percussion.tomcat.valves.PSSimpleRedirectorValve.invoke(PSSimpleRedirectorValve.java:104) ~[perc-tomcat-common-1.0.0-SNAPSHOT.jar:?] Errors in Logs

This error can be caused by a missing or broken database driver when the DTS service is started.  If the DTS is configured for MySQL and you are using a symbolic link for the MySQL Java Connector.  Verify that the link is still good by checking the mysql-connector.jar file in the Deployment/Server/lib/mysql-connector.jar location. 


FTP Publishing Fails With Error

"An unexpected problem occurred: Problem connecting to ftp server: connect: timeout can't be negative".  This error can be caused by a missing timeout setting, corrected in a later patch, on the FTP publisher configuration.  You can work around this problem by editing the AppServer/server/rx/deploy/rxapp.ear/rxapp.war/WEB-INF/user/config/spring/publisher-beans.xml file and add a timeout property to the sys_ftp and sys_ftp_only bean configurations.

 

<bean id="sys_ftp"
class="com.percussion.rx.delivery.impl.PSFtpDeliveryHandler">
<!-- Properties that can be set here:
timeout
(defaults to -1 as not defined.
It is the socket timeout in milliseconds for both when opening a
socket and a currently open connection).
usePassiveMode
(defaults to false.
Determines if using passive or active mode for the FTP client.
Defaults to use active mode. If using passive mode is on, then it
will also disable the remote verification
-->
<property name="usePassiveMode" value="true" />
<property name="timeout" value="10000" />
</bean>

<bean id="sys_ftp_default"
class="com.percussion.rx.delivery.impl.PSFtpDeliveryHandler">
<!-- Properties that can be set here:
timeout
(defaults to -1 as not defined.
It is the socket timeout in milliseconds for both when opening a
socket and a currently open connection).
usePassiveMode
(defaults to false.
Determines if using passive or active mode for the FTP client.
Defaults to use active mode. If using passive mode is on, then it
will also disable the remote verification
-->
<property name="usePassiveMode" value="true" />
<property name="timeout" value="10000" />
</bean>

Saving this file and restarting the instance will correct this error.


Full Publishing Fails with error: Prepared or callable statement has more than 2000 parameter markers

This can be caused by a known issue / limitation of the Ignore Unmodified Assets feature of the publisher. To work around, uncheck the "Ignore Unmodified Assets" option and save the Publishing Server configuration.  After de-selecting this option, Full Publish will work correctly.