Flow Sync Error: SG Date field

General
1

Hi community,

On my side there is an error at synchronizing SG ‘Date’ fields to Ayon,
in particular the Task start/due dates from SG to Ayon and viceversa.

Is it working on your side?
Of course the attributes have been correctly mapped.
Does maybe Ayon need to support 2 types of attributes: date and datetime, just like SG?

This is an error from SG to Ayon:

Description
An error occurred while processing. Shotgrid Event ID: 7511961.
Message
Traceback (most recent call last):
File “/service/processor/processor.py”, line 251, in start_processing
handler.process_event(
File “/service/processor/handlers/shotgrid_event.py”, line 37, in process_event
hub.react_to_shotgrid_event(sg_payload[“meta”])
File “/service/ayon_shotgrid_hub/init.py”, line 355, in react_to_shotgrid_event
update_ayon_entity_from_sg_event(
File “/service/ayon_shotgrid_hub/update_from_shotgrid.py”, line 426, in update_ayon_entity_from_sg_event
ayon_entity_hub.commit_changes()
File “/usr/local/lib/python3.11/site-packages/ayon_api/entity_hub.py”, line 1201, in commit_changes
self._connection.send_batch_operations(
File “/usr/local/lib/python3.11/site-packages/ayon_api/server_api.py”, line 8597, in send_batch_operations
return self._send_batch_operations(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/ayon_api/server_api.py”, line 8699, in _send_batch_operations
raise FailedOperations((
ayon_api.exceptions.FailedOperations: Operation “7f6e4ee6041411f0a7170242ac120007” failed with data:
{
“type”: “update”,
“entityType”: “task”,
“entityId”: “10ced126fe8911efaa780242ac120007”,
“data”: {
“attrib”: {
“startDate”: “2025-03-18”
}
},
“id”: “7f6e4ee6041411f0a7170242ac120007”
}
Detail: 1 validation error for TaskPatchModel
attrib → startDate
invalid datetime format (type=value_error.datetime).

2

Does this suggestion below work?

  1. Add a new attribute in attribute tab
    image
    image1989×464 71.8 KB
  2. Add your attribute to mapped entity settings ayon+settings://shotgrid/compatibility_settings/custom_attribs_map?
3

Hi Mustafa and thanks.

How could it work, if I can’t create datetime attributes?

image
image713×612 30.7 KB

4

If it can be usefull, here’s the error from Ayon to SG:

Traceback (most recent call last):
File “/service/processor/processor.py”, line 251, in start_processing
handler.process_event(
File “/service/processor/handlers/sync_projects.py”, line 34, in process_event
hub.synchronize_projects(source=sync_source)
File “/service/ayon_shotgrid_hub/init.py”, line 262, in synchronize_projects
match_ayon_hierarchy_in_shotgrid(
File “/service/ayon_shotgrid_hub/match_ayon_hierarchy_in_shotgrid.py”, line 196, in match_ayon_hierarchy_in_shotgrid
sg_session.update(
File “/usr/local/lib/python3.11/site-packages/shotgun_api3/shotgun.py”, line 1464, in update
record = self._call_rpc(“update”, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/shotgun_api3/shotgun.py”, line 3423, in _call_rpc
self._response_errors(response)
File “/usr/local/lib/python3.11/site-packages/shotgun_api3/shotgun.py”, line 3740, in _response_errors
raise Fault(sg_response.get(“message”, “Unknown Error”))
shotgun_api3.shotgun.Fault: Invalid date format: 2025-03-09T23:00:00+00:00. Correct format is: 2011-01-21

5

Also note that because of it,
if we set a start/due date when creating an SG task,
it won’t be created in Ayon.

image
image555×636 17 KB

The only solution I found so far is:

  1. unmap the start/end attributes (removing them from the sync)
  2. restart ayon services

and the SG task will be created in Ayon at least.