Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - msdb

Pages: [1]
General Board / Re: Task Scheduler
« on: September 12, 2016, 11:21:34 pm »
Thank you both for replying.

I've tried what you suggest. EA is installed on the server and a user has been specified for the task. When I log back in to the server I can see that EA.exe is running, so it has been launched but no export occurs.
I have also given the user full write/read access to the export folder and where EA.exe is located. Not sure what else I can do.

General Board / Task Scheduler
« on: September 12, 2016, 06:12:03 pm »

I've written a C# console program that uses the EA Api to access a repository and export an xmi file. I'm trying to make this program run automatically on a windows server 2008 with the task scheduler which works fine when I'm logged on to the server, however, I'd like it to be able to run when I'm not. This doesn't seem possible though, no matter what settings I use. Thus far, I've assumed that windows was the problem, not EA.

Has anyone tried something similar or know whether EA is unable to be launched without a logged in windows user?

Automation Interface, Add-Ins and Tools / Re: Cannot update connector
« on: June 02, 2016, 06:24:22 pm »
Okay, I see my mistake now. Thank you.

Automation Interface, Add-Ins and Tools / Cannot update connector
« on: June 01, 2016, 06:30:34 pm »
In my C# program i have a method that should create a connector between two elements but it's throwing this error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in SparxProject.exe

Additional information: Cannot update connector as either the Start or the End object is NULL

The method:
Code: [Select]
static void LinkToSuperDepartment(Element subDepartmentOrEmployee, int superDepartment)
            Connector aggregationConnector = subDepartmentOrEmployee.Connectors.AddNew("", "Connector");
            aggregationConnector.Type = "Aggregation";
            aggregationConnector.Stereotype = "Archimate2::ArchiMate_Aggregation";
            aggregationConnector.ClientID = subDepartmentOrEmployee.ElementID;
            aggregationConnector.SupplierID = superDepartment;
            aggregationConnector.Direction = "Source -> Destination";


The error occurs when Update() is called.

Do ClientID and SupplierID not specify the start and end objects of the connector?

Automation Interface, Add-Ins and Tools / Re: API autostart
« on: May 27, 2016, 06:47:24 pm »
Ah, right. Now I get it. Thank you.

Automation Interface, Add-Ins and Tools / API autostart
« on: May 27, 2016, 06:15:31 pm »

In my c# project im accessing EA with

Code: [Select]
App eaApp = (App)System.Runtime.InteropServices.Marshal.GetActiveObject("EA.App");

but it requires EA to be running. Is there a way to open EA automatically via code?

Bugs and Issues / Re: GetElementSet query failure
« on: May 19, 2016, 09:36:09 pm »
SQLQuery works like a charm.  :)

Many thanks to both of you.

Bugs and Issues / Re: GetElementSet query failure
« on: May 19, 2016, 12:09:13 am »
I still get the same error even when only selecting Object_ID.

Bugs and Issues / Re: GetElementSet query failure
« on: May 18, 2016, 11:17:45 pm »
The DBError.txt doesn't provide much insight, unfortunately.

I'm writing a program that populates an .eap-file with elements via the API. The purpose is to add data from a seperate database that does not exist in the eap yet. The .eap-file I'm using already has almost 9000 elements in t_object, which is quickly exceeded upon first execution. If I launch the program again it causes EA to return the error when it reaches the query.

My query looks like this:
Code: [Select]
App eaApp = (App)System.Runtime.InteropServices.Marshal.GetActiveObject("EA.App");
Repository sparx_repository = eaApp.Repository;
sparx_repository.OpenFile("C:/Sparx/MDR legemodel (EA-model klon).eap");
string sql_query = "select * from t_object where Stereotype = 'ArchiMate_BusinessActor' AND (Alias <> 'NULL')";
Collection eap_data = sparx_repository.GetElementSet(sql_query, 2);;

Bugs and Issues / GetElementSet query failure
« on: May 18, 2016, 10:21:21 pm »

I'm using GetElementSet to query some data in Sparx EA which generates the following error, seemingly when the amount of data becomes too large:

"DAO.QueryDef[3219] Invalid operation"

However, it works fine with smaller amounts of data.

How do I query my data without getting this error?

Pages: [1]