Problem

This article addresses the occasion when the Transfer Log Maintenance Application fails to execute and export the File Tracking Logs during its scheduled occurrence.

This behavior is observed after version 5.5-20220224 of Secure Transport. The Transfer Log Maintenance Application fails with the following message observed in the TM log:

org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found ')' near line 1, column 170 [delete from com.tumbleweed.st.server.appframework.TransferResubmitDataBean rd where rd.mStartTime >= :fromDate and rd.mStartTime <= :toDate and rd.mEndTime <= :toEndDate)]
at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74)
at org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:301)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)

This issue is observed only when there is a record with a NULL value for sessionStartTime in the TransferDetails table in the DB.

Resolution

Fill in the value for "Delete in-progress transfers that started more than" as shown below:

The number of days specified in the "Delete in-progress transfers that started more than" field cannot be less than the days specified in the "Delete transfer log when:" field.