Here's the fix (allegedly)......
Summary: ODBC Unable to allocate disk block for temp table use
[MM-No data block] (7631)
Book: Support Solutions
Page: 6311MPS
PROBLEM DESCRIPTION: Generating Crystal Report using the SQL-92 ODBC
driver and is getting the error:
"Unable to allocate disk block for temp table use [MM - No data
block] ( 7631 )"
It appears the Temp file M00AB.... file created in the PROWORK directory
by the ODBC process gets to 500MB and the error message is generated.
The SQL-92 SQL server process while executing a query or command needed
to use SQL temp tables. Temp tables are used for aggregation, sorting,
update statistics usage, etc. The SQL server needed to allocate a disk
block for some temp table, but failed in the allocation. Among the
possible reasons are: disk space not available in chosen work
directory, SQL configuration limit on disk space exceeded, IO failure on
disk device.
PROBLEM RESOLUTION:
=====================
Add the following System Environment variable to the machine where the
ODBC DSN is running. (For V8.03, this would be the V8.03 server.)
After adding the Variable and Value, reboot the workstation.
Size of MM on disk backing store. Default 500000KB.
--> System Environment variable: TPE_MM_SWAPSIZE=
STEPS:
1) At the machine, right mouse click on "My Computer", select
"Properties"
2) Click on the Environment tab.
3) Click into the "System" section
4) At the bottom of the screen, type in the following information
for the Variable and Value fields:
Variable: TPE_MM_SWAPSIZE
Value: 1000000
Set the value size in KB. Using 1000000 will give you 1 gig. The
default value is 500000 KB or 500 MB.
5) After adding this to your system environment, you will need to
reboot the workstation.
6) The database needs to be restarted to take this change into account.
This will reset the previous connection parameters.
** See doc 3863MPS on how to set the WRKDIR. This will need to be done
at the server.
ADDITIONAL Workstation VARIABLES:
===============================
Size of MM memory buffer. default 1000 KB.
System Environment variable: TPE_MM_CACHESIZE=
Size of MM datablocks (page size). Default 7KB.
System Environment variable: TPE_MM_BLOCKSIZE=7
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Doma Reddy
Sent: Tuesday, July 13, 2010 10:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress ODBC Error - [OPENEDGE] Unable to
allocate disk block for temp table use [MM - No Data Block] 7631
We need to apply the filters to reduce the data for display on the
crystal. This happens when trying to develop an ODBC report with complex
calculations.
The return data set has to be minimized.
Thanks,
Doma Reddy
--- On Tue, 7/13/10, Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40timco.aero> > wrote:
From: Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40timco.aero> >
Subject: [Vantage] Progress ODBC Error - [OPENEDGE] Unable to allocate
disk block for temp table use [MM - No Data Block] 7631
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Tuesday, July 13, 2010, 8:50 AM
[OPENEDGE] Unable to allocate disk block for temp table use [MM - No
Data Block] 7631
I was using ODBC to create a complex report not do-able in a BAQ.
The query has a couple Left Joins in it. It worked until I added the
2nd LJ and then the ODBC blew back this message:
[OPENEDGE] Unable to allocate disk block for temp table use [MM - No
Data Block] 7631
I am assuming the result-set is rather large. Is there a way to
circumvent/fix this error...... Progress gurus..... hello? :-)
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Summary: ODBC Unable to allocate disk block for temp table use
[MM-No data block] (7631)
Book: Support Solutions
Page: 6311MPS
PROBLEM DESCRIPTION: Generating Crystal Report using the SQL-92 ODBC
driver and is getting the error:
"Unable to allocate disk block for temp table use [MM - No data
block] ( 7631 )"
It appears the Temp file M00AB.... file created in the PROWORK directory
by the ODBC process gets to 500MB and the error message is generated.
The SQL-92 SQL server process while executing a query or command needed
to use SQL temp tables. Temp tables are used for aggregation, sorting,
update statistics usage, etc. The SQL server needed to allocate a disk
block for some temp table, but failed in the allocation. Among the
possible reasons are: disk space not available in chosen work
directory, SQL configuration limit on disk space exceeded, IO failure on
disk device.
PROBLEM RESOLUTION:
=====================
Add the following System Environment variable to the machine where the
ODBC DSN is running. (For V8.03, this would be the V8.03 server.)
After adding the Variable and Value, reboot the workstation.
Size of MM on disk backing store. Default 500000KB.
--> System Environment variable: TPE_MM_SWAPSIZE=
STEPS:
1) At the machine, right mouse click on "My Computer", select
"Properties"
2) Click on the Environment tab.
3) Click into the "System" section
4) At the bottom of the screen, type in the following information
for the Variable and Value fields:
Variable: TPE_MM_SWAPSIZE
Value: 1000000
Set the value size in KB. Using 1000000 will give you 1 gig. The
default value is 500000 KB or 500 MB.
5) After adding this to your system environment, you will need to
reboot the workstation.
6) The database needs to be restarted to take this change into account.
This will reset the previous connection parameters.
** See doc 3863MPS on how to set the WRKDIR. This will need to be done
at the server.
ADDITIONAL Workstation VARIABLES:
===============================
Size of MM memory buffer. default 1000 KB.
System Environment variable: TPE_MM_CACHESIZE=
Size of MM datablocks (page size). Default 7KB.
System Environment variable: TPE_MM_BLOCKSIZE=7
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Doma Reddy
Sent: Tuesday, July 13, 2010 10:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress ODBC Error - [OPENEDGE] Unable to
allocate disk block for temp table use [MM - No Data Block] 7631
We need to apply the filters to reduce the data for display on the
crystal. This happens when trying to develop an ODBC report with complex
calculations.
The return data set has to be minimized.
Thanks,
Doma Reddy
--- On Tue, 7/13/10, Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40timco.aero> > wrote:
From: Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40timco.aero> >
Subject: [Vantage] Progress ODBC Error - [OPENEDGE] Unable to allocate
disk block for temp table use [MM - No Data Block] 7631
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Tuesday, July 13, 2010, 8:50 AM
[OPENEDGE] Unable to allocate disk block for temp table use [MM - No
Data Block] 7631
I was using ODBC to create a complex report not do-able in a BAQ.
The query has a couple Left Joins in it. It worked until I added the
2nd LJ and then the ODBC blew back this message:
[OPENEDGE] Unable to allocate disk block for temp table use [MM - No
Data Block] 7631
I am assuming the result-set is rather large. Is there a way to
circumvent/fix this error...... Progress gurus..... hello? :-)
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]