NullPointerException when Deploying to Oracle database

ChatBox

Any help is greatly appreciated....

Deployment Configuration
[html]



























[/html]


XML to be deployed
data.xml
[html]


Test Title
549374
Test Category
http://google.com


[/html]


error i am getting

[html]

ENG: 2011-06-22 12:12:24 EDT GMT-04:00 Proceed to execute the database deployment

DBD: Deployment : depdatabase
DBD: Database Vendor set to oracle
DBD: SQL datatype for column TITLE is VARCHAR2(255)
DBD: SQL datatype for column PRODUCT is NUMBER(20)
DBD: SQL datatype for column CATEGORY is VARCHAR2(50)
DBD: SQL datatype for column LINK is VARCHAR2(255)
DBD: # of columns: 4
DBD: WARNING:Assuming group name as the table name for [RECORDS].
DBD: # of groups defined in element: 1
DBD: [Wed Jun 22 12:12:24 EDT 2011] Begin executing depdatabase
DBD: Begin Set up the publisher thread
DBD: End Set up the publisher thread
DBD: Area VPath:/iwhome/iw-home/opendeploy/OpenDeployNG/conf/dd/ddnew
DBD: Setting up TDbSchemaAgent.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [testdb:1521:testdb]
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
DBD: ERROR:Exception4: java.lang.NullPointerException
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.Init(TDbSchemaGroupInfo.java(Compiled Code))
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.(TDbSchemaGroupInfo.java(Compiled Code))
at com.interwoven.dd100.dd.TDbSchemaAgent.Prepare(TDbSchemaAgent.java:176)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:132)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java(Compiled Code))
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)


DBD:
### IWDataDeploy FAILED ###

DBD:
### Sending result ###

ENG: 2011-06-22 12:12:24 EDT GMT-04:00 Database deployment execution returned 1

[/html]


Environment

Linux 2.6, Open Deploy Version 6.2, DB - Oracle 10g

Adam Stoller

... <database use="testdb" update-type="standalone" delete-tracker="yes" enforce-ri="no"> ...

Does the user/password associated with 'testdb' have the ability to create tables in the database? If not, you might be running into a problem with it trying to create / access the delete-tracker table.

You could also try setting delete-tracker to "no" and see if that works - since that seems to be where you're getting the exception. However, even if that works, you probably need to do some more investigating (perhaps with the help of Support) to figure out what you need to do to allow for the deltracker table.