I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Reports Topic   Print This     

data threshold on reports?

data threshold on reports? in Paradox Reports topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: threshold   reports   data threshold   data threshold reports  
GreatDivideIT
Great Divide IT Consulting LLC
-- USA

My client closed a large amount of jobs in November and cannot generate reports. The error is '#Record_band is too big'.

They are able to use the same report but for a different time period. For example, reports from Jan thru July work.

Is there a setting we can change that will accommodate a larger dataset? 

Thanks!

Tim Albertson
Great Divide IT Consulting LLC
2995 Skyline Blvd.
Suite # 208
Reno, NV 89509
tim@greatdivideit.com
775-229-4415 (direct)
775-636-5047 (mobile)
775-229-4398 (fax)
www.greatdivideit.com

 Posted 118 days ago (Thread Starter)
Comment Quote
About GreatDivideIT -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17362, 6 replies
Thread Started 12/27/2018 12:56:24 PM
View Counter=176
Last Reply Posted 1/10/2019 5:29:06 AM)
Location=-- USA 
Joined=6 months ago   MB Posts=7  
Moderator
Steven.G
Myrtle Beach, SC USA

"too big" refers to the actual size of the record band within the report spec, not the number of records associated with it

the same physical report file (rsl) with a code-generated and/or user-generated date range? shouldn't matter

two different saved versions of the same report? one file is damaged, the other is not.. kinda like the report is too big for an 8.5 x 11 page, but within the report design, not the output from the report.. a parameter is out of range

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 118 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17364 (Level 2) and Parent is 17362
Reply Posted 12/27/2018 1:18:39 PM
Location=Myrtle Beach, SC USA 
Joined=31 months ago   MB Posts=259  
Moderator
Steven.G
Myrtle Beach, SC USA

I can't save the design with a parameter out of range, that's why I suggest damaged file

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 118 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17365 (Level 3) and Parent is 17362
Reply Posted 12/27/2018 1:28:13 PM
Location=Myrtle Beach, SC USA 
Joined=31 months ago   MB Posts=259  
GreatDivideIT
Great Divide IT Consulting LLC
-- USA

So it's possible that a parameter is out of range? Where would we look? 

 Posted 105 days ago (Thread Starter)
Comment Quote
About GreatDivideIT -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17379 (Level 4) and Parent is 17362
Reply Posted 1/9/2019 10:36:47 AM
Location=-- USA 
Joined=6 months ago   MB Posts=7  
Moderator
Steven.G
Myrtle Beach, SC USA

if it's a damaged report spec file, you can't look.. in theory, you shouldn't be able to open it.. never actually had that happen

if it's damaged, and you can replace it, and everything seems ok, you're fine.. if not, this might be much more complicated.. do you know the name of the file? the extension is .rsl

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 105 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17380 (Level 5) and Parent is 17362
Reply Posted 1/9/2019 12:37:53 PM
Location=Myrtle Beach, SC USA 
Joined=31 months ago   MB Posts=259  
GreatDivideIT
Great Divide IT Consulting LLC
-- USA

I just reviewed with the end user and observed the following:

  1. it's a custom report (.rsl) which returns the following error "#Record_Band is too big to fit in report" if the Query (.Qbe) date range is >=01/01/2018, <=01/01/2019
  2. When we change the date range to >=01/01/2018, <=07/01/2019 it opens without issue.

The only other new information is that the customer closed a lot of jobs in November. They close jobs in 2 tables (jobs.db, invinfo.db). It won't generate in the reports unless it's closed in both db's. 

This is the first time I have watched this process. A lot of human intervention. High margin for error. 

 Posted 105 days ago (Thread Starter)
Comment Quote
About GreatDivideIT -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17381 (Level 6) and Parent is 17362
Reply Posted 1/9/2019 10:36:47 AM
Location=-- USA 
Joined=6 months ago   MB Posts=7  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

> A lot of human intervention. High margin for error. 

yes.. welcome to the wonderful world of self-made apps.. I've been cleaning up behind folks for almost 30 years (sigh)

when different query parameters on the same table sometimes work / sometimes fail, it usually just means the indexes for that table are hosed.. only a temporary show-stopper, once you know how to deal with it

Alison said you called last night, I'll try to call you back this afternoon

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 104 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17384 (Level 7) and Parent is 17362
Reply Posted 1/10/2019 5:24:34 AM
Location=Myrtle Beach, SC USA 
Joined=31 months ago   MB Posts=259  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1244A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17362 Counter
176
Since 12/27/2018
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech