INTERNAL_SERVER_ERROR

[Aerofoils]

Hi, 

we created a new company in BC. When trying to synchronize products in a shopify shop within that new company, we get the following error message:

---------------------------

Wenn Sie Support anfordern, geben Sie bitte die folgenden Details zur Problembehandlung an.:

Fehler auf Shopify:

[{"message":"Internal error. Looks like something went wrong on our end.\nRequest ID: 4985a2b7-cfa6-4a80-b213-bb03d61b9706 (include this in support requests).","extensions":{"code":"INTERNAL_SERVER_ERROR","requestId":"4985a2b7-cfa6-4a80-b213-bb03d61b9706"}}]

Interne Sitzungs-ID:
e502abaf-1176-4a44-8ced-f8a4a8deef95

Application Insights-Sitzungs-ID:
7380856a-6ecf-44e7-9feb-3033c889d155

Client-Aktivitäts-ID:
7b96246f-6092-4bce-ba1b-f922584bd155

Zeitstempel bei Fehler:
2024-01-02T11:50:06.7056540Z

Benutzertelemetrie-ID:
adfe0c88-806b-491b-98ee-74fc09c917d7

Al-Aufrufliste:
"Shpfy Communication Mgt."(CodeUnit 30103).ExecuteGraphQL line 19 - Shopify Connector by Microsoft
"Shpfy Communication Mgt."(CodeUnit 30103).ExecuteGraphQL line 4 - Shopify Connector by Microsoft
"Shpfy Communication Mgt."(CodeUnit 30103).ExecuteGraphQL line 6 - Shopify Connector by Microsoft
"Shpfy Product API"(CodeUnit 30176).RetrieveShopifyProductIds line 22 - Shopify Connector by Microsoft
"Shpfy Sync Products"(CodeUnit 30185).ImportProductsFromShopify line 13 - Shopify Connector by Microsoft
"Shpfy Sync Products"(CodeUnit 30185).OnRun(Trigger) line 14 - Shopify Connector by Microsoft
"Shpfy Sync Products"(Report 30108)."Shop - OnAfterGetRecord"(Trigger) line 8 - Shopify Connector by Microsoft

--------------------------

The Error seems to be within Shopify. Is there anything I can do? Maybe renew the access token or something? 

Thanks in advance

[Liam · Accepted solution]

Hi Aerofoils,

From looking into our logs I'm seeing that the error is related to an "Incorrect DATETIME value" - are there any instances where there's a DATETIME property in an API call where you are missing a value or it's incorrectly formatted?

[Aerofoils]

Hi Liam,

Thank you for checking the logs. There is indeed a field that is tested. It is called "Last Sync Time," which exists for Products, Customers, and Orders. By creating a new company, this field was obviously empty. It would be helpful to understand how it is initially set. I managed to set the DATETIME value by resetting the synchronization to the current datetime, as shown in the images.

This fixed the Internal Error. I'm uncertain about the potential side effects of creating a new company.

Despite this, the Shopify products list remained empty, even after initiating the synchronization action. To address this, I logged into the Shopify backend and updated every product (by simply adding a whitespace to the product descriptions and then saving). This action triggered the synchronization and subsequently imported the products into Business Central. It seems there is an update/modify trigger on the Shopify products, which sets a flag, allowing their import into BC. It would also be nice to know if there's an action in the Shopify backend to mark all products for update.

Maybe this will be usefull to others.