×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Insufficient memory tu run this query

Insufficient memory tu run this query

Insufficient memory tu run this query

(OP)
Hi there !! i newly on this i hope if any one could help me !!!
    
I have i report that have a lot of metrics about 20
an run fine when in the report options the join type is
inner join , but i wat to do this with outer type.
when i run the report its fails with err:

i dont think about the memory , becouse  i ran other
query more bigger than its.


thanks in advance

FIdel

Report: RESUMEN INDICADORES

Status: Execution failed

Error: QueryEngine encountered error: Call SQLExecDirect got SQL_ERROR
[37000:701: on HSTMT] [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system memory to run this query.

Error in Process method of Component: QueryEngineServer, Project 5, Job 70, Error Code= -2147212544.


Starting Time: 11:27:58

RE: Insufficient memory tu run this query

You have quite a few options here...

First, Try using 'page-by' on the report to restrict the number of rows returned to the desktop.  To do this, drag an attribute up to the page-by field.  This will reduce the number of rows returned to the client.  You could also filter your report by some of the attribute elements....

The server has several settings that can be tweaked, i.e. max number of rows.  Also, the SQL Server ODBC driver has its own settings that can be adjusted if the physical size of the query is too big.  

What version of MSTR are you using?
Are you running everything off of one machine, or are the machines separated?

RE: Insufficient memory tu run this query

(OP)
i will try to reduce the numbers of rows filtering,

about the MSTR version is 7.2.0 and run everthing in one machine.

Could you give me some kind of MSTR configuration?.

thanks.

P.S. Im having some problems to login to the page
could you send me CC to fsilva@gnm.com.mx

regards

RE: Insufficient memory tu run this query

(OP)
its works filtering the report , for now i use i prompt
but i have i question.

If i increase the number of rows of a report this will work?


thanks cael

RE: Insufficient memory tu run this query

this looks like a SQL server error, actually.  The following troubleshooting steps will verify it.

1)  instead of running the report, view sql instead.
2) copy and paste the sql into another tool accessing sqlserver directly.  maybe in SQLServer enterprise manager.

if the same error occurs it's a sqlserver problem, get your admin to tweak sqlserver.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close