Solved

New to Documentum, Install Issues

Posted on 2008-06-17
12
2,167 Views
Last Modified: 2013-12-13
I am currently trying to setup Documentum 6 as a test environment for our developers and running into issues when trying to connect it to our test SQL server.  When I get the Content server loaded and run the configuration everything works until it gets to the section to connect to the database.  If I have the software try to create the Database in SQL then I get this error (copy/pasted out of the log):

Database version not supported. Detailed error:
Database successfully opened.
DB Version test fails, the RDBMS version is: 08.00.0194

If I create a database and then try to connect to it, I get:

User unable to create tables, view or index. Detailed error:
Database successfully opened.
Test table successfully created.
Could not create view dmdbtest_view.
  Error from database system is:  -- The database object is invalid --  STATE=S0002, CODE=208, MSG=[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.dmdbtest'.


I am not really sure what to do from here.  I have tried using SQL2000, SQL2000SP4, SQL2005 to see if the issue was a version issue with SQL.  Also, I have tried loading it locally so the database is on the same box and tried setting up instances on our test sql server and get the same errors.

Other info that I can think of that may be useful to know:

Machine is running Windows 2003 Server SP2
Loading Documentum 6.1
Account being used for the config and service is a domain admin


Any help is appreciated and if you need any info please let me know!
0
Comment
Question by:PunkGeek
  • 6
  • 4
12 Comments
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 21820467
Try to install with SA user.
0
 

Author Comment

by:PunkGeek
ID: 21822339
I just tried using the SA user to see if possibly there were some permission issues.  Now I get the same error for both methods I described above.

The error is:

Database version not supported. Detailed error:
Database successfully opened.
DB Version test fails, the RDBMS version is: 08.00.0194

Is there a specific version of SQL Server required for Documentum 6?
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 21823269
SQL Server 2000 only works well on Win2003, with SP4. So before you install Document you need to install SP4 for SQL Server 2000.
0
 

Author Comment

by:PunkGeek
ID: 21823597
Thanks for the reply, I am still having the same issue.  I know I had forgot to add SP4 this last attempt and just fixed that, but it is giving the same error with just the last 4 numbers on the version being slightly different.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 21844422
Sorry I couldn't help but here in our office we work with Documentum 5.3 and we don't have any problem with SQL Server.
(Un)fortunally we didn't migrate yet to Documentum 6.1

Wish you good luck
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:PunkGeek
ID: 21845892
We are currently using 5.3 with no issues as well, but 6.1 is new territory and just proving to be a pain in the butt.
0
 

Author Comment

by:PunkGeek
ID: 21856262
Just something else to add that I tried.  I tried to add a database that we were using in 5.3 and got the same error stating that the version is not compatible.
0
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 21856579
PunkGeek, the error that you have is about not finding a view in DB (dmdbtest_view).
It can't create it either. But you tried with SA user, so I suppose isn't permission issues:

"Could not create view dmdbtest_view.
  Error from database system is:  -- The database object is invalid --  STATE=S0002, CODE=208, MSG=[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.dmdbtest'."
0
 

Author Comment

by:PunkGeek
ID: 21856780
Yeah, I am not getting that error anymore, just the version one.
0
 

Accepted Solution

by:
PunkGeek earned 0 total points
ID: 21859424
Ok I found out the issue.  Somewhere in a completely unrelated document to the install documents there is something that states for SQL it needs to be 2005 SP2.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now