IV01196: ORA-00987: MISSING OR INVALID USERNAME(S) WHEN EXECUTING CREATESCHED.SQL AGAINST AN ORACLE DATABASE

APAR status

• Closed as program error.

Error description

• ORA-00987: missing or invalid username(s) when executing
  createsched.sql against an Oracle database.
  

Local fix

• N/A
  

Problem summary

• When configuring an Oracle database for use with WSRR, the
  following error occurs during execution of the createsched.sql
  script:
  
  ORA-00987: Missing or invalid username(s)
  

Problem conclusion

• The GRANT SQL statement within createsched.sql contained
  incorrect syntax.
  
  The keyword 'USER' has been removed from the following
  statements:
  
  GRANT SELECT,INSERT,UPDATE,DELETE ON WSRRTASK TO USER
  __DBUSER__;
  
  GRANT SELECT,INSERT,UPDATE,DELETE ON WSRRTREG TO USER
  __DBUSER__;
  
  GRANT SELECT,INSERT,UPDATE,DELETE ON WSRRLMGR TO USER
  __DBUSER__;
  
  GRANT SELECT,INSERT,UPDATE,DELETE ON WSRRLMPR TO USER
  __DBUSER__;
  
  The updated script is targeted for inclusion in fix pack 4 for
  WSRR v6.3.
  
  Customers that have an existing database should run the given
  SQL statements after removing the USER keyword and
  substituting the appropriate database user name.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SERVICE REGISTR

• Fixed component ID

  5724N7200

Applicable component levels

• R630 PSY

     UP

• R700 PSY

     UP

• R750 PSY

     UP