Error with Basic access

[Krzysztof Rodo]

Hi, 

I got an error:

```ApiException was thrown with message '{ "message": "Internal error encountered.", "code": 13, "status": "INTERNAL", "details": [ { "@type": "request-id", "data": "4jQ7iPe2qf0TApPpgPctkw" } ] }'.```

while running the query: 

```

$query = "SELECT campaign.name, ad_group.name, "

            . "ad_group_ad.ad.responsive_display_ad.marketing_images, "

            . "ad_group_ad.ad.app_ad.images, ad_group_ad.ad.app_ad.youtube_videos, "

            . "ad_group_ad.ad.responsive_display_ad.youtube_videos, ad_group_ad.ad.local_ad.videos, "

            . "ad_group_ad.ad.video_responsive_ad.videos, ad_group_ad.ad.video_ad.media_file,  "

            . "ad_group_ad.ad.app_engagement_ad.images, ad_group_ad.ad.app_engagement_ad.videos, "

            . "ad_group_ad.ad.display_upload_ad.media_bundle, ad_group_ad.ad.gmail_ad.product_images, "

            . "ad_group_ad.ad.gmail_ad.product_videos, ad_group_ad.ad.gmail_ad.teaser.logo_image, "

            . "ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image, "

            . "ad_group_ad.ad.local_ad.marketing_images, ad_group_ad.ad.responsive_display_ad.logo_images, "

            . "ad_group_ad.ad.responsive_display_ad.square_logo_images, "

            . "ad_group_ad.ad.responsive_display_ad.square_marketing_images, "

            . "ad_group_ad.ad.responsive_display_ad.youtube_videos, "

            . "metrics.impressions, campaign.campaign_budget, campaign.status, "

            . "campaign.start_date, campaign.end_date, metrics.all_conversions, "

            . "metrics.average_cost, ad_group_ad.ad.type, ad_group_ad.ad.id, "

            . "campaign.campaign_budget, metrics.cost_micros, ad_group_ad.status, metrics.impressions "

            . "FROM ad_group_ad "

            . "WHERE segments.date >= '{$this->from}' AND segments.date <= '{$this->to}'";

```

If I put `LIMIT` on the end of the query: 

```

$query = "SELECT campaign.name, ad_group.name, "

            . "ad_group_ad.ad.responsive_display_ad.marketing_images, "

            . "ad_group_ad.ad.app_ad.images, ad_group_ad.ad.app_ad.youtube_videos, "

            . "ad_group_ad.ad.responsive_display_ad.youtube_videos, ad_group_ad.ad.local_ad.videos, "

            . "ad_group_ad.ad.video_responsive_ad.videos, ad_group_ad.ad.video_ad.media_file,  "

            . "ad_group_ad.ad.app_engagement_ad.images, ad_group_ad.ad.app_engagement_ad.videos, "

            . "ad_group_ad.ad.display_upload_ad.media_bundle, ad_group_ad.ad.gmail_ad.product_images, "

            . "ad_group_ad.ad.gmail_ad.product_videos, ad_group_ad.ad.gmail_ad.teaser.logo_image, "

            . "ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image, "

            . "ad_group_ad.ad.local_ad.marketing_images, ad_group_ad.ad.responsive_display_ad.logo_images, "

            . "ad_group_ad.ad.responsive_display_ad.square_logo_images, "

            . "ad_group_ad.ad.responsive_display_ad.square_marketing_images, "

            . "ad_group_ad.ad.responsive_display_ad.youtube_videos, "

            . "metrics.impressions, campaign.campaign_budget, campaign.status, "

            . "campaign.start_date, campaign.end_date, metrics.all_conversions, "

            . "metrics.average_cost, ad_group_ad.ad.type, ad_group_ad.ad.id, "

            . "campaign.campaign_budget, metrics.cost_micros, ad_group_ad.status, metrics.impressions "

            . "FROM ad_group_ad "

            . "WHERE segments.date >= '{$this->from}' AND segments.date <= '{$this->to} LIMIT 10'";

```

There is no error. 

I have Basic access to the Google Ads manager account. 

Could you tell me how can I retrieve all the results without LIMITing the query?

[Google Ads API Forum Advisor Prod]

Hello,

I will take a closer look and get back to you as to why you are facing these internal errors.

Regards,
Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q29URLM:ref

[Krzysztof Rodo]

Hi Anthony, 

