TeamSite 7.1 Install hanging

Hello

We have a new install of TeamSite 7.1 with Windows Server 2008 32 bit using MSSQL Server 2008.

OpenDeploy Admin and Base 7.1 are installed.

The install is hanging when attempting to install "common services" when connecting to the SQL server using the JDBC 2.0 driver sqljdbc4.jar.

The driver is located in a folder by itself "C:\test\sqljdbc4.jar"

Nothing has been copied to iw-home

The only log file we've found with info is c:\tmp\installer.log

Here is a snippet from that file

.....
.....
.....

Enter or choose a directory where database drivers for Microsoft SQL Server are located, as well as other database fields for Interwoven Registry

The following database information is required by Common Services to create tables that store database details and some configuration information for other TeamSite components.

NOTE: It is recommended that you create a separate database schema for this component, instead of reusing the database schema of other components."
2010-03-02 14:19:38,912 INFO com.interwoven.wcm.install.framework.panels.CheckMetadata - Field1 DefaultValue="" Label="iwovRegistrydbconnection.panel.dbDriverDir.label" Name="irDbDir"
2010-03-02 14:19:38,913 INFO com.interwoven.wcm.install.framework.panels.CheckMetadata - Field2 DefaultValue="" Label="iwovRegistrydbconnection.panel.dbServerName.label" Name="irDbServerName"
2010-03-02 14:19:38,913 INFO com.interwoven.wcm.install.framework.panels.CheckMetadata - Field3 DefaultValue="1433" Label="iwovRegistrydbconnection.panel.dbPort.label" Name="irDbPort"
2010-03-02 14:19:38,913 INFO com.interwoven.wcm.install.framework.panels.CheckMetadata - Field4 DefaultValue="" Label="iwovRegistrydbconnection.panel.dbName.label" Name="irDbName"
2010-03-02 14:19:38,913 INFO com.interwoven.wcm.install.framework.panels.CheckMetadata - Field5 DefaultValue="" Label="iwovRegistrydbconnection.panel.dbUser.label" Name="irDbUser"
2010-03-02 14:19:38,913 INFO com.interwoven.wcm.install.framework.panels.CheckMetadata - Field6 DefaultValue="" Label="iwovRegistrydbconnection.panel.dbPwd.label" Name="irDbPwd" PasswordField="true"
2010-03-02 14:19:38,914 DEBUG com.interwoven.wcm.install.framework.panels.CheckMetadata - install: panel control executed for panel: iwovRegistryDBTypeConnection, type: InputPanelWith5FieldsAnd1FileChooser, jump label: InputPanelWith5FieldsAnd1FileChooser, jump: NOTNEXT
2010-03-02 14:22:49,788 INFO com.interwoven.wcm.install.framework.panels.Validate1FileChooserFiveTextFields - validating the input values.
2010-03-02 14:22:49,788 INFO com.interwoven.wcm.install.framework.panels.Validate1FileChooserFiveTextFields - vclassname is not empty. com.interwoven.wcm.ir.service.install.ValidateIRDBConnection
2010-03-02 14:22:49,794 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - irDbType:mssql
2010-03-02 14:22:49,794 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - irDbdbJarListVal :C:\test\sqljdbc4.jar
2010-03-02 14:22:49,794 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - irDbServerName:WIN-9F6QVPJNBRT
2010-03-02 14:22:49,794 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - irDbPort:1433
2010-03-02 14:22:49,794 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - irDbName:iwcommon
2010-03-02 14:22:49,794 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - irDbUser:iwdbuser
2010-03-02 14:22:49,797 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - irDbPwd: ****
2010-03-02 14:22:49,797 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - Making DBConnection:
2010-03-02 14:22:49,797 INFO com.interwoven.wcm.install.framework.util.DBConnection - Inside the Database Connection
2010-03-02 14:22:49,797 INFO com.interwoven.wcm.install.framework.util.DBConnection - building jar URLs from: [C:\test\sqljdbc4.jar]
2010-03-02 14:22:49,797 INFO com.interwoven.wcm.install.framework.util.DBConnection - DB Driver Class is: com.microsoft.sqlserver.jdbc.SQLServerDriver
2010-03-02 14:22:49,798 INFO com.interwoven.wcm.install.framework.util.DBConnection - file exists [true] :C:/test/sqljdbc4.jar
2010-03-02 14:22:49,798 INFO com.interwoven.wcm.install.framework.util.DBConnection - adding URL: jar:file:C:/test/sqljdbc4.jar!/
2010-03-02 14:22:49,798 INFO com.interwoven.wcm.install.framework.util.DBConnection - loading db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
2010-03-02 14:22:49,828 INFO com.interwoven.wcm.install.framework.util.DBConnection - registering driver: SQLServerDriver:2
2010-03-02 14:22:49,828 INFO com.interwoven.wcm.install.framework.util.DBConnection - dbType is:mssql DBDriverURL is: jdbc:sqlserver://WIN-9F6QVPJNBRT:1433;DatabaseName=iwcommon
2010-03-02 14:22:49,828 INFO com.interwoven.wcm.install.framework.util.DBConnection - attempting to connect: jdbc:sqlserver://WIN-9F6QVPJNBRT:1433;DatabaseName=iwcommon
2010-03-02 14:22:49,828 INFO com.interwoven.wcm.install.framework.util.DBConnection - dbType is:mssql DBDriverURL is: jdbc:sqlserver://WIN-9F6QVPJNBRT:1433;DatabaseName=iwcommon

Find more posts tagged with

Comments

nipper

Check your JDBC driver, could you have downloaded the 64 bit version by mistake ?

anew

Using a different driver (jtds-1.2.5) here is the error msg. Do you know the correct driver to use? The last driver used was sqljdbc4.jar. This driver seemed to be able to load the class com.microsoft.sqlserver.jdbc.SQLServerDriver.

