Book a Demo

Author Topic: Problem with compare / merge  (Read 4290 times)

skylord88

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Problem with compare / merge
« on: August 25, 2010, 04:53:29 pm »
when trying to compare a larger project package with an external exported project structure i receive an error: DAO.Database(3075) Syntax error (missing operator) in query expression t_object.Package_ID in () which renders the merge from baseline function inoperative in the end. Any ideas?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Problem with compare / merge
« Reply #1 on: August 25, 2010, 06:21:31 pm »
Look in the dbError.txt located in the main ea program directory.
That will probably contain the complete sql query that caused the error.

Geert

aburton

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
  • All your base are belong to us
    • View Profile
Re: Problem with compare / merge
« Reply #2 on: September 09, 2010, 03:20:28 pm »
I also get the same error... the db error file contains:

9/09/2010 3:10:15 PM
DAO.Database [3075]

Syntax error (missing operator) in query expression 't_object.Package_ID in ()'.

Context:
      SQL: SELECT null as Diagram_ID, null as RectTop, null as RectLeft, null as RectRight, null as RectBottom, null as [Sequence], null as ObjectStyle, null as Instance_ID , t_object.*, t_object.Object_ID as Object_ID, t_package.Name as PackageName , t_object_1.Name as ClassName FROM (t_object LEFT JOIN t_object t_object_1 ON t_object.Classifier = t_object_1.Object_ID) INNER JOIN t_package ON t_package.Package_ID = t_object.Package_ID  Where t_object.Package_ID in () Order by t_object.TPos :-[


Any ideas? also large file

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Problem with compare / merge
« Reply #3 on: September 09, 2010, 06:50:26 pm »
EA seems to somehow forget to fill in the list of packageID's the elements has to belong to.

Looks lik a plain and simple bug, I would report it to Sparx, they can probably fix it in the next release.

Geert