Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: bholtzman 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
-
You should contact Sparx support in any case. Else: make a backup (if you not already have it) and try your best with deleting the baseline.
q.
-
Hi Bill,
Just FYI, EA doesn't just store the baseline properties in t_document, the actual baseline is in there as well in the form of a compressed XMI file stored in t_document. So presumably something went wrong during creation of the baseline which corrupted its t_document row.
Deleting the baseline might resolve the situation. If EA won't let you do that, try deleting it using your favourite SQL query tool.
And as qwerty says, don't do maintenance in the live version of the EA project if you can avoid it.
/Uffe
-
For sure you can have more baselines in a database.
The problem with baselines is more the compare of stuff with baselines, what is not really useful.
I had a similar problem some weeks ago. I my case I got an error message, what made me belief that due to the error it was not possible to create the baseline, but at the end the baseline was created.
The root cause of the error message was a wrong SQL query I put in a modelview element.
So, maybe check (if not already done) if the baseline was created or not.
Further on, it might be a good idea to set up a test environment to try to create baselines of simple content, to find out if it is PostgreSQL or a model content problem.
-
Thanks all.
Bill