1915843 - Error "Operand data type nvarchar is invalid for sum operator" during Infocube Compression or LISTCUBE

1. The compression job of an Infocube terminated with the following error message.

System error in program SAPLRS_EXCEPTION and form RS_EXCEPTION_TO_MESSAGE

In the corresponding development trace, further information can be found:

dbdsmss: DBSL99 SQL8117
Operand data type nvarchar is invalid for sum operator.
***LOG BY2=> sql error 8117

2. When you displayed the Infocube data in transaction code LISTCUBE, it directly ran into the sql error 8117.

Operand data type nvarchar is invalid for sum operator.
SQL Error: 8117

• SAP NetWeaver Business Warehouse (BW)
• MSSQL database

"sql error 8117", "sql 8117", NVARCHAR, SAPLRS_EXCEPTION, RS_EXCEPTION_TO_MESSAGE, listcube, compress, compression , KBA , BW-BEX-OT-DBIF-CON , Condensor , BW-BEX-OT-DBIF , Interface to Database , Problem