Hi, I have an application-server-task setup for job-type = ‘QuickReport’. When the I runt the task, the generated excel file tell error: “SQL Statement malformed: [..select statement in quick report..]” Executing the quick report manually doesn’t have any error. Does anybody know about this error and how to handle it? The QR-sql-statement: SELECT job_id, state, t.description, procedure_name, t.queue_id, B.DESCRIPTION, B.PROCESS_NUMBER, B.EXECUTION_PLAN, arguments_string, LAG (executed,1) OVER (PARTITION BY t.queue_id ORDER BY started) prev_job_executed, (started - (LAG (executed,1) OVER (PARTITION BY t.queue_id ORDER BY created)))*24*60*60 time_since_prev_job_executed, (started-posted)*24*60*60 wait_for_start, (executed-started)*24*60*60 exec_time, posted, created, started, executed, error_text, username, t.lang_code, progress_info,
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.