[CoE Starter Kit - BUG] ISSUE TITLE - Issue with Admin Sync Template V3(PVA usage)

[ShaishilMandot]

Does this bug already exist in our backlog?

• [X] I have checked and confirm this is a new bug.

Describe the issue

Our admin COE PVA usage flow keeps failing on "count conversation transcript for the previous day" action. This results in blank usage/session data across PVA table and thus our Power BI report do not show any data around usage.

Expected Behavior

The flow should run successfully thus capturing the usage details in PVA table

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.2

What app or flow are you having the issue with?

Admin | Sync Template v3 (PVA Usage)

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

No response

Anything else?

AB#3255

[Jenefer-Monroe]

Please open the flow in edit mode and show me what is the formula in the Filter rows for the List Bots action:

Should be admin_pvadeleted eq false and _admin_pvaenvironment_value ne null and admin_PVAEnvironment/admin_environmentdeleted ne true and admin_PVAEnvironment/admin_environmentsku ne 'Teams' and admin_PVAEnvironment/admin_environmentsku ne 'Developer'

[ShaishilMandot]

Hi Jenefer,

We have updated the formula as suggested by you and the flow ran successfully. But it is not performing the main operation itself and thus update no data. Thus the session details for all the records are still blank in our bot table. [image: image.png]

Thanks, Shaishil

On Thu, May 18, 2023 at 6:47 PM Jenefer Monroe @.***> wrote:

Please open the flow in edit mode and show me what is the formula in the Filter rows for the List Bots action: [image: image] https://user-images.githubusercontent.com/89584709/239242902-64b2aec7-776e-49c8-bc8d-581102e6b97e.png

Should be admin_pvadeleted eq false and _admin_pvaenvironment_value ne null and admin_PVAEnvironment/admin_environmentdeleted ne true and admin_PVAEnvironment/admin_environmentsku ne 'Teams' and admin_PVAEnvironment/admin_environmentsku ne 'Developer'

— Reply to this email directly, view it on GitHub https://github.com/microsoft/coe-starter-kit/issues/5570#issuecomment-1553042100, or unsubscribe https://github.com/notifications/unsubscribe-auth/A2AI32C3MMSTFUEUFGKQAGTXGYONJANCNFSM6AAAAAAYGL22HQ . You are receiving this because you authored the thread.Message ID: @.***>

[Jenefer-Monroe]

Please note that images do not come through if you respond in email, you need to log in to GitHub to share them.

Can you confirm then, your filter was not the same? I was having you check because it was going to indicate that you may have an unmanaged layer on the flow.

[ShaishilMandot]

Hi Jennifer,

Yes the filter was not the same. Let me share the image with you from github

Thanks, Shaishil

On Fri, May 19, 2023, 17:34 Jenefer Monroe @.***> wrote:

Please note that images do not come through if you respond in email, you need to log in to GitHub to share them.

Can you confirm then, your filter was not the same? I was having you check because it was going to indicate that you may have an unmanaged layer on the flow.

— Reply to this email directly, view it on GitHub https://github.com/microsoft/coe-starter-kit/issues/5570#issuecomment-1554471800, or unsubscribe https://github.com/notifications/unsubscribe-auth/A2AI32G7XG5EEUNAVJADFQLXG5OU7ANCNFSM6AAAAAAYGL22HQ . You are receiving this because you authored the thread.Message ID: @.***>

[Jenefer-Monroe]

Hello. I'm afraid you ahve to log in to GitHub to share the picture. You cannot respond via email and share pictures. Please go remove the unmanaged layer from this flow, it not being what we shipped implies you are not seeing our changes. This is described here: https://learn.microsoft.com/power-platform/guidance/coe/after-setup#remove-unmanaged-layers-from-inventory-flows

[ShaishilMandot]

Issue is with this action where inspite of so many bots in our tenant, the output is 0

[Jenefer-Monroe]

This picture shows that there are 142 inventoried bots that it is looking through for conversation transcripts. So I'm not sure what you mean here. Did you remove the unmanaged layer?

[ShaishilMandot]

Hi Jenefer, Yes we did removed the unmanaged layer and tried again, but no output for session data. Infact the unmanaged layer was created because of the filter changes you had asked to do in 1st conversation. To cross verify, we installed the latest version of COE toolkit released in May and even in that version the conversation transcript data is coming blank in all 142 bots. The screenshot i shared above shows that for all 142 bots, the conversation transcript data shows 0000000.

[Jenefer-Monroe]

ok ill send over to the area owner for investigation.

[HenryJammes]

Hi @ShaishilMandot,

Can you verify that there are conversation transcripts for the previous day? For example, if you're confident one of your chatbots has conversation transcripts from the past day, can you tell me what you see when you run that query in your browser (authenticate first on https://{DOMAIN}.crm{REGION}.dynamics.com/)

https://{DOMAIN}.crm{REGION}.dynamics.com/api/data/v9.2/conversationtranscripts?$apply=filter(Microsoft.Dynamics.CRM.LastXDays(PropertyName='conversationstarttime',PropertyValue=1) and _bot_conversationtranscriptid_value eq '{BOTID}')/aggregate($count as statecode)

You should get a sum here:

[ShaishilMandot]

Hi Henry, I tried this for couple of bots which are regularly used, i get below output {"@odata.context":"https://orge5f8ee4b.crm.dynamics.com/api/data/v9.2/$metadata#conversationtranscripts","value":[{"statecode":0}]} Also on cross checking the last launched date, it gives weird results. For most of the bots last launched dates are shown blank even if they are used. For below one, some random date is shown in last launch

[HenryJammes]

If you get 0, that means there are no Dataverse conversation transcript records, and this is what the CoE Starter Kit uses. Regarding the last launched date, I believe the field was deprecated and is planned to come back in the shape of a rollup field.

[Aditi3981]

Is this issue resolved?