Basis Errors and Solutions

Symptom
A long runtime occurs in a select with outer join. The executing transaction may terminate due to a timeout.
Other terms
Outer join, join view, select, performance, query rewrite
Reason and Prerequisites
1. You use MaxDB Version 7.6 or 7.7.2. The affected SELECT statement is an OUTER JOIN in which at least one of the two tables is a [...]

Symptom
In RZ20, the value for “Database Size” in the “DB KPIs Oracle” tree is displayed without specifying the size of PSAPTEMP.
Other terms
RZ20, DB, database, KPI, key performance indicator, DB KPIs Oracle
Reason and Prerequisites
This problem is caused by a program error.
Solution
This error is corrected in Basis Release 7.00 Support Package 20 and Basis Release 7.01 [...]

Symptom
Middleware is taking a long time to send records for Add action during synchronization for any smartsync application.
Other terms
Smart Sync, Delta, Synchronization, Middleware, Application,
Performance, Time, Data, Iteration, SyncBO, Loop, T01, T51, MI 2.5, MI
7.0, MI 7.01.
Reason and Prerequisites
The SQL query with a clause FOR ALL ENTRIES is executed without condition prior to this query leads [...]

Symptom
Loading the channel data in Channel Monitoring takes a long time, especially when there are many channels configured for the Adapter Engine. Even using a more restrictive filter, that would include only a small number of channels, does not help to reduce the load time.
Other terms
RWB, Channel Monitoring, performance, slow
Reason and Prerequisites
Inefficient [...]

Symptom
You use an ALE interface to generate and send IDocs. If you use a very complex distribution model (transaction DB64) with a large number of recipients and filter conditions, you will benefit from reducing the number of calls for reading the distribution model.
Other terms
Performance, TBD06, MMODEL_INT_VALID_GET, BMODEL_INT_VALID_GET, ALE_MODEL_INFO_GET
Reason and Prerequisites
The distribution model is [...]

Symptom
Performance problem in searching Person name on NAME_TEXT field.
Other terms
BAS_NAME, BAS_PERFORMANCE, ADDR_PERS_COMP_NAME_SEARCH, SO01
Reason and Prerequisites
When the searching on the full name, a functionality introduced in the note 0001128361(Please look at the note for more details), performance problem can occur. In this correction search on the name text is performed only when no results [...]

Symptom
You have a system with a high usage of the IGS. Due to lots of parallel IGS calls and a limit of parallel RFC threads the response time of IGS is very slow.
Other terms
RFC, IGS, Performance
Reason and Prerequisites
Additional Functionality.
Solution
Install the IGS SP mentioned in this note and set the profile parameterigs/listener/rfctoIGS.$(SAPSYSTEMNAME),$(SAPLOCALHOST),sapgw$(SAPSYSTEM),60,60,
where
is a number between [...]

Symptom
There are long runtimes in the after-import methods of BOR objects.
Other terms
Business Object Repository
Reason and Prerequisites
There are none.
Solution
Import the relevant Support Package.