query:
SELECT p2pbi.dw_load_dm((date_trunc('month',current_date) + interval '1 month' - interval '1 day')::date);
ex log:
2018-08-28 19:54:35 Application error: Application error: Running 147946154733.dkr.ecr.us-east-1.amazonaws.com/developer-portal-v2/keboola.ex-db-pgsql:2.2.11 container exceeded the timeout of 18000 seconds.
2018-08-28 17:43:15 Executing query via PDO ...
2018-08-28 17:43:15 Failed \copy command (will attempt via PDO): ERROR: missing FROM-clause entry for table "p2pbi" LINE 1: SELECT p2pbi.dm_sales_affiliate ^ QUERY: SELECT p2pbi.dm_sales_affiliate CONTEXT: PL/pgSQL function dw_load_dm(date) line 18 at PERFORM
2018-08-28 14:54:34 Executing query 'load_dm_2' via \copy ...
2018-08-28 14:54:34 Exporting to in.c-keboola-ex-db-pgsql-1482171.load-dm-2
2018-08-28 14:54:31 Running component keboola.ex-db-pgsql (row 1 of 1)
in this case, the stored procedure seems to be broken and should not be retried using pdo?
ExceptionId docker-398f39170b1465e53841098acf703b68
query:
SELECT p2pbi.dw_load_dm((date_trunc('month',current_date) + interval '1 month' - interval '1 day')::date);ex log:
in this case, the stored procedure seems to be broken and should not be retried using pdo?
ExceptionId docker-398f39170b1465e53841098acf703b68