Symptom
When creating a live model(SAP BW) in SAP Analytics Cloud (SAC), below error message is popped up:
lOLayer Error: Error[lOLayer]:(#2001) Bad control character in string literal in JSON at position 331 (line 1 column 332)
Error [Protocol]:(#401) {"Messages": [{ "Type": 2, "Number": 100, "MessageClass": "BW_BICS_INA", "Text": "BW_INA_GR_LOGON_ERROR", "Details":{} }, { 'Type": 2 "Number": 101, "MessageClass": "BW_BICS_INA", "Text": "Logon error. User or password notknown"},{'Type": 2, "Number": 106, "MessageClass": "BW_BICS_INA", "Text":""}[}
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Analytics Cloud
Reproducing the Issue
- In SAC Menu, select "Modeller".
- Click "Live Model" button.
- Select "SAP BW" for "Connection Type".
- Select the live connection, error occurs.
Cause
Wrong setting in service sap/bw/ina.
Resolution
- Logon SAP BW or SAP S4/HANA system in SAP GUI and run transaction code: SICF.
- Find service sap/bw/ina and double click on it.
- Switch to change mode by clicking "Change" icon on the top left.
- Switch to "Logon Data" tab.
- Select checkbox "Use All Logon Procedures".
- Save the service.
Keywords
KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-BICS-INA , BW INA provider , Problem
SAP Knowledge Base Article - Public