Ruud Duin Posted November 18, 2013 Report Share Posted November 18, 2013 Hi, I have successfully installed Plastic SCM 5.0.43.495 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. Link to comment Share on other sites More sharing options...
calbzam Posted November 18, 2013 Report Share Posted November 18, 2013 Hi, We are investigating an issue related to Oracle database and Plastic 5 .net4 installer. Is it your case? Could download the Plastic 5 .net 2 installer and check if the Oracle backend is working fine? Sorry for the inconveniences, Regards, Carlos Link to comment Share on other sites More sharing options...
Ruud Duin Posted November 19, 2013 Author Report Share Posted November 19, 2013 Hi Carlos, Thanks for your quick response. I'm not sure what you mean by ".net4 installer" and ".net2 installer". We have .NET Framework 4.5 installed, or are you referring to something else? Do I need to download something from the Plastic downloads page? Kind regards, Ruud. Link to comment Share on other sites More sharing options...
calbzam Posted November 19, 2013 Report Share Posted November 19, 2013 Hi, In our web page you will see you links for Windows. Please use the first one instead of the second one. We have detected an issue with the .Net 4 installer using the Oracle backend. DOWNLOADDOWNLOAD (.NET 4 including methodhist) Regards, Carlos Link to comment Share on other sites More sharing options...
Ruud Duin Posted December 16, 2013 Author Report Share Posted December 16, 2013 Hi Carlos, Thanks. It has been a while due to several circumstances. It seems we're getting there slowly, but we came across the following error when trying to create a repository: "Error trying to create the database rep_2: ORA-00955: name is already used by an existing object". We have tried several times but similar messages keep appearing. According to the DBA the user and tablespace "rep_2" are created at the same time we tried it. See also below extract from the oracle log. Please help us in getting to get this resolved since we don't know how to proceed. Thanks in advance. 2013-12-16 15:01:41,901 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 INFO Operations - Create repository MAGMA 2013-12-16 15:01:43,526 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 INFO Security - Creating new user or group S-1-5-21-839522115-606747145-725345543-37121 2013-12-16 15:01:45,667 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in DoExecuteDatabaseScript. ORA-00955: name is already used by an existing object ORA-06512: at line 1 at xc.u.d() at Devart.Data.Oracle.a7.c() at Devart.Data.Oracle.p.a(Int32 A_0, aw A_1) at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() at aee.a(CmConnection A_0, String A_1, Boolean A_2) 2013-12-16 15:01:45,667 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error trying to create the database rep_2: ORA-00955: name is already used by an existing object ORA-06512: at line 1 2013-12-16 15:01:45,682 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in CreateSingleRepository. The database rep_2 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object ORA-06512: at line 1 at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName) at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) 2013-12-16 15:01:45,682 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR Operations - Plastic server version: 5.0.44.505 2013-12-16 15:01:45,682 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR Operations - OnError catching exception The database rep_2 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object ORA-06512: at line 1 2013-12-16 15:01:45,745 NT AUTHORITY\SYSTEM at ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:The database rep_2 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object ORA-06512: at line 1 2013-12-16 15:01:45,745 NT AUTHORITY\SYSTEM at INFO ChannelCall - recb: 538|rect: 0|sentb: 1559|sendt: 0|prt: 3891|th: 15|dest: 0|mt: 3891|sert: 0|zip: 0| 10.12.57.160|CreateRepository 2013-12-16 15:02:16,494 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed 2013-12-16 15:02:16,494 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - conn 5 Tcp transport error. Connection closed 2013-12-16 15:06:07,221 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 INFO Operations - Create repository MAGMA 2013-12-16 15:06:11,783 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in DoExecuteDatabaseScript. ORA-00955: name is already used by an existing object ORA-06512: at line 1 at xc.u.d() at Devart.Data.Oracle.a7.c() at Devart.Data.Oracle.p.a(Int32 A_0, aw A_1) at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() at aee.a(CmConnection A_0, String A_1, Boolean A_2) 2013-12-16 15:06:11,799 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error trying to create the database rep_4: ORA-00955: name is already used by an existing object ORA-06512: at line 1 2013-12-16 15:06:11,799 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in CreateSingleRepository. The database rep_4 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object ORA-06512: at line 1 at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName) at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) Link to comment Share on other sites More sharing options...
calbzam Posted December 16, 2013 Report Share Posted December 16, 2013 Hi, You installed Plastic .net2 installer, right? When you are running the command "cm lrep", are you able to list the repositories? Could you post the output? The error is happening after creating a new repository using Plastic GUI? Could you add a database suffix to the "db.conf" file (server folder) and restart the Plastic server service?? <DbConfig> <ProviderName>oracle</ProviderName> <ConnectionString>Direct=true;User={0};Password={0};Data Source=localhost;Port=1521;SID=orcl</ConnectionString> <AdminConnectionString>Direct=true;User Id=sys;Password=mypwd;Data Source=localhost;SID=orcl;Connect Mode=sysdba</AdminConnectionString> <DatabaseCreationCommands> create smallfile tablespace @PlasticDatabase datafile '@PlasticDatabase.dbf' size 10M reuse autoextend on next 10M; create user @PlasticDatabase identified by @PlasticDatabase default tablespace @PlasticDatabase temporary tablespace Temp account unlock quota unlimited on @PlasticDatabase; grant connect, resource, create session, create table, create view, create any index to @PlasticDatabase; </DatabaseCreationCommands> <DatabaseSuffix>suffix</DatabaseSuffix> </DbConfig> Regards, Carlos Link to comment Share on other sites More sharing options...
Ruud Duin Posted December 17, 2013 Author Report Share Posted December 17, 2013 Hi Carlos, I think there is no need anymore to investigate it further. Based on your recommendation the dba changed the db.conf and now it seems to work fine! Thanks for your help. Ruud. Link to comment Share on other sites More sharing options...
calbzam Posted December 17, 2013 Report Share Posted December 17, 2013 Great! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.