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

January 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
Rank: Cadet 2nd Year

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 20 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=41
Last Reply Posted 1/10/2019 5:29:06 AM)
Location=-- USA 
Joined=97 days ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

"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 20 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=28 months ago   MB Posts=233  
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

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 20 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=28 months ago   MB Posts=233  
GreatDivideIT
Great Divide IT Consulting LLC
-- USA
Rank: Cadet 2nd Year

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

 Posted 7 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=97 days ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

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 7 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=28 months ago   MB Posts=233  
GreatDivideIT
Great Divide IT Consulting LLC
-- USA
Rank: Cadet 2nd Year

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 7 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=97 days ago   MB Posts=6  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

> 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 6 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=28 months ago   MB Posts=233  
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 = P1164A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17362 Counter
41
Since 12/27/2018
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

1,939 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


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