| Error: | Advantage Client Engine Error |
| Error 7200: AQE Error: State = S00000; NativeError = 2122; [Extended Systems] [Advantage SQL Engine] Table or alias not found: (TABLENAME) -- Location of error in the SQL statement is: 2883. |
| Action: | Error encountered when printing a report. Error indicates that there are too many alias entries in the \Accubld8\ADS.INI file for Crystal Reports. |
| All users must exit the program. Make a copy of the ADS.INI file for backup and then edit the original ADS.INI file with Notepad. Delete the lines referencing the database aliases. Save the file and then open the program. |
| The following is an example of which lines to delete in the ADS.INI file: |
[Settings]
ADS_SERVER_TYPE=7
[Databases]
LAN_IP=192.168.168.14
LAN_PORT=2003
INTERNET_IP=192.168.168.14
INTERNET_PORT=2002
*** Begin line selection here ***
CADD5ab=P:\ACCUBLD8\AccuBuildLLC\BASECOMP.ADD;D
CFREE5ab=P:\ACCUBLD8\AccuBuildLLC;A
UADD_19ab=P:\ACCUBLD8\AccuBuildLLC\JACK\BASEUSER.ADD;D
UFREE_19ab=P:\ACCUBLD8\AccuBuildLLC\JACK;A
GADD=P:\AccuBld8\DATA\BASEGLOB.ADD;D
GFREE=P:\AccuBld8\DATA;A
[Crystal]
UseBDECompatibleOJ=CADD5ab; CADD12ab; CADD28ab; CADD24ab; CADD20ab; CADD26ab; CADD27ab; CADD30ab; CADD13ab; CADD23ab
*** End line selection here ***
| Save the file and then open the program. |
| Error: | If the company name that was embedded in the AccuBuild Serial Number contained an apostrophe (single quote) or if a customer MAR Form or Report had an apostrophe in the user defined report name, then an exception error was generated whenever an MAR Form or Report was being generated during the creation of the UserMARReportParametersTable: Exception Error at accfunc.CreateUserMARReportInfoTable :Error 7200. |
Action: This problem has been corrected with the 9.1.0.1 Release and if the apostrophe is included in the Serial Number or custom report or form name, it will now work correctly.
|