Re: [Gusdev-gusdev] LoadNRDB: table not found

[Chetna W. <wa...@ya...>]

Hello,

I tried with --maketemp and I am getting:

DBD::Oracle::st execute failed: ORA-01400: cannot
insert NULL into
("CHETNA"."NRDBTEMP"."EXTERNAL_DB_REL_ID") (DBD ERROR:
OCIStmtExecute) at
/var/local/gus_home/lib/perl/GUS/Common/Plugin/LoadNRDB.pm
line 270, <NRDB> line 156693.

Let me know what is null?

Thanks
Chetna

--- "Deborah F. Pinney" <pi...@pc...> wrote:
> Hi Chetna,
> 
> The plugin was written so that it could be run in
> three parts: 1) making
> the temp table, 2) inserting into the NRDBEntry and
> ExternalAASequences
> tables, 3) deleting obsolete rows in those tables. I
> looked back at your 
> previous e-mail and it looks as if you have not
> included the option to 
> create and fill the temp table, --maketemp. The
> plugin should create the 
> table if that is included on the command line. You
> can see the table 
> schema by looking into the code, sub makeTempTable.
> I'm hoping to rewrite 
> this plugin as it is complicated and could be put in
> a better form.  
> 
> 
>                                                    
> Debbie
> 


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/