Unable to successfully download the AyaNova installation file

Depending on your Internet connection, you could be experiencing congestion - too many users attempting to download and access the Internet at the same time. Wait a while and than try again.

Or use one of the other suggestions also found on the AyaNova Download web page if you are experiencing a problem downloading :

1. Use Gozilla or Accelerator to schedule the download during non-peak times (do not use GetRight as it has a known problem in that it erroneously states unable to resume)

2. Download AyaNova SCPSETUP.EXE via Tucows this hyperlink allows you to choose your corresponding province, country or state closest to where you are for a faster and reliable download.

3. Have your local computer retailer download the setup file and burn it and the AyaNova Manual to a CD for you. They usually charge a very minimal amount for the cost of the blank CD itself as well as for the download time.
 

1607: Unable to install InstallShield Scripting Runtime

There are a couple of possible reasons for the error message that is occurring

1. First ensure that you delete ALL files in the C\WINNT\TEMP or C:\WINDOWS\TEMP directory. There are known cases where previous partial setup files and TMP files in the TEMP directory will cause problems with installing. This is because InstallShield is widely used to install numerous different programs, and previously extracted files can cause a problem with new installs. Than run the SCPSETUP.EXE again. 

2. The ISSCRIPT.MSI file can be corrupt on your station.

InstallShield is used to install thousands of software programs, including AyaNova. In the following InstallShield support page, will be a link to Download  ISSCRIPT.MSI

You will need to unzip it using a compression utility like WinZip, and than run it as per the instructions on the web page.

 After it's installed, and you have rebooted your computer, run the SCPSETUP.EXE again.

Check that you have the minimum requirements to use AyaNova

If you have specific questions regarding your network, workstations, or server (if applicable),  please refer to the AyaNova Contact web page where you can view the AyaNova forum for questions and answers, or email us directly.

We would need a complete picture of the configuration and the versions in place to be able to give specific recommendations.

Upon logging in receive:

At ex standard
Cspview: unspecified error
Operation must use an updateable query
Query: update users set users.mail=truewhere (((users.id)=23));

At ex standard
Stat EBRS: unspecified error
Operation must use an updateable query
Query: update users set users.statview =”8” where (((users.id)=23));

At ex standard
CDButils(RS): unspecified error
Operation must use an updateable query
Defaults set defaults.last-maintdate=#02/14/2005#;

This occurs when the user logged into the network on this computer does not have full rights to the AyaNova database folder and file.

Review the AyaNova QuickStart Guide installation information regarding installing in a network environment.

Receive an error message "cannot install MDAC 2.6 on this computer" when installing to a Windows 2003 operating system

Use the 2K_XP_SCPSETUP.EXE installation file when installing to a Windows 2003 computer.

The 2K_XP_SCPSETUP.EXE installation file does not attempt to install MDAC, as Windows 2003 already has MDAC 2.8 installed by default.

Receive message "AyaNova could not open the database file

C:\Program Files\AyaNova\database\\scdata.sc

The database driver gave the following reason"

There are two possible reasons for this to occur:

1. When the error message shows the path with two "\\" as in C:\Program Files\AyaNova\Database\\scdata.sc this indicates that the present Windows system files are not capable of running the AyaNova program.

Go to Microsoft Support and download the appropriate latest Jet 4.0 files for your operating system. Apply and reboot.

2. Share level permissions and/or NTFS permissions on the database folder and/or files are not provided. AyaNova requires that FULL access to the database folder and files be given.

Receive an error message License Key has been revoked or INVALID LICENSE KEY

As per the message, one of five  instances are occurring:

1. The license key code has been entered incorrectly. This is a common occurrence for those that type it in instead of copy and paste. Check that the keycode is exactly as provided in your Activation Key email message as well as the exact registered name.

2. The license key has been revoked either due to being replaced because of additional licenses order, or due to other circumstances. Therefore the license keycode is invalid and can not be used. Check with your accounting department or manager to confirm you are utilizing the correct keycode.

