Installation Instructions

Troubleshooting

LAN Client
  Installing the Server Application
  Installing the Client Application

WEB Client
  Installing the Web Client Application

 Web Client
 LAN Client
 LAN and Web Clients
 Administrator Program
 Custom Reports
 Upgrading from 3.1 to 4.0
 Miscellaneous

There are two steps in installing WinAward on the LAN. First, you will need to install the server and then install the client on the workstations that will be accessing WinAward on the server. The following instructions are for installing the server.

WinAward 4.0 will arrive on CD. There is no formal install program for the LAN server. The contents of the CD should be copied to a location that is to be shared out to the Application users. Make sure that your WinAward folder is placed within a share. If the WinAward application "Is" the share, it will not function properly. For example, if you were to copy WinAward to D:\Apps\WinAwardServer, the user share should be the Apps folder.

When you copy the files from the CD there are two things to be wary of. First, make sure that you are copying all files. There are three .dll files which may not be copied if your Explorer window is set to hide system files. Be sure that BAYESWEB.dll, WA_EMAIL.dll, and WA_DB.dll are all copied with the other files.

The second thing to take note of is that all files copied from a CD-ROM retain a read-only file attribute. This file setting will allow you to view and use the information copied but not make modification to it, nor delete it. It is not so important to remove this "read-only" attribute from all of the files copied, but it is necessary to remove it from the WA.mdb file. This is your data repository. You will also want to remove the "read-only" attribute from the WA.txt file as it will be used in the customization process.

Permissions on the network share for WinAward should be full control, or at a minimum change, for all users.

Back to main menu at top of page.

For running WinAward on the LAN first follow the instruction for installing the server. The following are instructions for installing WinAward on the individual workstations that will be accessing WinAward on the server.

Look to the server share where WinAward was placed. Within the WinAward folder on the Network share you will find a client Installation folder. This folder will contain four files, three of which are executable files and the fourth a .cab file. The order in which you run these executable files is this. Dcom95-12.exe will need to be run on any Windows95 machine. Dcom has been built into Windows98, Windows200 and WinNT. (If you run Dcom, it will ask you to reboot when it's installation is complete. Skip the reboot now, because you will have to reboot again after installing MFC42.exe.) Next you will need to run the MFC42.exe. Once MFC42.exe has been run, reboot the machine. You will probably be prompted to reboot, but if you are not, do so now.

Once the machine comes back up, you may run the WinAward setup application. (If you are working on a Windows NT workstation, make sure that you are logged on to the terminal as an administrator.) The setup will walk you through it's installation. It's purpose is to prepare a machine to run WinAward, not to copy the application onto the machine. The setup will run a version of MDAC (Microsoft Data Access Components), and then copy a group of files to the System (or System32) folder of your machine. With the setup complete, one step remains.

Look back to the root folder on the server for WinAward. There are three .dll files found there: bayesweb.dll, wa_email.dll, and wa_db.dll. These three files will need to be registered on each client machine. If you are feeling clever and if all of your clients will have the same drive letter mapping to this location, it may be easiest for you to write a batch file to register these .dll(s). You may also register these .dll files by dragging and dropping them on the regsvr32.exe. You will find the regsvr32.exe file in this same WinAward folder. As each dll file registers, you will receive a system reply of: "DllRegisterSever in (path to .dll file) succeeded."

The last step is to create shortcuts for the WinAward.exe and the WAAdmin.exe, if necessary, for the user.

Back to main menu at top of page.

(Recommended procedure)

1. Open the Global.asa file. It is found in the WebClient folder that you just copied into the ..\WWWRoot folder. You can open Global.asa with the Notepad text editor if you don't have a file associated with .asa and .asp files. (The following changes will be made to the WinAward options block. This is set off by a string of "*"'s surrounding the words WinAward Options.)



2. Change the "WinAward.root" to point to the location of the WA.mdb or the LAN installation where the WA.mdb is located. You just need the path with a trailing "\".

Example: Application("WinAward_Root")="S:\WinAward40\"

3. Change the application.home, exit location, from www.bayesian.com to the location users will be directed when they exit from WinAwardä.
4. Change the WinAwardHome to \WinAward or whatever you've called your virtual scripts or virtual directory. The Virtual directory is the one you've created for WinAwardä, e.g., \webclient. If WinAward is created to be it's own webpage with its own IP address then remove the text and leave only the "\".
   
