Bug: ERROR: syntax error at or near ","

[Rijk J. van Vulpen]

I am using PostgreSQL as a database.

When I run a rtf report I receive the error:
ERROR: syntax error at or near ",";
Error while executing the query

If I push OK the scripts will progress it seems
and after many of these errors, the rtf report results
(apparently without failure?)

A colleague of mine gets it when opening
any view/archimate schema I made. Views
open correctly after clicking OK.

Can you help me out?

[Eve]

If you haven't already, can I suggest that you fill out the bug report form?

Please include the contents of '%appdata%\sparx systems\EA\dberror.txt'  (paste that into your file system explorer bar, run window or open dialog of any text editor)

[Rijk J. van Vulpen]

Will do. Found bug and solution, see below.

ERROR: syntax error at or near ",";
Error while executing the query

    Select * from t_xref where  Type ='swimlane' and Client='{E7EB60AE-7120-4db7-9448-56D64B1401A0}' order by to_number(Partition, '99999999999999999999999')

Solution:

Select * from t_xref where  Type ='swimlane' and Client='{E7EB60AE-7120-4db7-
9448-56D64B1401A0}' order by to_number('Partition', '99999999999999999999999')

the function to_number expects two 'text' parameters aka the Partition parameter has to escaped by single quotes.

Cheers