Product Support Portal

社区

搜索

欢迎来到社区

Query to get all bridge errors

2022年12月01日 02:39

Currently we need to goto each jobid (or FTP location) of the crm bridge and download the erroc csv file to see the error records, Is there a way to get all the error record of all job id of CRM bridge via sql editor and then I will download it in a single file.?

It is very time consuming to goto each jobid and see the bridge error.

Thanks,

Avinash Parihar

1 条评论

Michael Pay

2022年12月02日 07:29
Hi Avinash,

You might be able to do something like
```
SELECT
                job_id,
                "address.errors",
                "hco.errors",
                "hcp.errors",
                "license.errors",
                "parenthco.errors"    
    FROM
                job_stats_summary
    ORDER BY
        job_id DESC LIMIT 100
```
In order to get your last 100 jobs and skim through whether they have errors or not.

Or if you remember the last job you checked, you might be able to do WHERE job_id > {your last job id}

I tried using more complicated queries that joins the job table or do a where clause on the ".error" fields but those all failed to compile / build execution plan / validate.

This query also takes a very long time to run and I'm not sure why, maybe you could open a support ticket on this to have it investigated.

Hope this helps,

Michael
0