Welcome, Guest. Please Login.
04/18/24 at 21:08:31
News:
Home Help Search Login


Pages: 1
Send Topic Print
Sales Report broken after 1/18/11 Update (Read 3304 times)
Missy Burke
Browser
*




Posts: 24
Gender: female
Sales Report broken after 1/18/11 Update
02/01/11 at 13:19:23
 
We have some Crystal Reports that use BKARCUST and BKARHINV. Since updating to Evo 1/18/11, the reports throw a Btrieve 22 Data Buffer Length error. There are probably some tables I should discontinue using and use new ones instead because of the new Contact Manager. Can someone tell me what those might be?
 
Is BKARCUST still an active file?
Back to top
 
 

Missy Burke
Awareness Technology, Inc.
Evo 2015.2
Pervasive 10/Win2008/Client-server
43 Full/5 DC Users
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Sales Report broken after 1/18/11 Update
Reply #1 - 02/01/11 at 14:16:55
 
BKARCUST is still the active customer file but you need to run ODBCDDF at UT-A because the file structure changed.  Then you need to recompile (or whatever the equivalent for your version of Crystal) the reports to read the new structures.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Missy Burke
Browser
*




Posts: 24
Gender: female
Re: Sales Report broken after 1/18/11 Update
Reply #2 - 02/02/11 at 11:40:52
 
Recompile, yes.  It's under Database - Verify Database in Crystal 8.5, if anyone else has this issue.
 
Thanks!
Back to top
 
 

Missy Burke
Awareness Technology, Inc.
Evo 2015.2
Pervasive 10/Win2008/Client-server
43 Full/5 DC Users
Email WWW   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Sales Report broken after 1/18/11 Update
Reply #3 - 03/08/11 at 16:31:07
 
Lynn, what other tables are affected in this way that we should know about? We've a couple hundred Crystal reports out there and I want to be sure the staff know which reports they will need to recompile beforehand so they don't take my head off after the update.
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Sales Report broken after 1/18/11 Update
Reply #4 - 03/09/11 at 08:45:36
 
It all depends what you are updating from to know which files are affected.  Most significant lately are a new index and new fields in BKARCUST and a change in the Department field size in WORKCTR.   When the update itself is processing, any file that you see counting records in and out has had a change since the version you are updating from.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Sales Report broken after 1/18/11 Update
Reply #5 - 03/10/11 at 09:13:53
 
We'll be updating from  January 2010 to January 2011 with the SP1.
Back to top
 
 

Val Feehan
  IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: Sales Report broken after 1/18/11 Update
Reply #6 - 05/19/11 at 07:31:42
 
val,
there's on option that if checked, "Verify on first refresh" located under File - Report Options. if that is checked before you save your report design, then when you do a dictionary update as a result of an update, then your report will automatically adjust it's files and fields used in the report to match with the new changes.
 
hth
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1
Send Topic Print