The performance of certain SAP transactions is all of a sudden extremely slow or terminates with the ABAP/4 runtime error DBIF_RSQL_SQL_ERROR or DBIF_RTAB_SQL_ERROR. In the SYSLOG and in the detail information of the ABAP/4 runtime error you find the following entries:
"SQL error -243 occured when ... within a table
."
"INF-243: Could not position within a table."
"ISAM-101: file is not open."
Previously you may have found (it may have been some time prior to the occurance of this problem) in the database log file ("online.log file") messages of the type:
hh:mm:ss ...
hh:mm:ss Results: Index is now unusable
hh:mm:ss Action: Run 'oncheck -cI ...'
hh:mm:ss ...
Additional key words
INF243, INF101, ISAM101, INF271, INF131, ISAM131, INDEX, UNUSABLE
Cause and prerequisites
In your system a dbspace overflowed while an index modification was being cancelled (rollback of a different transaction). You may find in your SYSLOG previous entries of the type:
"SQL error occurs when...within table ."
"INF-: ..."
"ISAM-131: no free disk space."
Solution
Check the specified index with 'oncheck -cI ...' as described in the database log file ("online.log file") and, if necessary, recreate the index with the tool SAPDBA. (Caution: deleting and recreating an index may take some time). Proceed as follows:
1. Stop the R/3 System (as user adm):
$ stopsap r3
2. Repair the index with the tool SAPDBA. For this refer to the related Note 38401.
3. Start the R/3 System (as user adm):
$ startsap r3
Symptom:The partner indicated as default partner in the customer master does not appear in the first position during order processing.
Cause and prerequisitesThe problem is caused by a program error.
SolutionCheck the following coding locations:
1. LV05EF0P (only in Releases 2.2A-2.2D)
FORM PARTNER_BEARBEITEN.
....
SORT LKUPAV BY KUNNR PARVW PARZA.
SORT LTPAER BY MANDT SORTF PARGR PARVW. "<-- new as of 2.2A
LOOP AT LTPAER WHERE PARVW NE *VTCOM-PARVW AND
HERTAB = ' '.
2. LV05EFMO (only in Release 2.2A to 2.2D):
FORM MOVE_KNVP_TO_LKUPAV.
....
MOVE KNVP-VTWEG TO LKUPAV-VTWEG .
IF KNVP-DEFPA = 'X'.
LKUPAV-PARZA = '000'.
ELSE. "<=== New
IF LKUPAV-PARZA = '000'. "<=== New
LKUPAV-PARZA = '001'. "<=== New
ENDIF. "<=== New
ENDIF.
Keyword: default partner
Symptom:Different trading units of a material cannot - in contrast to R/2 - be saved like batches under one material master.
Cause and prerequisitesTrading unit handling is not planned.
SolutionPlease define a separate material master for each trading unit.
Key word: Trading unit
Symptom:When data medium exchange is used for foreign wire transfers (DTAZV format for the Federal Republic of Germany), the customer receives a notice from the bank that the information about the payee bank is missing.
Cause and prerequisites1. The house bank agreed with the customer to share the address as well as the SWIFT code of the payee bank. This agreement is due to the obvious assignment of the receiver to the corresponding receiver bank, and the resulting fewer complaints and charges for this from the foreign bank.
2. In accordance with an agreement with his/her house bank, the customer does not place the SWIFT address of the payee bank in the SWIFT code (vendor data), but instead the correspondence bank in the payee's country to provide the house bank with the routing.
When the SWIFT code is filled in DTAZV format, however, no data is passed on other than the account number. This means that
1. there may be problems determining the receiver bank which leads to costs due to additional research;
2. the correpsondence bank in the payee's country is missing the information regarding the bank the payee actually uses. As a result, no payment is possible.
SolutionDespite the above agreement, the bank routing code of the payee must be entered instead of the SWIFT address in the vendor master record.
As of Release 3.0, you have the option of filling the empty fields in accordance with the regulations of the house bank by means of a user exit, and to forward the information in such a way. Refer to the program documentation for further details.
Additional key words RFFOD__L
Symptom:Program: SAPMM61P
Error ID: 61402
Transaction MD19 for firming up a planned order cannot be called. An error message is issued on the initial screen, "No authorization for...", although the user has authorization profile SAP_ALL.
Cause and prerequisitesAuthorization profile for planned orders is incomplete
Solution1) Select menu path: Tools -> Administration -> User maintenance
-> Profiles.
2) Enter profile 'M_PLAF_ALL'.
3) Select the profile on the following screen by double-clicking
4) Add authorization 'M_PLAF_5_ALL', the authorization for firming
up planned orders.
5) Activate profile 'M_PLAF_ALL'.
6) Log off and then on again.
7) Finished!
Key word: MD19
Symptom:FM: A system error has occurred in the block handler
The following error message is displayed in syslog: Lock table overflowed
Reason and PrerequisitesThe lock table has overflowed.
Cause 1: The dimensions of the lock table are too small.
Cause 2: The update lags far behind or has shut down completely, so that the lock entries of the update requests that are not yet updated cause the lock table to overflow.
Cause 3: The application programs are poorly designed. A lock is issued for each object in an application program, for example a collective run with many objects.
SolutionDetermine the cause:
Call transaction SM12 and choose "Goto" -> "Diagnosis" (old)
Call transaction SM12 and choose "Extras" -> "Diagnosis" (new)
checks the effectiveness of the lock management
Call transaction SM12 and choose "Goto" -> "Diagnosis in update" (old)
Call transaction SM12 and choose "Extras" -> "Diagnosis in update" (new)
checks the effectiveness of the lock management in connection with updates
SM12 -> OkCode TEST -> Error handling -> Statistics (old, only in the enqueue server)
SM12 -> Extras -> Statistics (new)
shows the statistics of the lock management, including the previous maximum fill levels (peak usage) of the partial tables in the lock table
If the owner table overflows, cause 2 generally applies.
In the alert monitor (RZ20), an overrunning of the (customizable) high-water marks is detected and displayed as an alert reason.
The size of the lock table can be set with the profile parameter "enque/table_size =
". specifies the size of the lock table in kilobytes. The setting must be made in the profile of the enqueue server ( ..._DVEBM.. ). The change only takes effect after the restart of the enqueue server.
The default size is 4 MB for releases below 701 and 32 MB (32 Bit) or 64 MB (64 Bit) as of kernel release 701.
The maximum sizes for the individual tables are (example size: 4 MB):
Owner table: approx 5400
Name table: approx 5400
Entry table: approx 5400
Example: With the profile parameter
"enque/table_size =32000" , the size of lock table is set to
32000 KB (32 MB). With this setting, the tables can contain around 40000 entries.
Note that the above sizes and numbers depend on various factors such as the kernel release, patch number, platform, address length (32/64-bit), and character width (Ascii/Unicode). Use the statistics display in SM12 to check the actual capacity of the lock table.
If cause 2 applies, increasing the size of the lock table only delays the overflow of the lock table, but it cannot generally be avoided.
In this case you need to eliminate the update shutdown or accelerate the throughput of the update program using more update processes. Using CCMS (operation modes, see training BC120), the category of work processes can be switched at runtime, for example, an interactive work process can be converted temporarily into an update process to temporarily increase the throughput of the update.
For cause 3, you should consider a tuning of the task function Instead of issuing a large number of individual locks, it may be better to use generic locks (wildcard) to block a complete subarea. This will also allow you to considerably improve the performance.
Other terms
M3021, MM02, F5 288, F5288, FBRA
Keyword: Enqueue
Symptom:Key word: Interest indic. When you maintain the interest indicators in the configuration fo the dunning program, entries with a validity period of the form
" . .0000" cannot be deleted.
Cause and prerequisitesA validity period must be entered from Rel. 3.0 onwards. Old entries without a date cause error message SG102.
SolutionUse the following help program to delete the entries:
REPORT ZFT056Z .
TABLES: T056Z.
DELETE FROM T056Z WHERE DATAB = '99999999'.
IF SY-SUBRC = 0.
WRITE: 'deleted'.
ELSE.
WRITE: 'not found'.
ENDIF.
Symptom:If customers use self-defined programs to supply a short text
for a material, problems occur in the screen required for entry.
Cause and prerequisitesA different screen is used in batch input for the short texts
in the material master than in the normal transaction.
SolutionThe best way is to use the standard report for BTCI. If you do not
want to do this, you must specify OkCODE KTBT in field BDC_OKCODE
to make sure that the correct screen, SAPMM03K 110, is used.
Of course, screen fields MAKT-SPRAS and MAKT-MAKTX must then be
provided with data directly.
Key word: BTCI MM01 MM02
Symptom:If an RFQ is created with reference to a purchase requisition,
and the rejection indicator is set later in the vendor's bid,
the system does the following:
1. If a purchase order is created with reference to this purchase
requisition for the vendor whose bid was rejected, no message
is issued; the purchase order is created.
2. If a purchase order is created with reference to a rejected bid,
no message is output either. The purchase order is created
(system reacts the same even when the RFQ is created without
reference to a purchase requisition).
Cause and prerequisitesWorks as programmed
Solution1. No change is planned for this, as many RFQs can be created
for one purchase requisition, and in turn many items can be
rejected.
2. Will be changed in Rel. 3.0
Key word: ME21 ME51 ME47
Symptom:You find a confirmation dialog box (pop-up window) in an application and want to provide it with data in batch input. You do not know how to do so because the OK code input does not work.
Cause and prerequisitesThese dialog boxes (POPUP_TO_CONFIRM) do not have any input-capable fields; only pushbuttons.
SolutionSolution 1:
Enter the prefix '=' for OK CODE field (function code) BDC_OKCODE.
For example:
=NO or
=YES or
=CANC
Do not use notation '/00' in BDC_OKCODE for data release!
Solution2:
You position the cursor on the pushbutton and press Enter.
How does this work technically?
- Use F1 and technical info to find out the name of the key field behind the pushbutton.
Provide batch input field "BDC_CURSOR" with the key field name and do not enter BDC_OKCODE.
(Do not use notation '/00' in BDC_OKCODE for data release!)
Example: 'POPUP_TO_CONFIRM_STEP'
Screen: SAPLSPO1 0100
-------------------------------------------------------------------
Field name Value Description
---------- -------------- ------------------------------
BDC_CURSOR SPOP-OPTION1 for YES
or
BDC_CURSOR SPOP-OPTION2 for NO
or
BDC_CURSOR SPOP-OPTION2 for CANCEL
Additional key words Batch input
SAPLSPO1 0100
SAPLSPO1 0200
SAPLSPO1 0300
SAPLSPO1 0400
Symptom:Frontend cannot communicate with the application server if the frontend environment variable SAP_CODEPAGE is set to a character set unlike that of the application server.
This is normally the case for the R/3 Systems, which use the code page ISO8859-x, x=2...,9 (for example Russian: ISO8859-5 = Codepage 1500, frontend SAP_CODEPAGE=1504).
Whenever R/3 is automatically regenerated, and the message "Compiling ..." appears in the status line of the SAPGUI: The SAPGUI terminates with the error message "Abnormal Termination ...".
Even Windows must then be restarted in order to be able to use SAPGUI again.
Cause and prerequisitesThe conversion file for character conversion does not exist in Frontend. This file is needed if the RFC interface is to send data to the SAPGUI (for example, during regeneration).
The SAP_CODEPAGE parameter has two effects:
1. The character set of the frontend is sent to the R/3 kernel. The kernel undertakes further conversions by using conversion tables in the databank (maintain with transaction SPAD).
2. The RFC receiver in SAPGUI is set to this codepage. Since during RFC the receiver must perform the conversion and the frontend has no direct access to the databank, a conversion file must be available for the conversion.
SolutionThe corresponding conversion file must be recognized by the SAPGUI and generated from R/3:
1. Login R/3, user SAP*. client 0002. Call SM59 menu option RFC -> Generate conv. tab. or start the report RSRFCPUT using SE38.
Parameter:
a) Source code page (= APPL server character set, for example, 1500 for Russian), (Check: SE38: RSPARAM: parameter value install/codepage/appl_server)b) Target code page: Code page, which is set as the DOS Paremeter SAP_CODEPAGE, and runs in the SAPGUI.
(check: DOS shell, then "set" shows the SAP_CODEPAGE)
c) Path: The path on the application server (on UNIX, for example, /tmp/), in which the generated conversion file is stored.
Caution:
The path must end with a path identifier (for UNIX: SLASH)
Effect: A file
.CDP is generated.
File format:
Each line contains a number in Hex format. For example: during a
conversion in which all characters are transferred indentically,
each line contains the line number in Hex format--as follows
0x00 (Meaning: Character 0x00=Line 0 is changed to character 0x00)
0x01
0x02
....
0xFF
2a. If 2. is not possible because SM59 is also compiling and the SAPGUI terminates once again, it is possible (from 3.0B) to switch off the conversion at the front end temporarily. Simply set PATH_TO_CODEPAGE to NONE. The path is "fixed" only when the codepage is generated with SM59.
2b. If you have 3.0A or an older release, you can call the c program ldcdprfc on the application server. Enter the appropriate connect options and do not forget -3 as an option.
Example: ldcdprfc -d C11 -3 =s 00 -h myhost -u SAP -p PASS -S 1100
-T 1105 -P /usr/sap/C11/
This program creates the codepage files without using the GUI.
3. The file generated must be transferred to the frontend (for example with ftp, binary), into the SAPGUI working directory.
The file has the extension CDP.
4. In the AUTOEXEC.BAT file on the frontend, a line must be created with the DOS environment variable:
SET PATH_TO_CODEPAGE=
Do not forget the platform specific path identifier at the end.
Example:
a) the application server uses code page 1500 (Russian ISO8859-5)
b) The Frontend uses CP 1504 = MS Windows CP 1251 (Russian MS Windows);, the SAPGUI working directory is C:\SAPGUI
- The conversion file should be called: 15001504.CDP - in AUTOEXEC.BAT: SET SAP_CODEPAGE=1504
SET PATH_TO_CODEPAGE=C:\SAPGUI\
- in R/3 SM59: source CP: 1500, target CP: 1504, Path: /tmp/- on the application server, the file /tmp/15001504.CDP is generated, which must then be transferred to the C:\SAPGUI directory on the PC.
Additional key words
Error in the application program, SAPGUI crash, code page, conversion
Key word: Code page. Conversion, character set, SAP_CODEPAGE, SAPGUI
Symptom:When you enter a goods receipt for a purchase order (transaction MB01,
MBOA), the system displays the following error message:
Please check table T156S: entry 101_ _ _ B missing.
Cause and prerequisitesA new account assignment category was entered in table T163K (with
Customizing transaction OME9). The new account assignment category was
given the consumption indicator Blank (field T163K-KZVBR).
SolutionPlease assign a valid consumption/usage indicator to the relevant
account assignment category. The standard system supports A (asset),
V (consumption), E (sales order stock), and P (project).
Key word: T156S
Symptom:An acquisition tax code 0% is created and by doing so, 0% is specified for input and output acquisition tax (both as 0%-). In the advance return for tax on sales/purchases, the base amount of output tax is then displayed as a positive and not a negative amount, the second line (input tax) is not mentioned at all if the base for it was the amount of the output tax (that is, zero).
Cause and prerequisitesOur programs cannot distinguish a positive zero from a negative zero after the data has been saved. The programs for calculating tax thus calculate the amount zero twice and you do not know anymore for which base amount the +/- sign is to be changed.
SolutionYou can either
- use the normal code for tax-exempt deliveries,
or
- create a separate tax code for "Exempt from acquisition tax"
which, however, is defined just as "Exempt from input tax".
As a result, the base amounts for tax-exempt imports from other EC
member states can then be calculated separately in the advance
return for tax on sales/purchases.
From our point of view, it is not necessary to display a tax-exempt acquisition from other EC member states in both parts of the advance return for tax on sales/purchases (input tax and output tax).
Subsequent activities
(only for german customers who use the tax form printing program)When using the tax code for "Exempt from acquisition tax", the relevant base amounts are displayed in the advance return for tax on sales/purchases in exactly the same way as the base amounts in "Exempt from input tax". The base amount is therefore displayed with a negative sign on the F_RFUVD____01 tax on sales/purchases form (program RFUVDE00). What you require, however, is the display to be the same as the output tax portion of the acquisition tax, that is without a +/- sign. This can be done in the form as follows (MAIN window):
Base amount without decimal places for group nn in the standard system:
AM ,,&UMSVP-BASnn(IZ13.0)&
With an inverse +/- sign:
/: IF &UMSVP-BASnn+20(>)& EQ '-'
/: DEFINE &SIGN& = ' '
/: ELSE
/: DEFINE &SIGN& = '-'
/: ENDIF
AM ,,&SIGN&&UMSVP-BASnn(CSIZ13.0)&
Additional key words Taxes, SAPLTAX1
RFUMSV00, RFUVDE00, F.36
Symptom:Dataset in table NAST contain keys from reorganized application objects.
Cause and prerequisitesThere is no special reorganization for table NAST. This table is reorganized with the application documents (to which it is allocated through the application keys).
The messages represented by the NAST records are attributes of the related application objects. NAST records must therefore be reorganized together with the application documents to avoid inconsistencies caused by uncoordinated reorganization runs and NAST records for reorganized documents.
NAST datasets can be deleted with the functions RV_MESSAGES_DELETE and RV_MESSAGES_UPDATE. This also deletes the processing logs in table CMFP.
SolutionCheck the reorganization program as far as the reorganization of NAST is concerned.
As of Release 3.0D, the report RSCLNAST is contained in the delivery. You can use it to explicitly delete NAST records, if this is necessary.
Additional key words Message, entry, deletion, removal, message record, NAST
Key word: Reorganization
Symptom:If discrepancies exist in the basis entries of a report line structure,
(Entries Line structure ' ', elements 9001+), you can reset
these entries in the Tables 237A, 237T and 237.
Cause and prerequisitesThe same program error described in note 12343.
SolutionSE37: Start function module RKE_FILL_TABLES_T237FF in test mode:
ERKRS XXXX - current operating concern
MODE N - reconstruct basis entries
TABNAME CE1XXXX - current line item file
Execute function module using F8.
As of release 4.0, the function module copies the operating concern
into the table name. Thus the third import parameter is omitted.
Do this while you are logged on in the language in which the
operating concern was originally generated.
Foreign-language entries in Table 237T need to be translated manually
using Transaction SM31. This goes for both the entries 9001+ and for
created report line structures.
Key word: Line structure
Symptom:Cancelled billing documents are considered in the sales qualifying for rebate. They increase the sales qualifying for rebate and are displayed in the drill-down.
Cause and prerequisitesThe cancellation billing document type (for example, S1) is marked as not qualifying for volume-based rebate. As a result, the cancellation billing document does not reduce the sales qualifying for rebate.
The cancellation billing document contains the same values as the cancelled billing document. Only the values of the cancellation
billing docuement have a different +/- sign. For this reason, the total of cancellation billing document and the cancelled billing document is 0. If the cancellation billing document and the cancelled billing document are qualifying for volume-based rebate, the cancellation is correctly taken into account during the rebate settlement.
Solution1) Mark the cancellation billing document as qualifying for volume-based rebate.
-> Customizing SD -> Functions -> Rebate processing -> Control data
-> Billing documents.
Caution: If the cancellation billing document is marked as qualifying for volume-based rebate, you may only cancel billing documents qualifying for volume-based rebate with this cancellation billing document type. If you cancel a billing document not qualifying for volume-based rebate with a cancellation billing document qualifying for volume-based rebate, this would reduce the sales qualifying for rebate although the original billing document is not qualifying for volume-based rebate.
Key word: Rebate
Symptom:The following error can occur when using your own reference screens for the selection screen of a report:
1.) Comments and underscores, which were defined with SELECTION-SCREEN COMMENT or SELECTION-SCREEN ULINE and were left on the reference screen, do not appear on the selection screen.
2.) The database program SAPDBldb has several selection screens; i.e., there are more objects defined in DBldbSEL than fit on a screen. All these objects, as well as pushbuttons to scroll between the screens appear without the use of your own reference screens. However, when you use your own selection screens, only those objects which are exactly on the that screen and the scroll buttons are missing if additional screen are not created via report-specific select options or parameters.
Additional key words() ABAPNOTE SELECTION SCREEN LDB
Cause and prerequisitesRe: 1
The names of the corresponding fields on the selection screen are structured as follows:
- %_xxxnnn for SELECTION-SCREEN COMMENT TEXT-xxx ... FOR TABLE tab
- %_Unnn%% for SELECTION-SCREEN ULINE ... FOR TABLE tab
In this case, 'xxx' is the number of the comment and 'nnn' is a consecutive number that was used in the report generation to number the SELECT-OPTIONS, PARAMETERS and SELECTION-SCREEN statements.
When generating a selection screen based on a reference screen, the system searched for the corresponding object in the currently generated version of the report to decide whether a reference screen is to be copied or ignored.
The error occurred if, after creating the reference screen in the database INCLUDE DBxyzSEL (xyz = name of the logical database), a SELECT-OPTIONS, PARAMETERS or SELECTION-SCREEN statement was included or removed from it before the SELECTION-SCREEN statement. Because of the resulting shift in the consecutive number, the fields were not found in the current load and as a result they were not copied to the selection screen.
Re: 2
Only this is supported. When using your own reference screens only the onjects found in the screen are taken into consideration.
SolutionRe: 1
In such a case, generate Dynpro 1000 of the databank program SAPDBxyz (SE38, Prgram --> Generate). Then copy the filed names from this dynpro, which contains correct consecutive numbers) onto the reference screen.
Afterward, the selection screen of the report must also be regenerated.
Re: 2
When using your own selection screen, the database-specific portion is limited to a maximum of one page. In any case, objects in a selection screen can appear which are split across several dynpros in the "normal case."
From 3.0:
There are no longer any reference screens; they have been replaced by the defining selection screen versions SELECTION-SCREEN BEGIN/ END OF VERSION.
Keyword: Reference screens
Symptom:The following error message is displayed when creating a delivery: Customer in a certain partner function cannot have a certain account group. Error message: VP303 in transaction VL01.
Cause and prerequisitesThe account group was not assigned to the partner function of the customer. When creating an order, a partner function was entered which is defined in a hierarchy, and for which no account group is assigned.
SolutionAssign the account group to the partner function via:
Tools -> Customizing -> Configuration -> Logistics -> Sales/ distribution -> Functions -> Partner determinat. -> Partner functions, place the cursor on the affected function -> Environment ->
Acct grp assignment. Here you have to enter the account group for the required partner.
Key word: Customer hierarchy
Symptom:If during the batch input for material master data the customer
enters a name that diffes from the one proposed by the system, he
might receive the error message MG016:
For ...., no physical file name can be determined.
Cause and prerequisitesTable FILENAME not maintained.
SolutionCall SF01 and create the new name as a logical file name and
specify the corresponding physical file name (including path).
Here it is useful to take the entries for MATERIAL_MASTER_BTCI as
a reference.
Key word: RMMMBIM0 MG016
Symptom:Key word: SMOD, CMOD
Customer wants to add proprietary functions to the SAP standard or
change SAP programs; would like support.
Solution1. SAP enhancement concept: transaction CMOD (SMOD), documentation:
transaction CMOD (SMOD), (--> Documentation: menu Environment->
Manual).
2. "Traditional" modifications
Symptom:The information you provided the SAP Hotline about your reported
problem is not sufficient to guarantee fast processing.
Cause and prerequisitesThis note should help you speed up the processing of your
reported problem.
SolutionYou have to find the information that the Correction and Transport
System writes to its logs and provide it to the SAP Hotline.
Please fill out the form below and send it to the SAP Hotline, along
with the relevant log excerpts.
--> At operating system level.......................................
o Which action caused the problem (termination, error message) ?
.____________________________________________________________________.
o How was this action started (e.g. tp import C11K900001 P11 u1) ?
.____________________________________________________________________.
o Are other SAP systems connected in the network ?
.____________________________________________________________________.
o Under UNIX, analyze the errors by examining the following:
a. /usr/sap/trans/log/SLOG*
b. /usr/sap/trans/log/LOG
c. /usr/sap/trans/log/<>?9nnnnn.
= source SID
= target SID
? = Abbreviation for import step
(fourth column in SLOG in lines with ERROR
)
d. grep /usr/sap/trans/bin/T_hugo
e. ls -ltr /usr/sap/trans/bin
Extract the relevant portions for the SAP Hotline.
o Under WINDOWS NT, analyze the errors by examining the following:
a. \usr\sap\trans\log\SLOG*
b. \usr\sap\trans\log\LOG
c. \usr\sap\trans\log\<>?9nnnnn.
= source SID
= target SID
? = Abbreviation for import step
(fourth column in SLOG in lines with ERROR
)
d. dir /OD \usr\sap\trans\bin
Extract the relevant portions for the SAP Hotline.
--> In the R/3 System ................................................
o Transaction SM37: are there any terminated batch jobs for user DDIC?
If so, what is the complete text of the job log(s)?
Please find the section relevant to the time in question in the local system log.
Additional key words
r3sl
Symptom:Archiving the DB with "ontape -s" terminates with the following error message:
"Archive failed - function write to tape failed code -1 errno 28"
Cause and prerequisitesThe value of parameter TAPESIZE in the configuration file ($ONCONFIG) of the OnLine DB system is set too large.
SolutionReduce the value of $ONCONFIG parameter TAPESIZE accordingly. For example, for HP non-compressed 4 mm DAT tapes
60 m to 1250000 [1.3 GB capacity according to manufacturer]
90 m to 195000 [2.0 GB capacity according to manufacturer]
For HP non-compressed 8mm DAT tapes
112m to 2095000 [2.3 GB capacity according to manufacturer]
To active these prarmeter changes the databank system must be restarted.
Additional key words archive ontape INF1 INF28 ontape -s Archive failed code -1 errno 28,
errno28
Symptom:Sometimes, you cannot set up the connection to SAPSprint (see Note 894444).
This happens whenever the PC issues a previously received list with device type SAPWIN, or when another application on the PC hands control over to SAPSprint too rarely.
the error appears in the system log as 'Connect failed'. It appears in the SAPSprint log as
Error: socket_read: l_rc = -1
or as
Error: lpxxslpd: read on socket ...
An NILIB message normally appears just before it, for example:
'***ERROR: NiPRecv: errno: 132'.
The spool work process tries to rescue the situation by repeating the transmission twice after a short wait (the default is five minutes). Nothing can be printed on the affected PC during the waiting period!
If all three attempts fail, the print request is marked as faulty and must be triggered manually later.
Other termsSAPLPD
Reason and PrerequisitesDevice type SAPWIN lets the Windows driver prepare the print data for the connected printer. Some of these drivers are slow, and do not pass control to other tasks while they are preparing a page. Since the TCP software in Windows does not receive control either, the connection request is not answered, and the spool work process reports a problem.
SolutionThe problem can be solved only partially, as the main problem, the poor printer driver, is outside our control.
The only way to reduce the problem is to reduce the time required by the printer driver. There are several ways to do this:
- If your printer understands Postscript, PCL or Prescribe, you can change the device type in R/3 from SAPWIN to the relevant type. Then R/3 takes over the data formatting and relieves the computer because now it only has to transfer the data.
- Try other printer drivers for the printer.
- Configure the printer using the host spooler in UNIX and access it using access method 'U' from the SAP system. The host spooler then generates a separate process for each printer that can wait for the connection "as long as necessary". While this does not speed up the printer output, it avoids the terminations and delays in the SAP editor.
Symptom:Oracle rturns ORA1113 although a complete off-line backup of all file systems was restored and it should be consistent with all objects.
Cause and prerequisitesUnknown.
The following tables will help you to examine the recovery situation in more detail:
V$RECOVER_FILE: Display of the files, which require a recovery.
V$RECOVERY_LOG: All OFFLINE Redologs that are required to do this.
The select commands can be performed in the MOUNT status of the database. If no logs appear in V$RECOVERY_LOG, a recovery with the online redologs is sufficient.
SolutionIf V$RECOVERY_LOG does not return any file, you can perform:
sqldba> recover database
and if this was successful;
sqldba> alter database open;
irectly in the MOUNT status.
Otherwise, we always recommend the program SAPDBA, which however is based on correct information of Oracle in the V$ tables. Therefore the workflow is also incorrect if the information in V$ tables in SAPDBA is incorrect.
Key word: RECOVERY
Symptom:Conflicts with structures with the name "TEXT" and text elements
(numbered TEXTS).
Cause and prerequisitesElements of a structure with name "TEXT" whose names are 3
characters long are interpreted as text elements by the ABAP/4
compiler
SolutionTreat "TEXT" as a reserved word; do not name your variables
"TEXT".
Key word: ABAP/4
Symptom:When you scroll in the partner overview of a sales activity,
a partner is skipped whether the step loop is activated or not.
Cause and prerequisitesProgram error
SolutionChange to program DV02PF55:
- in module SAVE_CURSOR_5555.
old : IVBPA51_LOOPIND1 = HTABIX2 - HTABIX1 + 1.
new : IVBPA51_LOOPIND1 = HTABIX2 - HTABIX1.
Key word: Scrolling
Symptom:Error ID: CALL_FUNCTION_*
Remote function call terminates with the message
"No free connection available".
Cause and prerequisitesOne of the administration tables in the SAP System overflowed
SolutionThe administration tables for open connections can be set using
the following parmeters:
The max. number of all active connections via one SAP gateway is
set using profile parameter
gw/max_conn
The default value is 20. It can be set to 100 (or more) without
causing any problems.
An additional restriction exists for the maximum number of open
connections for one application server. This is controlled by the
parameter
rdisp/max_comm_entries
The default value is 100. You only need to increase this value when you have increased the parameter gw/max_conn.
Please note: changes to profile parameters only become effective after the instance has been restarted.
Key word: ABAP/4
Symptom:
Sometimes, you cannot set up the connection to SAPSprint (see Note 894444).
This happens whenever the PC issues a previously received list with device type SAPWIN, or when another application on the PC hands control over to SAPSprint too rarely.
the error appears in the system log as 'Connect failed'. It appears in the SAPSprint log as
Error: socket_read: l_rc = -1
or as
Error: lpxxslpd: read on socket ...
An NILIB message normally appears just before it, for example:
'***ERROR: NiPRecv: errno: 132'.
The spool work process tries to rescue the situation by repeating the transmission twice after a short wait (the default is five minutes). Nothing can be printed on the affected PC during the waiting period!
If all three attempts fail, the print request is marked as faulty and must be triggered manually later.
Other terms:
SAPLPD
Reason and Prerequisites
Device type SAPWIN lets the Windows driver prepare the print data for the connected printer. Some of these drivers are slow, and do not pass control to other tasks while they are preparing a page. Since the TCP software in Windows does not receive control either, the connection request is not answered, and the spool work process reports a problem.
Solution
The problem can be solved only partially, as the main problem, the poor printer driver, is outside our control.
The only way to reduce the problem is to reduce the time required by the printer driver. There are several ways to do this:
* If your printer understands Postscript, PCL or Prescribe, you can change the device type in R/3 from SAPWIN to the relevant type. Then R/3 takes over the data formatting and relieves the computer because now it only has to transfer the data.
* Try other printer drivers for the printer.
* Configure the printer using the host spooler in UNIX and access it using access method 'U' from the SAP system. The host spooler then generates a separate process for each printer that can wait for the connection "as long as necessary". While this does not speed up the printer output, it avoids the terminations and delays in the SAP editor.
Symptom:You want to delete project master data (project definition, WBS element).
Cause and prerequisites SolutionThis note contained a reference to Report RCJDEL01 with which you could delete WBS master data in test systems before project archiving was supported in the R/3 system.
Do not use this report any longer.
To delete and archive, use functions Deletion flag, Delete, Archiving, Reorganization which are now contained in the standard system.
Refer to the documentation for further information.
Key word: WBS, Delete
Symptom:Error message: Reversal cannot be run due to missing CO documents
Description: A revaluation must be performed. The system requires you
to reverse the data first. An error occurs when the
reversal is run: Reversal not possible due to missing
CO documents
Transactions: KSPU / Revaluation
Program: SAPMKPU2
Cause and prerequisitesInconsistency between CO documents (Header: Table COBK) and allocations
document management (Table T823D).
Conditions: This error occurs if revaluation documents were deleted
(using archiving objects for cost centers or using other programs)
without the corresponding T823D entries.
SolutionInstall the correction program (K11K102786),
which removes the superfluous entries for Table T823D:
*---------------------------------------------------------------------*
REPORT RKCORR06.
PARAMETERS: KOKRS LIKE CSKS-KOKRS,
TESTLAUF LIKE KREO-TESTLAUF DEFAULT 'X'.
TABLES: COBK, T823D.
DATA: COUNTER LIKE SY-TABIX.
SELECT * FROM T823D WHERE TAB = 'CCSS'
AND UMGRP = KOKRS .
SELECT SINGLE * FROM COBK WHERE KOKRS = KOKRS
AND BELNR = T823D-DOCNR .
CHECK SY-SUBRC <> 0.
ADD 1 TO COUNTER.
CHECK TESTLAUF = SPACE.
DELETE T823D.
ENDSELECT.
WRITE: / TEXT-001 COLOR 6 INTENSIFIED, "Verwaltungseinträge ohne
COUNTER. "CO-Beleg:
IF TESTLAUF = 'X'.
WRITE: TEXT-003. "ermittelt
ELSE.
WRITE: TEXT-002. "gelöscht
ENDIF.
*---------------------------------------------------------------------*
Title: Reorganize Revaluation Document Management
*---------------------------------------------------------------------*
Selection texts: Name Text
KOKRS Controlling area
TESTLAUF Test run
*---------------------------------------------------------------------*
Numbered texts: 001 Admin. entries without CO documents:
002 deleted
003 determined
*---------------------------------------------------------------------*
Key word: Revaluation
Symptom:A date stored in table TCURR, whose form contradicts the date standards when being displayed using transaction OB08, cannot be deleted.
Cause and prerequisitesAn entry with an incorrect date was delivered by SAP which you cannot maintain online. The program outputs the FC236 error message "Enter valid date", to which you cannot react.
The same problem could be generated with Report RFDEV310 up to Release 3.1H if nothing had been entered in the field date.
SolutionThe incorrect entry can be deleted via an ABAP program you have to
write yourself.
Example:
REPORT ZZDTCURR.
TABLES: TCURR.
DELETE FROM TCURR WHERE KURST = 'B' "Exchange rate type
AND FCURR = 'BEF' "From currency
AND TCURR = 'DEM' "To currency
AND GDATU = '50000000'. "Valid from
The entry for the GDATU field is to be determined using transaction SE16 (Release 2.2) or SE17 (Release 3.0) and applied to table TCURR. The value stored in the database is displayed under the 'Valid from' field.
Delete your program after running it.
Key word: TCURR
Symptom:Error message: Message ID 'GA' stating that the reversal
cannot be reversed due to missing CO documents.
Description: Example: A CO allocation transaction is to be repeated.
The system requests the reversal. The error occurs if
the reversal is carried out:
Reversing is not possible because of missing documents.
Transactions: KSW5 / Perform Periodic Transfers
KSV5 / Perform Actual Distribution
KSU5 / Actual Assessment
KSVB / Perform Planned Distribution
KSUB / Perform Planned Assessment
Program: SAPMKGA2
Cause and prerequisitesInconsistency between CO documents (Header: Table COBK) and
allocation document numbers (table T811D).
Requirements: The error occurs if allocation documents were
deleted (for example, using archiving objects for cost centers or
by means of other programs) and the respective T811D entries were
not deleted.
SolutionImport or maintain a correction program (K11K102786) which
eliminates the unnecessary T811D entries:
********************************************************************
The correction program makes possible only the repetition of the
coresponding documents. A previous reversal no longer takes place. That
means that the totals records contain double values. If you do not
want this to be the case, contact SAP.
*********************************************************************
*---------------------------------------------------------------------*
REPORT RKCORR05.
PARAMETERS: KOKRS LIKE CSKS-KOKRS,
TESTLAUF LIKE KREO-TESTLAUF DEFAULT 'X'.
TABLES: COBK, T811D.
DATA: CYCLE(5) TYPE C VALUE '&&&&%',
COUNTER LIKE SY-TABIX.
REPLACE '&&&&' WITH KOKRS INTO CYCLE.
SELECT * FROM T811D WHERE TAB = 'CCSS'
AND CYCLE LIKE CYCLE .
SELECT SINGLE * FROM COBK WHERE KOKRS = KOKRS
AND BELNR = T811D-DOCNR .
CHECK SY-SUBRC <> 0.
ADD 1 TO COUNTER.
CHECK TESTLAUF = SPACE.
DELETE T811D.
ENDSELECT.
WRITE: / TEXT-001 COLOR 6 INTENSIFIED, "Verwaltungseinträge ohne
COUNTER. "CO-Beleg:
IF TESTLAUF = 'X'.
WRITE: TEXT-003. "ermittelt
ELSE.
WRITE: TEXT-002. "gelöscht
ENDIF.
*---------------------------------------------------------------------*
Überschrift: Bereinigung Allocations-Beleg-Verwaltung
*---------------------------------------------------------------------*
Selection text : Name Text
KOKRS COntrolling area
TESTLAUF Test run
*---------------------------------------------------------------------*
Numbered texts: 001 Administration entries without CO documents:
002 deleted
003 determined
*---------------------------------------------------------------------*
Key word: Allocations
Symptom:When you create a transfer posting by entering a line item, the
system automatically generates a second line item as soon as the
document is posted.
The first line item updates the issuing stock, the second line item
updates the receiving stock. This procedure is primarily used for the
following movement types: 301-304, 309-314, 321-324, and 401-404.
However, this procedure is not used in the case of placements in
storage from or (in the case of reversals) to an in-transfer stock or
an in-transit stock. This applies primarily to movement types
101-102, 122, 305-306, 315-316.
Cause and prerequisitesThis procedure ensures that a separate line item is generated for
every material segment for which inventory can be posted.
SolutionPlease consider these facts for your analyses and reports.
Key word: Transfer postng
Symptom:When you create a billing document, ABAP/4 run-time error
DBIF_RSQL_INVALID_CURSOR occurs in program SAPLV60A. The error
occurs at command SELECT * FROM VBPA WHERE VBELN = XKOMFK-VBELN
Cause and prerequisitesIn the text scheme for determining the item texts, at least one
TEXT-ID was assigned the MUST (display) indicator with value
Y (text displayed when copied).
SolutionFor billing document item texts, the must (display) indicator must
have value "X" or " ".
Entering the value 'Y' leads to value ' '.
The following information appears:
"No text dialog window can be sent for billing document texts"
Key word: Billing doc.
Symptom:An SAP consultant or support representative has made data available to the customers in the form of a note attachment (or - possible until January 2003 - on sapservX) for the import into the customer system (as described in the internal Note 11920).
Other termssapserv3 Walldorf
sapserv4 Foster City
sapserv5 Tokyo
sapserv6 Sydney
sapserv7 Singapore
Reason and PrerequisitesAs of Release 3.0, preliminary transports (delivery of preliminary corrections) have been delivered in the form of Support Packages. There are also preliminary transports of developments that are imported using the manual procedure described here.
When importing requests from SAP systems, you must ensure that requests in area 900000 - 999999 (for example, Q30K90821), possibly collide with customized transports, especially if there are customer systems with the same name (in the example, this would be Q30). These jobs should be rejected if the names are the same.
In systems with Releases older than 4.6C the following is important: When you import jobs from SAP systems, note that jobs in the range 900000 - 999999 (for example Q30K900821) are treated as customer- specific transports. The transport objects are considered modified. Such jobs should therefore be rejected if the system is older than 4.6C. As of Release 4.6C, this restriction does not apply.
The transport properties will be imported with the transported objects. After the import the original system will therefore no longer be SAP but for example, P30 if the export was carried out in P30. As user DDIC, you can maintain this in Transaction SM31 in Table TADIR, and change it to SAP again. This is required if a system with the same name as the export system exists in your system landscape.
SolutionTwo files are generated when exporting:
- The R3trans file which contains the actual data.
- The transport information file which contains the control-data for the transport.
This data has been made available to your either as a note attachment or directly on a sapservX host.
1. Situation: The data is available as a note attachment (procedure as of February 2003).
a) Download the data from the note dealing with preliminary transport, as described in Note 480180.
b) The data is contained either in a ZIP or in a SAR archive that you will need to unpack.
2. Situation: The data is available on sapservX and has to be transferred using ftp. You can find the data in directory general/R3server/abap/note.0012345.
The following describes the procedures for UNIX, WINDOWS, and OS/400.
a) UNIX:
The binary mode MUST be switched on for the data transfer, otherwise the R3trans file will be destroyed.
The customer calls ftp as follows:
cd /usr/sap/trans/tmp /* cd at customer site */
ftp sapservx /* Start file transfer program */
/* Enter 'ftp' as user and password */
cd general/R3server/abap/note.nnnnnnn /* directory */
bin /* Switch to binary mode */
get Rnnnnnn.xxx /* Fetch R3trans data file, name */
/* depends on the transport request.*/
get Dnnnnnn.xxx /* Fetch SDO file if it exists. */
get Knnnnnn.xxx /* Fetch the transport info file. */
bye /* End ftp. */
mv Rnnnnnn.xxx ../data /* Copy R3trans file into data dir. */
mv Dnnnnnn.xxx ../data /* SDO file into the data dir. */ mv Knnnnnn.xxx ../cofiles /* info file into cofiles dir. */
b) Windows
Since the text mode on WINDOWS is different from the text mode on UNIX, using ftp the text files (command files and buffer) have to be transferred in text mode and the data files in binary mode.
Example: Assuming that the transport request is called P21K000123, then the following files have to be transferred in the specified mode using ftp:
Name Contents Mode Target directory Exists
R000123.P21 data bin \usr\sap\trans\data always
K000123.P21 info ascii \usr\sap\trans\cofiles always
D000123.P21 data bin \usr\sap\trans\data only for ADO
It is essential to use the correct mode when transferring data, otherwise the import cannot be carried out successfully.
The customer calls up ftp as follows:
<>
cd \usr\sap\trans\tmp /* cd at the customer site */
ftp sapservX /* start file transfer program */
/* enter 'ftp' as user and password */
cd dist general/R3server/abap/note.0012345 /* directory */
bin /* switch to binary mode */
get Rnnnnnn.xxx /* fetch R3trans data file, name */
/* depends on the transport request */
get Dnnnnnn.xxx /* fetch SDO file, if it exists */
ascii /* switch to text mode */
get Knnnnnn.xxx /* fetch transport info file */
bye /* end ftp */
/* Copy..... */
move Rnnnnnn.xxx ..\data /*R3trans file to data dir. */
move Dnnnnnn.xxx ..\data /*SDO file to data directory */
move Knnnnnn.xxx ..\cofiles /*Info file to cofile directory*/
c) AS/400
Use command APYABFIX: APYABFIX SID() FROMHOST('sapserv3')
FROMDIR('general/R3server/abap/note.0012345')
TRANSPORT('*FROMDIR')
TPIMPORT(*YES)
Replace the place-holders , sapserv3 and note.0012345.
The parameter value TRANSPORT(*FROMDIR) controls the automatic determination of the transport request number while the system searches through the specified directory for transport files. The last parameter TPIMPORT initiates the calls tp 'addtobuffer ...' and tp 'import ...' for the transport request.
If the execution of this command causes the error 'Too many files found in directory' copy the files manually into your data and cofile directory using ftp.
<>
ftp sapservX /* start file transfer program */
/* enter 'ftp' as user and password */
cd dist general/R3server/abap/note.0012345
/* to change to the directory that */
/* contains the transport */
namefmt 1
/* to access the file system of AS/400 */
lcd '/usr/sap/trans/data'
/* change to the transport data directory locally*/
bin /* Switch to binary mode */
get Rnnnnnn.xxx /* fetch R3trans data file, name of */
/* file depends on transport request. */
get Dnnnnnn.xxx /* fetch SDO file if it exists. */
lcd '/usr/sap/trans/cofiles'
/* change to cofile directory locally */
ascii /* following transfer in text mode */
get Knnnnnn.xxx /* fetch transport info file. */
quit /* end ftp. */
Manual import of the transports:
Logon as OFR
tp 'pf= addtobuffer '
tp 'pf= import U26'
Starting the import:
- Start the import as follows:
a) UNIX:
as user adm:
/usr/sap//SYS/exe/run/tp addtobuffer \
pf=
/usr/sap//SYS/exe/run/tp import U26 \
pf=
Replace with the current SID, for example, C11.
Example:
/usr/sap/C11/SYS/exe/run/tp addtobuffer P21K000123 C11 pf=/usr/sap/trans
/bin/TP_DOMAINABC.PFL
/usr/sap/C11/SYS/exe/run/tp import P21K000123 C11 U26 pf=/usr/sap/trans
/bin/TP_DOMAINABC.PFL
b) Windows:
as user adm:
cd \usr\sap\trans\bin
\usr\sap\\SYS\exe\run\tp addtobuffer
\usr\sap\\SYS\exe\run\tp import U26
Replace by the current SID which is for example C11.
Example:
cd \usr\sap\trans\bin
\usr\sap\C11\SYS\exe\run\tp addtobuffer P21K000123 C11
usr\sap\C11\SYS\exe\run\tp tst P21K000123 C11
\usr\sap\C11\SYS\exe\run\tp import P21K000123 C11 U26
c) AS400: Already completed by the command above.
- A prerequisite for the import is that the periodic background job RDDIMPDP has been scheduled in the target system (see manual BC System Administration, Appendix D).
- Specifying unconditional modes 2 and 6 (u26) results in original objects and objects in unconfirmed repairs being overwritten as well. If the "tp tst" call (test import) ends with return code 8 as a result of such objects, we recommend the release of the open repairs before the import so that the corresponding versions of the modified objects will be generated in the version database.