Support Center > Search Results > SecureKnowledge Details
SmartReporter fails to generate report for selected hours with "ERROR: syntax error at or near ','LINE 1: SELECT MOD(((EXTRACT(HOUR FROM , SUM(..."
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 .