Updating Requirements Status

[jhaydt]

Hi,
I have written a script that updates the t_object.status field via ODBC from an exeternal (to EA) application.  When I do this successfully, however, the display does not correspond to the updated value.  For example: If a requirement object has a Status of "Proposed", and the design has been accepted in our design tracking application, I want to change it the Status to "Accepted".  I use the OBJECT_ID to locate and update the desired STATUS field, and this happens successfully.  When I query the database from SQLPLUS I see the new value in the STATUS field (different session, so I know it is committed and updated in the DB).  When I view the properties dialogue of the requirement, however, I see the status is still showing Proposed.

I am also updating the Version field in this way, and the Version field in the properties dialogue is updated as per the database value.

Is there something more I need to do to get the Status field to update in the properties dialogue, or is this a bug in the UI?

I have even tried refreshing the project, but the Status field in the Properties dialogue remains unchanged while the DB value is still the new value.

Thanks,
Jeff

[thomaskilian]

You probably need to reload the model via File/Reload. EA does not read from the DB every time.

[jhaydt]

Thomas, As stated, I reloaded the project and no change occurred.  Here is the SQLPLUS session

SQL> select status from t_object where name like 'BR0394%';

STATUS
--------------------------------------------------
Implemented

SQL>

But the window still shows "Proposed" in the status field.  This is even after restarting EA.

Jeff

[thomaskilian]

I see. But I tried it here and it works. So it is either something trivial or something complicated. Have you checked that EA points to the same repository where you execute your SQL?

[jhaydt]

Strange indeed  .  I did check to see if the repository was the same, just in case.  When I change the Status via Properties Dialogue, it is updated and the same sql returns the value from the dialogue, so I've checked to make sure I'm updating the right <everything>.  What build and version are you using?

[jhaydt]

Sorry... also would be good to know which DB, and which ODBC driver.  Thanks  

[thomaskilian]

I'm using 789 with plain EAP files. But I'm sure I've done similar things with other repositories. You're likely using Oracle (hence the antique Plus ). Honestly, I'm clueless. Could it be that your ODBC driver behaves strange?

[jhaydt]

Solved.  For anyone looking at this thread in the future, you also need to update PDATA1 for Requirements, as the Status, for some reason, is stored here.

Happy coding.
Jeff