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 number
IV01196
Reported component name
SERVICE REGISTR
Reported component ID
5724N7200
Reported release
630
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-01
Closed date
2011-06-01
Last modified date
2011-06-07
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWLGF","label":"WebSphere Service Registry and Repository"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
07 June 2011