3. When applying the activation key, the sample data was retained and the sample technicians were not internally reset to inactive, thereby "taking up" use of licenses. This has occurred in only a couple instances and we have been unable to recreate. Zip up the AyaNova database file SCDATA.SC using WinZip and send in a private email address to us along with the exact error message you receive, and the manager password if changed from the default. Refer to the AyaNova Contact Us web page for direct private email address. We will fix and send the database back.

3. The latest AyaNova update has not been applied to a trial AyaNova database. Refer to the Patches web page for more information.

4. You are using an illegally obtained keycode from a crack site which doesn't work with AyaNova.

Using AyaNova

Unable to view all of the program screen and unable to "scroll" sideways or horizontally

AyaNova requires that you have a minimum screen resolution of 800X600 and the font setting of small fonts. AyaNova is a forms based application rather than a document based application such as a word processor.  In a document based application it doesn't matter what your resolution is set to as the program can simply re-arrange the text to fit, however in a forms based application the screens can not be made any smaller, only larger.  

We can not fit everything onto all screens at less than 800X600 resolution due to the large number of fields on some of the forms.

When AyaNova is closed, a error message "SC.EXE has caused an invalid page fault in KERNEL32" occurs

This can be caused by either of two things:

1. There is no file called P2SMON.DLL in the C:\WINDOWS\SYSTEM directory at all 

2. The file P2SMON.DLL that is in your C:\WINDOWS\SYSTEM directory is NOT version 8.5.0.12

3. There is more than one copy of P2SMON.DLL on the computer, and it is not the same version as the C:\Windows\System\P2SMON.DLL file

To check the version of the P2SMON.DLL file if you do have one in the C:\WINDOWS\SYSTEM directory, right-click on the file, and click on the Version tab.

If it is an incorrect version, copy the correct version from another station, reboot your computer and test to ensure the error message does not re-occur when you close AyaNova.

Receive message "AyaNova could not open the database file

C:\Program Files\AyaNova\database\\scdata.sc

The database driver gave the following reason"

There are two possible reasons for this to occur:

1. When the error message shows the path with two "\\" as in C:\Program Files\AyaNova\Database\\scdata.sc this indicates that the present Windows system files are not capable of running the AyaNova program.

Go to Microsoft Support and download the appropriate latest Jet 4.0 files for your operating system. Apply and reboot.

2. Share level permissions and/or NTFS permissions on the database folder and/or files have been changed or not provided. AyaNova requires that FULL access to the database folder and files be given.

Errors occurring when opening or editing work orders

"At GoExclusive access (all users out) unspecified error, You attempted to open a database that is already opened exclusively by user "admin" on machine 'XXXXX'. Try again when the database is available."

or

"In order to protect the integrity of your data you need exclusive access to the database to access this function. All other users must exit before proceeding."

or

"At CString FetchField CWOHeaderDlg (CBRS): unknown error 0x800A0BCD, Either   BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Query: first"

A user is going into an exclusive access part of the program such as adding or editing users or using one of the functions on the database utilities screen while there are still other users in the program.

Or they have started something like above while the other users were out, but subsequently another user went into the program while they were still busy doing the exclusive access operation.

Or a user has opened the scdata.sc file directly using Microsoft Access which will cause that error at other stations.

Solutions:

A. Set your virus scanner on all computers to not scan the SCDATA.SC file at the server or at the workstations. A virus scanner that is scanning the database file will kill performance and will lead to all sorts of strange intermittent errors so you should double check that's not happening at *any* of the workstations running AyaNova (it only takes one) or at the server itself.

B. Double check that other users as well as yourself, do not have AyaNova opened into an exclusive access feature (creation of users, database utilities, etc). Or if you are attempting to enter an exclusive access feature, that all others  including ARAS is shut down.

C. Shut down and reboot all computers related to AyaNova use - that have the program installed, or have/had the database opened via Access or have the database folder and file located locally.

D. If still experiencing an issue, after ensuring all users are out and having performed the two solutions above,  please refer to the AyaNova Contact web page where you can view the AyaNova forum for questions and answers, or email us directly. Please be sure to identify what steps you have already performed and the actual results of each of those steps.

