GraphQL regex error

General
,
1

Hi all! My name is James and I’m the new pipedev from Alkemy-X. I’m taking over for @fabiaserra. I’m very new you Ayon and only have 11 days on the job so far.

My very first issue popped up as we were ingesting new shots. We had some issues with some field values between Shotgrid and Ayon not syncing properly. I reached out to @fabiaserra and he pointed out that there was a string of errors showing up in Ayon Events. Some of them seemed to be related to poorly named reference movs from the client. Some other errors we haven’t been able to identify:

GraphQL: /ayon_server/types.py:88 (project/folders) Name '501 VFX 1118 Ref QT, 501.001.030-410' does not match regex '^[a-zA-Z0-9_]([a-zA-Z0-9_\.\-]*[a-zA-Z0-9_])?$'
--
GraphQL: /ayon_server/types.py:88 (project/products) Name 'Video 4' does not match regex '^[a-zA-Z0-9_]([a-zA-Z0-9_\.\-]*[a-zA-Z0-9_])?$'
--
GraphQL: /ayon_server/types.py:88 (project/folders) Name 'V1H_5_48FPS**' does not match regex '^[a-zA-Z0-9_]([a-zA-Z0-9_\.\-]*[a-zA-Z0-9_])?$'

We’ve since fixed the source reference material file names and the sync issues seem to have cleared up as a result. But being new to Ayon, I wanted to take the opportunity to make this a learning moment and understand better where in the pipeline this error occurred. I was not able to find this “types.py” file mentioned in the error. So if anyone wants to take a crack of walking me through this a bit I would be greatly appreciative.

2 
GraphQL: /ayon_server/types.py:88 (project/products) Name 'Video 4' does not match regex '^[a-zA-Z0-9_]([a-zA-Z0-9_\.\-]*[a-zA-Z0-9_])?$'

Yep, it doesn’t match the regex.

Here’s ayon_server/types.py it’s in the backend repo.

You’d like to get clone ayon repos and add them to the python analysis or whatever the way to do it in your IDE.
Here’s my Workbench.

And another community workbench, shared on discord

3

Hi Mustafa! Thanks for the response and the very helpful links.

I do have a question about the backend repo. I don’t see it anywhere in our local codebase. So I’m curious to understand how it ties into our pipeline. Fabia thought that these regex errors were blocking our sync process between Shotgrid and Ayon. I was never able to verify that but I wanted to investigate it further.

EDIT:

OK I just spotted the connection with the backend repo. It’s included in the ayon-docker repo.

4

Hi @mustafa_jafar. As I mentioned in my OP, the GraphQL error doesn’t seem to be noticeably effecting our sync process. But this error is persisting in the Ayon events even though we fixed the naming of the source files. Fabia had suggested I look at our PostgresQL database to see if there is an entry in there with the bad filepath names. I did an initial query of the DB and didn’t find anything. But I’m still fairly unfamiliar with our internal pipeline and I haven’t used SQL in a good bit. So I am sure I am missing something.

I was hoping you could offer me some guidance on tracking down this issue.

Thx!

5

It’s hard for me to tell as I don’t interact that much with this area of AYON.
Maybe @martin.wacker can provide better guidance if he has time.

As far as I know, you can:

  • Check AYON docker log.
  • Use a GUI tool to examine the postgers DB. I recall pgAdmin was mentioned several of times on discord.
  • Try replicating your issue step by step. (I prefer to do it manually using jupyter for example, Here are some guide AYON Python API First Steps and AYON REST API Guide)
  • Check with your studio if they’d like to be client. we can provide paid support. for more information reach out https://ynput.io/ (the chat bubble on the bottom right.)
6

Thanks for taking the time to provide me with more info Mustafa!