Topic Options
#31159 - 03/03/12 04:25 AM Report table error
Mach Offline
Adagio Enthusiast

Registered: 08/07/07
Posts: 22
Loc: Nova Scotia, Canada
I just moved a client from an old Server (2003 & workstations with mapped drive to the server). Old server had Adagio installed to a mapped (K:\ drive).

To a new server - Server 2008 with all users logging in to the server using terminal services (RDP). Everything was installed on the new server to the C:\Softrak folder

I moved the Adagio folder from the old server to the new, and installed all the new modules on top.

During installation I got these error messages:

When Adagio BankRec was installed, its Report Tables drive was specified as (C:) which is a non-network drive.

WARNING! Workstations that use a non-network Report Tables drive may not access vital shared information!

and:

The Report Tables drive (C:) does not have the Adagio BankRec Tables installed invalid (\qrasp\qrtables.ini). Please check that you have selected the proper directory and if necessary, re-install Adagio BankRec.

When I go to C:\Softrak\qrasp\qrtables.ini, there's no place that I see where I can change it so that it points to the C:\ drive as the reports table drive.

Finally - just to point it out - all the modules work fine. I can open them, login, process transations, etc. The only one that won't is multicurrency - when I try to open Multicurrency, I get this error message:

The Report Tables drive [C:\] does not point to valid Reports Tables for this program.

To correct, please check with your Dealer or qualified Adagio expert to do one of the following:
1. Run the workstation setup program if you haven't already (WkSetup\WkSetup.exe);
2. Check and adjust your workstation drive mappings;
3. Run the Adagio utility \Softrak\System\SetReportsTableDrive.exe to properly set the Reports Tables drive;
4. If necessary, re-install the Adagio program.

I've already ran Wksetup, I ran the Adagio utility to set report tables, it doesn't look like it does anything.

I feel like all the above issues are 1 issue.

Where can I go to set the report tables to C:\ and have the modules not complain about that?

I've rebooted the server, reinstalled modules

Top
#31161 - 03/05/12 03:27 AM Re: Report table error [Re: Mach]
Mach Offline
Adagio Enthusiast

Registered: 08/07/07
Posts: 22
Loc: Nova Scotia, Canada
I moved over the MC*.LD4 files, and I checked the currency path in the ADSPROF.XXX file – it’s pointing to the new location (C:\Softrak\system)

I also did a reinstall, restarted their server and it’s still not working.

Anything else that I should check?

Top
#31163 - 03/05/12 06:38 AM Re: Report table error [Re: Mach]
Bob Wisener Offline
Adagio Conductor

Registered: 03/19/02
Posts: 561
Loc: Vancouver, BC
I'd recommend that you run \Softrak\System\chksys.exe for more information on the problem.
_________________________
Bob Wisener
Dakota Software

Top
#31164 - 03/05/12 06:51 AM Re: Report table error [Re: Bob Wisener]
Mach Offline
Adagio Enthusiast

Registered: 08/07/07
Posts: 22
Loc: Nova Scotia, Canada
When I run chksys I get 28 errors:


======= Checking Special System Configurations ======

WARNING: Potential Multi-user folder problem! Click View Session Details, or see Log for details.

========== Checking 32-bit System Status ==========
--- OK ---

======= Checking Report Tables Configuration =======
*** NOTE: Report Tables drive is: [C:];
Override status for user [Administrator] is [Y].

=============== Checking Products ==============
Adagio BankRec Status:
*** Configuration error - missing entry in C:\qrasp\qrtables.ini.
C:\qrasp\QRTBRW80.qrw
Date: [06/09/2011] OK.
C:\qrasp\QRTBRZ80.qrw
Date: [03/28/2007] OK.
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [04/03/2008]
C:\qrasp\QRTBRB81.qrw
Date: [06/21/2007] OK.
C:\qrasp\QRTBRZ81.qrw
Date: [03/30/2011] OK.

Adagio DataCare Status:
C:\qrasp\QRTDCW80.qrw
Date: [11/21/2010] OK.

Adagio DataCare Status:
C:\qrasp\QRTDCW80.qrw
Date: [11/21/2010] OK.

Adagio Inventory Status:
*** Configuration error - missing entry in C:\qrasp\qrtables.ini.
C:\qrasp\QRTICW81.qrw
Date: [06/10/2011] OK.
C:\qrasp\QRTICZ80.qrw
Date: [03/19/2009] OK.
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [04/03/2008]
C:\qrasp\QRTICW65.qrw
Date: [06/10/2011] OK.
C:\qrasp\QRTICZ81.qrw
Date: [05/21/2010] OK.

Adagio Ledger Status:
*** ERROR: Missing Report Table [C:\qrasp\QRTALW65.qrw]
*** ERROR: Missing Report Table [C:\qrasp\QRTALZ80.qrw]
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [10/15/2006]

