Sapiens.BI PRO - Analytic Reporting

by sapiens.bi

Sapiens.BI helps you produce effective reports with charts in a fast and easy way. It is a Sugar and SuiteCRM BI plug-in with powerful reporting capabilities, ease of use, elegant design, and a quick and easy setup. This Reporting Tool is easy to use, there is no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports.

Free 30 day trial
Try it Now

#3829 - Report loading not working when include details checkbox selected in Group & Order Tab

Open Bug? created by agonzalez Verified Purchase 3 years ago

Any report we configure to be grouped by some fields and the checkbox include details is selected, fail on load and the load spinner next to preview button gets stalled forever. Checking for ajax calls we can found this:

[Wed Sep 01 10:11:00.545489 2021] [php7:error] [pid 2716:tid 388] [client 192.168.1.199:27645] PHP Fatal error: Uncaught TypeError: Argument 1 passed to ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2::ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZU2020() must be an instance of ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZV2121, string given, called in D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php on line 116 and defined in D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php:116\nStack trace:\n#0 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(116): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZU2020(' Query Failed:S...')\n#1 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(116): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZT1919(Array, true)\n#2 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(116): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZG66(Array, true)\n#3 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(151): ZZZZZZZZZZZZZZZZZZZZZZZZZ in D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php on line 116, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515

We cannot debbug further because code offsucation.

