EAP to DBMS (SQL server) transfer

[OpenIT Solutions]

Hi All,

I'm getting an error whan transfering a blank EAP to DBMS - t_category does'nt exist. Well it does in the DBMS...anyone come across similar issue ? Same with 9.2 and 8.0 - so i've probably got something mis-configured - but can't see it

Any help, pointers appreciated...

ps Sparxs crashes after reporting the error....

[qwerty]

No real idea, just a guess: user rights.

q.

[Stefan Bolleininger]

are you sure the EAP is really blank?

i had the same issue but with another table when i tried to move an sample project where i forgot to delete an old unused picture.

Have you tried to transfer the Standart sample project which is delivered with you installation or can be downloaded here?

[Geert Bellekens]

I would check that:
- the sql server database is properly initialised using the latest creation script from the sparx website
- The "empty" eap file is also created by a recent version of EA.
- There's nothing strange in the "empty" eap model.
- Also check if you are using the latest EABase.eap to create a new model. (mine is dated 28/10/2011 and I'm on version 9.2.921)

Geert

[OpenIT Solutions]

Thanks for all responses - ill try all and feedback.

Regards,

Jon.

[OpenIT Solutions]

Hi All,

FYI the solution was in back and white on the sparx site - all be it in the small print  :-/

"When transferring a project you must have db_ddladmin permission in order to execute the SET IDENTITY_INSERT ( table )  {ON | OFF} command"

Got my db to change my rights and all is now ok....

[qwerty]

I guess 90% of all SQL issues are due to missing rights so that's the first I try if something fails: go to the DBA and let him do it.

q.