Transcriptions and Sentiment not making it to Data Connector Google BigQuery

[AbleTP]

I'm self-hosting Version 20.0 Update 8 (Build 1121 Release) with Enterprise+ 16SC and using 3CX Transcription Service (Cloud). Stereo recording is enabled.
I'm working on a Grafana Dashboard, using the Google BigQuery Database under Data Connectors. I have all four Data Types selected under the Data Connector and a paid Google Account set up under Google Workplace.
My Grafana Dashboards for Call History and System Metrics work fine. My Grafana Dashboard for Call Recordings and Sentiment shows all zeros.
If I go to Recordings in 3CX, I see Transcriptions, Summaries, and Sentiments for all calls except very short ones, which I would expect.
In Google BigQuery, under public_recordings, I see recordings_url, cdr_id, start_time, end_time populated but summary, transcription, and sentiment_score are all null.
For some reason, none of the AI-generated information is making it over the Data Connector to Google BigQuery.
Any ideas would be appreciated.

 

[KyriacosS_3CX]

Hello,

What's your frequency of data exports? If you make it a little longer, does it make a difference? Trying to see if this is a timing issue before we dig deeper.

 

[AbleTP]

Hello,

What's your frequency of data exports? If you make it a little longer, does it make a difference? Trying to see if this is a timing issue before we dig deeper.

Sorry for the late response. We Auto-Archive everything (Chat Files, Faxes, Recordings, & Voicemails) to SharePoint if older than 30 days. What I found was that I had sentiment data for any calls older than 30 days. I changed the Recordings Archive to older than 1 day, and now I get current Sentiment data and transcripts in Google BigQuery and to Grafana. I'm not sure if this is by design or a bug, but this workaround works for now.