Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: petahatea on February 21, 2023, 06:52:50 pm

Title: update filesize in t_files
Post by: petahatea on February 21, 2023, 06:52:50 pm

Hi all,

we have EA v16 and repository in Postgre v13.6. Sometimes an issue appears with multiple users, independently on project they work.

In c:\Users\<USER>\AppData\Roaming\Sparx Systems\EA\dbError.txt, for all users, there is an error:

Microsoft OLE DB Provider for ODBC Drivers [0x80004005]
ERROR: column "t_files" of relation "t_files" does not exist;
Error while executing the query Context: UPDATE t_files SET t_files.FileSize = 1 WHERE  t_files.FileID IN ('{<a fileid>}')

Apparently, there is no table alias t_files, so update fails.

How to solve this?

Thanks.

Title: Re: update filesize in t_files
Post by: qwerty on February 21, 2023, 09:22:02 pm

Your sql is probably wrong. The column should read just FileSize without the prefix.

q.

Title: Re: update filesize in t_files
Post by: petahatea on February 21, 2023, 09:29:15 pm

You are right. Thanks. But I think this sql query comes from EA itself. I think we do not query t_files at all, in custom way.

P.

Title: Re: update filesize in t_files
Post by: qwerty on February 21, 2023, 09:45:08 pm

What DB are you using? Have you check the table columns? You might run a SELECT * FROM t_files from the query window.

q.

Title: Re: update filesize in t_files
Post by: petahatea on February 21, 2023, 11:55:23 pm

We did some tests.

If you sent message in Chat&Mail with link to an object, such as archimate function, it causes on "receiver" side mentioned error. In chat option there is Check for Messages Every <minute, 2, 5, 10 minutes>. The error then appears in the same interval as it is set in that option.

Title: Re: update filesize in t_files
Post by: Geert Bellekens on February 22, 2023, 12:06:36 am

I have a feeling like this is invalid syntax, but might be overlooked by some databases.

The correct syntax should probably be
UPDATE t_files SET FileSize = 1 WHERE  FileID IN ('{<a fileid>}')

Simply report as a bug to Sparx; there's nothing else you (or any of us) can do I think.

Geert

Title: Re: update filesize in t_files
Post by: petahatea on February 22, 2023, 12:45:35 am

Reported as bug to Sparx.

Thank you all.

Cheers

EDIT> This issue was corrected in EA version 16.1 build 1621.