ORA-01795 Error when working with DBMS and SVN VC

[kosh.iii]

We have experienced severe data consistency problems with the .EAP files in some of our models so I wanted to try an Oracle-DBMS as an alternative backend.

The model transfer from EAP->DBMS worked very well but when I checked out a package from SVN and performed a "Cancel Check-Out" later on I reveived the following error message:

Code: [Select]

OraOLEDB [-2147217900]
ORA-01795: Maximum number of expressions in a list is 1000
I know only of a limit in Oracle-DBs since version 8 where SELECT IN-clauses support a maximum of 1000 parameters. Is it possible that EA breaks this limit during its VC operations?

[Geert Bellekens]

I've had this error a few years ago as well.
On which version on EA are you trying this? If I remember correctly there was a bugfix about 1.5 years ago that fixed that problem for me.

Geert

[Eve]

Please contact Sparx Support directly at http://www.sparxsystems.com/support/bug_report.html with your support request.

[zapolo]

I get this error, there is a solution