cortex-data-foundation: gcloud build fails / Error when using _TEST_DATA
Getting the below error even though all the buckets/BQ tables/gcloud build location is in EU.
starting build "3667fa7c-e603-4997-98b0-fe47c26c28c2"
FETCHSOURCE
Fetching storage object: gs://tsystems-cortex/********_cloudbuild/source/1650983390.276123-c95cd6b49d70426284a1b75fc263d40c.tgz#1650983391911618
Copying gs://*******/*******_cloudbuild/source/1650983390.276123-c95cd6b49d70426284a1b75fc263d40c.tgz#1650983391911618...
/ [0 files][ 0.0 B/ 3.9 MiB]
/ [1 files][ 3.9 MiB/ 3.9 MiB]
Operation completed over 1 objects/3.9 MiB.
BUILD
Pulling image: gcr.io/kittycorn-public/deploy-kittycorn:v1.2
v1.2: Pulling from kittycorn-public/deploy-kittycorn
f003217c5aae: Already exists
d1541c6ba716: Already exists
dfb3217166c8: Already exists
a1033864d5e1: Already exists
699b15d2c3b8: Already exists
6cb7a5182461: Pulling fs layer
026205fede29: Pulling fs layer
d8c5e66a9ac6: Pulling fs layer
3eaec9438278: Pulling fs layer
e5f65183c5dc: Pulling fs layer
7a7752f8dff9: Pulling fs layer
3eaec9438278: Waiting
e5f65183c5dc: Waiting
7a7752f8dff9: Waiting
026205fede29: Verifying Checksum
026205fede29: Download complete
6cb7a5182461: Download complete
d8c5e66a9ac6: Verifying Checksum
d8c5e66a9ac6: Download complete
3eaec9438278: Verifying Checksum
3eaec9438278: Download complete
7a7752f8dff9: Verifying Checksum
7a7752f8dff9: Download complete
6cb7a5182461: Pull complete
e5f65183c5dc: Verifying Checksum
e5f65183c5dc: Download complete
026205fede29: Pull complete
d8c5e66a9ac6: Pull complete
3eaec9438278: Pull complete
e5f65183c5dc: Pull complete
7a7752f8dff9: Pull complete
Digest: sha256:12e8ebb8320513fd5611824d11ae3c59f7687016a4d4a64bc34aa50db4bf6089
Status: Downloaded newer image for gcr.io/kittycorn-public/deploy-kittycorn:v1.2
gcr.io/kittycorn-public/deploy-kittycorn:v1.2
---Creating View: ---
CREATE OR REPLACE FUNCTION `********.******_Cortex_REPORTING.Fiscal_Case3`(
ip_mandt STRING, ip_periv STRING, ip_date DATE
) AS (
(
SELECT MIN(CONCAT(CAST(
IF(Bdatj = '0000',
CAST( EXTRACT(YEAR
FROM
Ip_Date)AS STRING),
Bdatj) AS INT) + CAST(Reljr AS INT), "|", Poper))
FROM
`digitribe-335411.CDC_TABLES.t009b`
WHERE
Mandt = Ip_Mandt
AND Periv = Ip_Periv
AND CONCAT(
IF(Bdatj = '0000',
CAST( EXTRACT(YEAR
FROM
Ip_Date)AS STRING),
Bdatj), Bumon, Butag) >= FORMAT_TIMESTAMP('%Y%m%d', Ip_Date) )
);
BigQuery error in query operation: Error processing job
'digitribe-335411:bqjob_re9b75f4ed0e8e38_000001806647855e_1': Not found: Table
digitribe-335411:CDC_TABLES.t009b was not found in location EU
ERROR
ERROR: build step 0 "gcr.io/kittycorn-public/deploy-kittycorn:v1.2" failed: step exited with non-zero status: 2
Seems like the table t009b is not being generated.
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 15 (4 by maintainers)
@fawix Sure
Thanks