Attempting to log into AyaNova, a dialog box states the database is corrupted and states AyaNova can not repair itself and to contact tech support

Error may also state "unrecognized database format"

Both indicate that the database is corrupted. If AyaNova can not repair itself, there are four options:

The five main causes of database corruption are:

1. Database is suspect/corrupted because of interrupted write operation - computer crashed or network lost power etc
2. Faulty networking hardware - network wiring, network cards, hubs etc chatter, or are faulty
3. Opening and saving the file in another program
4. Jet database engine version is older than 04.00.4331
5. Mismatched versions of the Jet database engine - different computers on the same network accessing the same database have different versions.

It's absolutely *CRITICAL* that your version of the JET database driver on *any* computer that will either run AyaNova or will run Access to open the AyaNova database (for example to repair it or import data) be version 04.00.4331 or newer due to a serious bug in the Microsoft JET database driver that can cause problems such as are happening to you. Once a station with the older version opens the database, it causes continuous problems until it is fixed, even if then used on systems with the correct driver.

In AyaNova it's easy to check the version, go to Help->About->Detailed info for tech support button and check the line that says "Provider version" it should be 04.00.4331 or higher

To check the version on computers that do not have AyaNova installed check in the Windows\System folder for the following file

MSJETOLEDB40.DLL

Right click on it from Windows Explorer and then click on the version tab to confirm the version number.

Note that AyaNova automatically installs the correct version, however it's not unusual for other applications to downgrade it with the most common being Microsoft Office during setup or re-setup. The most common problem related to this is repairing the AyaNova database on a computer that did not have AyaNova installed to it but does have Access 2000, because it has the stock version of JET that came with Office 2000 which is quite outdated now.

Only the JET requires updating, ignore the other links. The JET download link will take you to Microsoft's website where you can download the latest JET driver package. Carefully read that page as there are different versions for different OS's.

Receive "Error at::CLoginDlg: Class not registered, (null)"  errors:

An issue with MDAC or the Microsoft Jet database engine is the cause.

Refer to our MDAC / Jet web page for information on downloading and re-installing MDAC and Jet on your computer.

If using XP and unable to re-install MDAC, perform the following steps:

1. Right-click on C:\Windows\Inf\mdac.inf and choose "install".
2. When prompted for the XP SP2 media, point to the "C:\Windows\ServicePackFiles\i386" folder.
3. When prompted for the "handler.reg" file, point to the "C:\I386" folder.
4. After install completes, reboot computer.
5. Open AyaNova and should work fine.

AyaNova appears to be running slowly

Printing from AyaNova

Code = 469830
Code Meaning = Invalid pointer
Source = (null)
Description = (null)

or

Code = 469cb0
Code Meaning = Invalid pointer
Source = (null)
Description = (null)

or

Code = 435b50

Code Meaning = Invalid pointer

Source = (null)

Description = (null)

This error indicates that the Crystal Reports 9 printing engine was not successfully registered.

1. For a Windows 98 or ME stations, run the file REGCR.BAT from the location:

C\Program Files\Common Files\Crystal Decisions\2.0\bin

For a Windows NT 4.0SP6a or 2000 or XP, run the file XP2KREGCR.BAT from the following location:

C\Program Files\Common Files\Crystal Decisions\2.0\bin

This will register the required files to be able to print successfully using the new Crystal Reports engine that is installed with AyaNova 1.9

2. If you do not have the file in this directory, than that indicates that the Crystal Reports printing engine was not successfully installed. Please reinstall the full installation SCPSETUP.EXE on this station, and ensure to reboot after.

3. If the error above continues to occur after running the REGCR.BAT or XP2KREGCR.BAT file, than open the batch file itself and confirm that the files and the path that this batch file calls are in the exact location specified on the computer - C:\Program Files\Common Files\Crystal Decisions\2.0\bin

4. If you have your Windows operating system set to a language other than English, you will need to manually move to the stated directory at a DOS command line and manually register the required files as laid out in the batch file for your operating system version.

