DataSource.Error: The SAP BW server reported an error: 'Allocation failed

[SNumphud]

Hi,

I'm trying to get the data from a query in SAP BW HANA. However, there is one field that causing the issue as shown below. There is no issue with the other field as I can select and load it into the report.

I used to create the report with this query before, but somehow when I try to refresh the data today it shows the error message.

Please let me know if there is any information else that I need to provide.

DataSource.Error: The SAP BW server reported an error: 'Allocation failed ; $size$=144194406136; $name$=expr; $type$=pool; $inuse_count$=7; $allocated_size$=4472; $alignment$=8; ...'. To find more information about this error, visit the SAP support site and search for 'DBMAN 099'.
Details:
DataSourceKind=SapBusinessWarehouse
DataSourcePath=10.20.1.155/01/910
ID=DBMAN
NUMBER=099
MESSAGE_V1=Allocation failed ; $size$=144194406136;
MESSAGE_V2=$name$=expr; $type$=pool; $inuse_count$=7;
MESSAGE_V3=$allocated_size$=4472; $alignment$=8;
MESSAGE_V4=...
SYSTEM=BDPCLNT910
Command=SELECT
{
[Measures].[00O2THL5LBWKXF9PUT4BDPAXJ00O2THL5LBWMN8N0BRP2CU0FT]
}ON 0,
NON EMPTY DISTINCT(
[4ZCO_C001-EBELN].[LEVEL01].ALLMEMBERS
)
PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON 1
FROM [ZCO_C001/ZCO_C001_Q0004] CELL PROPERTIES VALUE SAP VARIABLES [!V000002] INCLUDING [0COMP_CODE].[US03] [ZCV_FP1] INCLUDING [0FISCPER].[K42021008] [!V000007] INCLUDING [0CURTYPE].[10]

[v-chuncz-msft]

@SNumphud 

Try the latest version and take a look at links below.

• Use advanced options
• SAP BW connector troubleshooting