Skip to main content
N
nborrerojr.1-Visitor
1-Visitor
November 25, 2014
Solved

Using TestVerdictName(LastResult()) in Computation Definition causes error MKS131372

  • November 25, 2014
  • 1 reply
  • 1519 views

When I try to use TestVerdictName(LastResult()) in the Compuatation Definition of a custom field, I get the below error.

errorMKS131372.jpg

MKS131372: An unhandled database exception has occurred. Please contact your administrator. The error supplied by the database is: ORA-00932: inconsistent datatypes: expected CHAR got CLOB

If I just use ToText(LastResult()) then I can at least get the number value of the last result but as soon as I replace it with TestVerdictName I get this error. I think I understand what the error is saying but I don't understand why I'm getting it.

Currently I am trying to work through the embedded if statements. The field type is shorttext. The Computation Definition (which isn't complete) is:

isMeaningful() ?

(

IsEmpty(lastResult(), 99) == 99 ?

(

"ALM_Verified By Trace Count" > 0 ?

Text("Traces")

:

Text("Not Run")

)

:

TestVerdictName(LastResult())

)

: emptytext()

    Best answer by KaelLizak

    Hello Nolin,

    This may be a product problem. Please contact PTC Integrity Support to open a ticket for this issue.

    The error is happening because your backing Oracle database is expecting a CHAR type value for a method, and is instead getting a CLOB. The ORA-00932: inconsistent datatypes error comes up anytime this sort of situation occurs, and I doubt it is as a result of your computation definition, although I am not convinced about the results of the TestVerdictName(LastResult()) call..

    Regards,

    Kael

    1 reply

    K
    KaelLizak16-PearlAnswer
    16-Pearl
    November 26, 2014

    Hello Nolin,

    This may be a product problem. Please contact PTC Integrity Support to open a ticket for this issue.

    The error is happening because your backing Oracle database is expecting a CHAR type value for a method, and is instead getting a CLOB. The ORA-00932: inconsistent datatypes error comes up anytime this sort of situation occurs, and I doubt it is as a result of your computation definition, although I am not convinced about the results of the TestVerdictName(LastResult()) call..

    Regards,

    Kael

    N
    nborrerojr.1-VisitorAuthor
    1-Visitor
    November 26, 2014

    Kael,

    I will open a ticket. Thank you for the info.

    Thanks,
    Nolin

    Terms & ConditionsCookie settingsAccessibility statement