on 04-11-2012 5:11 PM
Hi,
Statistics update job is failing in our BI 7.0 ABAP system from past 1 month.
But it is running successfully in Quality system.
Can you please help me on this
BR0280I BRCONNECT time stamp: 2012-03-25 02.00.14
BR0301E SQL error -1008 at location BrOwnListGet-27, SQL statement:
'SELECT DATA_LENGTH FROM DBA_TAB_COLUMNS WHERE OWNER = 'SAPSR3' AND TABLE_NAME = 'DBSTATTORA' AND COLUMN_NAME = 'ANDAT''
ORA-01008: not all variables bound
BR0806I End of BRCONNECT processing: ceiehbkw.sta 2012-03-25 02.00.14
BR0280I BRCONNECT time stamp: 2012-03-25 02.00.14
BR0804I BRCONNECT terminated with errors
Regards,
Kirthi S
Hi Kirthi,
This looks like an Oracle problem. Which exact Oracle version are you running your repository on?
Because this message has been seen more often with 10.2.0.2 (ORA-01008: not all variables bound).It should be fixed in the latest versions of Oracle.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kirthi,
Perhaps this note can help you:
1640115: "ORA-01008: not all variables bound" after cancel
Regards,
Hugo Amo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kirthi,
If this error is not reproducible and occurs sporadically, you can ignore it. Sometimes, because of running parallel processes(update statistics here), some memory was not available and this ORA-1008 error would happen.
A good approach would be to apply the latest BR*tools patch.
Hope it helps.
Regards,
Hugo
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.