5. Set the application report options. These are usually set to ASP with HTML is commented out. If you are using Crystal, you should leave it as is. If you wish to use the HTML reports then remove the apostrophe that is in front of the HTML format and place one in front of the ASP format.
   
6. Change the application login notice to read "proprietary information of ..." and your company's name rather than "Our Company."
   
7. Save and close the global.asa file.
   

Step 4: Bring up the Microsoft Management Console. If you've already placed your scripts in the wwwroot folder, you should already have a virtual directory established as an application. If you haven't, you need to set up a virtual folder that points to your WinAward script files. (Setting up a Virtual Directory below)

The console sets up a tree structure. The root of the tree branches to Internet Information Server and from there it should branch out to the server name and then under the server name the default FTP site, default Gopher site, and default web site. If you dropped your WA folder under wwwroot, it will show up in the default web site and if not you'll have to create a virtual directory that points to your WA script files.

****Most of this doesn't seem to be an issue with Crystal Reports Version 8. It does it's installation without prompting you for web server settings.****

Step 5: Install Crystal on the web server. During the installation process, after you've selected the components you will or will not install, the Crystal installation program will ask if you want to install files to support IIS or CGI. The IIS is what you want. The rest of the install should run without prompting until we reach web server port configuration. In most cases the default values work fine. If they don't, contact the person who runs the server. The ports Crystal is looking for are 2000 and 2001 and for some reason those ports are blocked off. You will have to provide a pair of ports that are open, for use with the web server.

Setting up a Virtual Directory

1. To set up the virtual folder.
2. Make a right mouse click on the default web page.
3. In the pop up menu select new and you will get an option for either site or virtual directory. Pick virtual directory. It will ask for a name for the virtual directory.
4. We strongly suggest using "WinAward" for that name since things work more smoothly that way.
5. Click on OK.
6. Enter the location of your script files (files you want to publish). This might be c:\inetpub\wwwroot\WinAward then click OK.
7. You should see a group of default permissions like "script" and "read." Whatever the defaults are fine.
8. Click on OK. You now have a virtual folder called WinAward. Right mouse click on that WinAward folder and then select "properties." You are now looking at the directory tab for the properties window. Note that there should be an application setting window and the application name should be "WinAward." If it is not, you will want to configure an application and name it WinAward.
9. Next, on the documents tab, there are two documents that you'll have to select from "default.asp" and "default.htm." Make sure that "defaults document" is enabled.
10. Remove the "default.htm."

Back to main menu at top of page.

Problem: I have entered information through the web client and am now getting strange characters in some of the fields.

Solution: Text information has been entered into numeric fields. E.g. "Seven years" in the duration field rather than the number "7". There are no field edits on the web client. Be sure to enter dates into date fields and numbers into numeric fields.

**Duration is not an issue with the newest version of the Web-Client. It uses pick lists for year and month fields.**

Problem: I get an error message when I try to save a lead on the web client, but my leads do save on the LAN client.

Solution: There may be a problem with the "status" field. If you have a status description that has a space in it or an underscore, or if you have several status values that begin with a similar description followed by a blank, (i.e. Phase 1, Phase 2, Phase 3, etc…), you may encounter problems a saving leads. The solution is to use the LAN WAadmin.exe and change the status descriptions so that they don't have either the spaces or underscores.

Problem: In the LAN client, the filters on the Lead List Window are concatenating my status descriptions.

Solution: If you have a group of status descriptions that begin with the same string of text followed by a space and then more text, the filters in the LAN client will only read up to the space. Where you may have had Phase 1, Phase 2, and Phase 3, You now have three entries of Phase. Either remove the space to have Phase1, Phase2, and Phase3, or add a hyphen to have Phase-1, Phase-2, etc…

Problem: Cannot run Web client and getting error "Microsoft OLE DB provider for ODBC drivers error 80004005" and a message that the Microsoft Jet Database connector cannot open a file.

Solution: Typically when Internet Information Service (IIS) is installed, it creates a user called iwan. This is the behind the scenes login used by IIS. Two things could have caused this problem. (1) Some people delete this user if they are not using it or (2) the user may not have proper permissions on the folder.

