Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PERVASIVE ERROR >>>HELP!

Status
Not open for further replies.
JRHEIN

JRHEIN

MIS
Joined
Feb 6, 2007
Messages
18
Location
US
Hello Everyone,
I'm using pervasive version psql 2000i. I've been trying to query my db and I keep getting an error I've never seen before. I know what the error is but I 'm not sure why I keep geting it. I'm combining three tables and querying ALOT of information. Below is a sample of the query I'm running and the error message. Any help with a different query structure or help with my logic would be greatly appreciated!

SELECT
PR_WCOMP.LOC_NO,
PR_WCOMP.WC_CODE,
SY_WMAST.DESCRIP,
SUM(PR_INP.AMT_1) AS Gross_Wages,
SUM (PR_WCOMP.Wc_Bbase) AS Reportable_Wages
FROM
PR_WCOMP INNER JOIN SY_WMAST ON
(PR_WCOMP.WC_CODE = SY_WMAST.CODE)

INNER JOIN PR_INP ON
(PR_WCOMP.LOC_NO = PR_INP.LOC_NO)
WHERE ........
GROUP BY
PR_WCOMP.LOC_NO,
PR_WCOMP.WC_CODE,
SY_WMAST.DESCRIP

ORDER BY
PR_WCOMP.WC_CODE
#

error message:
ODBC Error: SQLSTATE = S1000, Native error code = 0
Out of disk space writing temporary sort file.
The 'TempFileDirectory=' variable in odbc.ini can be used
to specify different drive/directories.

(I specified a different directory and freed up some space on my local drive....still get the error)

JRHEIN
IS ADMIN
 
Sort by date Sort by votes
And how much space do you have? Also, how big are your tables?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Two more things:
1. Do you have an index on the PR_WCOMP.WC_CODE?
2. What's the actual WHERE clause?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Thanks for your response mirtheil. I managed to figure out my problem. I was trying to do to many calculation at once. The tables that I was trying to query were huge and I was runnin my query on my local machine not the server. I redesigned the query to extract the info in peices and then combined later. It still took about 5 hours.
Thank you for your help!

Jonathan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ianbtheog
  • Locked
  • Question Question
Connection Manager is not running at the specified port number - Pervasive 13.31.014 - Intermittent
Replies
2
Views
838
ianbtheog
ianbtheog
dgillz
  • Locked
  • Question Question
DDF Builder for Actian fka Pervasive SQL
Replies
3
Views
831
mirtheil
mirtheil
profoundhypnotic
  • Locked
  • Question Question
How to read a csv file in Pervasive?
Replies
1
Views
876
mirtheil
mirtheil
ianbtheog
  • Locked
  • Question Question
Error Code 7009: Data is unavailable when using DTO
Replies
3
Views
794
mirtheil
mirtheil
michellepace
  • Locked
  • Question Question
Source control for pervasive? (git)
Replies
1
Views
542
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top