« previous next »
Pages: [1]

Author Topic: Specification Manager displaying error before open  (Read 6470 times)

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 341
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Specification Manager displaying error before open
« on: October 25, 2014, 06:39:35 am »
We have a large database repository in SQLServer (3 Gb aprox). Several modeles, several users, several groups and every package/element/diagram locked to a given group.

Repository was created and tipically used in EA 9.3. We are testing it now using EA11 and we have noted when you try to open Specification Manager for some packages it display an alert with the text: "Microsoft OLE DB Provider for SQL Server (...) Conversion failed when converting the nvarchar value '{A-GUID-LIKE-VALUE}' to data type int."

Below the message you can see the Specification Manager for the selected package, and after clicking OK button in the alert window, the SM works fine.

The GUID-LIKE-VALUE shown in the message is always the same, no matter the package you selected to open the SM. We have tested in different packages, located in different views and different models. For some of them the error is shown (same GUID in the message) and for other is never shown.

This problem only happens in one of 4 EA SQLServer repositories. The problem could not be replicated in EAP or other local files.

Any ideas?
Logged

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Specification Manager displaying error before
« Reply #1 on: October 27, 2014, 09:31:50 am »
Yes. Report a bug!

q.
Logged

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 341
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: Specification Manager displaying error before
« Reply #2 on: October 30, 2014, 05:45:41 am »
I have just reported it.
Logged

SSee

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Specification Manager displaying error before
« Reply #3 on: November 20, 2014, 07:49:01 pm »
The same issue here using EA 11.0.1107 using a SQL Server based repository with nearly no content in. SQL Server Express 64bit 11.0.2100.60 is used.
What should I try to get rid of this issue?

Best Regards,
Stefan
Logged

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 341
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: Specification Manager displaying error before
« Reply #4 on: February 04, 2015, 08:50:46 am »
I tested it again in v 11.1.1113 and the message is different not. It says:
 "Microsoft OLE DB Provider for SQL Server (...) Conversion failed when converting the nvarchar value 'Proposed' to data type int.".

It seems to be related to the element status.
Logged

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 341
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: Specification Manager displaying error before
« Reply #5 on: February 04, 2015, 08:53:19 am »
Good News: Now tested in V12 RC2 (where Specification Manager is called now "View as Requirements List") and it seems to work fine. So if you have the same issue wait for the official release of V12.
Logged

TomO

  • EA Administrator
  • EA User
  • *****
  • Posts: 80
  • Karma: +7/-0
  • EA - Bridging the gap between Business and IT
    • View Profile
    • Sparx Systems
Re: Specification Manager displaying error before
« Reply #6 on: February 17, 2015, 02:49:50 pm »
You can also access it by Tools -> Specification Manager in EA 12.
Logged
Pages: [1]
« previous next »