One way around this is to try to recreate the iwan user. This is done through the user menu where you can create a new user. You'll probably want to create this user as a domain user and make sure it is a member of the network group that has permission to log into WinAward. The main thing is to make sure that this user has sufficient permissions to access the WA.mdb.

Another solution is to take an existing user and use his login name and password as the anonymous user for this web page.

The third solution is to password protect the web page so that anyone logging in needs to provide a valid network login and password. This is done from the management console on the Directory Security tab. Click on the "Edit" button next to Authentication Control. There will be three options there.

Notice that "Allow Anonymous Access" is checked. Uncheck Anonymous Access and, if it is checked, uncheck Windows NT Challenge/Response. What you want checked is "Basic Authentication."

Problem: I want to configure my LAN and web clients so that the WA.mdb (data file) resides on the web server where the web client is located.

Solution:

• (Web) Four files will need to reside somewhere on the web server. They are WA.mdb, bayesweb.dll, and win.kb and rea.kb. The global.asa needs to be modified to point to the location of these files. Change the first line of the WinAward options. The bayesweb.dll must be registered. With these changes, the web client will function.
  
  
• (LAN) To get the LAN client to function, you will need to provide a pointer to the data source for the LAN WinAward. This is done through the WA.txt file. WA.txt contains one line reading installation= and the default is "Our Company". You will want to create a line below this reading db= and provide the path to the location of the WA.mdb. Very important to put in a trailing slash. (e.g., db=f:\webapps\WinAward\)

Problem: I have a group of users who can access WinAward from inside the firewall, but no one can access it from outside the firewall.

Solution: The default settings for HTTP communication are on com ports 80 and 81 and these are within the range of ports your firewall is blocking. This is more of an issue of your network security and the answers will have to be very specific to your network architecture.

Web Reports

If you are experiencing problems with web based reports, the source of your problems may lay in one of two files: global.asa or reports.asp. If you are using another URL for your WinAward web page other than HTTP://LOCAL.HOST/WinAward then you will have to inform WinAward. You will have to do this in two places, the Global.asa file found in the root of your script folder and the reports.asp file found in the Report subfolder of your scripts.

Problem: I'm getting HTTP Error 403
403.1 Forbidden: Execute Access Forbidden.

Solution: This error can be caused if you try to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed. Please contact the Web server's administrator if the problem persists.

Check the web address that your browser has been set to. If the name of the WinAward folder has changed, then the problem is in the global.asa file. Change the "Application WinAwardHome For Reports" so that it points to the correct virtual folder location or web page name for WinAward.

Problem: I attempt to run a report, but when I click on the link I am taken to a blank page with "Back to Reports" and "Back to Lead List Window" at the top.

Solution: This is a setup issues that has to do with the name of the virtual folder. Once again, if the name of the virtual folder is not WinAward, you will need to note this in your global.asa file. You will also want to note this change in your report.asp file, localhost\WinAward\reports\report.asp.

Problem: I have created custom reports and they are working on the LAN but not on the web.

Solution: If you have spaces in the names of the reports, they may not work on the web. You can fill these spaces with "_"s or you might use capitalization to denote spaces such as "LeadListReport."

Problem: Web WinAward works fine except for the reports.

Solution:

This may manifest in one of many ways. If the problem resides with Crystal reports, somewhere in the error message you will find a comment about a "CPEAUT.dll". This is the Crystal Reports engine. If it isn't working, none of your reports will work

• Make sure that you have rebooted the server since you installed Crystal. Make sure that there is now a Crystal Web Server loaded in your Services listing on that sever.
  
  
• You may have a problem with the ActiveX viewer. To test to see if this is the problem, change the format of the WinAward reports to HTML. This can be done in the global.asa file. In the WinAward configurations you will notice two report formats, one for ActiveX and one for HTML. Remove the hyphen form the front of the HTML statement line and place a hyphen in front of the ActiveX statement. Now run the reports. If they are running now then you are having a problem with Crystal's ActiveX report viewer. (See the next problem for more options.)
  
  
• If you have the web client script files on one machine and the IIS Web Server on a second machine. IIS seems to support this and WinAward is able to work, but Crystal Reports will not function. Move WinAward to the IIS server and install Crystal on that machine.
  
  
• These errors may also occur if users' permissions on WA.mdb are "authenticated" rather than "everyone."

