Error while saving Datasource

Question

While testing the datasource.It's correctly tested but on saving the datasource it prompted with error "Error while posting  DS"

Answer 1

Dear Vishal,

We need more information about the environment.

Best Regards

Angelo

Comments

Hello, I have met the same problem.

Here is my environment infomation

    Knowage：Knowage-6_2_0-RC-CE-Installer-Windows-JVM64bit-20180509

    OS: window 7

Here  is my Screen shoot

Answer 2

Hi,

It sounds like in your database knowage_ce you lack the table SBI_DATA_SOURCE.

I discovered that this table isn't created during installation if you choose Highcharts Js (without demo), you have to use the db script to create those table, for instance :

mysql -u root -p knowage_ce -e "source ./MySQL_create.sql ;"

Also you may need to change your sql_mode with something like this :

mysql -u root -p knowage_ce -e "SET sql_mode=(SELECT REPLACE(@@sql_mode,'NO_ZERO_DATE','')) ;"

HTH

Regards,

Sylvain

Comments

Hi,

I'm having the same issue, installed CE on Ubuntu 16.04 with Chart.js.
However I cannot find the MySQL_create.sql you refer to.  I've found MySQL_drop.sql, not create.

please advise.

thanks
Neil

---

The script MySQL_create.sql I was refering to is downloadable on source forge (https://forge.ow2.org/project/showfiles.php?group_id=442&release_id=5958)
under section "Knowage 6.0.0 - Script db", you will find the file mysql-dbscripts-6.0.0_20170616.zip (https://forge.ow2.org/project/download.php?group_id=442&file_id=21770) containing the scripts.

---

excellent, thanks.
BTW I had to edit the SBI_DATA_SOURCE script to add DEFAULT NULL to time_up & time_de.
Maybe that's why the table wasn't created with the others.

Other than that, worked fine and data source added fine.

thanks