Database Connector Error Vantage 8.00.809g

Yahoo Archive
1
I've had this problem before and it is usually a link error.
Carefully check all your links.


--- In vantage@yahoogroups.com, "jonesdj55" <djones@...> wrote:
>
> Hello, I am trying to create a Crystal Report XI report but am
> getting the error "Failed to retrieve data from the database."
When
> I click OK I get the error:
>
> Database Connector Error: 'HY000:[DataDirect][ODBC OPENEDGE driver]
> [OPENEDGE]Unable to allocate disk block for temp table use [MM -
No
> data block] (7631) [Database Vendor Code: -16001 ]'
>
> The report involves the POHeader, PODetail, PORel, and Vendor
> tables. I am reporting by Vendor, the PODetail(PONum, PartNum,
> LineDesc, OrderQty, UnitCost) and PORel(ExpChart, DueDate)
> information with a calculated field (OrderQty * UnitCost).
>
> I have gotten this error before but when I changed a link between
> the various tables (detail to head vs. head to detail) the report
> worked.
>
> This seems to be a problem with the complexity and size of the
data.
>
> Do I need to setup a temporary work space?
>
> Any help would be appreciated.
> Thanks
> djj
>
2
Hello, I am trying to create a Crystal Report XI report but am
getting the error "Failed to retrieve data from the database." When
I click OK I get the error:

Database Connector Error: 'HY000:[DataDirect][ODBC OPENEDGE driver]
[OPENEDGE]Unable to allocate disk block for temp table use [MM - No
data block] (7631) [Database Vendor Code: -16001 ]'

The report involves the POHeader, PODetail, PORel, and Vendor
tables. I am reporting by Vendor, the PODetail(PONum, PartNum,
LineDesc, OrderQty, UnitCost) and PORel(ExpChart, DueDate)
information with a calculated field (OrderQty * UnitCost).

I have gotten this error before but when I changed a link between
the various tables (detail to head vs. head to detail) the report
worked.

This seems to be a problem with the complexity and size of the data.

Do I need to setup a temporary work space?

Any help would be appreciated.
Thanks
djj
3
This is more than likely due to your report creating a swap file larger
than the default 500MB in the progress working directory



The report will use this for sorting and grouping the data for your
report



You can resolve it by adding a swap file parameter in the environmental
settings on your server

TPE_MM_SWAPSIZE 2000000 (this one would be for a 2GB Limit)



You will have to restart your server after setting it



Gary



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jonesdj55
Sent: 23 February 2007 15:10
To: vantage@yahoogroups.com
Subject: [Vantage] Database Connector Error Vantage 8.00.809g



Hello, I am trying to create a Crystal Report XI report but am
getting the error "Failed to retrieve data from the database." When
I click OK I get the error:

Database Connector Error: 'HY000:[DataDirect][ODBC OPENEDGE driver]
[OPENEDGE]Unable to allocate disk block for temp table use [MM - No
data block] (7631) [Database Vendor Code: -16001 ]'

The report involves the POHeader, PODetail, PORel, and Vendor
tables. I am reporting by Vendor, the PODetail(PONum, PartNum,
LineDesc, OrderQty, UnitCost) and PORel(ExpChart, DueDate)
information with a calculated field (OrderQty * UnitCost).

I have gotten this error before but when I changed a link between
the various tables (detail to head vs. head to detail) the report
worked.

This seems to be a problem with the complexity and size of the data.

Do I need to setup a temporary work space?

Any help would be appreciated.
Thanks
djj





[Non-text portions of this message have been removed]