Having a problem at a client where the migration packages are not visible, and documentation does not finish.
Restarting services has not worked. Any suggestions? Version 5.8.2.
Below latest error in error log:
2020-04-03 05:40:48 ERROR org.quartz.core.ErrorLogger Job (Core.LoggerUpdate threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.jooq.exception.DataAccessException: SQL [insert into [Session] ([ServerName], [ServiceName], [ThreadId], [UserName], [DisplayName], [LogInTime], [LogOutTime], [SessionTime], [LogCount], [WaitingCount], [RunningCount], [CommittingCount], [RollingBackCount], [UserWaitingCount], [IsAdmin], [IsReadOnly], [IsTM1Web], [Context]) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; String or binary data would be truncated.]
at org.quartz.core.JobRunShell.run(JobRunShell.java:218)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
Caused by: org.jooq.exception.DataAccessException: SQL [insert into [Session] ([ServerName], [ServiceName], [ThreadId], [UserName], [DisplayName], [LogInTime], [LogOutTime], [SessionTime], [LogCount], [WaitingCount], [RunningCount], [CommittingCount], [RollingBackCount], [UserWaitingCount], [IsAdmin], [IsReadOnly], [IsTM1Web], [Context]) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; String or binary data would be truncated.
at org.jooq.impl.Utils.translate(Utils.java:1078)
at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:302)
at org.jooq.impl.UpdatableRecordImpl.storeInsert(UpdatableRecordImpl.java:172)
at org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:135)
at com.cubewise.P.execute(SourceFile:92)
at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
... 1 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:328)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
at org.jooq.tools.jdbc.DefaultPreparedStatement.executeUpdate(DefaultPreparedStatement.java:83)
at org.jooq.impl.AbstractStoreQuery.execute(AbstractStoreQuery.java:295)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:298)
... 5 more