From: Terry C. <tw...@cs...> - 2003-07-07 19:01:56
|
This attribute was defined as DESCRIPTION VARCHAR2(255) causing a problem for the comment/description for GUS::Common::Plugin::LoadPfam Rather than shortening the comment and modifying the source, I opted to change the TABLE as shown below to DESCRIPTION VARCHAR2(1024) Terry SQL ERROR!! involving INSERT INTO Core.AlgorithmParamKey ( group_read, algorithm_param_key_id, user_read, algorithm_implementation_id, modification_date, other_write, algorithm_param_key_type_id, row_group_id, algorithm_param_key, user_write, other_read, group_write, row_user_id, description, row_alg_invocation_id, is_list_valued, row_project_id ) VALUES ( ?, ?, ?, ?, SYSDATE, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) Values: 1, 280, 1, 22, 0, 0, 1, flat_file, 1, 1, 1, 1, Flat file containing the release of Pfam to load. Expects the file containing the annotation and full alignments in Pfam format of all Pfam-A families (called "Pfam-A.full" in release 5.2) The specified file may be in gzip (.gz) or compressed (.Z) format. SQL> alter table Core.AlgorithmParamKey modify 2 DESCRIPTION VARCHAR2(1024) 3 ); ) OKAY NOW, gus> ga +create GUS::Common::Plugin::LoadPfam --commit Reading properties from /home/gus/run/config/GUS-PluginMgr.prop Reading properties from /home/gus/.gus.properties Mon Jul 7 13:40:35 2003 INFO Plugin GUS::Common::Plugin::LoadPfam registered with cvs revision '1.10' and cvs tag ' ' . |