SmartReporter fails to generate report for selected hours with "ERROR: syntax error at or near ','LINE 1: SELECT MOD(((EXTRACT(HOUR FROM , SUM(..."

Support Center > Search Results > SecureKnowledge Details

Solution ID	sk105840
Product	SmartReporter / Eventia Reporter
Version	R77, R77.10, R77.20
Platform / Model	All
Date Created	25-Apr-2015
Last Modified	22-Nov-2016

Symptoms

SmartReporter fails to generate report (e.g., Network Activity) for selected hours.

Examples:
- Unable to complete generation for: Section: 1. Network Activity Summary Unit: 1.1 Network Activity SummaryAdditional information: :ERROR: syntax error at or near ','LINE 1: SELECT MOD(((EXTRACT(HOUR FROM , SUM(CONN_NO)AS SUM_CONN_N....
- Unable to complete generation for: Section: 1. FTP Activity Summary Unit: 1.1 FTP Activity SummaryAdditional information: :ERROR: syntax error at or near ','LINE 1: SELECT MOD(((EXTRACT(HOUR FROM , SUM(GROSS_DURATION)AS SUM_CONN_N....

Solution

Note: To view this solution you need to Sign In .