Input history on SAP GUI is not displayed - Learn from my SAP Consultant experiences

Today a user talk to me complaining the input history on SAP GUI is not displayed after his pc hard drive formatted and reinstalled. I try to help by doing a check customizing of local layout. Find this icon to see customizing of local layout. I see the history radio button has been set on. It means the customizing is oke. But why the input history is still not displayed?

Then I try asking the SAP expert and searching on internet. Here some solution offering form the SAP Experts:

Log out of SAP–>close the logon pad–> In the directory: C:Documents and Settings*yourlogonname*SapWorkDir, deleted or rename the file named SAPHistory*yourname*.mdb–> Log back into SAP and start creating history. Your history should start builing now.

Another solution to display input history on SAP GUI:

Follow the below steps:

1. Locate mdac.inf under C:Windowsinf (Generally this is a hidden folder. Also windows folder might be named as WinXP).

2. Right-click the file mdac.inf and click Install.

3. When prompted for adcjavas.inc, point to C:Windowsservicepackfilesi386

4. When prompted for the file handler.reg, either point to C:Program FilesCommon FilesSystemmsadc

5. When prompted for MDACRdMe.htm, point to C:Program FilesCommon FilesSystemAdo. If it not present rename the file MDACReadme.htm to MDACRdMe.htm.

6. When prompted for oledbjvs.inc, point to C:Program FilesCommon FilesSystemOle DB.

7. When prompted for mssoap1.dll, point to C:Program FilesCommon FilesSystemMSSoapBinaries or C:Program FilesCommon FilesMSSoapBinaries

8. When prompted for mssoapr.dll, point to C:Program FilesCommon FilesSystemMSSoapBinariesResources1033 or C:Program FilesCommon FilesMSSoapBinaries Resources1033

9. If any of the above files not found then look for the file in Windows Installation CD

I follow the above steps since the the user said that Windows Operating System on his PC is refreshed (new installation) including SAP GUI. I guess the input history in SAP GUI  is not displayed because the Windows is not full installation. There are some objects not installed. Finally after follow all the steps, the input history on SAP GUI is displayed and user very happy.

From the internet, I also got SAP Notes related to this case: 199527 – Input history for SAP GUI for Windows.

Here the explanation:

Symptom

The input history is not displayed in SAP GUI 620 or there are information requirements.

Reason and Prerequisites

A number of requirements must be met in order to display the input history.

• At least patch 20 of SAP GUI 6.20 should be installed.

• The Microsoft components MDAC and MSJET must be installed correctly.

• The user must have logged on under a user name in Windows.

• The machine must have a name.

• For the connection to R/3, the low speed connection must not be set in SAP Logon; see Note 161053. If the low speed indicator is set, a respective warning is displayed on the page “Local data” in the options dialog.

• In R/3 Release 3.1i, the history does not work in table controls, because no field names are transferred.

Solution

Depending on the problem, you must check different points:

• If the history is not shown at all:

• Check MDAC/MSJET installation

In SAP GUI 6.20, ADO is used instead of the DAO components, because DAO is not compatible with the new multi-threading architecture of the SAP GUI, as described in Microsoft Knowledge Base article Q169395.

ADO requires two components: MDAC and MSJET. Up to MDAC 2.5, MSJET was part of MDAC. Since MDAC 2.6, MDAC and MSJET are shipped separately, as described in Microsoft Knowledge Base article 271908.

You can check the installation of MDAC using the Microsoft Component Checker as described in Note 620677.

If MDAC does not exist, you can install MDAC 2.5 using the SAP GUI installation as described in Note 568119.

Alternatively, more current versions of MDAC are also available at the URL mentioned above. As mentioned, note that MSJET must be installed separately in the current MDAC versions.

• Checking the options

You can set the history options under Local Data in the option dialog box of the GUI.

The runtime shows when entries will be regarded as obsolete and deleted.

The maximum file size of the locally stored database must be larger than 0, since otherwise the history will not be available.

The maximum number of entries shows how many values are to be saved for each input field. Permitted values are numbers between 1 and 20 (as of GUI 7.10 Patch 10, numbers between 1 and 99; the default value for this patch is 20). The history is saved in the folder for local data. This folder must exist and it must be possible to write to it.

Option changes will be activated after restarting the GUI.

• If the history is still not displayed…

Check whether the folder mentioned under options contains files with the names SapHistory*.mdb and SapHistory*.ldb, delete these files and restart the GUI. Unfortunately, existing history entries will be lost in the process.

Create a trace:

In the file sapfront.ini in the Windows directory, add the following entry:

[Trace]

Mode=0×00000307

Components=Local DB

Then make sure that the trace is switched off in the options dialog, because otherwise the settings in the sapfront.ini will not be used.

These settings will become active after restarting the GUI. After creating the trace file, the trace can be switched off again by setting Mode=0.

• Errors in the trace

If errors occur in the trace created above that indicate access to or creation of the DB, check the MDAC installation. Instructions are available in Note 931540.

• MDAC installation seems correct/still no history available

If you tried to repair the MDAC installation in accordance with Note 931540, but the histoy is still not displayed: Note 1176026 contains a minimal test program to create an Access DB on your PC. If this also fails, we recommend contacting Microsoft Support.

• If the history is not shown individual fields:

The history does not support input fields whose field names or input length exceed a certain size. This is described in detail in Note 399180.

If input history on SAP GUI is not displayed, better you try to follow instruction from the SAP Notes.

Tags: Input history * SAP GUI *

Filed under: General

Like this post? Subscribe to my RSS feed and get loads more!