Problem: When I try to run reports on the web client, I get a blank gray window with the "Back to Reports" and "Back to Lead List" links at the top.

Solution: Crystal's ActiveX Smart Viewer isn't being loaded on the client. The SmartViewer is an applet that should be downloaded automatically if the user doesn't already have it. For some reason this doesn't always happen. Here is what you can do solution. The SmartViewer consists of three component .dll files that will need to be registered. (crviewer.dll, sviewhlp.dll, and swebrs.dll). Copy these three files to the system folder, or somewhere else where they aren't likely to be deleted by accident, and register them. You should now be able to view those reports. If you can't find the files, contact Bayesian Systems for a self-extracting zip file that contains the needed dll files and a batch file that will register them.

See also troubleshooting LAN and web clients.

Back to main menu.

Problem: When I log into WinAward I am not able to update leads. I also can't change my filter values.

Solution: WinAward is not able to save your filter preferences in WA's login file. You won't be able to create new opportunities either and will have other problems. The WA.mdb file is read only or you do not have write privileges on it.

Problem: I tried to save a lead and got the message "Error saving lead." I am able to save other leads, but I am not able to create new leads, nor save some existing leads.

Solution: Certain default values are required for "pick lists" in WinAward. If those values are not in the tables, the opportunities won't save. You will be able to save some leads if you have changed the values, but if you are using any of the default values, they won't save. Contact your WinAward Administrator and make sure the following items are in the tables:

Problem: I tried to print. I got a sequence of errors, the first about CPEAUT.dll (which is the Crystal reports automation engine). The next two errors were about OLE.

Solution: Crystals report engine isn't able to make a connection to the WinAward database file. There is an ActiveX component for Crystal reports that hasn't loaded properly. The only solution we have found thus far is to install Seagate Crystal Reports on the problem machine. Crystal installs whatever component is missing. You can then uninstall Crystal leaving the shared dlls thereby avoiding liscensing problems. The correct dlls will remain on the machine.

Problem: I'm trying to install the LAN client, have run dcom95, mfc42 and then, after loading all (7 of 7) installation components, I receive a message stating "Cannot load main setup program," then setup proceeds to uninstall all setup components.

Solution: Your machine has certain incompatibilities with Visual Basic ver 6.0. Contact Bayesian Systems. We will send you an installation disk containing a batch file that will run through the installation process without creating the installation GUI (Graphical User Interface).

Problem: During the installation of WinAward's client, I run into an error message that "…system can't find MFCANS32.dll." If this problem is ignored the setup is subsequently unable to load OC30.dll. The installation will complete, but WinAward doesn't open properly.

Solution: Copy the MFCANS32 file, from another system, to the Windows\system or Winnt\System32 folder of the problem machine. Now run the installation again. Note that there seem to be different versions of this file for Windows NT and Windows95/98. If you aren't able to find this file somewhere please contact Bayesian Systems and let us know what operating system you are using. We will provide you with the missing file.

Problem: I'm trying to install the Web client, see the login page, but am getting the following error messages: "Error initializing the application level objects. Make sure the database location is correct." And "You have exceeded your number of concurrent licenses."

Solution: You may not be running IIS Version 4.0 or higher. WinAward does not work properly unless you are using IIS 4.0. If you are running 4.0 or higher and still get the error, you may have not created an application or a virtual folder for WinAward.

Problem: I'm trying to run web reports and getting the following error message, "Server Object error ASP. Server.Create Object Failed. Report.asp line 167. Invalid Class String."

Solution: Crystal reports has not been installed on the IIS server that is hosting Web WinAward.

Problem: When trying to run reports on the Web client, we're getting "VB Script runtime error 800A01AD. Active X component. Can't create object. App reports.asp line 167."

Solution: You probably need to reinstall Crystal on you IIS server again. It does not take much to disrupt Crystal's smooth operation.

Problem: On the Web client I'm getting "ADODB field error… Either BOF or EOF is true or the current record has been deleted. The operation requested by the application requires a current record."

