Workflow activity with a large amount of data processing cause error "actor: failed to unmarshal history event" about dapr HOT 7 OPEN

@olitomlinson
Yes, my customer uses Azure SQL state store component.
And they report in Production environment, when data is small (just two items), this error is still raised.

from dapr.

@cgillum SQL_Latin1_General_CP1_CI_AS

from dapr.

@heavenwing

Which state store component are you using for storing the Workflow state?

We've seen weird things like this cropping up on Azure SQL state store...

from dapr.

Cc @cgillum

Another Azure SQL workflows issue

from dapr.

@heavenwing

Couple more questions

• What is the compute host technology in use here? Is it AKS, ACA, or something else?
• Is the compute located in the same azure region as the Azure SQL?
• What Azure SQL configuration are you using?
  -- vcore / DTU?
  -- serverless / provisioned
  -- Service Tier : General Purpose / Business Critical / Hyperscale
  -- Hardware Type : Standard / DC / Premium etc

from dapr.

Also, what is the collation of the SQL database?

https://learn.microsoft.com/sql/relational-databases/collations/view-collation-information?view=sql-server-ver16

I suspect this might be an important detail.

from dapr.

@olitomlinson
1、What is the compute host technology in use here? Is it AKS, ACA, or something else?
AKS
2、Is the compute located in the same azure region as the Azure SQL?
YES
3、What Azure SQL configuration are you using?
DTU Standard S3

from dapr.