asked on June 8, 2022
Hi,
At the moment, the error in the Flexmonster library occurs on the display of the grouped data. where not present all records of the database, and at the compare the sum Total visual in the report with sum total all records in excel, these values than different.
Thank.
⋅ June 9, 2022
Hi, Jefferson!
Thank you for such a detailed report. It helped us a lot to understand the matter.
Nevertheless, we need more details to reproduce the described behavior on our side.
Could you please specify if you are using Mondrian as a data source?
If yes, we would ask you to provide the dump of the database and cube structure to reproduce the case.
If not, please give us more information about your data source.
Looking forward to hearing from you.
Regards,
Solomiia
⋅ June 9, 2022
Hi Solomiia,
Yes, I use Mondrian, I attach the file based.xml that the Accelerator Flexmonster process needs, where the error with dimension occurred:
With the dimension "dim_ep_gm" alone in visual, the total sum is correct, but if it is generated with the dimension "dim_edis_ezn_ppal_gm" in a group, the sum is incorrect, as explained in the issue before.
Thanks.
⋅ June 10, 2022
Hello, Jefferson!
Thank you for the attached files. They are very helpful.
Nevertheless, we still need the database dump to reproduce the issue on our side. You can send it to our inbox in reply to this notification.
Looking forward to hearing from you.
Regards,
Solomiia
⋅ June 10, 2022
Hello Solomiia,
I talk to my area director, but they access our databases, so I need a static IP from you to connect to the databases. This database is a copy of the actual error databases, but the information is masked for client confidentiality.
Thanks
⋅ June 15, 2022
Hello Jefferson,
Please see the response we have sent you via email.
Best regards,
Valeriia
⋅ June 15, 2022
Hello Valeria,
Today we create access for your static IP, sending the password data by mail and the connection data to the server through this ticket.
Thanks
⋅ June 16, 2022
Hello
The connection to the server database is :
IP : 207.182.142.59
Port : 3307
Database : testflex
The password, we send by email.
Thanks
⋅ June 18, 2022
Hello Jefferson,
Thank you for the details.
I have sent you the response via email.
Best regards,
Valeriia
⋅ June 21, 2022
Hello, Jefferson!
Thank you for providing us with the username.
We have moved forward but still lack some permissions to establish the connection.
Please, have a look at the attached screenshot for the details.
Could you please check one more time that you can establish the connection with the given credentials from your side and that IP 52.5.238.221 has all the necessary permissions?
Looking forward to your response.
Regards,
Solomiia
⋅ June 21, 2022
Hello,
Excuse me, please check the connection for Accelerator Flexmonster and check permission for v_infinidb database, this is due to tables type columnstore connection error, at this time test is ok.
I attach a file, with the connection test, where the service is seen above and without any error.
Thanks.
⋅ June 22, 2022
Hello, Jefferson!
Thank you for your quick response.
We have managed to access the database and test the described behavior. The results are sent to you via email.
Looking forward to your response.
Regards,
Solomiia
⋅ June 29, 2022
Hello, Jefferson!
Hope you are having a great week.
Our team is wondering if you had some time to check out the attachments we have sent by email. Could you please let us know if you have any updates on the case?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ June 30, 2022
Hello, Solomiia,
I attach a file, with images and information about the test done today with the last version of Flexmonster. Where the error occurs equally.
Regards,
⋅ July 1, 2022
Hello, Jefferson!
Thank you for the new bug report. It was very helpful.
We have finally managed to reproduce the case on our side.
Out development team will research possible solutions and return back to you with the results by the ETA on July 25.
We kindly ask you to keep access to the testing database open for us till the ETA.
Feel free to contact us in case of any other questions.
Regards,
Solomiia
⋅ July 1, 2022
Hello, Solomiia
Thanks for your answer,
I have no problem keeping the service databases active, during the time indicated in before the message.
Regards
⋅ July 4, 2022
Hi, Jefferson!
Thank you for your response.
We will notify you about any updates on the matter.
You are welcome to contact us if any further questions arise.
Best regards,
Solomiia
⋅ July 18, 2022
Hi, Solomiia!
At this time, we have updated the jar file, sent by your colleague Valeriia Khomenets, whit this file new the error has not occurred.
Thank you very much for your help with this issue.
⋅ July 18, 2022
Hello, Jefferson!
Thank you for your confirmation.
Our team is glad to hear that everything works fine now.
You are welcome to contact us in case of any other questions.
Best regards,
Solomiia
