Breadcrumbs
Page History
...
| id | 730125926 |
|---|
...
| id | 730125929 |
|---|
...
| id | 1330429518 |
|---|
On this page
...
| Table of Contents |
|---|
...
|
...
| id | 730125928 |
|---|
Magic Collaboration Studio is equipped with a Data Manager for administrative processes. You need to download the data manager .zip file and extract it to the machine where you installed Cassandra. Before using Data Manager, we recommend that you backup your database in the same manner as you do before using the migration tool. You can download the Data Manager tool from the same location you download the migration tools for the Cassandra database and UML meta-model.
...
|
Data Manager is a Teamwork Cloud Java utility for interfacing directly with the Cassandra database. The Data Manager package can be found in the Utilities directory of your server installation, and as a portable zip package in the 3DS installer distribution.
| Warning |
|---|
Data Manager is used to make permanent and irrecoverable modifications to the Cassandra database. A full database backup should always be performed before making any modifications to the database. Always use the Data Manager package included with your version of Teamwork Cloud distribution. |
Running Data Manager
To run Data Manager
- Stop
...
| Note |
|---|
If the command-line migration tool is running, it needs to be stopped as well. |
...
Make sure Cassandra is up and running.
| Note |
|---|
The ports through which Data Manager is connected to Cassandra is 9042. |
...
On the command line, change the directory to the DataManager folder.
...
- Teamwork Cloud services to prevent users from accessing the database.
- Ensure Cassandra is up and running: use the nodetool status command to verify the database status is Up and Normal.
Run a Data Manager command.
Info If Data Manager is executed for the first time on the system, you will be prompted to provide the path to Java. Use the same version of Java as Teamwork Cloud.
Execute with the -help option to ensure Data Manager is working:
Code Block language bash theme DJango linenumbers true ./datamanager -help
...
Run the desired command on Linux, for example, to show the user list:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
./datamanager -lu |
...
After finishing all Data Manager steps, start Teamwork Cloud services to resume user access.
Data Manager configuration
Data Manager has its own configuration files, located in the Data Manager installation path, under configuration.
Database access
For best performance, run Data Manager on the Cassandra server. By default, Data Manager will access the database via Localhost. If you need to run Data Manager remotely from the Cassandra server, modify the contact-points field for datastax-java-driverin application.conf.
Cassandra Authentication
Data Manager will connect to Cassandra on localhost using anonymous authentication. If your Cassandra node is configured to bind to a specific IP address (by default, port 9042 binds to all interfaces), or if you have configured Cassandra to use an authenticator other than AllowAllAuthenticator, you will need to modify
...
the auth-providerfields inapplication.conf accordingly.
...
The log file of Data Manager appears in the following directory:
Logs
Data Manager will append to a detailed log file on each execution. The datamanager.log file is stored in the logs directory of the Data Manager installation path. You can change the location of the log file and the level of logging in logback.xml.
...
Data Manager commands
The following table outlines the commands you can use in Data Manager to manage your data.
| Server tool command | Function | |||||||
|---|---|---|---|---|---|---|---|---|
-help | Displays Help information. | |||||||
-dk, --drop-keyspace <keyspace=value> --silent-drop | Drops the 19.0 keyspace to free up the storage space after the database migration from 19.0 to 2021x.
| |||||||
-dr,--delete-resource <resource ID> | Deletes the given resource(s) and all of its related information. Specify multiple resource IDs using space as a separator.
| |||||||
-drb,--delete-branch <resourceID=value branchID=<ID1>,<ID2> includeChildBranch=<true/false>> | Deletes the given branch(es) and all of its related information. Specify multiple branch ID using a comma as a separator. includeChildBranch has two values: true and false.
| |||||||
-drd,--delete-marked-deleted-resources | Deletes all resources that were marked as deleted.
| |||||||
-drr,--delete-revision <resourceID=value revision=<revision1,revision2> includeChildRevision=<true/false>> | Deletes the given revision(s) and all of its related information. Specify multiple revisions using a comma as a separator. includeChildRevision has two values: true and false.
| |||||||
-du,--delete-user <username> | Deletes the given username(s) and all of its related information. Specify multiple usernames using comma as a separator.
| |||||||
| -rrof, --remove-read-only-flag <-resourceID=<value1>,<value2> --categoryID=<value1>,<value2>> | Removes the read-only flag from a synchronized resource or category in the target server. Specify multiple resources or categories using a comma as a separator, for example:
| |||||||
-lb,--list-branch <resourceID=value> | Lists all branches of the given resource. | |||||||
-lc,--list-cluster-ids | Lists previous cluster IDs and the current one. | |||||||
-li,--list-index | Lists all available data that have indexes. | |||||||
-lr,--list-resources | Lists all available resources. | |||||||
-lrd,--list-marked-deleted-resources | Lists all resources that are marked as deleted. | |||||||
-lrv,--list-revision <resourceID=value branchID=value> | Lists all revisions in the given branch. | |||||||
-lu,--list-users <--no-info> | Lists all usernames and their information, sorted by name.
| |||||||
-ram,--reset-administrator | Resets admin password, status, and permissions.
| |||||||
-rc,--recreate-cluster-id | Recreates a cluster ID. | |||||||
-ri,--rebuild-index <data=value1,value2> | Rebuilds all indexes for the given data and uses the data=* option to rebuild all indexes of all available data. | |||||||
-urd,--unmark-deleted-resources <resource ID> | Unmarks the given resource(s) previously marked as deleted. Specify multiple resource ID using space as a separator. | |||||||
-vb,--validate-blob <savePath=value onlyInconsistent=value --readAllWithCQL --createCompareOfThriftAndCQL> | Validates blob information. | |||||||
-ve,--validate-eobject <resourceID=value1,value2 saveDir=value onlyInconsistent=value> | Validates the eObject information of a specific resource ID and uses the resourceID=* option to validate all resources. | |||||||
-version | Displays the version of Data Manager. | |||||||
-vi,--verify-index <data=value1,value2> | Verifies all indexes for the given data and uses the data=* option to verify all indexes of all available data. | |||||||
-vr,--validate-rbac <savePath=value onlyInconsistent=value> | Validates a user, user group, role, and role assignment information. | |||||||
-vrc,--validate-resource-commit <savePath=value onlyInconsistent=value> | Validates a metamodel, branch, and committed information. | |||||||
| -col,--cleanup-object-locks | Removes released object locks (that are no longer used) from the database.
| |||||||
-rcc,--rebuild-change-count <--resourceID=<resourceID1>,<resourceID2>> | Rebuilds the commit change count of all or the selected resources.
| |||||||
-crb,--clean-resource-blobs <--resourceID=<resourceID1>,<resourceID2>> | Cleans resource metadata and obsolete local cache blobs. If the optional resourceID argument is not set, all the listed resource blobs (for archiving resources) will be cleaned. | |||||||
-ll,--list-ldap | Lists all LDAP realm information. | |||||||
-rlu, --remap-ldap-users | Remaps LDAP user realms to another existing LDAP realm.
| |||||||
-vlu,--validate-ldap-users <saveDir=value onlyInconsistent=value> | Validates users which have an LDAP realm ID pointing to a non-existing LDAP configuration. | |||||||
-udb,--unmark-deleted-branches <resourceID=value branchID=<ID1>,<ID2>> | Unmarks the given branches that were previously marked as deleted. |
The delete command to delete resources and users works as follows.
Deleting selected resource
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
-dr,--delete-resource <resource ID> <resource ID> ... |
These commands delete a selected resource and all of the following resource-related information:
- Tags information of the resource.
- Category information (the resource will be removed from all categories).
- Branch information.
- Commit information.
- Role assignment information (role assignment information related to the resource will be removed).
- Locking information.
Deleting selected user
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
-du,--delete-user <username>,<username> ... |
This command deletes a selected user and all of the following user-related information:
- Role assignment information (all role assignment information belonging to the user will be removed).
- Session (the existing user session will be removed).
- Lock information (model elements in projects locked by the user will be unlocked).
- User group information (the user will be removed from all user groups).
| Note |
|---|
In the modeling tool's history panels, the word deleted will appear in brackets next to the deleted users. |
Deleting selected branch
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
-drb,--delete-branch <resourceID=value branchID=<ID1>,<ID2> includeChildBranch=<true/false>> |
The branch-related information which will be removed together with the branch includes:
- Tags information of each revision in the branch
- Object information created/modified at each revision in the branch
- Commit information of each revision in the branch
- Locking information of each object locked in the branch
- Branch information of the branch
- If the branch has child branches, depending on the includeChildBranch value, the branch will be deleted or not:
- When the includeChildBranch value is set to False andthe branch has child branches, then this branch will not be deleted.
- When the includeChildBranch value is set to True, then even if the branch has child branches it will be deleted.
Deleting revisions
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
-drr,--delete-revision <resourceID=value revision=<revision1,revision2> includeChildRevision=<true/false>> |
The revision-related information which will be removed together with the revision includes:
- Tags information of the revision
- Object information created/modified at the revision
- Commit information of the revision
- Locking information of objects whose id's do not exist anymore in the branch that the revision belongs to
- Branch information of the branch if the revision was the first revision of the branch
- If a selected revision is not the latest, depending on the includeChildRevision value, the revision will be deleted or not:
- When the includeChildRevision value is set to False, and the revision is not the latest, then it will not be deleted.
- When the includeChildRevision value is set to True, thenrevisions upward and branches within it from the selected version will be deleted.
...
| id | 730125925 |
|---|
Related pages
...