[Gusdev-gusdev] deleteEntries.pl error

[sucheta T. <su...@vb...>]

Hi,

I have been trying to use the deleteEntries.pl program to delete some of
the rows inserted into the DoTS::NRDBEntry table.

First it gave an insufficient privilege error, so when we looked at the
code at line 30, 31, we noticed, it calls the
$gusconfig->getReadOnlyDatabaseLogin(),
$gusconfig->getReadOnlyDatabasePassword()

which has only readonly privileges (From the .gus.properties file).

So I changed it to

$gusconfig->getDatabaseLogin(),
$gusconfig->getDatabasePassword(), at those 2 lines which has read, write,
delete privileges.

The options I have used are:

deleteEntries.pl --idSQL 'delete from DoTS::NRDBEntry where
nrdb_entry_id=1' --table DoTS::NRDBEntry

It is throwing the following errors:

Reading properties from /home/apps/gus/.gus.properties
The login is GUSrw
DBD::Oracle::st execute failed: ORA-00933: SQL command not properly ended
(DBD E
RROR: OCIStmtExecute) [for Statement "delete from DoTS::NRDBEntry where
nrdb_ent
ry_id=3" with ParamValues: :NRDBEntry=undef] at
/home/apps/gus/gushome/lib/perl/
GUS/ObjRelP/DbiDbHandle.pm line 82.
Execute FAILED: ORA-00933: SQL command not properly ended (DBD ERROR:
OCIStmtExe
cute)
 sql_cmd:
 delete from DoTS::NRDBEntry where nrdb_entry_id=3
DBD::Oracle::st fetchrow_array failed: ERROR no statement executing
(perhaps you
 need to call execute first) [for Statement "delete from DoTS::NRDBEntry
where n
rdb_entry_id=3" with ParamValues: :NRDBEntry=undef] at
/home/apps/gus/gushome/bi
n/deleteEntries.pl line 51.
deleting 0 ids from DoTS::NRDBEntry
-- 
Sucheta Tripathy
Virginia Bioinformatics Institute
1880 pratt drive,Bldg XV
Virginia tech.
Blacksburg
Virginia
VA 24061
phone-(540)231-8138