GAM Error Alias Print Failed: Query Invalid

112 views
Skip to first unread message

Fran Rodríguez

unread,
Feb 14, 2023, 8:10:59 AM2/14/23
to GAM for Google Workspace
Hi all.

Since 13 Feb 21:00 (CET) we started noticing errors using GAM on operations related to the full directory list. 
Those extractions were working uninterruptedly since months ago.

The error appears after receiving info from a random amount of users.
Example:

$ gam print aliases  nogroups
Getting all Users, may take some time on a large Google Workspace Account...
Got 12500 Users: aaa...@xxx.edu - ccc.dd...@xxx.edu   Alias Print Failed: Query (None) Invalid

$ gam print aliases  nogroups
Getting all Users, may take some time on a large Google Workspace Account...
Got 18000 Users: ffff...@xxx.yyy.edu - hhhh....@xxx.yyy.edu     Alias Print Failed: Query (None) Invalid

$ gam print aliases  nogroups
Getting all Users, may take some time on a large Google Workspace Account...
Got 500 Users: jjjj...@xxx.yyy.edu - llll...@xxx.yyy.edu Alias Print Failed: Query (None) Invalid

In the API console, we can see lots of erros on this methods:
 "ccc.hosted.frontend.directory.v1.DirectoryUsers.List"
 "ccc.hosted.frontend.reports.v1.ReportsUserUsageReport.Get"

Did anybody else noticed something similar ?

Thanks in advance.


INFORMACIÓ BÀSICA SOBRE PROTECCIÓ DE DADES:

 

Responsable: UPCNET, Serveis d'Accés a Internet de la Universitat Politècnica de Catalunya, SLU   | Finalitat: gestionar els contactes i les relacions professionals i comercials amb els nostres clients i proveïdors   | Base legal: consentiment, interès legítim i/o relació contractual   | Destinataris: no seran comunicades a tercers excepte per obligació legal   | Drets: pots exercir els teus drets d’accés, rectificació i supressió, així com els altres drets reconeguts a la normativa vigent, enviant-nos un missatge a pri...@upcnet.es   | Més informació: consulta la nostra política completa de protecció de dades.

 

AVÍS DE CONFIDENCIALITAT

Jay Lee

unread,
Feb 14, 2023, 8:14:19 AM2/14/23
to google-ap...@googlegroups.com
What does:

gam version extended

Show for you?

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/f814eea7-8a7c-4b4f-a2ac-ebf18828c3b3n%40googlegroups.com.

Fran Rodríguez

unread,
Feb 14, 2023, 9:31:23 AM2/14/23
to google-ap...@googlegroups.com

$ gam version extended
GAMADV-XTD3 6.32.05 - https://github.com/taers232c/GAMADV-XTD3 - pyinstaller
Ross Scroggs <ross.s...@gmail.com>
Python 3.11.2 64-bit final
Linux Ubuntu 20.04 Focal Fossa x86_64
Path: /home/fran.rodriguez/bin/gamadv-xtd3
Config File: /home/fran.rodriguez/.gam/gam.cfg, Section: DEFAULT, customer_id: my_customer, domain:
Your system time differs from admin.googleapis.com by 1 second
OpenSSL 3.0.8 7 Feb 2023
cryptography 39.0.1
google-api-python-client 2.77.0
admin.googleapis.com connects using TLSv1.3 TLS_AES_256_GCM_SHA384

__________________________________
Fran Rodríguez
Service Operation
UPCNet
Edifici C'. Carrer Pascual i Vila, 15, S1
08028 Barcelona
Telèfon centraleta: 93.40.11600
Telèfon directe: 93.40.54523


You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/qCPssSyzO3U/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BVVBp8UzkmWoQEpgzNV0CUYEQx7A%3Drd1jtU0ShtOw4Forjp0Q%40mail.gmail.com.

Ross Scroggs

unread,
Feb 14, 2023, 9:35:27 AM2/14/23
to google-ap...@googlegroups.com
Google APIs that return long lists of items produce them in pages; each page of results contains a field nextPageToken
that is used to ask the API for the next page of results. Almost for sure what's going on is that Google is returning
an invalid nextPageTokenn and when it is passed to the API Google generates an error.

This has happened in the past when listing Chrome devices,

Ross
----
Ross Scroggs



Fran Rodríguez

unread,
Feb 14, 2023, 10:17:12 AM2/14/23
to GAM for Google Workspace
Hi Ross.
I've realized through another post (from Mitchell Hoffman), that downloading the list of users from the Admin console, also stopped working.
We will open a case with Google Support.
Thanks for your help.

Regards.

Samuel

unread,
Feb 14, 2023, 10:25:56 AM2/14/23
to GAM for Google Workspace
Seeing Ross' message, I would say I have the same concern
Between each execution, I don't get the same number of counts
Even by going through  https://developers.google.com/admin-sdk/directory/reference/rest/v1/users/list?hl=en  with "try this method" on the google site, I was able to reproduce the error using the nexpage tokens, 

in my case the error is

{
  "error": {
    "code": 400,
    "message": "Invalid Input",
    "errors": [
      {
        "message": "Invalid Input",
        "domain": "global",
        "reason": "invalid"
      }
    ]
  }
}

Case opened since this morning

Reply all
Reply to author
Forward
0 new messages