Trying to query the asyncoperation entity through sdk / SQL. Not able to see the Workflowstate field. RRS feed

  • Question

  • Hello

    I've been trying to troubleshoot some failed workflow issues.  One of the things I'm doing is querying the asyncoperation entity through the sdk.

    When I view the Data field of an AsyncOperation record I can see the xml representation of AsyncOperationData.  This is great!

    However when I try to view the WorkflowState field of the AsyncOperation through the sdk, I always get a NULL back, even though I can verify that it's non-null through a sql query.

    1) Has anyone encountered this issue before?

    2) Does anyone know how to read the unencrypted versions of the following fields from this sql query:

    SELECT ao.Data, ao.WorkflowState
    FROM dbo.AsyncOperation ao 


    Monday, January 23, 2017 4:40 AM