Documentum Dev Edition - install with an existing SQL Server

dm.co.th

I am trying to install Documentum Dev Edition against an existing SQL Server 2008 Std edition.

(I have already installed with the provided Express edition)

I am logged in as a member of the machine administrator group

In the SQL Server 2008, I precreated an empty database (named Documentum) with a dedicated user being the db_owner of Documentum

I created a system DSN with this user.

The setup starts, I enter all information (about the DSN and the username/password), then it blocks. I waited a few hours, without any difference.

There is nothing in the log with the default log level.

The process explorer indicates that it is running SQLCMD.EXE

There is nothing that I can see being created in the database at the other end.

I changed the debug level in log4j in the "documentumSetup.jar" and I have the following error message

DEBUG [Runnable bean context: Di WA Oem Validate Input Data (validateInputData)] com.documentum.install.shared.common.error.DiException - Failed to load xml for macro substitution:dctmOemInstall.xml
com.documentum.install.shared.common.services.xml.DiXMLDataStore.findFile(DiXMLDataStore.java:62)
com.documentum.install.shared.common.services.xml.DiXMLDataStore.getRootNode(DiXMLDataStore.java:45)
com.documentum.install.shared.common.services.xml.DiXMLDataStore.retrieve(DiXMLDataStore.java:27)
com.documentum.install.shared.common.services.xml.DiCommonXMLStringResolver.invoke(DiCommonXMLStringResolver.java:39)
com.installshield.util.StringResolver.invokeMethod(Unknown Source)
com.installshield.util.FunctionToken.getValue(Unknown Source)
com.installshield.util.AbstractStringResolver.mergeTokens(Unknown Source)
com.installshield.util.AbstractStringResolver.resolveInternal(Unknown Source)
com.installshield.util.StringResolver.resolve(Unknown Source)
com.installshield.wizard.service.AbstractWizardServices.resolveString(Unknown Source)
com.documentum.install.shared.common.services.datavalidation.DiDataValidation.getValueFromSources(DiDataValidation.java:388)
com.documentum.install.shared.common.services.datavalidation.DiDataValidation.validateAndSave(DiDataValidation.java:191)
com.documentum.install.shared.common.services.datavalidation.DiDataValidation.validateAndSave(DiDataValidation.java:77)
com.documentum.install.oem.common.beans.wizard.action.DiWAOemValidateInputData.execute(DiWAOemValidateInputData.java:82)
com.installshield.wizard.RunnableWizardBeanContext.run(Unknown Source)

Any idea ?

Did anyone manage to install the Dev Edition against an existing SQL Server ?

Find more posts tagged with

Comments

dm.co.th

Ok, so I was on the wrong track.

The main problem was that documentumSetup could not connect to the database with SQLCMD.

it was trying to run

SQLCMD -r 1 -w 800 -h-1 -d master /D Documentum /U sa /P sa

but when I manually run the same command in a dos prompt, I have the following message

Sqlcmd: Warning: '-D' is an obsolete option and is ignored.

then after a few seconds:

HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

the only way I can connect is by giving the server name with the -S option

SQLCMD -r 1 -w 800 -h-1 -d master -S SQLSERVER2K8 /U sa /P sa

Any idea which SQLCMD I should use so it can work?

The version I have is the one from Microsoft SQL Server 2008 Feature Pack

C:\Program Files\Microsoft SQL Server\100\Tools\Binn>SQLCMD.EXE /?
Microsoft (R) SQL Server Command Line Tool
Version 10.0.1600.22 NT INTEL X86

As a temporary workaround, I wrote a small wrapper around SQLCMD to change the options on the fly (in addition to -S, I add quotes around /Q query), so the first two checks (ProductVersion and Collation) pass.

Now the query the setup is trying to run is:

sp_helpuser 'documentum'

which returns

The name supplied (documentum) is not a user, role, or aliased login.

and the setup fails with

'database user documentum already exists, please chose a different user name'.

If I create manually in SQL Server 2008 the user documentum, the query returns something, but the setup gives the same message.

So it is not clear to me how to move forward: what username should I pre-create, what username should I give to the setup ?

Did anyone manage to install the Dev Edition against an existing SQL Server 2008 Standard Edition? Is it possible or I am wasting my time ?

clonak

Hello dm.co.th,

Thank you for your fantastic, detailed post.

I will see if I can find out if anyone knows how to manage installing the Documentum Developer Edition against an existing SQL server (2008)

That is a very specific question that I hope can be answered via the community. We don't want you to feel like you are wasting your time. Especially since you are utilizing the Documentum Community as a dedicated tool for assistance.

