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 - Arquesoft

Pages: 1 2 [3] 4 5 ... 9
31
Two approaches:

1) Avoid automatic calculation of timeseries chart (which only works when having Cloud Server), and manipulate the data of the chart via a custom script that calculates your data and stores it in the suitable tag value of the timeseries chart (the data is stored as an XML). Just a programming solution.

2) Use some query that returns as rows as the value of your current dot in the graph. For example, the following SQL returns 10 rows (change the 10, and return different number of rows). Works in SQLServer:
Code: [Select]
SELECT TOP(10) 'true'
FROM sys.columns AS a CROSS JOIN sys.columns AS b

32
I created a C# console app that works fine in development environment and in production environment (windows server 2008 R2 64 bits) but only when executed manually. When scheduled in Windows Task Manager it throws the following exception:

Retrieving the COM class factory for component with CLSID {67F4E0FA-46A7-4255-B084-69A9433D08C3} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).

I followed the instructions described in:

But when trying to find the EA.App component in the Component Services windows, it is not listed, as shown:


Even in my local PC (windows 10, 64 bits), the EA.App is not listed. Note the shortcut of the comexp executable:


I followed all the instructions in the previous links, even in my local PC but the EA.App is never listed in the Component Services window, so it becomes imposible to configure full launch permissions to this component.

Any ideas?

33
As it seems there is no way to include triggers in the template editor, you can explore the database in order to determine how your triggers are stored. Then, you can do a Document fragment to get the information of you trigger via an SQL. After that, just include your fragment into your document.

34
I did it!

35
Bugs and Issues / Re: V14 different browser order
« on: May 16, 2018, 02:41:42 am »
Corrected in today build (1420). See https://www.sparxsystems.com/products/ea/history.html#1420

36
I could 'unhide' the hidden baselines by executing the following SQL in the database:

UPDATE t_document SET ElementID = SUBSTRING(DocType,12,38), DocType = 'Baseline' WHERE DocType LIKE 'BaselineOf={%};'

37
Hi, I have just noted some inconsistent data in a SQLServer model about baselines.

I've been using in the last weeks different versions of EA (Build 1310, Build 1351, Build 1352, 14 Beta 1, 14 RC 1, Build 1418 and Build 1419).

I have a script that creates baselines for a list of package GUIDs. I've run the scripts periodically and it used to work by april 10.

Now, I noted that data is inconsistent in the database, for the following reason:
Table t_document is supposed to store the baselines. I had several data in which column 'ElementID' stores the GUID of the package with the baseline, and the column 'DocType' stores the string 'Baseline'.

But now, I have data of table t_document modified and the same entries (recognized for DocID field) have now another data for column 'ElementID' (not a real element guid), and field 'DocType' now stores the string 'BaselineOf='{THEGUIDOFTHEPACKAGEWITHTHEBASELINE};'

Obvuiosly, EA does not detect this modified entries as baselines of the package, so the baseline list for all my packages are empty, but I still can see the entries in the database.

Any idea of what to do? what make this happen?

(I know a solution is to restore the 'ElementID' entries based on 'DocType' entries but I need to know what make this happen).

38
Now, when creating a Diagram Legend, it is visible in the Project browser but without name.

39
So I've just got some clarification that to fix this problem with SQL Server you need to apply an additional patch to the schema (EASchema_1220_SQLServer_Update1.sql). This update was just recently made available on our website (April 2018). In particular, please note that it requires all users to have EA 14 and is not backwards compatible. For more details, see:
http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts

What is the consecuence of executing the SQL patch and having some users using version 14 and others using previous versions? will this bother the use of image library? or just version-13 users would be unable to upload images? Will this scenary cause errors? (asuming I pretend to upload images only from version 14 users)

40
Bugs and Issues / Re: Tooltip on menu options
« on: May 03, 2018, 05:33:57 am »
Excelent! thank you very much!

41
Bugs and Issues / Tooltip on menu options
« on: May 03, 2018, 05:01:48 am »
In previous versions of EA (12 and older) it used to have a tooltip in the mouseover for every button in the user interface. In version 13 it is not present anymore, so I supposed it was a bug. But now, the version 14 has the same "bug"

42
Use the following function in JScript-type script and validate it in the logic of your script:

Code: [Select]
function isUserInGroup(groupGUID) {
var userGUID = Repository.GetCurrentLoginUser(true);
var result = DBGetFieldValueArrayString("GroupID", "t_secusergroup", "UserID = '" + userGUID + "' AND GroupID = '" + groupGUID + "'");
if(result.length == 0) {
return false;
}
return true;
}

43
General Board / Re: Displaying A Banner When Accessing A Model
« on: May 01, 2018, 05:47:13 am »
Lock the diagram with user lock, so they will not be able to modify it.

44
Thanks Geert, it worked!

45
Is your automation running with an .exe file? a .bat file? a windows scheduled task? Please tell us about the environment you created for you automation in order to clarify.

Pages: 1 2 [3] 4 5 ... 9