We face this problem after suitecrm update from 7.10.x (don't rember x) to 7.10.30

Thanks in advance.

  1. sapiens-bi member avatar

    sapiens.bi Provider

    3 years ago

    Thank you for contacting us! Do you know what Analytic Reporting Tool / Sapiens.BI version have you installed? Or did you do any upgrades of Analytic Reporting after original installation on 2017?

    Best Regards, Sapiens.BI Team

    • agonzalez member avatar

      agonzalez Verified Purchase

      3 years ago

      Hi. We have Sapiens BI 3.0.4 installed.

      Best Regards Alberto González

    • agonzalez member avatar

      agonzalez Verified Purchase

      3 years ago

      The current version is 3.0.4, but yes, we have upgraded the version form the initial installed in 2017 to 3.0.4 version, after the suitecrm upgrade.

      Best Regards Alberto

  2. agonzalez member avatar

    agonzalez Verified Purchase

    3 years ago

    By the way something that can be relevant is that we use SQL Server 2012 as db backend. Previous warning messages before de fatal error:

    ... [Wed Sep 01 10:10:59.498582 2021] [php7:warn] [pid 2716:tid 1148] [client x.x.x.x:27644] PHP Warning: sqlsrv_client_info() expects exactly 1 parameter, 0 given in D:\www\crm-dev\include\database\SqlsrvManager.php on line 562, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:10:59.498582 2021] [php7:warn] [pid 2716:tid 1148] [client x.x.x.x:27644] PHP Warning: sqlsrv_server_info() expects exactly 1 parameter, 0 given in D:\www\crm-dev\include\database\SqlsrvManager.php on line 562, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:10:59.498582 2021] [php7:warn] [pid 2716:tid 1148] [client x.x.x.x:27644] PHP Warning: array_merge(): Argument #1 is not an array in D:\www\crm-dev\include\database\SqlsrvManager.php on line 562, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:10:59.592334 2021] [php7:warn] [pid 2716:tid 408] [client x.x.x.x:32786] PHP Warning: array_merge(): Argument #2 is not an array in D:\www\crm-dev\include\MVC\SugarApplication.php on line 558, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:10:59.811091 2021] [php7:warn] [pid 2716:tid 408] [client x.x.x.x:32786] PHP Warning: array_merge(): Argument #2 is not an array in D:\www\crm-dev\include\MVC\SugarApplication.php on line 558, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:11:00.139220 2021] [php7:warn] [pid 2716:tid 388] [client x.x.x.x:27645] PHP Warning: array_merge(): Argument #2 is not an array in D:\www\crm-dev\include\MVC\SugarApplication.php on line 558, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:11:00.514225 2021] [php7:warn] [pid 2716:tid 388] [client x.x.x.x:27645] PHP Warning: array_merge(): Argument #2 is not an array in D:\www\crm-dev\include\MVC\SugarApplication.php on line 558, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:11:00.529853 2021] [php7:warn] [pid 2716:tid 388] [client x.x.x.x:27645] PHP Warning: sqlsrv_client_info() expects exactly 1 parameter, 0 given in D:\www\crm-dev\include\database\SqlsrvManager.php on line 562, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:11:00.529853 2021] [php7:warn] [pid 2716:tid 388] [client x.x.x.x:27645] PHP Warning: sqlsrv_server_info() expects exactly 1 parameter, 0 given in D:\www\crm-dev\include\database\SqlsrvManager.php on line 562, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Wed Sep 01 10:11:00.529853 2021] [php7:warn] [pid 2716:tid 388] [client x.x.x.x:27645] PHP Warning: array_merge(): Argument #1 is not an array in D:\www\crm-dev\include\database\SqlsrvManager.php on line 562, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515

    • sapiens-bi member avatar

      sapiens.bi Provider

      3 years ago

      Thank you so much for helping with the description of the issue!

      We have just uploaded latest version of Sapiens.BI: 3.0.76 - you should see it in your profile. Can you please try upload it via SuiteCRM Module Loader (no need to uninstall previous). After successful installation please clean web cache on your browser (or you can quickly check it on Incognito Window), to see if issues are solved.

      Please let us know, how it goes ;).

      Thank you!

      Best Regards, Sapiens,BI team

    • agonzalez member avatar

      agonzalez Verified Purchase

      3 years ago

      We have uploaded and installed 3.0.76 version and nothing seems to be fixed, same problem, same errors.

    • sapiens-bi member avatar

      sapiens.bi Provider

      3 years ago

      Thank you for the feedback! Can you please let us know of your PHP version number?

      And - we understand that there are the same issues, but could you please send us the same error code again - only the one from the very first of your messages, i.e. this one:

      [Wed Sep 01 10:11:00.545489 2021] [php7:error] [pid 2716:tid 388] [client 192.168.1.199:27645] PHP Fatal error: Uncaught TypeError: Argument 1 passed to ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2::ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZU2020() must be an instance of ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZV2121, string given, called in D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php on line 116 and defined in D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php:116\nStack trace:\n#0 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(116): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZU2020(' Query Failed:S...')\n#1 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(116): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZT1919(Array, true)\n#2 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(116): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZc2->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZG66(Array, true)\n#3 D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php(151): ZZZZZZZZZZZZZZZZZZZZZZZZZ in D:\www\crm-dev\modules\AnalyticReporting\controllers\libs.php on line 116, referer: https://crm-dev.aec.local/index.php?module=AnalyticReporting&action=report&record=515

      • We believe, it might be a bit different after the update.

      Thank you! Best Regards, IT Sapiens Team

  3. agonzalez member avatar

    agonzalez Verified Purchase

    3 years ago

    Apache Log

    [Mon Sep 06 16:17:32.564776 2021] [php7:warn] [pid 2716:tid 1012] [client x.x.x.x:1078] PHP Warning: sqlsrv_client_info() expects exactly 1 parameter, 0 given in D:\www\crm_dev_como_prod\include\database\SqlsrvManager.php on line 562, referer: https://crm.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Mon Sep 06 16:17:32.564776 2021] [php7:warn] [pid 2716:tid 1012] [client x.x.x.x:1078] PHP Warning: sqlsrv_server_info() expects exactly 1 parameter, 0 given in D:\www\crm_dev_como_prod\include\database\SqlsrvManager.php on line 562, referer: https://crm.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Mon Sep 06 16:17:32.564776 2021] [php7:warn] [pid 2716:tid 1012] [client x.x.x.x:1078] PHP Warning: array_merge(): Argument #1 is not an array in D:\www\crm_dev_como_prod\include\database\SqlsrvManager.php on line 562, referer: https://crm.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Mon Sep 06 16:17:33.549177 2021] [php7:warn] [pid 2716:tid 1144] [client x.x.x.x:4079] PHP Warning: sqlsrv_client_info() expects exactly 1 parameter, 0 given in D:\www\crm_dev_como_prod\include\database\SqlsrvManager.php on line 562, referer: https://crm.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Mon Sep 06 16:17:33.549177 2021] [php7:warn] [pid 2716:tid 1144] [client x.x.x.x:4079] PHP Warning: sqlsrv_server_info() expects exactly 1 parameter, 0 given in D:\www\crm_dev_como_prod\include\database\SqlsrvManager.php on line 562, referer: https://crm.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Mon Sep 06 16:17:33.549177 2021] [php7:warn] [pid 2716:tid 1144] [client x.x.x.x:4079] PHP Warning: array_merge(): Argument #1 is not an array in D:\www\crm_dev_como_prod\include\database\SqlsrvManager.php on line 562, referer: https://crm.aec.local/index.php?module=AnalyticReporting&action=report&record=515 [Mon Sep 06 16:17:33.564805 2021] [php7:error] [pid 2716:tid 1144] [client x.x.x.x:4079] PHP Fatal error: Uncaught TypeError: Argument 1 passed to ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZL1111::ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZD33() must be an instance of ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZE44, string given, called in D:\www\crm_dev_como_prod\modules\AnalyticReporting\controllers\libs.php on line 130 and defined in D:\www\crm_dev_como_prod\modules\AnalyticReporting\controllers\libs.php:130\nStack trace:\n#0 D:\www\crm_dev_como_prod\modules\AnalyticReporting\controllers\libs.php(130): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZL1111->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZD33(' Query Failed:S...')\n#1 D:\www\crm_dev_como_prod\modules\AnalyticReporting\controllers\libs.php(130): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZL1111->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZC22(Array, true)\n#2 D:\www\crm_dev_como_prod\modules\AnalyticReporting\controllers\libs.php(130): ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZL1111->ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZp15(Array, true)\n#3 D:\www\crm_dev_c in D:\www\crm_dev_como_prod\modules\AnalyticReporting\controllers\libs.php on line 130, referer: https://crm.aec.local/index.php?module=AnalyticReporting&action=report&record=515

    suiteCRM log

    Mon Sep 6 16:17:33 2021 [2716][1 ][FATAL] Query Failed:SELECT t0.name AS m0_Opportunities_name , t0.id AS m0_Opportunities_name_id , N'Opportunities' AS m0_Opportunities_name_setype , t0.date_entered AS m0_Opportunities_date_entered , t0.id AS m0_Opportunities_id , t0.id AS m0_Opportunities_id_id , N'Opportunities' AS m0_Opportunities_id_setype , CASE WHEN (t1.id NOT LIKE '') THEN COALESCE(t1.first_name,'') + N' ' + COALESCE(t1.last_name, '') END AS m0_Opportunities_assigned_user_id , t1.id AS m0_Opportunities_assigned_user_id_id , N'Users' AS m0_Opportunities_assigned_user_id_setype , COALESCE(t1.first_name,'') + N' ' + COALESCE(t1.last_name, '') AS m0_Users_user_name , t1.first_name AS m0_Users_first_name , t1.last_name AS m0_Users_last_name , t0.lead_source AS m0_Opportunities_lead_source , t0.lead_source AS m0_Opportunities_lead_source_value , t0.amount_usdollar AS m0_Opportunities_amount_usdollar , t0.sales_stage AS m0_Opportunities_sales_stage , t0.sales_stage AS m0_Opportunities_sales_stage_value , t2.f_envio_propuesta_aec_c AS m0_Opportunities_f_envio_propuesta_aec_c , CAST(DATEPART(yy, t2.f_decide_propuesta_aec_c) AS nvarchar) + N'-' + CAST(DATEPART(mm, t2.f_decide_propuesta_aec_c) AS nvarchar) AS m0_Opportunities_f_decide_propuesta_aec_c_monthAndYear , CAST(DATEPART(yy, t2.f_decide_propuesta_aec_c) AS nvarchar) AS m0_Opportunities_f_decide_propuesta_aec_c_year FROM opportunities AS t0 LEFT JOIN users AS t1 ON ( t1.id = t0.assigned_user_id) LEFT JOIN opportunities_cstm AS t2 ON ( t2.id_c = t0.id) WHERE (1=1 AND (1=1 AND t0.name like N'SIC%' AND t0.sales_stage IN(N'Closed Won' , N'EnMarcha' , N'Cerrada') AND t0.deleted = 0 ) AND (1=1 AND t2.f_decide_propuesta_aec_c >= N'2021-01-01' AND t2.f_decide_propuesta_aec_c < N'2022-01-01' ) ) AND (1=1 ) GROUP BY t0.id , t1.id , COALESCE(t1.first_name,'') + N' ' + COALESCE(t1.last_name, '') , t1.first_name , t1.last_name , t0.lead_source , t0.sales_stage , t0.name , t0.date_entered , CASE WHEN (t1.id NOT LIKE '') THEN COALESCE(t1.first_name,'') + N' ' + COALESCE(t1.last_name, '') END , t0.amount_usdollar , t2.f_envio_propuesta_aec_c , CAST(DATEPART(yy, t2.f_decide_propuesta_aec_c) AS nvarchar) + N'-' + CAST(DATEPART(mm, t2.f_decide_propuesta_aec_c) AS nvarchar) , CAST(DATEPART(yy, t2.f_decide_propuesta_aec_c) AS nvarchar) ORDER BY m0_Opportunities_assigned_user_id ASC, DATEPART(yy, t2.f_decide_propuesta_aec_c) ASC, DATEPART(mm, t2.f_decide_propuesta_aec_c) ASC::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La columna "opportunities_cstm.f_decide_propuesta_aec_c" de la cláusula ORDER BY no es válida, porque no está contenida en una función de agregado ni en la cláusula GROUP BY.

    Spanish to english traslation of ODBC Error [Microsoft] [ODBC Driver 17 for SQL Server] [SQL Server] The column "opportunities_cstm.f_decide_proposal_aec_c" in the ORDER BY clause is not valid, because it is not contained in an aggregate function or in the GROUP BY clause.

    As you can see opportunities_cstm.f_decide_proposal_aec_c is a custom field. ¿Can be this the problem source?

  4. sapiens-bi member avatar

    sapiens.bi Provider

    3 years ago

    Thank you for the update! We will be working on this and get back to you as soon as we have some news!

    Best Regards, Sapiens.BI Team

  5. agonzalez member avatar

    agonzalez Verified Purchase

    3 years ago

    More info about environment. SO: Windows Server 2012 R2 Standard PHP: 7.2.12 DB: SQL Server 12.0.6433.1

    Best Regards, Alberto González

    • sapiens-bi member avatar

      sapiens.bi Provider

      3 years ago

      Hello Alberto,

      Sorry to take this long time (we tried to contact you via e-mail as well). We have uploaded version 3.0.78 with the fixes. You will find the Installation package in your profile. Please let us know if it is OK for you now ;).

      Thank you! Best Regards, Sapiens.BI Team

  6. agonzalez member avatar

    agonzalez Verified Purchase

    3 years ago

    Apparently everything works fine now. Although we will continue to do tests to fully validate correct operation.

    Thank you! Best Regards, Alberto González

    • sapiens-bi member avatar

      sapiens.bi Provider

      3 years ago

      Thank you for the feedback! We have recently uploaded one more newer version: 3.0.80 It is recommended to update to this version, as few bugs were discovered and fixed (mainly date visibility in report tables as time). Cache clean on your browser is recommended after this step as well. Hoping it's not too much of the trouble.

      Thank you!

      Best Regards, Sapiens.BI Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.0.0 to 8.6.1
Read Our Review
Rating

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

Background Updater

Does your CRM have calculated fields and logic hooks that your business depends on for reporting and business logic? Unfortunately those rules only run when a record is saved. Background Updater runs in the background to ensure your records are regularly updated so you can be sure your data is up to...

Suite2Excel

Experts in Excel export. An export to Excel from any list, report or subpanel of SuiteCRM.

Rating
Reporting reports charts dashboards reporting analytics report analytics data analytics sales analytics analytic reporting pivot tables matrix summary report charting sugarcrm charts advanced reporting analytic reporting tool sapiens.bi sapiensbi bi businessanalytics businessintelligence