How To Fix ILM_STOR689 - Specify connection type in the form @

SAP Error Message - Details

• Message type: E = Error

• Message class: ILM_STOR -

• Message number: 689

• Message text: Specify connection type in the form @

What causes this issue?

A valid connection to a storage storage system in the ILM Store consists
of two things: The connection ID and the ID of the connection type.
For example, the database connection to SAP IQ in DBCO can be created as
follows:
Connection Name: IQCONN
Database system: SIQ

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

If you want to return your own specific connection, both values are
required. To do so, these values are combined in return value EV
_CONN_TYPE and separated with '@'. In the above example, the correct
return value would be 'IQCONN@SIQ'.
In the existing case, however, the returned valued does not correspond
to the specification.

System Response

The execution of the current command is terminated.

How to fix this error?

Change the BAdI implementation in such a way that if your own connection
to a storage system is to be returned, this happens as expected.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ILM_STOR689 - Specify connection type in the form @ ?

  The SAP error message ILM_STOR689 indicates that there is an issue with the connection type specified for the database connection in the context of Information Lifecycle Management (ILM). The error message suggests that the system expects a connection string in the format <DBCON>@<CONN_SYS>, where <DBCON> is the database connection name and <CONN_SYS> is the connection system.
  Cause:
  
  Missing Connection Type: The error typically occurs when the connection type is not specified correctly in the configuration settings for ILM.
  Incorrect Configuration: The database connection might not be set up properly in the SAP system, or the connection string is incorrectly formatted.
  System Configuration Issues: There may be issues with the underlying database or the connection settings in the SAP system.
  
  Solution:
  To resolve the ILM_STOR689 error, follow these steps:
  
  
  Check the Connection Configuration:
  
  Go to transaction DBACOCKPIT or SM59 in SAP.
  Verify that the database connection (DBCON) is correctly defined and active.
  Ensure that the connection type is specified in the format <DBCON>@<CONN_SYS>.
  
  
  
  Update ILM Configuration:
  
  Navigate to the ILM configuration settings in your SAP system.
  Ensure that the connection type is correctly specified in the relevant ILM settings.
  If necessary, update the configuration to include the correct connection string.
  
  
  
  Test the Connection:
  
  Use the connection test feature in SM59 to ensure that the connection to the database is working correctly.
  If the connection fails, troubleshoot the database connectivity issues.
  
  
  
  Check Authorization:
  
  Ensure that the user has the necessary authorizations to access the database and perform ILM operations.
  
  
  
  Consult Documentation:
  
  Refer to the SAP documentation for ILM and database connections for any specific requirements or configurations that may be needed.
  
  
  
  Contact SAP Support:
  
  If the issue persists after checking the configuration and testing the connection, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  ILM (Information Lifecycle Management): A framework in SAP for managing data retention and archiving.
  DB Connection (DBCON): A defined connection to a database that allows SAP systems to communicate with the database.
  Transaction Codes: Familiarize yourself with relevant transaction codes like SM59 (RFC Destinations) and DBACOCKPIT (Database Administration) for managing database connections.
  
  By following these steps, you should be able to resolve the ILM_STOR689 error and ensure that your SAP system can properly connect to the database for ILM operations.