cancel
Showing results for 
Search instead for 
Did you mean: 

Brconnect, MISSING_INDEX, SAPSR3.TESTDATRNRPART0...

Former Member
0 Kudos

hi

Brconnect shows messages:

Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.TESTDATRNRPART0

Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.TESTDATRNRPART1

.......

I run db02 -> missing index but nowher missing index not there!!

How to find that indexes?

regard's

Denis

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

with the table name you get, this looks like a temporary table created at database level, not in SAP level. to make sure, check SE11 if you see those table's definition.

Ask your colleagues if they know about this table.

If nobody knows about it, consider exporting their contents and then drop those tables... if someone complains, you will find the culprit and will still have the contents available by importing them back.

if you find that this table is really needed, ask the person who created this table to create a primary key, thus creating an index.

as Basis, you should not create a primary key as this is the job of the functional/abapper who created the table.

Please do not forget to provide feedback.

Thanks.

Former Member
0 Kudos

owner of tables TESTDATRNRPART0 is SAP.

Former Member
0 Kudos

Hello Denis,

Try running Update statistics job through DB13 and then check if these missing indexes still exists.

With Regards

Junaid