Row Cannot be located for updating.... [FIXED]

[Richard D Vodden]

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?

[qwerty]

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.

[Stefan Bolleininger]

Hi,

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

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

Regards

Stefan

[Richard D Vodden]

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:










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.

[Richard D Vodden]

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.