Solution: Too long a time has elapsed between the user's keystrokes and the server has timed out the application. You may want to reset your server timeout to allow more time.

Problem: When I try to run a report on the Web, I get a message that there is an error in the report and "Unable to connect: incorrect table location."

Solution: The report is not mapped to the correct table. Bring up the report in Crystal, select "Database" on the pull-down menu and then "Set location." The location should be the production version of the WA.mdb. Occasionally the UNC doesn't work and you must map to the drive letter and sometimes vice versa.

See also troubleshooting LAN and web clients.

Back to main menu at the top of the page.

Problem: Users logging into WinAward received a "Method "~" of object "~" failed" message.

Solution:

• (Your WA.mdb file may be corrupted. Try to open the file with Microsoft Access97. If access finds that the file is corrupt it will notify you as it attempts to open the file and proceed to fix it's perceived problem.)
  
  
• This message will also appear when there is a problem with drive letter mapping. (With this version of the message, you may also get a "Can't find WA.TXT" message.) The share for WinAward cannot be on the WinAward directly. In other words, if you go to the drive, you should not see all of the files. You should see the WinAward folder, e.g. D:\WinAward.

Problem: We opened the WA.mdb file in Access 2000 and can no longer access it.

Solution: Once your WA.mdb file has been converted to Access 2000 WinAward will read it as a corrupted file. We have had no success reclaiming data from an WA.mdb file that has been converted to Access 2000. The best bet is to restore the most recent backup that you have of the WA.mdb file.

Problem: I'm trying to run the LAN client and get the message box reading "Failed to initialize Decision Engine," followed by a second error message box reading "Failed to initialize Database Engine."

Solution: The three dlls in WinAward server folder have not been registered on the client machine. From the client machine click on BayesWeb.dll and drag it and drop it into the rgserv32.exe file. Do the same with WA_Email.dll and WA_db.dll. This process must be done on each LAN client machine.

Problem: We get a message that we have exceeded the number of licenses for concurrent users when we know we are not.

Solution: (Web) When you exit the WinAward web client, be sure to do so by clicking on the "Logout" button on the Lead List page. That signals the application that you are no longer using it and your name will be taken off the concurrent user list. There is a 15 minute idle time on any user connection by way of web. These user seats will free themselves in time. If you need to free them immediately, talk to your server administrator and ask them to stop and restart the IIS web service.

(LAN) Make sure that everyone is logged out of WinAward. Check the LAN folder of a group of User(#).txt files. These user files are what WinAward uses to keep track of how many users are in the system. WinAward will create a number of these files equal to the number of concurrent users your license supports. When users log in, they are assigned to one of these files. If these files are set to read-only, then the users aren't able to claim them since WinAward isn't able to assign users to these files, it figures that they are already in use by another user and tells you that you have reach your number of concurrent users. Make sure that your users have write permission in the WinAward folder and that the User(#).txt files aren't set to read-only.

Problem: I was using WinAward, entering information, and after I save it and close the lead binder the lead seemed to disappear from the Lead List Window.

Solution: Check your filters and make sure that they are all set to "ALL". You may also try to Query for your lead to make sure that it does exist. Unless your receive a message reading "Error saving Lead Binder," it is likely that your lead did save. If you aren't able to find the lead in either of these methods, please contact Bayesian Systems.

Problem: I've created an opportunity and saved it. I have set my filters to "ALL" and I still can't find it on the lead list window. (If you see that the information for an opportunity is different from the information you typed in, that is another clue.)

Solution: There is a possibility that the opportunity is sharing a subject id number with another opportunity. This subject id number is the means by which WinAward tracks all information that should be attached to any given lead. If two leads share the same number, then WinAward will only display the first instance of that number that it finds. This is unlikely to happen with a new, fresh installation but has been known to happen after the upgrade from WinAward 3.1 to 4.0. Contact Bayesian Systems for help.

If you have Access97 installed, you may try to correct this problem on your own. Here is how.

1. Look in the BID_SUBJ (Main table) table and change the subj_id number for one of the opportunities that are sharing the same number.
2. Then be sure to modify the information connected to that instance of that number found in the BID_SUBE (Extra or custom) table, and then the BID_NOTE (Note and history) table for any notes that should be attached to that opportunity.This is going to be the hardest step because notes entries will appear in the table out of sequential order.
3. Lastly, check the BID_SESS (Bid session) table for any probability sessions associated with your opportunity.
4. Now check the BID_UIDS (Unique Ids) table to make sure that the number that you have assigned will not be given to another opportunity.

Problem: I am trying to print a report and getting a blank report window.

Solution: If you are printing a report for multiple leads, check the top of the Lead List Window and see how many leads are being reported on. If you are printing a report for more than 200 opportunities, then this is the root of the problem. The current version of WinAwards reports will not allow printing of more than 200 items per report. If you have an urgent need to print these types of large scale reports there are two possible solutions. First would be to create a custom report that will give you the same information. It will lack the runtime filtering or querying options of WinAward, but it will not have the same limitations with the number of leads printed. The second solution is to purchase and install Seagate Crystal Reports Version 8 on the machine from which you want to run the reports. If they are web reports, install Crystal 8 on the web server.

Problem: I select one or more filters on the web client, use the go button, and the filters show all leads.

Solution: WinAward is not able to save your filter preferences in the login file. You won't be able to create new opportunities either and will have other problems. The WA.mdb file is read only or you do not have write privileges on it.

Problem: I tried to export a report to a spreadsheet (or other file format), and when I clicked on the export button, nothing happened.

Solution:

• (Web) Make sure that the Crystal Export feature is active in the Crystal Web Sever Options. You may check this from the Programs menu on the server itself.
• (LAN) Crystal requires a set of .dll files, that Bayesian Doesn't routinely distribute, in order to accomplish this export. Contact Bayesian Systems for these files.

Back to main menu at top of page.

Problem: I am trying to add a user (SBU, Lead Type, Line of Business, etc.) in the administrator program and it won't save.

Solution: This is a known bug. There is no save button on these window and, if you don't click on another name on the list before closing the window, the last change made will not save. Moreover, if you do open a record on a blank line and then try to move to another line, the system attempts to save a null or empty record and you have to go back and delete that empty line.

Problem: I'm trying to add a new status to the table and the program won't let me. The cursor will not move to a new empty line and I can't move from the last status value I modified.

Solution: You have probably deleted a status and created a "hole" in the table, i.e., values from first number to last are no longer consecutive. In order to fix this you can add a status with the insert button (button is on the module). Be careful, as it is pretty easy to make a status number of the same value as one already there. If you do and you are not paying attention, they will be right next to each other and if you move one, both will move. This is when they have the same ordinal value (and more than likely they have the same status value.)

Problem: I am trying to change the order that status values in WinAward are displayed and two status values seem to be moving together.

Solution: It is very likely that the two values are share the same ordinal value. The only way to adjust this problem is to open the Status table in Access and manually change the ordinal values.

Back to main menu at top of page.

Problem: I've created a custom report but it won't run from within WinAward.

Solution: There are several reasons this might be happening.

The first table that you chose when selecting data files is generally selected to be the master table. Crystal will arrange them in alphabetical order so if you were to select bid-sube, bid-subj and bid-note, bid –sube will be the first table and therefore all the links will be done as a result of that. One way to avoid this is to select your bid-subj table first. And then go back and select all of the subordinate tables afterwards. The other method would be to physically modify your table linkages. We do not recommend changing your linkages.

Problem: When I make changes to the database, the changes are not showing up on the reports in WinAward.

Solution: If you are not able to refresh data on a report, you may be pulling from the wrong WA.mdb file. You might also have an invalid WA.mdb location. This can be corrected in 2 ways.

1. Under the "Database" pull-down menu, select "Verify database". If Crystal cannot find a database where it expects to, it will prompt you to find a new database location. From there it will proceed to fix the rest of the report.
2. The second method is to select "Set location" under the database menu. You will see all of the tables that you have selected from the WA.mdb and have the opportunity to individually point to the WA.mdb. This is far more time consuming and we suggest the first method rather than the second.

Problem: I have created custom reports, but they are not showing up inside WinAward.

Solution: You may have a misnamed the reports folder. For the LAN client the reports should be located in the "reports" folder and for the web client in the "reports folder/custom." If you are using both the LAN and web clients and you modify one report, you will have to copy it to the other location.

Problem: My web custom report tells me that it has an error connecting to database or it shows old data and when I try to refresh it with the report refresh button it gives me an error message similar to the fore mentioned.

Solution: The location of the WA.mdb for custom reports should be assigned from the perspective the web server. The LAN server doesn't seem to care and looks for the WA.mdb in the folder above reports. However, for the web server, the web server will need to know where the WA.mdb file is, relative to the web server. If you were running web reports, you would have Crystal installed on that machine and you would go directly to the report and "Verify database."

Back to main menu at top of page.

Problem: I have attempted to update WinAward, but nothing happens, or I have a message that table bid_subj is busy or in use by another application.

Solution: If you have just copied the WinAward files from CD, you must remove the" read-only" file attribute.

Problem: I am attempting to update WinAward and I get a message saying that table bid_subj (or other table) cannot copy/overwrite because it contains related records.

Solution: The upgrade program only works when the WA.mdb file is empty. If you already have records in the database the relations between the tables will not allow you to copy into many of the tables.

Problem: I'm using a Windows NT machine and when I update WinAward, I receive an error message saying "No Installable ISAM found."

Solution: This seems to be a result of information that was found missing from the ergo.ini file. If you have any blanks where there should be labels, the upgrade program will not operate correctly. Your solution is to open the ergo.ini file into a text editor and add labels for all of the items. If you need these items to be blank in WinAward 4.0, you can delete the labels through the WAadmin.exe.

Problem: Upgrade stops and says that it can't have duplications in the primary key. The upgrade program has stopped on the BID_SUBJ table.

Solution: You may have duplicate Ids in your data. This is something that you might encounter if you have been unsuccessful in converting the data on many occasions and know that you are working with a blank WA.mdb file to start with. What happens is that you have a lead #225 that has been copied and then you try to add another lead #225. The information may be different with each lead, but as long as they have the same ID number you will run into errors. This can be verified by opening the WA.mdb file with Microsoft Access97 and looking at the SUBJ_ID numbers in the BID_SUBJ table. If you do find that you have a duplicated ID number in the Bid_Subj table you will have to change the number for one of the leads. This means that you will have to change it in the SUBJ, SUBE, NOTE, BID_SESS, etc... tables. You will also want to check the newly assigned number against the BID_UIDS table. (This is the table the WinAward looks to in order to assign unique ID numbers.)

Back to main menu.

Problem: None of the above describes my problem.

Solution: Most of the problems that are not described above have to do with mismatched files while trying to upgrade very, very old versions of the web client. One of the best ways to know if this is the case is to look at the global.asa file. If it doesn't have all of the following component, you are working with an old version of WinAward. Contact Bayesian for the most recent version of the web client to replace everything and start over.

Application("WinAward_ROOT")="D:\WINAWARD\ClientVB\"
Application("WinAward_DB")=Application("WinAward_ROOT") & "Wa.mdb"
Application("KB_WIN")=Application("WinAward_ROOT") & "Win.kb"
Application("KB_REALITY")=Application("WinAward_ROOT") & "Rea.kb"
Application("HOME")="http://bayesian.com" 'HOME will exit to http://ThisServer/
Application("WinAwardHome")="/WinAward" 'For Reports

Application("HELP_LOCATION")="http://www.bayesian.com/WinAward"

Problem: I want to read the documentation files that come with WinAward and don't know how.

Solution: You will need to use Adobe Acrobat reader to read the pdf files. Double click on one of the files. If you can't read it, the fastest way to do so is to download from ftp.adobe.com in the pub\adobe\acrobatreader\win\4.0 folder, the file named ar40eng.exe.

Problem: We are running Division Level Security and find that none of the Capture Managers can view any of the screens in the lead binder except for the first.

Solution: In WAadmin.exe you will have to mirror the permissions that were given on the Maintenance for Users option in the Div Level User Access page.

Problem: We are having problems with WinAward's web based reports and the problems always point to the CREAUT.dll, no matter what problem solving steps are taken. It may be that the Crystal report automation engine was mis-installed or is corrupt.

Solution: In most cases reinstalling Crystal on the web has done nothing. Most of the problems seem to be related to the way the web page is set up.

Back to main menu at top of page.