Topics

1

Automation Interface, Add-Ins and Tools / Automation issue with Tagged Values in Oracle DB

« on: March 08, 2016, 09:14:01 pm »

Hello EA guys, I'm blocked for days and I would like assistance for the following issue. 
I receive the following error when I try to create a tagged value on a package object...

Code: [Select]

OraOLEDB [-2147217900]
ORA-01400: cannot insert NULL into ("IB0040_ENT_ARCH_TEST"."T_OBJECTPROPERTIES"."PROPERTYID")
I'm using Visual Studio 2015 and I use the DLL provided via EA version 12 (the latest one).
When I inspect the content of the Element COM object, I see the TaggedValuesEx collection with 2 items.
When I try to add a 3rd one, the addItem() seems to work but the collection is not updated ?
Aftert that, when I try to call the Update() method, I received the error I described before.

Code: [Select]

   Private Sub SetReqId(element As EA.Element, value As String)
        Dim taggedValue As EA.TaggedValue = CType(element.TaggedValuesEx.GetByName("HPALM_ReqId"), EA.TaggedValue)
        If taggedValue Is Nothing Then
            Dim obj As Object = element.TaggedValuesEx.AddNew("HPALM_ReqId", "String")
            taggedValue = CType(obj, EA.TaggedValue)
        End If
        taggedValue.Value = value
        taggedValue.Update()
    End Sub
Your help will be precious for me. 
I would like to avoid to access directly and dirtily to database.

Cheers.
Emmanuel @ Eurocontrol