Messages

1

General Board / Re: transfer project to DBMS

« on: August 10, 2016, 04:06:52 pm »

To add to the questions that might help narrow the issue.


- Do you have all rights on the database or was it set up by someone else who granted you permissions on it?
- Is EA security turned on?
- Is the RDMS server set up to allow multiple users for this database?

What is being described appears to indicate that something (you or another process) has write locks on the tables which are preventing updates.

2

General Board / Re: Share model components between different projects

« on: August 06, 2016, 03:30:28 am »

There is no scripting ability for RAS.  I put in a feature request when it first came out requesting this, however based on the posts I've seen I don't think it has enough momentum yet for this type of request to bubble up.  You should make the feature request though so it gets logged.

Stan.

3

Automation Interface, Add-Ins and Tools / Re: Open Specification Manager by API for a Package

« on: July 27, 2016, 09:01:06 am »

Well Windows does have PowerShell which has pretty much all the same command line tools available in bash - assuming you are using Win 7 or later.  The part that annoys me is that the names and options are all different so I have to use PowerShell ISE and constantly look up equivalents.  Supposedly the upgrade to Win 10 due in a few days will support a native Ubuntu bash shell with access to all the familiar unix command line tools.

4

Bugs and Issues / Re: Issue in SPARX Diagrams Navigation after Generating HTML Report

« on: July 07, 2016, 02:14:12 pm »

This might happen if the elements you are missing in the web browser are in a package (or project root) that is not being exported to html.  As the elements are in the same repository the EA client project browser won't have a problem finding and displaying them.

Stan.

5

Bugs and Issues / Re: Cloud Service user

« on: July 07, 2016, 05:55:42 am »

I don't know if its a best practice, however I've used the first option (or variant) proposed in the past i.e. create a local service account that can access the database - assuming the database and cloud service are running on the same machine.  If the database and cloud service are on different machines, you might have to create a domain account as the service account and add it to the security group just like a regular user.

It's probably not a good idea as noted to grant the local system user access to the database.

qwerty, the cloud service exposes the repository via http calls from a web server included with the service.  The web server in turn communicates with a Windows service that connects to the database and runs the actual queries whose results get repackaged back into content for the EA client.

Stan.

6

Bugs and Issues / Re: HTML export on web server

« on: May 14, 2016, 09:09:59 am »

I've used it with IIS before and never had to do any additional work other then copy the root directory where the html gets generated to a folder exposed by IIS.  In my case I had an automated process that generated the html and then copied the root over for IIS to expose.

Stan.

7

Automation Interface, Add-Ins and Tools / Re: Automation for DBMS to DBMS backup?

« on: April 26, 2016, 03:38:55 am »

I posted a little PowerShell snippet that does exactly this below.

http://sparxsystems.com/forums/smf/index.php/topic,2708.msg222357.html#msg222357

Stan.

8

General Board / Re: Import new tagged value onto component

« on: April 26, 2016, 03:17:29 am »

You might try the csv import functionality.  It was updated over the last couple of versions to allow import of tag values.  You'll need to do something like:

• Export the GUID, Name, Type of the components to be updated to csv
• Update the csv to include the new tag values
• Import the updated file

I haven't looked at Geert's importer in a while but it should be fairly easy to update that to add tag values to existing components as well.

Test offline to catch any specific nuances for your case.

Stan.

9

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: April 02, 2016, 04:07:08 am »

qwerty pointed how to do this in his post.  I just posted a short powershell script that will do exactly this and can be run from the scheduler.

http://sparxsystems.com/forums/smf/index.php/topic,2708.0.html

10

Automation Interface, Add-Ins and Tools / Re: Automated project transfer from DBMS to EAP file.

« on: April 02, 2016, 04:00:47 am »

This has been asked somewhere else as well.  The Powershell snippet below can be run from a scheduler to automate the process.  All the caveats about having a user logged into an interactive session still apply.

Code: [Select]

# Create the EA object
$ea = New-Object -ComObject "EA.Repository" -Strict

# Get the project interface
$project = $ea.GetProjectInterface()

# Do the repository replication
$project.ProjectTransfer("<SourceFilePath>", "<TargetFilePath>", "<TransferLog>")

# Close the session and exit
$ea.Exit()


11

Bugs and Issues / Re: error recording in enterprise architecture

« on: February 27, 2016, 11:54:36 am »

I'm not familiar with this area but do notice that you are using a 64bit jvm.  EA is a 32 bit application and most likely will only work if the 32bit jvm is used.

Stan.

12

Bugs and Issues / Re: MS SQL problems

« on: February 07, 2016, 05:42:35 am »

There are two parts to creating a repository when using a dbms like SQL Server.  First the script needs to be run to create the database schema.  It appears that your administrator has already done this.  Second the empty schema needs to be seeded with the base model (assuming you want to start with an empty model).  This can be done by using the model transfer functionality of EA to transfer the 'EA Base' empty model to the SQL repository.  The repository should now be ready to use.

The error message is indicating that the empty schema has not been seeded with a starter model.

From you message it appeared you might be trying to do the seeding but its failing.  Validate with your administrator that you have read/write capability on the EA schema.

Stan.

13

Suggestions and Requests / Re: Problem with HTML Report

« on: January 06, 2016, 09:03:58 am »

I think you probably need to upgrade you EA version.  I seem to remember a long time ago there was a bug in the html that caused this issue with IE (don't recall which version) but it has been fixed for a few years now.

14

Suggestions and Requests / Re: Add 'Show InformationFlow <<flow>> Lab

« on: December 01, 2015, 05:37:18 am »

Not addressing the semantics or usage for specific situation.  The linked thread had a discussion and script on how to toggle the <<flow>> off and on by diagram.

http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1398959952/9#9

15

Suggestions and Requests / Re: selecting multiple elements in project borwser

« on: September 06, 2011, 08:09:10 am »

I'm not sure if this is available in all version (it is with Corporate and above).  If you open up scripting an example script that ships with EA 'Recursive Element Count Example' will get the number of elements for the selected package.

Stan.