-
Display Nameagonzalez
-
Member SinceJanuary 10th, 2017
-
Last SeenMarch 4th, 2022
agonzalez does not have any add-ons for sale.
-
Support October 4th, 2021 @ 10:41 am
Apparently everything works fine now. Although we will continue to do tests to fully validate correct operation.
Thank you! Best Regards, Alberto González
View Comment
-
Support September 7th, 2021 @ 7:13 am
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
View Comment
-
Support September 6th, 2021 @ 2:37 pm
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?
View Comment
-
Support September 6th, 2021 @ 1:51 pm
We have uploaded and installed 3.0.76 version and nothing seems to be fixed, same problem, same errors.
View Comment
-
Support September 1st, 2021 @ 1:26 pm
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
View Comment
-
Support September 1st, 2021 @ 1:19 pm
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
View Comment
-
Support September 1st, 2021 @ 12:47 pm
Hi. We have Sapiens BI 3.0.4 installed.
Best Regards Alberto González
View Comment
-
February 1st, 2017 @ 5:46 pm
Comprehensive tool that allows all types of advanced reports including audit tables, custom fields and combined reports. The developers offer fast and efficient support. Great tool! View Add-on
agonzalez has not verified any add-ons.
agonzalez has not created any Wanted Add-ons.