Data warehouse extract ERROR

[abhijithr]

I'm re-querying the existing job w/ destination being GCP bucket, but for some reason it says "Error - Failure To Send" and the email notification received tells the below error. Could someone help what does this err mean and how we could tackle it? 

As an alternate when I tried emailing the report myself, the email notification stated FILE TOO LARGE for email. Wonder what the above err means!  

@Jennifer_Dungan

[Vernon_H]

Hi @abhijithr,

There is a 10mb limit via the email delivery method, you may have to use an alternative delivery method like Amazon S3 bucket or Azure, etc. I personally use S3 bucket and it's pretty easy to get it set up. 

Cheers

[abhijithr]

hi@Vernon_H 

thanks though. It seems you have missed the GCP bucket mentioned, email was an alternate approach.

[leocwlau]

@abhijithr, not familiar with GCP and wondering if there is any chance of a disk space limitation issue as well. As the original error message suggested, are you able to find any incomplete file transfer on GCP?

Two things I may try to test out

• a smaller data warehouse request with the same GCP location, to test the location configuration and connection are all good.
• same request to an old-school FTP location, to test if the data warehouse request itself and output data file size

[abhijithr]

@leocwlau Appreciate your consideration/response here.

YES, check GCS bucket and no file posted; neither incomplete nor empty(I had chosen this option when no data for any day).

Tried smaller and then regular window and both worked in another bucket. But the same time, I have received many files to the bucket where is erroring now, so something really strange. I'd be worried if this happens in Production randomly.

And, FTP was our regular/past state and GCP is current/future state in works due to Org's FTP limitation. Thanks again

[fhusain]

If this is still not resolved, please log a ticket to Adobe Customer Support, and please do mention the Legacy Request ID.

[abhijithr]

@fhusain are you referring to the Request ID in the green ribbon in my screenshot attached in this thread?

And I didn't get the "Legacy" prefix. Thanks much

[fhusain]

Yes, you can share the same screenshot when logging a ticket. We can then check and share more details on this.

[Jennifer_Dungan]

Like the others, I am have not used the GCP bucket, but the initial error looks like there is some authentication issue... the error indicated that the file completed on the Adobe side, but wasn't able to transfer it.

As others said the file is too large to email, so that isn't a workaround for you.

Have you tried connecting to GCP Bucket using the credentials you provided in the Warehouse settings to confirm they are working?

@fhusain is right, if you contact Client Care, they may be able to run additional tests from the servers to try and test the connection to GCP Bucket.