Can print occasionally one copy of a report, but when print a second copy or another report right after, receive Invalid Pointer messages, or errors in SC.EXE

The printer driver may be corrupt.

1. Delete the printer driver as per the instructions for your printer (some printers provide an uninstall, some can be deleted via the Printers in Control Panel).

2. Make sure to reboot the computer.

3. Download the latest printer driver from the printer manufacturer website and install as per instructions.

4. Reboot the computer.

5. Now print from AyaNova.

6. If you continue to experience an issue, please ensure to provide the following information when contacting support:

1. Confirmation above has been performed with what steps and the detailed results

2. Detailed Info from AyaNova on this exact same computer where the error occurs - select menu Help -> select About this program -> click on Detailed Info -> copy to NotePad document, save and attach

3. Model and make of printer occurring with

4. Printer driver and version of the printer that is set as the default printer in Printer Settings on this computer

5. Does this occur if use a different printer and different default printer driver? (be sure to reboot the computer before testing if changed such settings)

6. Is printer local (physically attached to the computer) or via network access?

7. Confirmation if this occurs with all reports or if occurs with only certain reports, what report or reports from which screen or screens.

Code = 435b50

Code Meaning = IDispatch error #14531

Source = Crystal Reports ActiveX Designer

Description = File not found.

This error came at the point where AyaNova had just asked the RDC to

open report path and name of report [i.e C:\Program Files\AyaNova\Database\wofull.rpt]

This error occurs because the report file is not in the database directory where the AyaNova database file SCDATA.SC resides.

Usually this occurs because the user has made a copy of the AyaNova database to test creating new reports or queries, and has not also copied all the files including reports from the AyaNova database folder along with the database file itself. 

1. If you get a similar error message, check that the file is in the path stated in the  error message.

2. If the stated report file is in the path, and you have full rights to the directory, email  us with the following information:

1. Is this the only report where this error occurs?
2. Does this error occur for other users / other computers?

3. Exact wording of the entire error message
4. Zip up the AyaNova database file SCDATA.SC using WinZip and attach to your reply
5. Include the manager password
6. Include your username and password
7. Detailed Info from AyaNova on this exact same computer where the error occurs - select menu Help -> select About this program -> click on Detailed Info -> copy to NotePad document, save and attach

8. If this is the only report that results in this error, include a copy of the report file from the database directory

Code = 432810
Code Meaning = IDispatch error #14563
Source = Crystal Reports ActiveX Designer
Description = Invalid TLV record.

This error may occur because required files on the computer have been modified or corrupted. Perform the following:

1. Ensure you have a good backup of AyaNova database

2. Download the latest AyaNova installation file

3. Shut down all running programs on your computer

4. Open up Control Panel -> Add/ Remove Programs and remove AyaNova

5. Reboot your computer

6. Make sure to log into the computer with full access

7. Run the latest AyaNova installation file (install to previous location  and do not worry, it does not overwrite your existing database)

8. When indicated that the installation is finished, reboot your computer

9. Log into the computer with full access

10. Now log into AyaNova and print reports.

11. Log into the computer as normal and run AyaNova as normal. If you have additional issues, confirm user rights to the database folder and files.

Printing a work order results in  a dialog box that pops up saying " Some links could not be updated because their sources are presently unavailable" or "ActiveX link is unavailable".

Custom logo does not print on work orders or reports

Refer to the AyaNova Manual in the section "Using your logo on reports" and to the Help within AyaNova itself for detailed information.

1. Your custom logo.bmp file must be located in C:\Program Files\AyaNova directory as this is the exact location that the report file looks for a logo.bmp file

2. Be aware to ensure that the file is logo.bmp in lowercase, as the report is looking for C:\Program Files\AyaNova\logo.bmp. If it is logo.BMP the report will not "see" it, as the spelling and case is not as specified.

3. BMP type files must be associated with a Windows program that supports object linking and embedding, such as Windows Paint.

4. Your logo.bmp file must be as close as possible in dimensions and size to the sample logo.bmp file provided.

