update filesize in t_files

[petahatea]

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.

[qwerty]

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

q.

[petahatea]

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.

[qwerty]

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

q.

[petahatea]

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.

[Geert Bellekens]

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

[petahatea]

Reported as bug to Sparx.

Thank you all.

Cheers

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