2010-03-02 16:05:54,161 INFO com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - Making DBConnection:
2010-03-02 16:05:54,161 INFO com.interwoven.wcm.install.framework.util.DBConnection - Inside the Database Connection
2010-03-02 16:05:54,161 INFO com.interwoven.wcm.install.framework.util.DBConnection - building jar URLs from: [C:\test\jtds-1.2.5.jar]
2010-03-02 16:05:54,162 INFO com.interwoven.wcm.install.framework.util.DBConnection - DB Driver Class is: com.microsoft.sqlserver.jdbc.SQLServerDriver
2010-03-02 16:05:54,162 INFO com.interwoven.wcm.install.framework.util.DBConnection - file exists [true] :C:/test/jtds-1.2.5.jar
2010-03-02 16:05:54,162 INFO com.interwoven.wcm.install.framework.util.DBConnection - adding URL: jar:file:C:/test/jtds-1.2.5.jar!/
2010-03-02 16:05:54,163 INFO com.interwoven.wcm.install.framework.util.DBConnection - loading db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
2010-03-02 16:05:54,164 ERROR com.interwoven.wcm.ir.service.install.ValidateIRDBConnection - error is:com.interwoven.wcm.install.util.InstallException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
2010-03-02 16:05:54,164 ERROR com.interwoven.wcm.install.framework.panels.Validate1FileChooserFiveTextFields - validation failed: Database connection failed. : com.interwoven.wcm.install.util.InstallException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

anew

Another piece of the puzzle, TS is being installed on VMWare Workstation 7.0.1. As a test I tried creating an ODBC connection to the DB. That failed when the network adapter was configured for NAT and Bridged. When I set the network adapter to host only I was able to make the ODBC connection but still not able to use JDBC.

Any ideas?

columnAreaPageBreak.png

nipper

As I said before this is likely a JDBC issue, I do not know what to tell you except that you need to have that installed and working before you can install teamsite.

Verify your connection to the DB from the new server. Download again the DB drivers and make certain you get the 32 bit files. When the install screen asks for the drivers, add both jars (the installer will seperate them by a colon)

example.rptdesign

Migrateduser

Try using the JDBC 3.0 version, sqljdbc.jar instead of sqljdbc4.jar.

Also try putting your jar file in \eventsubsystem\lib.

nipper

.
Also try putting your jar file in \eventsubsystem\lib.

He won't be able to do that as the installer never creates iwhome.

Now the different JDBC driver might be the right thing

Crsb

The install is hanging when attempting to install "common services" when connecting to the SQL server using the JDBC 2.0 driver sqljdbc4.jar.

The driver is located in a folder by itself "C:\test\sqljdbc4.jar"

My experience with JDBC issues when installing TS 7.x is that the installer will immediately complain if it can't connect to DB for any reason (including invalid jdbc driver) or timeout then complain, so your issue might be something else.

Try using the JDBC 3.0 version, sqljdbc.jar instead of sqljdbc4.jar.

Also try putting your jar file in \eventsubsystem\lib.

I used sqljdbc.jar with MSQL 2008 and TS 7.0 and it worked fine.

anew

Make sure you use Windows 2008 Enterprise Server and not Standard. This solved the issue.

nipper

Make sure you use Windows 2008 Enterprise Server and not Standard. This solved the issue.

Really ? IWOV went from supporting 2003 ES only to 2003 Standard, now 2008 ES only ? It certainly could be a MSFT issue, that they do not include some some critical features for Standard.

Frederik

Make sure you use Windows 2008 Enterprise Server and not Standard. This solved the issue.

hmmm... that's disturbing because I asked Interwoven Support only last week whether they support the Standard Editions of windows (with TS 7.1), and they said yes.

(I opened a Case just because Release Notes only mention Enterprise Editions).

AmyAtPGN

Did you get an answer for your Case or has anyone gotten a definitive answer from Autonomy about what is supported for which piece?

We're working on our 7.1 evaluation install we are already running into compatibility issues. We were told Win 2008R2 Standard 64-bit would be supported with LiveSite (even though we know it's not for TeamSite itself) and it won't let us get through the install.

Frederik

here's a copy paste of the "summary" of my case, as written by Support:

*** | Mar 08, 2010 @ 09:20:05 PST | Status: Resolved ***

Problem:

is Windows *Standard* Edition supported for TS 7.1

Solution:

Yes both Standard and Enterprise editions of Windows OS for TeamSite.

however, we decided to install our test env on Solaris, so I can't comment further

Shivangi Malot

Hi

We are trying to install Teamsite 6.7.1 on Windows 2003 Standard Edition SP2 for our dev environment.

DO you think this would cause a issue?
Any suggestions?

Adam Stoller

Hi

We are trying to install Teamsite 6.7.1 on Windows 2003 Standard Edition SP2 for our dev environment.

DO you think this would cause a issue?
Any suggestions?

Why are you asking about 6.7.1 on a thread regarding 7.1?
If you have issues with 6.7.1 please start a new thread.

Shivangi Malot

So sorry Ghoti, my typo.

I am asking for Teamsite 7.1 itself. Please suggest

"We are trying to install Teamsite 7.1 on Windows 2003 Standard Edition SP2 for our dev environment.

DO you think this would cause a issue?
Any suggestions?"

mytest.rptdesign

Adam Stoller

So sorry Ghoti, my typo.

I am asking for Teamsite 7.1 itself. Please suggest

"We are trying to install Teamsite 7.1 on Windows 2003 Standard Edition SP2 for our dev environment.

DO you think this would cause a issue?
Any suggestions?"

Please start a separate thread for you question rather than tagging it onto an existing thread that is not directly related to your question.