[sqr-users] #sqr-status issues

["Peter Daalder" <pdaalder@2coolboarders.com>]

Hi

We have an sqr that is already running since ages. Now we did an PS88
upgrade project and this sqr moved to its new environment.

The old env:
- HP 
- Oracle 8i
- SQR V6.1.4

The new env:
- HP Itanium
- Oracle 9i
- SQR for PeopleSoft V8.45.09

When I run my sqr program ni the old env, a unique constraint error returns
a -1. (with both old or new database)
The procedure called:
*********************************************
Begin-Procedure SQL-Load-Error
        show ' '
        show 'Error Loading table ' $ps_table_name  ' from ' $tname '. Table
is now EMPTY.'
        show ' '
        Display 'SQL error:  '         noline
        Display $sql-error
        Display 'Error number:  '      noline
        Display #sql-status 9999999
        Display ' '
  if #sql-status = -1
        show 'with key ' $keydump
  else
                let $error_found = 'Y'
                let #return-status = 2
  end-if 
End-Procedure
*********************************************

The error in the output
*********************************************
with key deptid = 38135 and cs_hierarchy_type = MANAGEMENT
 
Error Loading table PS_CS_SI_DEP_TR_IN from SIADM.SI_HIERARCHY_PUBLISHED@si.
Table is now EMPTY.
 
SQL error:  ORA-00001: unique constraint (SYSADM.PS_CS_SI_DEP_TR_IN)
violated
Error number:       -1
*********************************************

When I now run this same sqr in the new environment, this same statement
does this
*********************************************
Error Loading table PS_CS_SI_DEP_TR_IN from SIADM.SI_HIERARCHY_PUBLISHED@si.
Table is now EMPTY.
 
SQL error:  ORA-00001: unique constraint (SYSADM.PS_CS_SI_DEP_TR_IN)
violated
Error number:        1
*********************************************

As you can see, the return-status will be set to 2, and that is not what I
want. Any suggestions. Did Peoplesoft adjust the sqr executable?

Peter


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users