Workflow Builder - installation fails - PTC.FactoryConsole.DataTable : Invalid format: "permanent"

[Radek]

Hello 

I have set up Thingworx environment with Manufacturing Apps and installation went fine.

However after adding Wokflow Builder - Console log fails to display

and I have message in logs

[message: Unable to Invoke Service QueryDataTableEntriesLocalized on PTC.FactoryConsole.DataTable : Invalid format: "permanent"]

For me it looks like the problem is that I have in CurenntLicenseInfo

THINGWORX_FOUNDATION

twx_utilities_workflows

uncounted

uncounted

0

8.1

permanent

As a expiration date

Did anyone encountered that issue ?

[hchanana]

Hi @Radek ,

Can you please share your license file, application logs and the exact version of ThingWorx, Manufacturing apps and workflow builder to look into this further.

Thanks,

Himanshu

[BFO]

I have the same issue:

Previously was in Manufacturing App 8.3

Decide to completely reinstall Manufacturing App 8.4 (download demo version) and generate license file based on new ID.

Start ok but no tiles in application and the same error than Radek occur.

Can you help ?

Best regards,

Log:

665+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Starting All Things...
2019-05-21 17:08:28.712+0200 [L: WARN] [O: c.t.t.Thing] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] Thing [PTC.Factory.DefaultShift] has logged properties but does not have a valid value stream assigned
2019-05-21 17:08:28.822+0200 [L: WARN] [O: c.t.t.Thing] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-0] Thing [PTC.Factory.Test.OPCDAThing] has logged properties but does not have a valid value stream assigned
2019-05-21 17:08:28.822+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Activating Property Bindings...
2019-05-21 17:08:28.837+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Property Binding relationships...
2019-05-21 17:08:28.837+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Sending Post Start Notifications...
2019-05-21 17:08:28.853+0200 [L: INFO] [O: c.t.s.s.i.SubscriptionStoreInMemoryThreadSafe] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] Firing event Type.Thing:Entity.PTC.FactoryConsole.DataTable:Event.ThingStart with 1 subscribers
2019-05-21 17:08:28.853+0200 [L: INFO] [O: c.t.s.s.i.SubscriptionStoreInMemoryThreadSafe] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-3] Firing event Type.Thing:Entity.PTC.SCA.Common.AlertNotification.NotificationDeliveryConfiguration:Event.ThingStart with 1 subscribers
2019-05-21 17:08:28.853+0200 [L: INFO] [O: c.t.s.s.i.SubscriptionStoreInMemoryThreadSafe] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] Firing event Type.Thing:Entity.PTC.FactoryConsole.C_DataTable_8.4.0_01:Event.ThingStart with 1 subscribers
2019-05-21 17:08:28.993+0200 [L: INFO] [O: c.t.s.s.i.SubscriptionStoreInMemoryThreadSafe] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-0] Firing event Type.Thing:Entity.PTC.ConvergeConsole.DataTable:Event.ThingStart with 1 subscribers
2019-05-21 17:08:29.134+0200 [L: INFO] [O: c.t.s.s.l.LicenseUsageData] [I: ] [U: SuperUser] [S: ] [T: pool-9-thread-1] Added license usage data with UsageID: 133 to table successfully!
2019-05-21 17:08:30.025+0200 [L: INFO] [O: c.t.s.s.i.SubscriptionStoreInMemoryThreadSafe] [I: ] [U: ] [S: ] [T: DefaultQuartzScheduler_Worker-1] Firing event Type.Thing:Entity.PTC.SCA.SCO.KEPServerExStatusCalculationScheduler:Event.ScheduledEvent with 1 subscribers
2019-05-21 17:08:31.025+0200 [L: INFO] [O: c.t.s.s.f.FileTransferSubsystem] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Restarting 0 transfer jobs loaded from persistence provider
2019-05-21 17:08:31.025+0200 [L: INFO] [O: c.t.s.s.f.FileTransferSubsystem] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Finished loading transfer jobs from persistence (took 0 ms)
2019-05-21 17:08:31.025+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Thingworx Server Application...ON
2019-05-21 17:08:31.040+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Datastore database...INITIALIZED
2019-05-21 17:08:32.618+0200 [L: WARN] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-9080-exec-4] Server WebSocket closed unexpectedly and has already been unregistered from Server Endpoint [ws session id: 3] An established connection was aborted by the software in your host machine
2019-05-21 17:08:32.618+0200 [L: WARN] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-9080-exec-2] Server WebSocket closed unexpectedly and has already been unregistered from Server Endpoint [ws session id: 2] An established connection was aborted by the software in your host machine
2019-05-21 17:08:32.618+0200 [L: WARN] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-9080-exec-6] Server WebSocket closed unexpectedly and has already been unregistered from Server Endpoint [ws session id: 0] An established connection was aborted by the software in your host machine
2019-05-21 17:08:32.947+0200 [L: WARN] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:06:18.440Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connection to ThingWorx was closed. | Platform: dsisv969.hgeurope.com:9080/Thingworx/WS.
2019-05-21 17:08:32.947+0200 [L: ERROR] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:06:20.050Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connection to ThingWorx failed. | Platform dsisv969.hgeurope.com:9080/Thingworx/WS, error: could not establish a websocket connection.
2019-05-21 17:08:32.947+0200 [L: ERROR] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:06:21.581Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connection to ThingWorx failed. | Platform dsisv969.hgeurope.com:9080/Thingworx/WS, error: could not initialize a secure socket connection.
2019-05-21 17:08:32.947+0200 [L: ERROR] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:06:58.724Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connection to ThingWorx failed. | Platform dsisv969.hgeurope.com:9080/Thingworx/WS, error: unknown error.
2019-05-21 17:08:32.947+0200 [L: ERROR] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:07:24.761Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connection to ThingWorx failed. | Platform dsisv969.hgeurope.com:9080/Thingworx/WS, error: could not establish a websocket connection.
2019-05-21 17:08:32.947+0200 [L: ERROR] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:07:25.792Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connection to ThingWorx failed. | Platform dsisv969.hgeurope.com:9080/Thingworx/WS, error: could not initialize a secure socket connection.
2019-05-21 17:08:32.947+0200 [L: ERROR] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:08:07.484Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connection to ThingWorx failed. | Platform dsisv969.hgeurope.com:9080/Thingworx/WS, error: unknown error.
2019-05-21 17:08:33.728+0200 [L: INFO] [O: c.t.l.Log] [I: KEPServerEX\ThingWorx Native Interface @ 2019-05-21T15:08:32.838Z thingname='KepServer-GW'] [U: Administrator] [S: ] [T: KepServer-GW_BulkLog] Connected to ThingWorx. | Platform: dsisv969.hgeurope.com:9080/Thingworx/WS, Thing name: 'KepServer-GW'.
2019-05-21 17:08:42.874+0200 [L: ERROR] [O: c.t.w.Things] [I: ] [U: Administrator] [S: ] [T: http-nio-9080-exec-5] [message: Unable to Invoke Service QueryDataTableEntriesLocalized on PTC.FactoryConsole.DataTable : Invalid format: "permanent"]

[hchanana]

Hi @BFO ,

It seems there is a conflict between manufacturing apps and utilities tiles.

Can you please uncheck/set the values to false of PTC.BusinessProcessEditor and PTC.BusinessProcessManager TileMashuporURL from PTC.FactoryConsole.DataTable or any custom datatable if you are using.

This will hide tiles from manufacturing console. If you want to use this you can use PTC.ConvergeConsole mashup as these are part of this.

Thanks,

Himanshu

[abarki]

Hi @BFO,

If @hchanana response has answered your question, please mark as Accepted Solution, for the benefit of others who may have the same question.

Thank you,

abarki