Skip to main content
S
subhashreel0001
Participating Frequently
March 7, 2022
Question

Error converting query output

  • March 7, 2022
  • 4 replies
  • 2 views

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
    March 7, 2022

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

    S
    subhashreel0001Author
    Participating Frequently
    March 7, 2022

    yes it does without any errors

    harshas2775
    harshas2775
    Brainy
    March 8, 2022

    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. 

    gopalk2865
    gopalk2865
    Participating Frequently
    March 8, 2022

    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