have you checked it, why I am facing these internal errors?

Regards,

Chris

[Google Ads API Forum Advisor Prod]

Hi Chris,

It appears as though these errors may be caused by a bug in our system, possibly due to the size of the query.

I'm going to correspond with our engineering team to see if they can help identify the specific issue.

I'll follow up with more information as soon as possible.

Best,
Ben, Google Ads API Team

ref:_00D1U1174p._5004Q29URLM:ref

[Krzysztof Rodo]

Hi, 

do you have some information?

[Google Ads API Forum Advisor Prod]

Hello,

We have determined that it may be an error with the field "ad_group_ad.ad.video_responsive_ad.videos". Please try rerunning the query without including that field and let me know if it goes through.

We're currently investigating why this field is causing issues, so I'm going to keep an eye on it and let you know when it might be safe to add that field back to the query.

Regards,
Mike, Google Ads API Team

ref:_00D1U1174p._5004Q29URLM:ref

[Krzysztof Rodo]

Hi, 

have you solved it?

Regards!

[Google Ads API Forum Advisor Prod]

Hello,

The fix is rolled out, so you should have no more issues with those fields in your query. Please give it a try and let me know if you're still having trouble.

[Krzysztof Rodo]

Hi, 

this field ad_group_ad.ad.video_responsive_ad.videos works, but no there is an error with this field: ad_group_ad.ad.video_responsive_ad.videos.asset

So my query looks like:

```

"SELECT campaign.name, ad_group.name, ad_group_ad.ad.video_responsive_ad.videos.asset, "

            . "ad_group_ad.ad.responsive_display_ad.marketing_images, "

            . "ad_group_ad.ad.app_ad.images, ad_group_ad.ad.app_ad.youtube_videos, "

            . "ad_group_ad.ad.responsive_display_ad.youtube_videos, ad_group_ad.ad.local_ad.videos, "

            . "ad_group_ad.ad.video_responsive_ad.videos, ad_group_ad.ad.video_ad.media_file,  "

            . "ad_group_ad.ad.app_engagement_ad.images, ad_group_ad.ad.app_engagement_ad.videos, "

            . "ad_group_ad.ad.display_upload_ad.media_bundle, ad_group_ad.ad.gmail_ad.product_images, "

            . "ad_group_ad.ad.gmail_ad.product_videos, ad_group_ad.ad.gmail_ad.teaser.logo_image, "

            . "ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image, "

            . "ad_group_ad.ad.local_ad.marketing_images, ad_group_ad.ad.responsive_display_ad.logo_images, "

            . "ad_group_ad.ad.responsive_display_ad.square_logo_images, "

            . "ad_group_ad.ad.responsive_display_ad.square_marketing_images, "

            . "ad_group_ad.ad.responsive_display_ad.youtube_videos, "

            . "metrics.impressions, campaign.campaign_budget, campaign.status, "

            . "campaign.start_date, campaign.end_date, metrics.all_conversions, "

            . "metrics.average_cost, ad_group_ad.ad.type, ad_group_ad.ad.id, "

            . "campaign.campaign_budget, metrics.cost_micros, ad_group_ad.status, metrics.impressions "

            . "FROM ad_group_ad "

            . "WHERE segments.date >= '{$this->from}' AND segments.date <= '{$this->to}'";

```

And I am getting the following error:

In GoogleAdsExceptionTrait.php line 75:

                                                                               

  {                                                                            

      "message": "Request contains an invalid argument.",                      

      "code": 3,                                                               

      "status": "INVALID_ARGUMENT",                                            

      "details": [                                                             

          {                                                                    

              "@type": "google.ads.googleads.v5.errors.googleadsfailure-bin",  

              "data": "<Unknown Binary Data>"                                  

          },                                                                   

          {                                                                    

              "@type": "grpc-status-details-bin",                              

              "data": "<Unknown Binary Data>"                                  

          },                                                                   

          {                                                                    

              "@type": "request-id",                                           

              "data": "YvSgQAnYqxtGzR65u8nV1w"                                 

          }                                                                    

      ]                                                                        

  }      

Could you check what's going on?

[Google Ads API Forum Advisor Prod]

Hello,

Looking at our logs, it looks like the API produced a reasonable error message: "The following field may not be used in SELECT clause: 'ad_group_ad.ad.video_responsive_ad.videos.asset'."

If you were not able to see this error on your end, you may need to update to a newer version of the client library.