Report worked on local but not working on server

[adamembun]

Hi .....My report successfully generate on local but not working on server . When i try copy the result of the code to my server terminal as below

$this->PHPJasper->process(
                   $input,
                   $output,
                   $options
                   )->output();

It terminal show error like below statement

Error filling reportError executing SQL statement for: listReport

Here is my code

$input = '/home/admin/reports/templates/'.$report_template;
$output = '/home/admin/reports/output/'.$report_name;
                 $options = [
                        'format' => [$reportFormat],
                        'locale' => 'en',
                        'params' => [
                            'reportTitle' => $request->reportTitle,
                            'image_path' =>  '/home/admin/reports/Logo.png',
                            'condition' => $genSQL,
                            'subCondition' => $genSQL2,
                            'SUBREPORT_DIR' =>  '/home/admin/reports/templates/'
                        ],
                            'db_connection' => [
                            'driver' => 'generic', //mysql, postgres, oracle, generic (jdbc)
                            'username' => env('DB_USERNAME'),
                            'password' => env('DB_PASSWORD'),
                            'host' => env('DB_HOST'),
                            'database' => env('DB_DATABASE'),
                            'port' => env('DB_PORT'),
                            'jdbc_driver' => 'com.microsoft.sqlserver.jdbc.SQLServerDriver',
                            'jdbc_url' => 'jdbc:sqlserver://' . env('DB_HOST') . ':' . env('DB_PORT') . ';databaseName=' . env('DB_DATABASE'),
                
                        ]
                    ];

I have tried my query on db and its successfully working ... here is my query which declare as $genSQl

WHERE recType = 'I' AND customerID IN ('064') AND branchCode IN ('0025') AND 
categoryCode IN ('15-03') AND statusCode IN ('6') AND severity IN (3) and 
(DATEADD(dd, 0, DATEDIFF(dd, 0, createDate)) between 
DATEADD(dd, 0, DATEDIFF(dd, 0,'2016-01-05 10:19:46.000')) 
and DATEADD(dd, 0, DATEDIFF(dd, 0,'2016-01-11 12:14:42.000'))) 
 group by prCode, prCategory, category, severity, getDate, shortName, logNo, resoCreateDate , custReportNo,customerId,branchCode,branchName,callerName,callerPhone,
dateReport,timeReport,dateClose,timeClose,severity,prCode,category,
cmDescription,dateCreate,timeCreate,dateEnd,timeEnd,action,resolutionDesc
,aging,statusCode,statusDesc,recType,createDate,cbState,agingClose, agingActr,cmCreateId,cmGroupId,crAction,crCreateId,cmVendorId,
cmAssetSn,cmFwdTo,catCode,rcgCheckGroup  order by shortName, logNo, resoCreateDate