Pulse 5.6 install error - log files
We have attempted to install pulse 5.6 on our development instance and the following errors are recorded in the log files, typically for multiple records.
I can provide full log files if necessary.
Can you shed any light on where we are going wrong?
2017-10-19 15:43:42 ERROR MigrateToH2 Unable to copy record 27359 in table OperationLog: SQL [insert into “PUBLIC”.“OperationLog” (“Id”, “ServerName”, “ServiceName”, “ThreadId”, “UserName”, “StartTime”, “EndTime”, “TotalTime”, “ItemCount”, “UserWaitingCount”, “RunningCount”, “WaitingCount”, “Context”) values (cast(? as bigint), cast(? as varchar), cast(? as varchar), cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp), cast(? as real), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as varchar))]; Table “OperationLog” not found; SQL statement:
insert into “PUBLIC”.“OperationLog” (“Id”, “ServerName”, “ServiceName”, “ThreadId”, “UserName”, “StartTime”, “EndTime”, “TotalTime”, “ItemCount”, “UserWaitingCount”, “RunningCount”, “WaitingCount”, “Context”) values (cast(? as bigint), cast(? as varchar), cast(? as varchar), cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp), cast(? as real), cast(? as int), cast(? as int), cast(? as int), cast(? as int), cast(? as varchar)) [42102-174]
……
2017-10-19 15:44:14 ERROR MigrateToH2 Unable to copy record 68833 in table OperationLogItem: SQL [insert into “PUBLIC”.“OperationLogItem” (“Id”, “OperationLogId”, “ElapsedTime”, “State”, “Function”, “ObjectLock”, “UserLock”, “ObjectName”, “ObjectType”, “HasRLock”, “HasIXLock”, “HasWLock”, “Info”) values (cast(? as bigint), cast(? as bigint), cast(? as real), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as boolean), cast(? as boolean), cast(? as boolean), cast(? as clob))]; Table “OperationLogItem” not found; SQL statement:
insert into “PUBLIC”.“OperationLogItem” (“Id”, “OperationLogId”, “ElapsedTime”, “State”, “Function”, “ObjectLock”, “UserLock”, “ObjectName”, “ObjectType”, “HasRLock”, “HasIXLock”, “HasWLock”, “Info”) values (cast(? as bigint), cast(? as bigint), cast(? as real), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as varchar), cast(? as boolean), cast(? as boolean), cast(? as boolean), cast(? as clob)) [42102-174]
…….
2017-10-19 15:44:27 INFO MigrateToH2 Migration complete
2017-10-19 15:44:27 ERROR ScheduleManager An error occured scheduling jobs
org.jooq.exception.DataAccessException: SQL [select “PUBLIC”.“ServerSettings”.“Id”, “PUBLIC”.“ServerSettings”.“ServerName”, “PUBLIC”.“ServerSettings”.“ClientLogState”, “PUBLIC”.“ServerSettings”.“ClientLogInterval”, “PUBLIC”.“ServerSettings”.“OperatingSystem”, “PUBLIC”.“ServerSettings”.“CPUProcessorCount”, “PUBLIC”.“ServerSettings”.“TotalMemory”, “PUBLIC”.“ServerSettings”.“TM1Version”, “PUBLIC”.“ServerSettings”.“RESTURL”, “PUBLIC”.“ServerSettings”.“Active”, “PUBLIC”.“ServerSettings”.“Deleted” from “PUBLIC”.“ServerSettings” where “PUBLIC”.“ServerSettings”.“ServerName” = cast(? as varchar)]; Table “ServerSettings” not found; SQL statement:
select “PUBLIC”.“ServerSettings”.“Id”, “PUBLIC”.“ServerSettings”.“ServerName”, “PUBLIC”.“ServerSettings”.“ClientLogState”, “PUBLIC”.“ServerSettings”.“ClientLogInterval”, “PUBLIC”.“ServerSettings”.“OperatingSystem”, “PUBLIC”.“ServerSettings”.“CPUProcessorCount”, “PUBLIC”.“ServerSettings”.“TotalMemory”, “PUBLIC”.“ServerSettings”.“TM1Version”, “PUBLIC”.“ServerSettings”.“RESTURL”, “PUBLIC”.“ServerSettings”.“Active”, “PUBLIC”.“ServerSettings”.“Deleted” from “PUBLIC”.“ServerSettings” where “PUBLIC”.“ServerSettings”.“ServerName” = cast(? as varchar) [42102-174]
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.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:339)
at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:330)
at org.jooq.impl.AbstractResultQuery.fetchAny(AbstractResultQuery.java:463)
at org.jooq.impl.SelectImpl.fetchAny(SelectImpl.java:1144)
at com.cubewise.db.SettingsLoader.load(SourceFile:148)
at com.cubewise.db.SettingsLoader.getSettingsAsAdmin(SourceFile:48)
at com.cubewise.R.a(SourceFile:64)
at com.cubewise.db.MigrateToH2.run(SourceFile:138)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.h2.jdbc.JdbcSQLException: Table “ServerSettings” not found; SQL statement:
select “PUBLIC”.“ServerSettings”.“Id”, “PUBLIC”.“ServerSettings”.“ServerName”, “PUBLIC”.“ServerSettings”.“ClientLogState”, “PUBLIC”.“ServerSettings”.“ClientLogInterval”, “PUBLIC”.“ServerSettings”.“OperatingSystem”, “PUBLIC”.“ServerSettings”.“CPUProcessorCount”, “PUBLIC”.“ServerSettings”.“TotalMemory”, “PUBLIC”.“ServerSettings”.“TM1Version”, “PUBLIC”.“ServerSettings”.“RESTURL”, “PUBLIC”.“ServerSettings”.“Active”, “PUBLIC”.“ServerSettings”.“Deleted” from “PUBLIC”.“ServerSettings” where “PUBLIC”.“ServerSettings”.“ServerName” = cast(? as varchar) [42102-174]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.schema.Schema.getTableOrView(Schema.java:440)
at org.h2.command.Parser.readTableOrView(Parser.java:4884)
at org.h2.command.Parser.readTableFilter(Parser.java:1117)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1724)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1832)
at org.h2.command.Parser.parseSelectSub(Parser.java:1718)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1560)
at org.h2.command.Parser.parseSelect(Parser.java:1548)
at org.h2.command.Parser.parsePrepared(Parser.java:415)
at org.h2.command.Parser.parse(Parser.java:289)
at org.h2.command.Parser.parse(Parser.java:261)
at org.h2.command.Parser.prepareCommand(Parser.java:226)
at org.h2.engine.Session.prepareLocal(Session.java:437)
at org.h2.engine.Session.prepareCommand(Session.java:380)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:70)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)
at org.jooq.impl.ProviderEnabledConnection.prepareStatement(ProviderEnabledConnection.java:107)
at org.jooq.impl.SettingsEnabledConnection.prepareStatement(SettingsEnabledConnection.java:71)
at org.jooq.impl.AbstractResultQuery.prepare(AbstractResultQuery.java:220)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:272)
… 9 more
2017-10-19 15:44:27 ERROR StateJob Unable to get state information
2017-10-19 15:44:27 ERROR StateJob Unable to get update state
information
………
2017-10-19 16:02:37 ERROR SecurityUtil unable to validate instance Access
2017-10-19 16:02:37 INFO UserRoleFilter User Guest doesn’t have access to GET /login