Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Richard D Vodden on June 19, 2014, 11:30:36 pm

Title: Row Cannot be located for updating.... [FIXED]
Post by: Richard D Vodden on June 19, 2014, 11:30:36 pm

I'm using a postgres database and the corporate edition of EA. I've created a BPMN 2.0 diagram, and created a single pool. Whenever I add an activity, it adds OK, but after I select the nature (manual, send etc.) of the activity, I get the following error:

Code: [Select]

Microsoft Cursor Error [-2147217864]

Row cannot be located for updating.
Some values may have been changed since it was last read.

I'm the only person using this database at the moment, as I'm running a PoC which I haven't rolled out to any other users yet. Does anyone have any ideas what might be going on?

Title: Re: Row Cannot be located for updating....
Post by: qwerty on June 20, 2014, 12:19:54 am

You might check whether the used ODBC driver is actually supported. I know there are similar issues with MySQL but can't actually speak about Postgres.

q.

Title: Re: Row Cannot be located for updating....
Post by: Stefan Bolleininger on June 20, 2014, 01:24:19 am

Hi,

Check if the ODBC-Driver has the following checkboxes activated:

"Allow big result sets"
"Return matched row instead of affected one"

Regards

Stefan

Title: Re: Row Cannot be located for updating....
Post by: Richard D Vodden on June 23, 2014, 07:07:28 pm

Stefan,

Thanks for the suggestion, but I don't seem to be able to find those options. I've taken screenshots of all the configuration screens I can find:
(http://s2.postimg.org/5oyqyv8lx/ea1.jpg) (http://postimg.org/image/5oyqyv8lx/)

(http://s2.postimg.org/lr1a598b9/ea2.jpg) (http://postimg.org/image/lr1a598b9/)

(http://s2.postimg.org/vpm8rqhqt/ea3.jpg) (http://postimg.org/image/vpm8rqhqt/)

(http://s2.postimg.org/t5qlxmu6t/ea4.jpg) (http://postimg.org/image/t5qlxmu6t/)

(http://s2.postimg.org/u6qumrb6d/ea5.jpg) (http://postimg.org/image/u6qumrb6d/)

I've checked and I've got all the settings from

http://www.sparxsystems.com/enterprise_architect_user_guide/8.0/projects_and_teams/setupapostgresqlodbcdriver.html.

I'm using version 9.03.03.00 of the driver.

Thanks!

Richard.

Title: Re: Row Cannot be located for updating....
Post by: Richard D Vodden on June 23, 2014, 07:48:24 pm

Ahaha - I've got it. The MaxVarchar needs to be set to 1024 and the Max LongVarChar needs to be set to 1000000 then all works fine. Thanks for your help :-)

Richard.