Skip to main content
subhashreel0001
Participating Frequently
Mar 7, 2022 8:26 PM UTC
Question

Error converting query output

Hello Everyone,

I am getting the following error when querying one of the table from application. The entity I am querying is a nested CDT. 

Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0]

It is an existing CDT which used to work just fine. The only recent change I have made is increased the column length for some of the fields in the table and removed the length parameter from the xsd annotation. Could it be the issue?

I am able to get data by sql select statement.

Please help if anyone knows or have experience on how to fix this issue. Thank you.

    4 replies

    andrewh0007
    andrewh0007
    Inspiring
    Mar 7, 2022 10:06 PM UTC

    This is a bit of a guess but does your data store entity still verify without errors in the data store?

    subhashreel0001Author
    Participating Frequently
    Mar 7, 2022 10:32 PM UTC

    yes it does without any errors

    harshas2775
    harshas2775
    Brainy
    Mar 8, 2022 4:38 AM UTC

    I suggest to modify XSD to have the length parameter as well so that its in sync with the database table attributes. As the issue happened after you made the changes, fixing the change should resolve the issue as well. 

    Happy to help. Even happier to optimize.
    gopalk2865
    gopalk2865
    Participating Frequently
    Mar 8, 2022 4:55 AM UTC

    HI subhashreel0001, Try to modify the xsd according to your db changes , keep lenth value in xsd  same as your db and then check if it works.

    Terms & ConditionsAccessibility statement