Question:
Hi CHC,EL,SBOB Help Urgent,
system :- BW 3.0b
After loading the data(27,000 rows) in ODS m trying to run a query ,but my excel gets hanged.
If i try to run another query it works well ,what could be the problem?
Thnkx in Advance
GuestBW
Answer:
Hi
M in to BW TEST Environ.
If i try to run query on other ODS it works fine.
help me out
GuestBW
Answer:
so few informations
try to restrict your query to a small subset of values using the key and see what happens
Answer:
Other possible problem:
Did you defined some variables for your query. If so, do you get the selection screen? If not, the selection screen 'jumps to the background', via ALT+TAB you can find your selection screen.
This can be prevented via a higher GUI patch level.
Answer:
what could be the problem?
you might be asking too much data at once?
Answer:
Thnkx El,Frank
Yes i do get the selection screen and its coming proper ,but even after giving small range my excel gets hanged.
Thnkx
GuestBW
Answer:
What is your SAPGUI version and Patch level?
Answer:
Hi SBOB
GUI is 6.2
SP level is 12
Also m facing this prob in Test and not in Dev for same query any clue??
thnkx
SAPBW
Answer:
it might still be that your "small" selection, selects too many records on the productive system...
try the same selection via InfoCube maintenance directly on the InfoCube and see how long it takes there
cheers,
El Belgio
Answer:
Hi EL
It throws query in few seconds both with and without selection of range values in INFOCUBE MAINTENAINCE.
so what could be the prob now in excel
Thnkx
GuestBW
Answer:
Hi El
FYInformation
Back end SP is 10 how do u find GUI SP,i meanwhat transaction??
Also sometimes gimme error below
BWT:SAP System Message"
"Maximum number of sessions reached."
thnkx
GuestBW
Answer:
Hi CHC,EL
Any thoughts on this
thnkx in adv
GuestBW
Answer:
Hi GuestBW
Whats the last error it gives,does it completely hang or shows some records and hangs in middle check the status in WINDOWS TASK MANAGER.
Chetan
Answer:
Hi Chetan,
I kept runnin query for 1 min after that saw status NOT RESPONDING in Task manager and then ended that task.
GuestBW
Answer:
did you at least TRY to leave running for more than one minute ???
"not responding" does not mean "not doing anything"
I sometimes had queries running up to 15 minutes (no comment about that) before showing up the result
Ch