Problems while opening the query in Analysis

[Former Member]

Good morning Gurus.

I have a problem while opening a query in MS Analysis. It is as follow:

Termination message sent

ERROR BRAIN (252): Query definition 006EJIGNIQ3QKXLCM4059LQ2L could not be read.

  MSGV1: 006EJIGNIQ3QKXLCM4059LQ2L

ABEND BRAIN (635): Query APV_M02_PLN223_QR001 could not be opened.

  MSGV1: APV_M02_PLN223_QR001

I recon the problem is in the object 006EJIGNIQ3QKXLCM4059LQ2L. I collect he necessary objects for transport in rsa1, but the object wasn't in the list.

I've found it in se03 and it was successfully transported to the test system before.

Can anyone help in resolving the issue?

Tnx in advance. 

PS: I was forwarded here from MS Analysis section:)

[former_member182470 · Accepted solution]

Just get into the edit mode of your query and activate it.

RSA1-->Transports-->Object Types-->Query Elements-->Collect your query and drag it to right side-->Click on Bex truck-->Create a new request, don't collect with in the old req-->You should see green light finally.

[Former Member · Accepted solution]

Hey Suman, thanks for the replay.

As I said, I tried to use Transport tool within RSA1 and cillect all required objects and transported the query again but still I've got that type of error

[former_member182470 · Accepted solution]

Do one thing. Delete the query from your Qua by using RSZDELETE t-code.

Collect freshly in DEv and move to Qua. After that, try to access through MS Analysis.

[Former Member · Accepted solution]

Nope. Did as you've said, no changes.  Same error occures again.

[former_member182470 · Accepted solution]

Generate your query in RSRT in Qua system. execute the query in RSRT. Try to access again from MS analysis..

[Former Member · Accepted solution]

Just deleted the report from both systems and created a new one .... Anyway tnx for help.

[former_member182470 · Accepted solution]

Can you close the thread?

[Former Member]

Have you tried to run program ANALYZE_RSZ_TABLES?!

This can give you hints as to why your query isn't accesable anymore. We had a case, where, for some reason, an Element used in a Formula didn't exist anymore, thus all queries using this element couldn't be accessed anymore.

[krishnendu_narayanan]

Thanks Daniela Bartlick,

Your solution solved my problem of "ERROR BRAIN (252): Query definition xxxxxxxxxx."

[Former Member]

It's not that you got problem with query import into Quality.

The error message shows that system is unable to read the query definition.

Go to quality system, open RSRT, In the menu bar, Environment -> Generate Query directly.

Give your query name and check whether your query has been regenerated successfully.

Br, H

[Former Member]

This message was moderated.

[yasemin_kilinc]

Hi Eldar,

Did you try transporting only the object which the error is about?

Regards

Yasemin...

[Former Member]

Hi Eldar,

As told by Suman,

Collect the query again and transport it so that have the active Query.

rgds

SVU