Can not create missing index

[former_member84399]

Dear all,

This is about a BW 3.5 system running Oracle 10.2.0.2 on Solaris 10

After an online database reorganisation, I receive these messages in db13

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3./BI0/F0BWTC_C02

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3./BI0/F0BWTC_C05

According to the logs, the tables above have been reorganised successfully.

I see the missing indexes in db02 under Missing Indexes:

Secondary indexes 13

/BI0/F0BWTC_C02-070

/BI0/F0BWTC_C02-060

/BI0/F0BWTC_C02-050

/BI0/F0BWTC_C02-040

/BI0/F0BWTC_C02-020

/BI0/F0BWTC_C02-010

/BI0/F0BWTC_C05-070

/BI0/F0BWTC_C05-060

/BI0/F0BWTC_C05-050

/BI0/F0BWTC_C05-040

/BI0/F0BWTC_C05-020

/BI0/F0BWTC_C05-010

/BIC/FZ_CPLN_00-900

If I try to select one and click on create in db, I get a short dump

Runtime Error RAISE_EXCEPTION

Date and Time 23.08.2007 11:12:13

ShrtText

Exception condition "STORAGE_NOT_DETERMINATED" raised.

What happened?

The current ABAP/4 program encountered an unexpected

situation.

What can you do?

Print out the error message (using the "Print" function)

and make a note of the actions and input that caused the

error.

To resolve the problem, contact your SAP system administrator.

You can use transaction ST22 (ABAP Dump Analysis) to view and administer

termination messages, especially those beyond their normal deletion

date.

is especially useful if you want to keep a particular message.

Error analysis

A RAISE statement in the program "SAPLSDB2" raised the exception

condition "STORAGE_NOT_DETERMINATED".

Since the exception was not intercepted by a superior program

in the hierarchy, processing was terminated.

173 else.

174 storage_source_hierarchy-dbr = 'X'.

175 endif.

176 storage_source_hierarchy-cmt = 'X'.

177 storage_source_hierarchy-cmp = 'X'.

178 if dbtabname ne space and dbtabname ne tabname.

179 perform shdupg_get_index_storage tables storpar

180 using dbsys prid tabname indexname storage_source_hierarchy

181 dbindex_of_origtable dbprimindex_of_origtable

182 changing rc.

183 else.

184 call function 'DB_STORAGE_GET'

185 exporting

186 dbsys = dbsys

187 prid = prid

188 tabname = tabname

189 indexname = indexname

190 dbindex = realname

191 dbrefindex = name_of_primidx

192 source_hierarchy = storage_source_hierarchy

193 tables

194 storpar = storpar

195 exceptions

196 mapping_error = 1

197 db_error = 2

198 uncomplete_parameter = 3

199 others = 4.

200 rc = sy-subrc.

201 endif.

202 if rc ne 0.

>>>> raise storage_not_determinated.

204 endif.

205

206 * Progamm generieren

207 perform db_get_progname using 'SDB2F' dbsys changing sdb2fdbs.

208 refresh statements.

209 perform gen_create_index in program (sdb2fdbs)

210 tables ddfldnames storpar loc_stmt

211 using tabname indexname realname unique dbsys rc.

212 if rc <> 0.

213 *KUGL-protocol-270694

214 perform stdo_sam1

215 using prid max_severity msgid '122' realname.

216 raise program_not_generated.

217 endif.

218 statements[] = loc_stmt[].

219

220 perform create_index_finish tables loc_stmt

221 using tabname realname dbsys no_exec rc.

222 if rc <> 0. raise program_not_generated. endif.

Any ideas?

Many thanks

Andreas

[Former Member · Accepted solution]

Hi,

Please check following note:

Note 703304.

You may have to import correction against your release.

Regards,

Payal Patel