Killbill analytics error

[Nour El-din Mansour]

Hello there, 

I installed killbill and it's working fine , but i have a problem with the reports(analytics plugin).

I installed it and tried to import the default reports found here:

https://github.com/killbill/killbill-analytics-plugin/tree/59c282f97960dc59b944ca33e17353bc19d7c842/src/main/resources

- But whenever i click on any report to view it i get :

SyntaxError: Unexpected token < in JSON at position 0

- And when i click on "Download Raw Data" I get this error: 

Error while communicating with the Kill Bill server: Error 500: java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: Unsupported DB engine: GENERIC

Anyone knows what's this about ? 

[Reshma Bidikar]

Hello,

This error mostly occurs when the underlying table/view used by the report is incorrect and missing some database columns. Could you let us know which default report is causing the issue so we can check at our end? 

Secondly, could you confirm your Kill Bill version and the database with which you have configured Kill Bill?

Regards,

Reshma

[Nour El-din Mansour]

Hello there,

Sorry for the late reply, the messages came up in the spam for some reason.

The versions for the KillBill are :

killbill/killbill:0.22.29

killbill/mariadb:0.23

It happens with all of the reports imported from analytics seed.

[Reshma Bidikar]

Hello,

Apologies for the delay in responding.  Could you take the latest version of the analytics plugin and give it a try? There was a bug in the plugin which was just fixed. If the issue still persists with the reports, could you help me by providing details about which operating system you are on and how you are importing the reports?

Regards,

Reshma

[Nour El-din Mansour]

Hello , 

I installed the plugin using the Kaui interface , "Install New Plugin" ... and then i select "analytics" 

For the operating system i am using Ubuntu 20.04 and docker.

I installed using docker-compose ( which i attached ) 

Also importing the reports through downloading the resources folder ( https://github.com/killbill/killbill-analytics-plugin/tree/master/src/main/resources )  ... into killbill docker instance ( using docker cp ) ... changing the API keys and credentials in seed_reports.sh file .. and running it inside the container.

I also attached the seed_reports.sh output .

[Nour El-din Mansour]

Also i wanted to mention that i installed it through Kaui KPM interface because i couldn't find the .jar file in the repo so i can install it through the command line.

--
You received this message because you are subscribed to a topic in the Google Groups "Kill Bill users mailing-list" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/killbilling-users/85kWtKchdJo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to killbilling-us...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/killbilling-users/2dd432c6-b7bf-4297-8a59-c8fb95d5357fn%40googlegroups.com.

--

Best Regards,

Nour Mansour.

[Reshma Bidikar]

Hello,

I believe there was a bug due to which an older version of the analytics plugin got installed via Kaui. This is now fixed. So,  could you try installing the analytics plugin again via Kaui?

Regards,

Reshma

[Nour El-din Mansour]

Hello , 

So i installed the new plugin on a clean installation, it gave me a different error this time , that " Table &#39;killbill.v_report_refunds_total_daily&#39; doesn&#39;t exist";

And i checked the database , i didn't find these views ... so that's good news.

But why am I missing them ? And how can I get the rest of the missing views ? 

These are the views I have , it appears to be missing most of them.

I checked the invoice adjustments daily and the others , they seem to work.

--
You received this message because you are subscribed to a topic in the Google Groups "Kill Bill users mailing-list" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/killbilling-users/85kWtKchdJo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to killbilling-us...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/killbilling-users/5a587589-7b9d-4ce7-85a8-dcac4f5207e0n%40googlegroups.com.

[Pierre-Alexandre Meyer]

Hello,

You can find the view here: https://github.com/killbill/killbill-analytics-plugin/blob/b4805c4d0b5ac5fe4e7e1f24d8b579c06eba2196/src/main/resources/reports/refunds_total_daily/v_report_refunds_total_daily.ddl

All of the views for the example reports can be found here: https://github.com/killbill/killbill-analytics-plugin/tree/master/src/main/resources/reports

Hope this helps,

You received this message because you are subscribed to the Google Groups "Kill Bill users mailing-list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to killbilling-us...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/killbilling-users/CAJyVyhV%3DxBbjpKQKpNqHECny6x1-_V0XcTjVQj1NBv%3DJg0u0Rg%40mail.gmail.com.

--

Pierre

[Nour El-din Mansour]

Hello, 

Yeah , that worked nicely 👍

Thanks a LOT guys for helping in fixing this ,I really appreciate it ☺

[Nour El-din Mansour]

Although I am curious as to what made the views in the subfolders not imported correctly, maybe I should investigate that.

[Pierre-Alexandre Meyer]

Sweet!

Glad we could help ☺

--

Pierre

[Pierre-Alexandre Meyer]

These views are mostly examples for users to get started. The seed_reports.sh script was initially created for the core team, for development purposes. I suspect some of the views changed and the script wasn't updated correctly unfortunately.

PR welcome if you can find the issue!

--

Pierre