• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2234
  • Last Modified:

New to Documentum, Install Issues

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
PunkGeek
Asked:
PunkGeek
  • 6
  • 4
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Try to install with SA user.
0
 
PunkGeekAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
PunkGeekAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
PunkGeekAuthor Commented:
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
 
PunkGeekAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
PunkGeekAuthor Commented:
Yeah, I am not getting that error anymore, just the version one.
0
 
PunkGeekAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now