on 02-28-2008 5:57 AM
Dear friends,
We have taken the system copy of existing WS quality to new quality and existing development to new development. In new quality and development.I have scheduled the job name "Check and update optimizer statistics" through "DB13". It has terminated with errors.
Both the system has same problem. Our artical master data is getting uploaded. but it is taking lots of time to upload. Last time when we scheduled this update stats job then it was uploading fast in old quality system.
***************************************************************************
Job log details are as follows:
***************************************************************************
Job started
Step 001 started (program RSDBAJOB, variant &0000000000004, user ID BASIS)
Execute logical command BRCONNECT On host WSECCQA
Parameters: -u / -jid STATS20080227200917 -c -f stats -t ALL
BR0801I BRCONNECT 7.00 (24)
BR0805I Start of BRCONNECT processing: cdxiznhe.sta 2008-02-27 20.09.18
BR0484I BRCONNECT log file: F:\oracle\WIQ\sapcheck\cdxiznhe.sta
BR0280I BRCONNECT time stamp: 2008-02-27 20.09.18
BR0301E SQL error -942 at location db_connect-4, SQL statement:
'SELECT NAME FROM V$DATABASE WHERE ROWNUM = 1'
ORA-00942: table or view does not exist
BR0310E Connect to database instance WIQ failed
BR0280I BRCONNECT time stamp: 2008-02-27 20.09.18
BR0301W SQL error -942 at location brc_dblog_open-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20080227200918', 'sta', 'WIQ', 'ALL', '9999', '
ORA-00942: table or view does not exist
BR0324W Insertion of database log header failed
BR0806I End of BRCONNECT processing: cdxiznhe.sta2008-02-27 20.09.18
BR0280I BRCONNECT time stamp: 2008-02-27 20.09.18
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished
Dear friends,
Problem has been resolved.
Now it is working fine.
I applied note number 134592.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please post the dev_w0 entries here, we need to check, whether it a problem related to user ops$.
With regards
Sudha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Execute logical command BRCONNECT On host WSECCQA
WSECCQA is refer to your old quality host or new quality server host?
after system copy did you apply sap license on new host?
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
WSECCQA is refers to new quality server.
yes we applied license to new host.
optput of BRCONNECT on host
C:\Documents and Settings\wiqadm.WSECCQA>brconnect -u / -c -f stats -t oradict_s
tats
BR0801I BRCONNECT 7.00 (24)
BR0805I Start of BRCONNECT processing: cdxjdomo.sta 2008-02-28 15.54.38
BR0484I BRCONNECT log file: F:\oracle\WIQ\sapcheck\cdxjdomo.sta
BR0280I BRCONNECT time stamp: 2008-02-28 15.54.40
BR0301E SQL error -942 at location db_connect-4, SQL statement:
'SELECT NAME FROM V$DATABASE WHERE ROWNUM = 1'
ORA-00942: table or view does not exist
BR0310E Connect to database instance WIQ failed
BR0280I BRCONNECT time stamp: 2008-02-28 15.54.40
BR0301W SQL error -942 at location brc_dblog_open-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('
20080228155438', 'sta', 'WIQ', 'ORADICT_STATS', '9999', ' ', 'cdxjdomo', '7.00 (
24)')'
ORA-00942: table or view does not exist
BR0324W Insertion of database log header failed
BR0806I End of BRCONNECT processing: cdxjdomo.sta 2008-02-28 15.54.40
BR0280I BRCONNECT time stamp: 2008-02-28 15.54.40
BR0804I BRCONNECT terminated with errors
User | Count |
---|---|
95 | |
13 | |
13 | |
11 | |
11 | |
7 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.