Thank you dm.co.th (what does that stand for by the way?? I'm curious.) ... we expect to reply back soon. In the meantime, if you stumble upon your own solution - please do post it for us~!

Best regards,
Kelly

dm.co.th

Hello Kelly,

thank you for the encouraging answer.

So far, I am still stuck, so I hope someone will be able to help.

To answer your curiosity, dm.co.th is because I am in Thailand, and the equivalent of .com in Thailand is .co.th

I guess I should introduce myself on the Ice Breaker thread:)

dm.co.th

I finally managed to install (there was a bug in my wrapper that prevented the last check to work).

So to recap,

0) To pass the checks, I add to install a wrapper to SQLCMD I had installed to have it understand the syntax used by Documentum. The installed SQLCMD does not use the System DSN, but is provided with the login/password. I used sa

1) The system DSN is used during install. The DSN uses sa

2) No user or database need to be pre-created in SQL Server. The setup will do it.

3) The setup estimates the install time to be close to 90mn and indeed it does take a long time. It stays stuck for a very long moment on 48%. There is no activity in the log, but if you look at your processes, some java program is running, so you know it's not stuck!

4) the SQLCMD is still used during install, so my wrapper was once again useful

I still don't understand why the default SQLCMD is not working, but since I managed to finally install, I don't have time to reinstall the whole OS to check if it was a bad install on my side.

I am still interested to know if anyone else manage to install the Dev Edition against an existing instance of SQL Server 2008 standard.

clonak

Hi there dm.co.th:

Thank you so much for sharing how you worked out your issue on the Documentum Community. The community may not respond with a thank you - but perhaps you have helped several people with your detailed explanation and resolution.

Thailand. Wow. Thanks for the user name explanation.

What is life like in Thailand? Can you tell us what a few days of weather and everyday life is like there?

Let's try asking the community again:

Has anyone managed to install the Dev Edition against an existing instance of SQL Server 2008 standard??

Best regards,
Kelly

jenksb

Is your SQL server remote or on the same system? There is a defect that was causing the CenterStage single-click install to fail when the SQL server was remote and the error you post is pretty close to what was reported. While it looks like the pre-GA release of CenterStage's Single-Click installer has a fix for the issue I don't see that it's been rolled into the standard Content Server Single-click install. But I'm checking.

dm.co.th

Hi Brian,

>Is your SQL server remote or on the same system?

the SQL Server is on a different machine, on the same network though (that rules out firewall problem).

thanks for checking!

GlennEggleton

Hi,

I would like to point out that this problem affects SQL Server 2005 as well.

Kothari

I am also getting similar error for xCP Developer Edition 1.0 installation.

(Dec 26, 2010 6:12:43 PM), Setup.product.install, com.documentum.install.shared.common.error.DiException, err, An exception occured in: DiWAOemExecuteConfigurationScripts, beanID: executeConfigurationScripts - DiWAOemExecuteConfigurationScripts failed! - 'Creating BAM Database Schema' failed.; Runtime execution failed with child process "C:\Documentum/bam/sql-loader/bin/create-db-schema.cmd " exit code of 1; For more detailed information, see the error log: \DCTM\xCP\Documentum_xCP_1.0_windows\setupError.log
(Dec 26, 2010 6:12:43 PM), Setup.product.install, com.documentum.install.shared.common.error.DiException, err, com.documentum.install.shared.common.error.DiException: Runtime execution failed with child process "C:\Documentum/bam/sql-loader/bin/create-db-schema.cmd " exit code of 1
at com.documentum.install.shared.common.services.DiUtilExecuteCommand.executeCommand(DiUtilExecuteCommand.java:110)
at com.documentum.install.shared.common.services.DiUtilExecuteCommand.executeCommand(DiUtilExecuteCommand.java:50)
at com.documentum.install.shared.common.services.DiUtilExecuteCommand.executeCommand(DiUtilExecuteCommand.java:44)
at com.documentum.install.oem.common.services.DiActionExecuteCommands.install(DiActionExecuteCommands.java:90)
at com.documentum.install.shared.common.services.actions.DiActions.install(DiActions.java:152)
at com.documentum.install.oem.common.beans.wizard.action.DiWAOemExecuteConfigurationScripts.execute(DiWAOemExecuteConfigurationScripts.java:59)

TomACN

Hello, I am running into this exact same issue as the original post. I noticed that the post is still marked "Not Answered". Does anyone know the proper workaround to this issue? I am trying to install Documentum Developer 6.6 on Windows Server 2008. Thanks.

jsilver

I've moved this discussion to the Documentum Developer Community, where it's more likely to get an answer.

SCharjan

I too am stucked in same problem, I will appreciate your help since you have already solved the problem can i ask a small favour, will you provice me the wrapper for SQLCMD you created. Thanks in Advance