Adagio Ledger Status:
C:\qrasp\QRTALW90.qrw
Date: [05/31/2011] OK.
C:\qrasp\QRTALZ90.qrw
Date: [05/31/2011] OK.
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [10/15/2006]
C:\qrasp\QRTSMZ90.qrw
Date: [10/24/2008] OK.

Adagio MultiCurrency Status:
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [04/03/2008]

Adagio OrderEntry Status:
C:\qrasp\QRTOEW65.qrw
Date: [09/09/2010] OK.
C:\qrasp\QRTOES65.qrw
Date: [09/13/2001] *** Error; Needs: [09/14/2001]
C:\qrasp\QRTOEZ80.qrw
Date: [04/23/2009] OK.
C:\qrasp\QRTARW10.qrw
Date: [04/13/2007] *** Error; Needs: [12/21/2007]
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [04/03/2008]

Adagio Payables Status:
*** Configuration error - missing entry in C:\qrasp\qrtables.ini.
C:\qrasp\QRTAPW68.qrw
Date: [11/16/2009] OK.
C:\qrasp\QRTAPZ80.qrw
Date: [03/28/2007] *** Error; Needs: [12/21/2007]
C:\qrasp\QRTAPB68.qrw
Date: [10/20/2009] OK.
C:\qrasp\QRTAPT68.qrw
Date: [12/27/2002] *** Error; Needs: [10/15/2006]
C:\qrasp\QRTAPJ68.qrw
Date: [09/13/2004] *** Error; Needs: [10/15/2006]

Purchase Orders For Adagio Status:
*** Configuration error - missing entry in C:\qrasp\qrtables.ini.
C:\qrasp\QRTIR65A.qrw
Date: [05/16/2007] OK.

Adagio Receivables Status:
*** Configuration error - missing entry in C:\qrasp\qrtables.ini.
C:\qrasp\QRTARW10.qrw
Date: [04/13/2007] *** Error; Needs: [12/21/2007]
*** ERROR: Missing Report Table [C:\qrasp\QRTARB68.qrw]
*** ERROR: Missing Report Table [C:\qrasp\QRTARZ80.qrw]
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [10/15/2006]
*** ERROR: Missing Report Table [C:\qrasp\QRTARZ81.qrw]

Adagio Receivables Status:
*** Configuration error - missing entry in C:\qrasp\qrtables.ini.
C:\qrasp\QRTARW90.qrw
Date: [06/09/2011] OK.
C:\qrasp\QRTARB90.qrw
Date: [12/16/2008] OK.
C:\qrasp\QRTARZ90.qrw
Date: [08/23/2010] OK.
C:\qrasp\QRTSMW90.qrw
Date: [11/05/2008] OK.
C:\qrasp\QRTSMZ90.qrw
Date: [10/24/2008] OK.

Adagio SalesAnalysis Status:
*** ERROR: Missing Report Table [C:\qrasp\QRTSRW68.qrw]
*** ERROR: Missing Report Table [C:\qrasp\QRTSRZ80.qrw]
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [04/03/2008]

Adagio SalesAnalysis Status:
C:\qrasp\QRTSRW90.qrw
Date: [06/21/2011] OK.
C:\qrasp\QRTSRZ90.qrw
Date: [10/14/2011] OK.
C:\qrasp\QRTMCW80.qrw
Date: [08/12/2003] *** Error; Needs: [04/03/2008]


. . . . 28 Error(s) and 1 Warning(s) Reported.
================== Finished ===================


I know that the tables are missing - supposedly, but I'm not sure how to fix the issue.

Can I just open all of those ini files and point them to the new softrak installation directory? C:\softrak\system?

Top
#31170 - 03/05/12 08:14 AM Re: Report table error [Re: Mach]
Bob Wisener Offline
Adagio Conductor

Registered: 03/19/02
Posts: 561
Loc: Vancouver, BC
You could manually copy QRW tables, but it's better if the installs corrected the problem, with assistance from Softrak Support.
_________________________
Bob Wisener
Dakota Software

Top
#31173 - 03/05/12 08:36 AM Re: Report table error [Re: Bob Wisener]
Mach Offline
Adagio Enthusiast

Registered: 08/07/07
Posts: 22
Loc: Nova Scotia, Canada
I don't understand though - I went through the installation and chose C:\ as my report tables - why didn't they get installed?

Either way, I'll contact Softrak Support to see what they say.

Top
#31182 - 03/05/12 01:12 PM Re: Report table error [Re: Mach]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
Your Report Table drive should be he same drive that Adagio is install on. FOr a network this is not normally drive C.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#31183 - 03/05/12 01:39 PM Re: Report table error [Re: Douglas Dickie]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3612
Loc: Toronto ON, Canada
Mach:
I would have mapped K: on the terminal server and done a fresh installation to that drive letter, then copied over the data.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 61 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70650 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30