null pointer exception

Hi,
when i'm running the datadeploy script through command line , the following error is coming up:
*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-01400: cannot insert NULL into ("INTERWOVEN"."PRESS_RELEA
SES"."SUBTITLE")

Vendor Error Code: 1400
SQL state: 23000
*******************************************************

*******STACK TRACE*************
java.sql.SQLException: ORA-01400: cannot insert NULL into ("INTERWOVEN"."PRESS_R
ELEASES"."SUBTITLE")

------------------------------------------------------
though the subtitle column is set to accept null values....in the database table

SUBTITLE VARCHAR2(1000) NULL = Y

even my deploy script(the dodeploy.cfg) has the column subtitle -allows null ="yes" .

any suggestions as to why that error is coming up , would be helpful..

thanx

Find more posts tagged with

Comments

Migrateduser

Were the tables created by DD or someother application?

Migrateduser

the table was created by an oracle application

thanx

Migrateduser

the allows-null attribute is only used for table creation. If the table was created outside of DD and the column was set to not allow null, DD will try to insert a null column and throw a NULL constraint violation. It does not consider the allows-null attribute during inserts/updates.

Migrateduser

Though the table was created outside DD , the column was set to accept null values.
i 'm not sure if i understood correctly what u're trying to say..could u be more specific?

thanx

Migrateduser

When the table was created by another application. The table was probably created with columns to not allow nulls. Hence DD fails to insert null values into those columns

Migrateduser

can somebody tell me the reason for the following error:

ORA-03120: two-task conversion routine: integer overflow

it says IWDATADEPLOY DONE....but there is no content in the database. immediate help is appreciated.

thanx

Migrateduser

What version of oracle are you using??