Microsoft Cursor Engine on Apply

130 views
Skip to first unread message

TBowersox

unread,
May 13, 2015, 11:46:52 AM5/13/15
to sparx-enterprise-architect-b...@googlegroups.com
I'm trying to create a new Model Document in one of my packages. After just creating it, I'm getting the error, ":Microsoft Cursor Engine [-2147217864] Row cannot be located for updating. Some values may have been changed since it was last read."

I have:
  • Deleted and re-created the Model Document
  • Deleted and re-created the containing package, then re-created the Model Document
  • Deleted and re-created the grandparent package, parent, and the Model Document


Any suggestions for what I can start looking into?
We're using a MariaDB backend to store the data.

Thanks!
Tom

-- Edit, been doing some more debugging, getting some SQL logs. The following two lines return all nulls when executed manually.
SELECT * from t_operation where  ( Object_ID IN (5862) )  Order by Object_ID, Pos DESC , Scope, Name DESC
SELECT * from t_attribute where  ( Object_ID IN (5862) )  Order by Object_ID, Pos, Scope, Name

[original message]

Bellekens@localhost Geert Bellekens

unread,
May 13, 2015, 12:55:14 PM5/13/15
to sparx-enterprise-architect-b...@googlegroups.com
There's a setting somewhere in the odbc connection for MySQL that you have to switch. Something with "return number of rows" or similar, I don't remember exactly.

Check the help for details.

Geert

[original message]

TBowersox

unread,
May 13, 2015, 1:06:51 PM5/13/15
to sparx-enterprise-architect-b...@googlegroups.com
Perfect, thanks!
And the option is under Cursors/Results -> "Return matched rows instead of affected rows"

[original message]
Reply all
Reply to author
Forward
0 new messages