Query on a virtual provider (nearlined) locks indexing

[murali_balreddy2]

Hi,

We have a few queries that are on the virtual providers. These are nearlined (SAND) data. When a user execute this query, a lock is established in SM12 on the RSDDTREXDIRTABL table with the virtual provider name as the argument. Due to this lock, any SIDs that are part of the virtual provider are not able to index in BWA. Since the queries on the virtual providers are usually long running ones, the indexing waits and finally fails. We plan to increase the wait time settings in the RSDDTREXADMIN table.

Why does a virtual provider query locks the SID? Is it because, the queries simulate a realtime data load from the nearline storage and in the process simulate SID generation (eventhough these SIDs are existing in BW and not yet archived).

Anyone dealt with a similar issue? Any suggestions?

Thanks,

Murali

[former_member93896]

Hello Murali,

I don't think this scenario has been tested much. Please open a customer message so SAP support can analyze the issue.

Regards,

Marc

SAP Customer Solution Adoption (CSA)

[murali_balreddy2]

We have already opened a customer message with SAP. No resolution yet.

Thanks.