Pulse 5.6 install error - log files


#1

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


#2

Hi @andy.webber,

In order to move data from a SQL Lite to a H2 database, we had to change the structure of some tables. During the upgrade to v5.6, you might see some error messages in the Pulse logs but it does not mean that the data is not migrated successfully.

The most important after the upgrade is to check if Pulse works with the new database.

If the upgrade was successful and Pulse is working with the new H2 database, you can then configure Pulse to use MS SQL Server.

Cheers,

Vincent


#3

Hi Vincent,

We currently can’t access Pulse following the upgrade. Is there anything you could suggest to help?

Thin client says that the page can’t be displayed. Do we need to anything in the configuration differently?


#4

Hi Andy,

We will follow up with the UK team to help you get your issue fixed.