Issues : Upgrade 6.1 to 6.2

Question

#1 : CacheDB

In version 6.1, to use MSSQL DB as Cache DB was enabled while in v6.2, this functionality has been disabled.

#2 : Upgrade

I have followed upgrade instruction as per following link

https://www.knowage-suite.com/qa/2932/how-to-upgrade-from-knowage-6-1-1-ce-to-knowage-6-2-0-rc-ce?show=2932#q2932

Step 1 - In v6.2, while I open DATASOURCE option and test each of data source, no issue.

Step 2 - Clicking on option DATASET, error show 'DATASOURCE CANNOT BE NULL'.

Step 3 - Created a new dataset and save it successfully but can't see new as well old datasets due to error mentioned in step 2.

Step 4 - Tried to open Dashboards created with v6.1 but error 'UNABLE TO OPEN WIDGET........'.

For troubleshooting, I again started v6.1 and change the cachedb from SQL Server to Mariadb. Done upgrade process again.There is no status change for step 1,2,3 but step 4, I found dashboards running.

Help me to get the above issue solve. Without datasets, I can't move further.

Let me know if anyone need more information on above.

I also take this opportunity to thank Knowage Team for new version where I can see a huge transformation from 6.1.

Regards

Sameer

Answer 1

Hi,

   probably some dataset (active or not) references a wrong datasource (maybe older that doesn't exist anymore?).

 So, to fix STEP2 you should check all datasets configuration field (json content) and verify that the 'dataource' property has a valid and current datasource label available. The table to check is SBI_DATA_SET on Knowage metadata schema.

Pay attention that the same check is necessary on older dataset versions too (where flag 'active' is 0).

To semplify, if you aren't interested to older version history you can delete them.

Comments

Thanks. Will give a try as suggested.

Get back with result.