Solution : https://service.sap.com/sap/support/notes/514178 (SAP Service marketplace login required)
Summary :
When using BRCONNECT in SAP BW environments, users encounter failures validating partitioned table structures with error messages such as BR0301E and ORA-14508, which indicate a missing VALIDATE INTO table. This issue occurs due to an absent INVALID_ROWS table in the BRCONNECT user's schema. To resolve, the INVALID_ROWS table must be created using Oracle's provided SQL scripts executed under the appropriate user account. After creation, necessary permissions and synonyms must be established to ensure proper operations. Key steps include logging into Oracle with system privileges and running scripts like utlvalid.sql, followed by granting permissions and creating synonyms for vital roles and systems within the SAP architecture.
Key words :
cd $oracle_home/rdbms/adminsqlplus system/<password>sql> @utlvalid, sqlplus system/<password>sql> create synonym ops$<sid>adm, sql> connect /sql> create synonym invalid_rows, sql> create synonym sap<sid>, br0970w database administration alert - level, ops$<domain>\sapservice<sid>, [cascade]br0301e sql error -14508, relevant private synonym explicitly, os user sapservice<sid>, foundbr0893e validating structure failed
Related Notes :
| 722188 | FAQ: Oracle partitioning |
| 23345 | Consistency check of ORACLE database |