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)

Most upvoted comments

@fawix Sure

169024827-c05503ed-5f0e-4ef6-a3e6-8e150ac2b6d22

Thanks