DataDeploy not finding database tables

Anip

Hi all,

We're trying to configure DataDeploy 6 and have hit a number of problems.

In the Open Deploy Admin UI -> Configurations -> Schema Mapping, I enter all the relevant information on "Map DCT/DTD to Database Schema", click "Create Map" and enter my database details and when I click "connect" I get a javascript pop-up saying "No Tables Returned".

I know the DB connection details are correct because I've created a dns to test it from that same server plus the original website is using the the same database and same database user.

This frustrated us for so long we ended up trying to get DAS working as an alternative route but hit the following error as shown in the ddmodule.log:

=============

[Sun Sep 26 14:34:48 WST 2004] Begin executing basearea
Area VPath:/default/main/watercorp/STAGING
Setting up TDbSchemaSynchronizer.
>>> Loading drivers <<<
ERROR:ERROR: Loading drivers
ERROR:ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:183)
at java.lang.ClassLoader.loadClass(ClassLoader.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:250)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:310)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at com.interwoven.dd100.dd.JdbcCheckup.LoadThirdPartyJDBCDriver(JdbcCheckup.java:138)
at com.interwoven.dd100.dd.JdbcCheckup.LoadThirdPartyJDBCDriver(JdbcCheckup.java:122)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:551)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:548)
at com.interwoven.dd100.dd.TDbAgent.<init>(TDbAgent.java:271)
at com.interwoven.dd100.dd.TDbSchemaAgent.<init>(TDbSchemaAgent.java:63)
at com.interwoven.dd100.dd.TDbSchemaSynchronizer.<init>(TDbSchemaSynchronizer.java:48)
at com.interwoven.dd100.dd.TConsumerManager.CheckDbSchemaPresent(TConsumerManager.java:528)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:586)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:191)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:97)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:520)
at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:165)
at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:49)
at java.lang.Thread.run(Thread.java:479)
ERROR:Unable to connect to devdb03.db.pretzel.com.au:1433?database=WaterCorp_demo
ERROR:TDbAgent constructor failed.
Error occured in TDbSchemaSynchronizer
ERROR:TDbSchemaSynchronizer create failure.

=============

Ideally we would like to get DataDeploy to work but really we'll be happy with getting data from Teamsite into a database whichever way possible....

thanks
Anita

foxman

Oops...environment is TeamSite 6.1, OD/DD 6.0 and Windows 2000, SQL database