Skip to main content
N
NiKlaus12-Amethyst
12-Amethyst
March 4, 2024
Solved

Upgrading Inlfuxdb 1.8.10 to 2.7.5 on thingworx 9.3 - Unable to query or view data

  • March 4, 2024
  • 1 reply
  • 1604 views

Hi there, 

 

I am looking for a solution on the upgrade process regarding inlfuxdb and thingworx. 
I managed to successfully upgrade influxdb from version 1.8.10 to 2.7.5 and I am able to succesfully connect a new persistence provider to thingworx. 
Not able to see an of the data that is present in the data base. 

On the influxdbV2 frontend hosted on port 8086, I am able to view the historic data, so i know i haven't lost the data. It's bucket name appeared a thingworx/autogen, so i renamed it to thingworx as that was the settings in the persistant provider. 
When we do a query named property history, we get an error with code : 2006

Any help or assistance would be appreciated. 

Thanks

Best answer by Surya_Tiwari

Hi @NiKlaus  check the DB user permission, and look at the below article.

https://www.ptc.com/en/support/article/CS239982

 

1 reply

S
Surya_Tiwari16-Pearl
16-Pearl
March 4, 2024

Hi, @NiKlaus   Can you share the Thingworx and DB logs?

N
NiKlaus12-AmethystAuthor
12-Amethyst
March 4, 2024

Hi @Surya_Tiwari , which logs from thingworx? 

Here is the configuration log file: 

2024-03-04 11:37:15.491+0000 [L: INFO] [O: Import] [I: END_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-4] action = END_BLOCK_CHANGE
2024-03-04 11:37:20.150+0000 [L: INFO] [O: Import] [I: BEGIN_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-2] action = BEGIN_BLOCK_CHANGE
2024-03-04 11:37:20.150+0000 [L: INFO] [O: Import] [I: END_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-2] action = END_BLOCK_CHANGE
root@ubuntu:/ThingworxStorage/logs# tail -100 ConfigurationLog.log
2024-03-04 11:34:22.288+0000 [L: INFO] [O: Import] [I: END_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-4] action = END_BLOCK_CHANGE
2024-03-04 11:35:34.341+0000 [L: INFO] [O: Import] [I: END_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-7] action = END_BLOCK_CHANGE
2024-03-04 11:35:41.537+0000 [L: INFO] [O: Import] [I: BEGIN_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = BEGIN_BLOCK_CHANGE
2024-03-04 11:35:41.537+0000 [L: INFO] [O: PersistenceProvider] [I: InfluxDB2] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = CREATE, reason = header : name : updated, projectName : updated, persistenceProviderPackage : updated, isDefault : updated, enabled : updated_
2024-03-04 11:35:41.537+0000 [L: INFO] [O: Import] [I: END_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = END_BLOCK_CHANGE
2024-03-04 11:36:09.258+0000 [L: INFO] [O: Import] [I: BEGIN_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = BEGIN_BLOCK_CHANGE
2024-03-04 11:36:09.258+0000 [L: INFO] [O: PersistenceProvider] [I: InfluxDB2] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = MODIFY, reason = configuration : orgName : updated, bucketName : updated, token : updated_
2024-03-04 11:36:09.258+0000 [L: INFO] [O: Import] [I: END_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = END_BLOCK_CHANGE
2024-03-04 11:36:19.068+0000 [L: INFO] [O: Import] [I: BEGIN_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = BEGIN_BLOCK_CHANGE
2024-03-04 11:36:19.068+0000 [L: INFO] [O: PersistenceProvider] [I: InfluxDB2] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = MODIFY, reason = header : enabled : updated_
2024-03-04 11:36:19.068+0000 [L: INFO] [O: Import] [I: END_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-6] action = END_BLOCK_CHANGE
2024-03-04 11:36:24.737+0000 [L: INFO] [O: Import] [I: BEGIN_BLOCK_CHANGE] [U: snkosi] [S: ] [P: ] [T: https-jsse-nio-443-exec-7] action = BEGIN_BLOCK_CHANGE

 

Here is the influx upgrade log: 

{"level":"info","ts":1709549032.323138,"caller":"upgrade/setup.go:73","msg":"CLI config has been stored.","path":"/root/.influxdbv2/configs"}
{"level":"info","ts":1709549032.3232183,"caller":"upgrade/database.go:202","msg":"Checking available disk space"}
{"level":"info","ts":1709549032.3258162,"caller":"upgrade/database.go:223","msg":"Computed disk space","free":"722 GB","required":"3.3 GB"}
{"level":"info","ts":1709549105.738603,"caller":"upgrade/database.go:51","msg":"Upgrading databases"}
{"level":"info","ts":1709549107.4220204,"caller":"upgrade/database.go:101","msg":"Creating mapping","database":"thingworx","retention policy":"autogen","orgID":"xxxxxxx","bucketID":"xxxxxx"}
{"level":"info","ts":1709549330.8308513,"caller":"upgrade/database.go:195","msg":"Database upgrade complete","upgraded_count":1}
{"level":"info","ts":1709549330.831032,"caller":"upgrade/security.go:45","msg":"Upgrading 1.x users"}
{"level":"warn","ts":1709549330.831069,"caller":"upgrade/security.go:50","msg":"User is admin and will not be upgraded","username":"xxxx"}
{"level":"info","ts":1709549330.8311048,"caller":"upgrade/security.go:115","msg":"User upgrade complete","upgraded_count":0}
{"level":"info","ts":1709549330.831132,"caller":"upgrade/upgrade.go:488","msg":"Upgrade successfully completed. Start the influxd service now, then log in","login_url":"http://localhost:8086"}

 

 

S
Surya_Tiwari16-Pearl
16-Pearl
March 4, 2024

Hi, @NiKlaus  Can you share the application and error logs?

Terms & ConditionsCookie settingsAccessibility statement