last changed: 1st of December, 2021
while a lot of People think that nearline storage (NLS) for SAP BW/4 and information lifecycle management (ILM) for S/4 is not used by SAP customer, you punish him with the lie. Of course the usage is still possible with SAP BW and ERP as well.
To bring more light into the NLS/DTO/ILM configuration, this Blog explains some of the most repetitive error messages and most importantly their root causes.
Unfortunally, when the child has fallen into the well, then good advice is expensive. For this topic the Document – SAP First Guidance – SAP NLS Solution with SAP IQ 16.x is the first line of defense, as it contains the complete e2e case described in detail and continuously updated since 2013. However, it still looks like that you can nail the Document to the gate of the Cologne Dom, and there would be still hardliners saying: “but my case is different”. Hell, it is not as all errors can be reduced to the proper configuration.
Example Error Messages
here some of the most current and repetitive Error Message which occur, when you start the Process the first time in the SAP ABAP Backend (despite which release/OS/DB/etc.)
Three Kind of Error Message could rise:
[IQ Error SQL-771:HY000][Sybase IQ]Event 'BACKUP_REQUEST' not found [IQ Error SQL-1090:08004][Sybase IQ]Function 'substr' has invalid parameter '3' ('-1') SQLCode = -121: Permission denied: you don't have the permission to create objects in dbspace IQ_SYSTEM_MAIN (refers to DB Option Enable_LOB_Variables) CL_RSDA_ADSO_ARCHIVING_REQUESTCM01Q (refers to IQ backup problems, Note 2741824) CL_RSDA_DAP_A=================CM02A (refers to RSDAP activation/prod. usage) CL_RSDA_NEARLINE_CONNECTION===CP (refers to missing NLS connection) CL_RSDA_NEARLINE_OBJECT=======CM00Q (refers to IQ lock mode problems after copy) CL_RSDA_NEARLINE_OBJECT=======CM01B (refers to IQ configuration problems) CL_RSDA_NEARLINE_REQUEST======CM004 (refers to missing IQ Backup event) CL_RSDA_NEARLINE_WRITER=======CM002 (refers to NLS configuration RSDANLCON) CL_RSDA_NEARLINE_WRITER=======CM004 (refers to NLS DAP Size) CL_RSDA_SYB_CONNECTION_IMPL===CM006 (refers to wrong setup of RSDANLCON) CL_RSDA_SYB_CONNECTION_IMPL===CM00C (refers to Note 2482264, space problem) CL_RSDA_SYB_CONNECTION_IMPL===CM00X (refers to Note 2191066, missing backup) CL_RSDA_SYB_CONNECTION_IMPL===CM01J (refers to IQ License LOB/VLDBMGMT) CL_RSDA_SYB_CONNECTION_IMPL===CM02U (refers to missing IQ Backup event) CL_RSDA_SYB_CONNECTION_IMPL===CM03T (refers Report RSDA_CLEANUP_DTO_COLDSTORE) CL_RSDA_SYB_WRITER_STRIPED====CM002 (refers to Note 2307267, stripping) CL_RSSDA_FEDERATION_SERVICES==CM004 (refers to Note 1989436, insufficient priv.) CL_SQL_STATEMENT==============CM008 (refers to Note 2482264, space problem)
the Solution for all of this …
to make a log story short, with the following SAP Notes 99% Percent of all “individual Problems” are solved.
Note 2780668 – SAP First Guidance – BW NLS Implementation with SAP IQ
Note 3017355 – SAP IQ 16.1 SP04 PLx – correct SAPIQDB.cfg settings
Note 3094594 – Enable SAP IQ for DBACOCKPIT
Note 3085053 – Landscape Considerations for NLS and ILM
Note 3119008 – Configure SAP IQ and HANA for SDA/ODBC
to easy for you? I’m afraid to say, it is quite straight forward.
Three things to know when using NLS/DTO/ILM
I can still remember this phrase from a Swiss SAP Sales Person, a very long time ago that he can only remember three things at the time.
First: correct Setup of the SAP IQ Database
this is already a big fountain of possible error and problem sources, especially
- SAP IQ Database Options are missing or wrong
- SAP IQ Database User to the SAP ABAP Backend lacks of permissions
- SAP IQ Database Backup with Events
Q – the easy Installer for SAP IQ – would be an answer, but unfortunally of “official” as the result is “supported, but the way of the SAP IQ Database Installation is not.
Second: correct SDA/ODBC Setup to the primary Database
- is really all necessary software accessible?
- is the grant possible between the IQ remote source and the primary DB?
- are the correct variables in the correct profiles activated
- are all server restarted after the configuration?
The SDA/ODBC Setup is still a complex manual task, which could be potentially automated, or SAP IQ and HANA could be use SAP proprietary connection Methods which is not considered
Third: correct ABAP Customizing for the use case
Also this could be automated with the extension of Q – the easy Installer for SAP IQ as the SAP Host Agent is capable to do remote calls and execution to the SAP Backends, and the SAP IQ Database Installer already defined all necessary SAP Environment Variables and Informations.
If you see this, then the NLS setup is done correctly and the IQ Backup Events are in place and triggered, the IQ Database Options are set and the permissions for the affected users in SAP IQ and the primary Database are maintained correctly.
Is there a final conclusion?
for now, there is no light a the end of the tunnel in sight. Never the less, the upcoming new and improved ABAP Transaction DBACOCKPIT for SAP IQ will allow the customer to have much more analysis capabilities solving the problems by themselves also with the help of the mentioned SAP Notes above (choose the three important ones for you … ;-))
And imagine: there would be absolutely nothing to complain and everyone would be a specialist …
Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics
“I have no special talent, I am only passionately curious.”