/home/pgm/server/data/DWRHM2008/gps/rinex/tmp/10010881.08O DBD::Oracle::db do failed: ORA-20106: Overlapping campaign monument profiles (by actual) are not allowed. ORA-06512: at "GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE", line 54 ORA-04088: error during execution of trigger 'GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE' (DBD ERROR: error possibly near <*> indicator at char 202 in 'insert into pgm.campaign_monument_profile (id,campaign_monument_id,start_date,end_date,scheduled_start_date,scheduled_end_date,status,local_time_zone_offset,rinex_obs_pathname,insert_date) values (pgm.<*>s_campaign_monument_profile_id.nextval,2389,to_date('20080328144927','YYYYMMDDHH24MISS'),to_date('20080329042029','YYYYMMDDHH24MISS'),to_date('20080328144927','YYYYMMDDHH24MISS'),to_date('20080329042029','YYYYMMDDHH24MISS'),'closed',7,'/home/pgm/server/data/DWRHM2008/gps/rinex/2008/088/10010881.08O',SYSDATE)') [for Statement "insert into pgm.campaign_monument_profile (id,campaign_monument_id,start_date,end_date,scheduled_start_date,scheduled_end_date,status,local_time_zone_offset,rinex_obs_pathname,insert_date) values (pgm.s_campaign_monument_profile_id.nextval,2389,to_date('20080328144927','YYYYMMDDHH24MISS'),to_date('20080329042029','YYYYMMDDHH24MISS'),to_date('20080328144927','YYYYMMDDHH24MISS'),to_date('20080329042029','YYYYMMDDHH24MISS'),'closed',7,'/home/pgm/server/data/DWRHM2008/gps/rinex/2008/088/10010881.08O',SYSDATE)"] at /usr/lib/perl5/site_perl/PGM/GeodeticOccupation.pm line 501. Geodetic Occupation "set in db" failed because (ORA-20106: Overlapping campaign monument profiles (by actual) are not allowed. ORA-06512: at "GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE", line 54 ORA-04088: error during execution of trigger 'GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE' (DBD ERROR: error possibly near <*> indicator at char 202 in 'insert into pgm.campaign_monument_profile (id,campaign_monument_id,start_date,end_date,scheduled_start_date,scheduled_end_date,status,local_time_zone_offset,rinex_obs_pathname,insert_date) values (pgm.<*>s_campaign_monument_profile_id.nextval,2389,to_date('20080328144927','YYYYMMDDHH24MISS'),to_date('20080329042029','YYYYMMDDHH24MISS'),to_date('20080328144927','YYYYMMDDHH24MISS'),to_date('20080329042029','YYYYMMDDHH24MISS'),'closed',7,'/home/pgm/server/data/DWRHM2008/gps/rinex/2008/088/10010881.08O',SYSDATE)')) at /usr/lib/perl5/site_perl/PGM/GeodeticOccupation.pm line 503 PGM::GeodeticOccupation::SetInDB('PGM::GeodeticOccupation=HASH(0x991db60)', 'DBI::db=HASH(0x97ff5a0)') called at /home/pgm/server/bin/pgmUtilRinexGeodeticOccupation.pl line 2008 MY::moveFiles('DateTime::Precise=ARRAY(0x97d5a3c)', 'ARRAY(0x972e714)', 'PGM::GeodeticOccupation=HASH(0x991db60)') called at /home/pgm/server/bin/pgmUtilRinexGeodeticOccupation.pl line 1129 error running ~pgm/server/bin/pgmUtilRinexGeodeticOccupation.pl --reciprocate -f /home/pgm/server/data/DWRHM2008/gps/rinex/tmp/10010881.08O -monument 1001 -campaign DWRHM2008 -type rinex -prh -ltzo 7 -ll 10, exiting /home/pgm/server/data/DWRHM2008/gps/rinex/tmp/AC660751.08O DBD::Oracle::db do failed: ORA-20106: Overlapping campaign monument profiles (by actual) are not allowed. ORA-06512: at "GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE", line 54 ORA-04088: error during execution of trigger 'GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE' (DBD ERROR: error possibly near <*> indicator at char 202 in 'insert into pgm.campaign_monument_profile (id,campaign_monument_id,start_date,end_date,scheduled_start_date,scheduled_end_date,status,local_time_zone_offset,rinex_obs_pathname,insert_date) values (pgm.<*>s_campaign_monument_profile_id.nextval,2387,to_date('20080315143512','YYYYMMDDHH24MISS'),to_date('20080315221038','YYYYMMDDHH24MISS'),to_date('20080315143512','YYYYMMDDHH24MISS'),to_date('20080315221038','YYYYMMDDHH24MISS'),'closed',7,'/home/pgm/server/data/DWRHM2008/gps/rinex/2008/075/AC660751.08O',SYSDATE)') [for Statement "insert into pgm.campaign_monument_profile (id,campaign_monument_id,start_date,end_date,scheduled_start_date,scheduled_end_date,status,local_time_zone_offset,rinex_obs_pathname,insert_date) values (pgm.s_campaign_monument_profile_id.nextval,2387,to_date('20080315143512','YYYYMMDDHH24MISS'),to_date('20080315221038','YYYYMMDDHH24MISS'),to_date('20080315143512','YYYYMMDDHH24MISS'),to_date('20080315221038','YYYYMMDDHH24MISS'),'closed',7,'/home/pgm/server/data/DWRHM2008/gps/rinex/2008/075/AC660751.08O',SYSDATE)"] at /usr/lib/perl5/site_perl/PGM/GeodeticOccupation.pm line 501. Geodetic Occupation "set in db" failed because (ORA-20106: Overlapping campaign monument profiles (by actual) are not allowed. ORA-06512: at "GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE", line 54 ORA-04088: error during execution of trigger 'GPSSITE.TIB_CAMPAIGN_MONUMENT_PROFILE' (DBD ERROR: error possibly near <*> indicator at char 202 in 'insert into pgm.campaign_monument_profile (id,campaign_monument_id,start_date,end_date,scheduled_start_date,scheduled_end_date,status,local_time_zone_offset,rinex_obs_pathname,insert_date) values (pgm.<*>s_campaign_monument_profile_id.nextval,2387,to_date('20080315143512','YYYYMMDDHH24MISS'),to_date('20080315221038','YYYYMMDDHH24MISS'),to_date('20080315143512','YYYYMMDDHH24MISS'),to_date('20080315221038','YYYYMMDDHH24MISS'),'closed',7,'/home/pgm/server/data/DWRHM2008/gps/rinex/2008/075/AC660751.08O',SYSDATE)')) at /usr/lib/perl5/site_perl/PGM/GeodeticOccupation.pm line 503 PGM::GeodeticOccupation::SetInDB('PGM::GeodeticOccupation=HASH(0xa14c288)', 'DBI::db=HASH(0xa02e5a0)') called at /home/pgm/server/bin/pgmUtilRinexGeodeticOccupation.pl line 2008 MY::moveFiles('DateTime::Precise=ARRAY(0xa004a3c)', 'ARRAY(0x9f5d714)', 'PGM::GeodeticOccupation=HASH(0xa14c288)') called at /home/pgm/server/bin/pgmUtilRinexGeodeticOccupation.pl line 1129 /home/pgm/server/data/DWRHM2008/gps/rinex/tmp/AC660781.08O (same) /home/pgm/server/data/DWRHM2008/gps/rinex/tmp/AC660791.08O /home/pgm/server/data/DWRHM2008/gps/rinex/tmp/AC660801.08O