Jump to content

Search the Community

Showing results for tags 'database'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Plastic SCM
    • General
    • Installation and configuration
    • Unity 3D
    • Plastic SCM on Mac
    • Plastic SCM on Linux
    • Gluon
    • Git interop
    • Integrations
    • Community Edition
    • Branching and merging
    • Announcements
  • Plastic SCM 4.0 Beta (Closed)
  • Plastic Cloud
    • General
    • Configuration
  • SemanticMerge
    • General
    • License
    • SCM's configuration
    • Share your experience!
    • External Parsers
  • GitJungle
  • Method History for Subversion

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 15 results

  1. Hello. We are using Plastic SCM Cloud with Unity for 1,5 years now and database size is growing up by time, although our Repository size doesn't increase at all. This happens because the database (and cloud storage) keeps multiple versions of all assets. For example we have 50+ versions of our scene assets and they are really big. And we almost never need the older versions of scenes. We no longer need the histories of most assets from 1 year ago. We currently have 600 changesets but the changesets 1 to 400 aren't required anymore. As I know there was a trim command to delete old changesets from the database, but I couldn't find any info about this in the documentation. In example, to delete all changesets from 1 to 400 and database would look like it started in changeset 401, keeping all changesets to 600. And I guess we can backup and locally keep the original database from our disk. And if we ever need a file from those early changesets, we can access it with plastic using those backups. (From this directory: C:\Program Files\PlasticSCM5\server\jet) Am I correct with these? And if there is such an operation available, whats it called? Are there some best practices on what to do with such scene files that are changed often, but old versions aren't important? What should we do to avoid them growing the database size so fast? Thank you,
  2. Hi all, according to https://plasticscmsupport.zendesk.com/hc/en-us/articles/360010163773-How-to-move-a-repository-to-a-new-Plastic-SCM-server there is an easy way to move a repository from one server instance to another. If you look at step 2 (Move the "jet/rep_2" folder to the new server "jet" folder): Is it possible to rename it in the same step e.g. to rep_1234? Is the string "rep_2" somewhere within the DB which will lead to problems when including that repo with following command? cm addrep rep_1234 core NEWSERVER:8087 Background: I want to move a repository from my local machine to the central server. There is quite a good chance that "rep_2" already exists on that machine. So I need to alter the number. Best regards Jan
  3. If you ever face the following error: --------------------------- Error --------------------------- There has been an unexpected error "Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.". For more information check the server log. --------------------------- OK --------------------------- is because MySQL is not liking the default Plastic isolation level. You can change it by adding the following entry in your "db.conf" server config file: <IsolationLevel>RepeatableRead</IsolationLevel> "RepeteableRead" is OK, no issues are reported so far using it, this is the first one you will want to try if you face the error described above. If it doesn't work... contact us!
  4. I've installed Plastic v6.0.16.1395 on a Windows 10 VM running on Mac - Accepted the default settings (including to use Jet back-end) and installation all went fine. I've started up the Plastic client, gone to create first repo, and I get an error which - strangely - references the Firebird backend: "...server wasn't able to open a connection to the database ... Error: The type initializer for 'FirebirdSql.Data.Common.Charset" threw an exception." I had an old installer on another machine for v6.0.16.1307 which I've installed successfully on another Windows 10 machine - so I uninstalled 1395, then installed 1307, but with the same result. Any ideas? Thanks, Steve. Additional info: I'm guessing this issue may be related to running Windows in a VM - if I change the server name from the suggested "Ghost.local:8087" to "localhost:8087", the repo is created successfully. But I still cannot progress any further without hitting the same database error.
  5. Hi, I have recently hit an issue where all my repositories seem to have disappeared, although the workspaces are still listed. Attempting to navigate to any section in the plastic GUI client results in an error reading "There has been an unexpected error "No database selected"". If I run 'cm lrep' it likewise states that "There are no repositories in this server". The problem started when I was attempting to modify my MySQL configuration. I ended up having to remove and create a new service due to a weird state I managed to get it in. The MySQL service is running again correctly and I can view it correctly in the MySQL Workbench but when I tried to run Plastic again I started hitting these problems. I am hoping that I have just managed to muck up some configuration files or something and that the databases are still in fact intact. I have attached the server logs that I think will be useful. Any help in resolving this would be incredibly helpful - I am meant to be shipping a new release for my software this week and this has crippled me really. Thanks, Tom Clifton ChannelCall.log.txt plastic.server.log.txt audit.log.txt
  6. Whenever I attempt to pull the quakecode branch from the server (demo.plasticscm.com:8087) on Plastic SCM 5, the BranchExplorer shows emptiness after the pull. It says, "No data found. The server did not return any data for the specified filter." I've tried reinstalling completely several times to no avail, and I really have no clue what to do at this point. Any ideas/solutions? I can provide more details if needed.
  7. Hi, I have successfully installed Plastic SCM on a 64-bit Windows 2008 R2 server. Then, when I got the connection details from our Oracle DBA, I started the Plastic SCM Server administration tool and tried to do a Migrate database backend to Oracle. I entered the values for Server, Oracle SID and Admin User name/Password. I left the default Port and Admin connection mode details (1521 and sysdba resp.) untouched. Then I clicked on Test connection and immediately got a popup showing the following error message: License not found. Please view "Licensing" topic in dotConnect for Oracle documentation for details or contact Devart technical support. I found on the internet that dotConnect is a product from company Devart, but that is as far as our knowledge goes. We haven't installed this product on the server so we don't know where this message comes from. It also doesn't matter what kind of details are entered; we always get this message. Does anybody know where this message comes from and what we can do to solve this problem? Thanks.
  8. Trying to replicate a big repository but the main branch cannot be fully replicated. Plastic says this reason: There has been an unexpected error "The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 4091 ]". For more information check the server log. The strange thing is that I have migrated the backend of the destination server to MySQL so there should be no such limit of database size. (The source server uses PostgreSQL.) I checked the server log but it doesn't help me. Am I missing something?
  9. I was wondering if there was an option in the connection settings (DbConfig) to set the path to the database log file. Also, max growth setting for log file. I've set the DatabasePath setting which tells plastic where to place database data files and it also puts log files (ldf) in the same directory.. Would there be a problem with running a weekly job that checks for log files configured to the DatabasePath and moves them to a different directory? Our sql server is setup as follows: ..\mssql\data\*.mdf/*.plastic ..\mssql\log\*.ldf
  10. Hi, We are in process of evaluating different SCM tools in our company. And, PlasticSCM is one of them. Yesterday I had downloaded PlasticSCM and installed it on our Windows 2008 server. The setup details are as follows: server: Windows 2008 R2 x64 Service Pack 1 CPU: 8 Core 3.00 GHz Intel Xeon ® Memory: 6 GB RAM Database: Microsoft SQL Server User authentication: LDAP with Active Directory. The server installation was successful as there was no error reported. The "test connection" buttons on SQL server configuration and LDAP configuration dialogue boxes were successful also. The client configuration also yielded no error message. I assume it went fine also. Now, when I try to start Plastic SCM tool. It gives following error message: " -------------------------- Error --------------------------- Plastic SCM server DKAARTSWCM02:8087 wasn't able to open a connection to the database. Check the server log (plastic.server.log). Error: Cannot open database "repositories" requested by the login. The login failed. Login failed for user 'cqadmin'. Plastic client can't continue and will be closed. --------------------------- OK --------------------------- " Can someone please tell me what am I doing wrong? my db.conf file is as follows: ************** <?xml version="1.0"?> <DbConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ProviderName>sqlserver</ProviderName> <ConnectionString>Server=dkaarcqdb01;User Id=cqadmin;Pwd=|SoC|Cgp/F8fe/5Vjbanxd2ucsA==;DATABASE={0};</ConnectionString> <DatabasePath /> <DatabaseSuffix /> <DatabasePrefix /> </DbConfig> ************* So in nutshell, I have not been able to start PlasticSCM though it shows as running in the Windows services. I am attaching the plastic.server.log file with this post. I have renamed it to log.txt because I was not able to attach it with its original name. Any help will be highly appreciated. Regards Sandeep log.txt
  11. HI guys. I am ahving trouble moving my .sdf files to a enw location with mroe free space. I have ampped network drive, where I ahve moved these to, but forthe life of me, I cant get plastic to use them. My mapped drive where the files are is: Z:\Data\10 Plastic Data The repositories.plastic.sdf file is definately at (in) that location. I have changed my db.conf to the following: <DbConfig> <ProviderName>sqlserverce</ProviderName> <ConnectionString>DataSource={0};Persist Security Info=False;Max Database Size=4090;Max Buffer Size = 4096;Password=;</ConnectionString> <DatabasePath>z:\Data\10 Plastic Data</DatabasePath> <DatabaseSuffix></DatabaseSuffix> </DbConfig> Can anyone please point me in the right direction? Regards Louis
  12. Is there a way to create a database (or databases) with a sensible name on SQL Server (i.e. on a SQL Server with 100+ databases can I create one prefaced with my division's name?) and then make entries in a config file to tell Plastic which database to use for repository management and then also which databases correspond to which repositories? Maybe some sort of unsupported hackish behind-the-scenes sort of thing? In enterprise organizations the typical setup has separated concerns and responsibilities between application servers and database servers. in addition, databases and backups are usually centralized. Security is always a concern and tightly managed. What all this leads to is usually centrally managed SQL Server clusters where databases to support applications are created. All the maintenance plans, backups, etc, are then handled by the DBA group. And then any applications are installed on app servers (overseen by another group) and connections are made to the database. In this setup, it's not possible to make use of Plastic. Why? Because no respectable DBA is going to give a service/app account the ability to create databases and put that account's password in clear text in a config file on a server he/she doesn't control (i.e. the application server where Plastic is installed). And if I can't use the enterprise's SQL Server, then I lose the integrity and robustness of the enterprise's database platform. The latter isn't really an option (it would never pass an audit). Without the ability to configure Plastic to point to databases created by a DBA for its use, you're missing a market. Is this capability something you've considered adding to Plastic? Maybe as part of creating a new repository there could be a dialog that presents a bunch of defaults (the current ones used behind the scenes) but allows the user to change things such as the database name and whether or not it already exists.
  13. Hello, We've just installed the latest versions of both 3.0 and 4.0 to facilitate migrating our databases from 3 to 4 using fast-export/import. I've run into a couple of problems. Problem 1: After import into 4, new check-in operations start as changeset number 1 rather than n+1! For example, I have a small project with 19 changesets made in version 3. I did a fast-export and then a fast-import to 4 and everything looked great. I then added 2 files to the project which should have created changeset 20. Instead, the last changeset in the project is listed as changeset 1 and it inherited the same comment from the real changeset 1 (though the two have different GUIDs. In the branch explorer, I now have two home icons displayed, one on each of the changeset 1's (see image - 1a.jpg has 1st changeset 1 selected, 1b.jpg has last changeset selected). In the image you can see the properties for the last changeset which are really the first changeset properties. This does not give us confidence in the import and the integrity of the database, especially for much bigger projects. Problem 2: In some of my projects, I include a folder with web links for reference. Some of these have filenames with odd, but legal characters (for example, a long dash "–" rather than a short dash "-"). Unfortunately, when exporting from the .30 release of 3, some of these odd characters are replaced with "?" characters in the exported file. Import into 4 works fine, but when I attempt to update a workspace, Plastic complains it can't create the file (because of the illegal ? character the file name now contains). My solution was to record which databases had this problem and delete them. I then manually searched through those export files for file names with illegal characters and edited them to something reasonable. Finally, I reimported the files and then workspace updates worked ok. A minor, but annoying issue. Luckly, we don't have many databases with this issue. In any case, the first issue is really preventing us from migrating to 4.0 at this time. Any ideas on this? Thanks, Steve
  14. Using PlasticSCM community edition's admintool.exe (v4.00.0239.0019) to migrate from SQL CE to SQL Server 2008 (v10.0.2531) I encountered a few challenges and a bug with the database migration wizard. It is unclear if the tool will be creating database(s) or if one should create them on their own. Now I know, the tool creates them. This of course, alters the permissions necessary on the supplied user. The default connection string includes DATABASE={0}. Okay, what do I put there? Answer - nothing. Don't touch it. Nothing you type will be going there - except for the database suffix appended to the database name the tool will generate. I understand now that you are creating a .NET format string for this and you are presenting the whole thing to the user. Perhaps you should not present the portion that the user does not need to edit. [*]BUG: Since I didn't know it needed to create databases, I initially created a service account, PlasticSCM, and gave it simple Read and Write permissions, created my own database and gave the user permissions to it. I now know that was wrong. However after realizing it and changing to using a different user account, it still did not work. Spying using SQL Server Profiler showed that it was still using the original PlasticSCM account. I had to close and reopen the admintool.exe to get it to use a different user account. Thanks. Up and running on SQL Server 2008 now. The evaluation continues... and I'm liking what I see. Greg
  15. can someone please tell me what are the exact permissions needed for the plastic user on the mysql server ? (a GRANT statement would be nice). Is it possible to create the databases it needs and give it rights only on those databases? if so, what databases should I create for it? and what permissions should I give on them (Actually when limiting it to those databases I don't care giving it ALL permissions).
  • Create New...