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

Technical Level

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 .