Query reading the data

[former_member283158]

Hi  all,

we are involved in a SAP BW Upgrade 7.0 --> 7.3.

During the manual follow up steps,  we are trying to launch some  Bex query to test if all works fine.

Some of this queries returns us the following  message:

Query XXX reading the data;

the extended message says:

DiagnosisXXX

You need to replace variable XXX from as a boolean value. It can therefore only have the values 0 and 1.

Entering (MWKZ = , WAERS = , ...) under Currency/Unit is therefore not advisable. Only dimension = number is allowed.

System Response

The query cannot be generated and executed.

Procedure

Change the definition of the variables.1.

Procedure for System Administration

Our SAP BW System is Version 7.3 support package 10.

We found just the note   1873747  that seems like our message error but, unfortunately, the note itself have been just released with our support package  (SAPKB73010).

Anyone have an idea?

Thx in advance

Best regards

Rino

[Former Member · Accepted solution]

Hi Gennaro,

you have to suppress the message.

this note solves your problem

1937470 - Brain 541 Query & is reading data

In resolution you can find the following steps

1. Run RSRT transaction

2. Click on "Environment" menu

3. Select "Suppress Message"

4. Select "Others (2)"

5. Select "541 BRAIN" information message

[former_member283158 · Accepted solution]

Wow Roberto Di Matteo,

u score a goal like a soccer player!

The Solution works!

Thx

Best regards.

R.

[Former Member]

Hello all,

Yes, I agree with Robert that with suppressing the message we can avoid the failure.

But, If the message is 541, you might have skipped the data which it reads. Query which you have executed must be with missing data.

If the message is "109 - No data was found", you can suppress it.

If you want to correct the 541 message either you have to reduce the selections of query or you should increase the memory elements.

Please correct me if I am wrong.

Thanks,

Bharadhwaz

[Former Member]

Hi Do you have any exception defined in the query?
Then check that because when I was doing the upgrade from &-->7.4 I faced few errors like this and everytime I had to change these definitions as they were not valid in 7.4 as the checks are strict in the  SAP 7.4 which I also heard same for .3