Errors in Validating Structures -

[Former Member]

Hi All,

This system is a BI7 Prod system with oracle on AIX.

When I schedule Validate Structures from DB13 I see that at the end of the log few errors like this.

Can anybody suggest what the problem is exactly and how to fix this.

Thank you.

-

---

BR0891I Structure validated successfully for table SAPPR3./BIC/AZOSTKATP00 (cascade)

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.28

BR0891I Structure validated successfully for table SAPPR3./BIC/AZOSTKATP40 (cascade)

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.29

BR0891I Structure validated successfully for table SAPPR3./BIC/AZPRICE00 (cascade)

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.29

BR0891I Structure validated successfully for table SAPPR3./BIC/AZPRICE40 (cascade)

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.33

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPPR3./BIC/B0000103000

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.37

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPPR3./BIC/B0000104000

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.42

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPPR3./BIC/B0000105000

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.46

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPPR3./BIC/B0000106000

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.50

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPPR3./BIC/B0000107000

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.54

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPPR3./BIC/B0000108000

BR0280I BRCONNECT time stamp: 2007-07-29 08.44.58

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPPR3./BIC/B0000109000

[fidel_vales]

Hi,

The table being analyzed is partitioned.

To validate structure for partitioned tables you need to ensure that you’ve got the table INVALID_ROWS

You can create it with the script utlvalid.sql located on $/rdbms/admin

[Former Member]

Hi Fidel,

Can you please let me know the usage of the same.!!

Thank you,

[Former Member]

Hi Fidel,

Can you please let me know the usage of the same.!!

Thank you,

[fidel_vales]

Hi,

Follow the SAP note 514178. You have all the details there.

SAP has a big knowledge base in form of notes.

A lot of time would be saved if before asking a question, the notes are checked.

[markus_doehr2]

The problem is, that the notes search function is not working. No matter what you enter, you will get 0 results.

--

Markus

[fidel_vales]

Hi,

Curious,

if I enter the following search on http://service.sap.com/notes:

<b>Search Term</b> 14508

<b>Application Area</b> BC-DB-ORA*

I get 3 results back:

<i> Application Area Number Short text Last Changed On

1. 0.560 BC-DB-ORA-DBA 514178 ORA-14508 when validating partitioned tables 17.07.2007

2. 0.300 BC-DB-ORA 722188 FAQ: Oracle partitioning 16.08.2006

3. 0.300 BC-DB-ORA 23345 Consistency check of ORACLE database 30.01.2007</i>

If you try the same and do not get anything back, please open a message reporting it.

Not really sure the component where it has to be reported.

Probaby the best would be "XX-SER-SAPSMP" (SAP Service Marketplace)

But thanks for the information. Sometimes the impresion is the one I mentioned.

[markus_doehr2]

Hi Fidel,

it does work now again. SAP have had BIG problems last friday with the SMP, apparently they restored the search index back

--

Markus