Full Structure for Duplication Issue

[GeistBW]

So I am used to using Copy to Clipboard -> Full Structure for Duplication . I used this a few days ago and it worked fine. I could even paste just fine. But now when I use this function, for a second it shows the progress bar like it is starting the copy, then this error comes up:
    Microsoft OLE DB Provider for ODBC Drivers [-2147217913]
    [Microsoft][ODBC SQL Server Driver][SQL Server] Conversion failed
    when converting the nvarchar value 'Approved' to data type int.

I haven't done anything with any "Approved" context.  I don't even know where "Approved" is used outside of the "Status" field in the Properties window.  Although everything I've done in Sparx, that field is left as the default value: Proposed.

Any idea on what happened?  Or how I can get back to how to make this copy function work again?

EA Sparx 15.0 and ProCloud Server 3
Thanx in advance.

[Geert Bellekens]

Try Project Integrity check.

If that doesn't work, contact Sparx support.

Geert

[GeistBW]

The Project Integrity check showed no problems.  If any other suggestions come to mind please let me know. I will also send email to Sparx Support.

[Eve]

First point, which may not help with this error.

Your error message indicates you're using 'ODBC SQL Server Driver'.

That driver is known to have problems and has never been a supported method for connecting to SQL server. You should get whoever is managing your PCS to update it.

See https://www.sparxsystems.com/enterprise_architect_user_guide/15.2/model_repository/connecttosqlserver.html

In particular:

Select 'Microsoft OLE DB Provider for SQL Server' or 'Microsoft OLE DB Driver for SQL Server' from the list.

Note:

• 'Microsoft OLE DB Provider for SQL Server' is usually part of the Windows Operating System, otherwise it can be installed as part of MDAC 2.8
• 'Microsoft OLE DB Driver for SQL Server' is a newly released driver that adds support for TLS v1.2 and other more recent features of Microsoft SQL Server (such as multi-subnet failover capabilities); this driver is available from the Microsoft website

What I also see in the error message is that some query in the XMI export is converting a text field to an integer value (likely a pdata field.) I would recommend trying a new version since my memory says that all of those were changed to work the other way around. Because I suspect that's not an answer that you will like, you may also be able to find the rogue value by checking the PDATA fields for both t_object and t_connector.