Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - bholtzman

Pages: [1]
1
General Board / Insert tagged value from MS Access
« on: August 10, 2017, 01:54:22 am »
I've built a tool in MS Access that connects to the EA database and provides tracking and a custom metadata "overlay". The tool can export a combined set of EA and non-EA metadata in various custom formats. One of the data elements I am extracting is from the two tagged value tables in EA, t_attributetag and t_objectproperties.

I have limited the Access app to querying the native EA tables only. I have never done any inserts from the Access app, but I have selectively run a few table updates manually.

The question has now come up as to whether new tagged value entries can be made from the Access side. Is that a bad idea or is it doable with careful diligence? Is there a way to populate the ea_guid field in the tagged value tables?

I am using EA 13.5 and Access 2016.

Thanks.

Bill

2
General Board / Upgrade to 13 with Postgres db
« on: December 07, 2016, 04:53:55 am »
Hi all,
If I upgrade my application to EA 13 can I still use the same EA 12 Postgres database? Thanks.

Bill

3
General Board / baseline fail
« on: July 14, 2016, 09:48:22 pm »
Hi all:
We have a PostgreSQL database set up with our EA 12.1.1227 Corporate Edition clients. I was trying to create a new baseline and got the message:

"ERROR: column "bincontent" is of type bytea but expression is of type lo; Error while executing the query"

I tracked this issue down to what I believe is the culprit, the column bincontent in the table t_document. This appears to be where EA stores the global attributes associated with each baseline. Interestingly, I was able to create a single baseline weeks ago for my database because (I believe) there was no data in this table previously. But now that a baseline exists I cannot create a second one because the code fails when it encounters the original baseline data. So as I see it I can only have one baseline in the database. Any ideas other than delete the first baseline?

Thanks.

Bill

Pages: [1]