AyaNova users have sent us copies of there customized logo.bmp files that we over 1MB in size and with the dimensions of 8 inches by 7 inches. The AyaNova Manual specifies no more than 50KB in size, and no more than 2.36 by .52 inches.

5. In some instances where the AyaNova Database directory is located on a network server remote from the station running the AyaNova program, a customized logo.bmp file will not show on the Detailed Completed Work Order report, but will continue to show "your logo here".

If this is the case, create a folder on the server with the exact path of C:\Program Files\AyaNova and copy the customized logo.bmp file here.

In this way, when the report is accessed, the report will check the server's local hard drive location of C:\Program Files\AyaNova for the logo.bmp file.

IDispatch Error #3088

Before you attempt to print your first workorder or any reports, you need to enter at minimum one customer record, one technician record, one service rate and one travel rate even if you don't use travel rates it must be there *before* you create your first workorder. 

This information was in the AyaNova activation key message.

1. Check that you have at least one client created (use the Accelerator key combination of ALT-c to open the Client entry screen)

2. Check that you have at least one user set as a technician (have all other users out of AyaNova, from the menu Options -> select Edit -> Users & Rights)

3. Check that you have at least one service rate (use the Accelerator key combination of ALT-a to open the Rates screen)

4. Check that you have at least one travel rate (use the Accelerator key combination of ALT-a to open the Rates screen)

Installing and using ARAS

Issue:  On a Windows 2003 SP1 computer, ARAS loads correctly via desktop mode, but when attempting to load via service, receive error

Error 87: The parameter is incorrect.

Solution:  

1. Remove the service setup by running  AyaService -u from command line at the AyaNova program directory

2. Download the replacement AyaService.exe for Windows 2003

AyaService_2003.zip

3. Extract the AyaService.exe overtop of the existing.

4. Perform the steps to run ARAS as a service again

Issue: Within the ARAS log file, you see the following

not secured / not valid GET request from
"\favicon.ico"
Sending error 403 FORBIDDEN instead.

Cause: Someone has created a bookmark or shortcut using Internet Explorer to the ARAS login page. If you surf with Internet Explorer you've probably noticed that some of your bookmarked sites have custom icons while others have the default IE icon. Those custom icons are the favicon.ico that IE is so diligently searching for. In addition to appearing in the Favorites menu, the favicon.ico replaces the default IE icon in the Address bar at the top of the browser. ARAS does not provide a favicon.ico As the file is not found IE5 uses the default icon and you get an error message in your log files.
 

Solution: You can safely ignore this message

Issue: After ARAS is successfully installed, receive an error referring to ayaserv.exe when first attempting to run

Cause: ARAS, when first started, uses the default http port number 80. This http port number is also used by default by other Internet programs like IIS etc.

What is occurring is that a service, whether IIS or another, is presently running and utilizing the http port 80, and ARAS can not initially start so you can configure it to use another port number.

Solution: In the ARAS Installation & Configuration Guide, it is recommended to check your Services (Programs -> Administrative Tools -> Services) and shut down all Internet related programs before first running ARAS. You can than start ARAS and configure it and the http port to another number as needed. Than restart your IIS or other program that was using the default http port

Issue: When printing reports via ARAS, they state "Evaluation" even though AyaNova and ARAS are licensed, and when printing the reports via AyaNova, they state our licensed company name.

Solution: Perform either of the following

1. Send us your AyaNova database. We will edit it here and send it back to you
Zip up your AyaNova database file scdata.sc using WinZip and send it to us along with the manager password. We will edit the database and send it back to you. Do not allow any users in AyaNova until after you have the database sent back to you and copied back to the database folder.

2. Use Access 2000 SP1 or higher to edit the database (only perform this if you have database experience)
Edit the queries in the rptmaster table for the reports wodispqu.rpt, wodispst.rpt, wodispst2.rpt. Edit the part of the query that states
           ""Evaluation"" AS compname,
   edit instead to be
           ""~REGTO"" AS compname,
 

Installing and Using QBI