Data Deploy problems

I'm trying to do a simple standalone DataDeploy, extracting 4 columns from a DCR file and inserting 1 row into the database. I have attached a zip file with all the necessary pieces:

011708_example.dcr (data capture file)
dbschema.cfg (database schema file)
index_type_1.xml (data deploy configuration)
src.index_type_1.TestDeploy.dtepper-470.to.database.log (Error Log)
src.index_type_1.log (another log file)

I am running this test from the OpenDeploy web ui, passing iwdd=TestDeploy

Here is the error:

DBD: Database Vendor set to microsoft-inetuna
DBD: Setting up TDbSchemaAgent.
DBD: ERROR Smiley Very Happy

eployment to a Microsoft SQLServer database using user-defined dbschema is not supported with JDBC-ODBC bridge. You should use Inet-UNA JDBC driver.Refer to DataDeploy Administration manual.

Needless to say, there is no further information in that PDF about this driver that seems to apply to our problem.

Dan Tepper
TV Guide Online

PS: databases, Logins and PATHs a re all correct - db server is MS SQL 2000 - all the latest patches

Find more posts tagged with

Comments

Adam Stoller

It might help if you indicated what version of OD/DD you were using.
In the 6.1.0 Release Notes I see the following:

...
<!-- Microsoft SQL Server  --> 
    <!-- Uses Inet-UNA JDBC Driver Version 3.05, see http://www.inetsoftware.de--> 
    <database name="microsoft_sqlserver_db_using_inetuna" 
              db="hostnameort?database=my_db_name" 
              user="my_db_username" 
              password="my_db_passwd" 
              vendor = "microsoft-inetuna"> 
    </database> 
 <!-- Microsoft SQL Server  --> 
 <!-- Uses Microsoft JDBC Driver See http://msdn.microsoft.com/ downloads for more details --> 
    <database name = "ms_sqlserver_db_using_ms" 
    db = "hostnameort;databasename=dbname" 
              user="username" 
              passwod="passwd" 
              vendor="microsoft-microsoft" 
              state-field = "state"> 
    </database>
...

tvguide_dev

Open Deploy Version: 6.2.0.0.0 Build 68916 Interwoven 20071109

modifying the database tag syntax to match the Inet-UNA seems to have gotten us further, however we now have a new and bigger problem. The deploy now fails with a null pointer exception. When it does this it locks trhe database and we need to kill the session manually.

here is the relevant part of the log...
Connected to jdbc:inetdae:NYC1SQL2:1433?database=DataDeploy&sql7=true
DBD: Driver i-net UNA 2000
DBD: Version 4.18
DBD: Connected to [NYC1SQL2:1433?database=DataDeploy]
DBD: CREATE TABLE IWDELTRACKER ( PATH VARCHAR(255) NOT NULL , AREA VARCHAR(255) NOT NULL , KEYCOLNAME VARCHAR(255) NOT NULL , KEYCOLVALUE VARCHAR(255) NOT NULL )
DBD: CREATE INDEX iwdelt_idx ON IWDELTRACKER( PATH , AREA )
DBD: IWDELTRACKER created successfully.
DBD: ERROR:Exception4: java.lang.NullPointerException
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.GetParentGroupNames(TDbSchemaUtils.java:297)

Migrateduser

Open Deploy Version: 6.2.0.0.0 Build 68916 Interwoven 20071109

modifying the database tag syntax to match the Inet-UNA seems to have gotten us further, however we now have a new and bigger problem. The deploy now fails with a null pointer exception. When it does this it locks trhe database and we need to kill the session manually.

here is the relevant part of the log...
Connected to jdbc:inetdae:NYC1SQL2:1433?database=DataDeploy&sql7=true
DBD: Driver i-net UNA 2000
DBD: Version 4.18
DBD: Connected to [NYC1SQL2:1433?database=DataDeploy]
DBD: CREATE TABLE IWDELTRACKER ( PATH VARCHAR(255) NOT NULL , AREA VARCHAR(255) NOT NULL , KEYCOLNAME VARCHAR(255) NOT NULL , KEYCOLVALUE VARCHAR(255) NOT NULL )
DBD: CREATE INDEX iwdelt_idx ON IWDELTRACKER( PATH , AREA )
DBD: IWDELTRACKER created successfully.
DBD: ERROR:Exception4: java.lang.NullPointerException
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.GetParentGroupNames(TDbSchemaUtils.java:297)

looking at your files, I think your DD xml is wrong, now that you seem to be connecting.. you can try this:

[html]

[/html]

tvguide_dev

Thanks for the reply - did NOT work same error.

java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.GetParentGroupNames(TDbSchemaUtils.java:297)

Seems to me some exception handling code in Open Deploy itself would be in order here, since the error message tells me nothing about the problem

Migrateduser

Thanks for the reply - did NOT work same error.

java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.GetParentGroupNames(TDbSchemaUtils.java:297)

Seems to me some exception handling code in Open Deploy itself would be in order here, since the error message tells me nothing about the problem

ok.. I believe my config above is correct.. but seems your getting an error before you get to it.. and more DD Logging would always be nice.. but they never really had it..

does the "IndexType1" table exist in the DB yet? if yes, try dropping it or changing the config to use IndexType2 or something.. if no, what happens if you manually create it, then rerun?

tvguide_dev

Well the problem is solved. It turns out my simple test database table did not have a primary key. Apparently the destination table needs one (makes sense - most tables do).

However I stand by my statement that this is extremely sloppy coding on Interwoven's part.

Obviously they are querying the database for the primary key column and not checking the return value. The return value (since there is no primary key) is probably null - hence the exception.

Had DataDeploy properly caught the exception and generated a useful error message in the logs, like "ERROR: Destination table requires Primary Key", I would have been spared several days worth of headaches.

AARGH!