Question Re: Problems while opening the query in Analysis in Technology Q&A

Problems while opening the query in Analysis

Former Member — Fri, 19 Jul 2013 06:44:59 GMT

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:)

Re: Problems while opening the query in Analysis

former_member182470 — Sun, 21 Jul 2013 15:40:19 GMT

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.

Re: Problems while opening the query in Analysis

Former Member — Sun, 21 Jul 2013 18:27:24 GMT

Hi Eldar,

As told by Suman,

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

rgds

SVU

Re: Problems while opening the query in Analysis

Former Member — Mon, 22 Jul 2013 07:08:23 GMT

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

Re: Problems while opening the query in Analysis

former_member182470 — Mon, 22 Jul 2013 07:27:40 GMT

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.

Re: Problems while opening the query in Analysis

Former Member — Mon, 22 Jul 2013 08:23:34 GMT

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

Re: Problems while opening the query in Analysis

former_member182470 — Mon, 22 Jul 2013 08:40:17 GMT

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

Re: Problems while opening the query in Analysis

Former Member — Mon, 22 Jul 2013 15:25:13 GMT

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

Re: Problems while opening the query in Analysis

yasemin_kilinc — Tue, 23 Jul 2013 06:39:58 GMT

Hi Eldar,

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

Regards

Yasemin...

Re: Problems while opening the query in Analysis

Former Member — Tue, 23 Jul 2013 09:57:39 GMT

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

Re: Problems while opening the query in Analysis

former_member182470 — Tue, 23 Jul 2013 18:00:28 GMT

Can you close the thread?

Re: Problems while opening the query in Analysis

Former Member — Thu, 06 Feb 2014 10:16:56 GMT

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.

Re: Problems while opening the query in Analysis

krishnendu_narayanan — Fri, 08 Aug 2014 06:21:13 GMT

Thanks Daniela Bartlick,

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

Re: Problems while opening the query in Analysis

Former Member — Thu, 24 Mar 2016 20:50:38 GMT

This message was moderated.