Applies To
Product(s):	AutoPIPE Nozzle
Version(s):	ALL;
Environment:	N/A
Area:	Error Message
Original Author:	Bentley Technical Support Group
Date Logged & Current Version	Nov. 2016 08.11.08.26

Problem:

The following message appears when entering the design temperature:

---------------------------
Warning
---------------------------

Error opening RecordSet with SQL

Select * from A2000A

---------------------------
OK
---------------------------

How to avoid this from happening?

Solution:

The message provides a clue to the problem encountered. "Error in opening RecordSet"... is hinting to an issue with opening a database file that contains various records. The only database files used in AutoPIPE Nozzle are related to Material files. Therefore, there is an issue with one or more of the 4 material database files installed by AutoPIPE Nozzle. Also, if there is a user defined material database file, the specific file may be missing or corrupted. 

In addition with the error message, it was noted that the vessel nozzle image was missing:

This issue has only been reported one time and was directly related to a missing file(s) from the installation folder and computer permissions at the time when the software was installed.

Avoidance:

1. 1. User must have AutoPIPE Advance or AutoPIPE Nuclear Licensing available.
   2. Delete existing exported PXF from AutoPIPE. 
   3. Uninstalled AutoPIPE and AutoPIPE Nozzle from the computer.
   4. Reboot the computer,
   5. Log into the computer with Administrative permissions (must have Admin role). 
   6. Install old AutoPIPE - AutoPIPE Nozzle - New AutoPIPE software as mentioned here. 
   7. Open Folder - 
      • C:\Program Files (x86)\Bentley\AutoPIPE Nozzle
   8. Verify the following 4 files are present:
      • khkmatlib.mdb
      • jismatlib.mdb
      • asme2009.mdb
      • asme2000.mdb
      • Note: Copy any user generated material libraries to this folder
   9.  If not, ask co-worker / Technical Support to provide these files. 
   10. Copy the files to the folder mentioned above.
   11. Again, Reboot the computer.
   12. Exporting nozzle loads from AutoPIPE to AutoPIPE Nozzle again.
   13.  The problem should now be fixed.

---

Steps when installing AutoPIPE 25 or higher. 

1. Uninstall all AutoPIPE and AutoPIPE Nozzle.
2. Reboot the computer.
3. Person with full admin rights logs into the computer.
4. Suspend virus protection.
5. Install AutoPIPE 12.08.04.09 with AutoPIPE Nozzle. Do not install AutoPIPE 25 at this point.
6. Perform test.
   1. Log into Connection Client
   2. Open AutoPIPE 12.08.04.09
   3. Open example model Walkthru.APC
   4. Open any anchor, enable option to export loads to AutoPIPE Nozzle.
   5. Analyze the model
   6. Export loads to AutoPIPE Nozzle
   7. Open AutoPIPE Nozzle
   8. Import AutoPIPE PXF file.
   9. Try to use JIS and KHK materials.
7. Does the reported error message "Error opening RecordSet" appear?
   1. If yes, stop. Obviously, there is a fundamental difference between your system and standard installation. One additional consideration would be localized / regional settings. Please confirm the following localized settings.   

1. 1. 1. Open your Regional / localized Number format and set the Decimal setting to “Period”
      2. Search internet for specific commands to use when setting the Decimal symbol on your computer.
      3. It is difficult to know if using "." (period) or using "," (comma) therefore, suggest using Window's Magnifier command to confirm setting. 
      4. To quickly turn ON Magnifier, press the Windows logo key  + Plus sign (+) .
         To turn OFF Magnifier, press the Windows logo key + Esc .  
      5. Repeat Step #6 above.
      6. If after repeating step #6 the same issue occurs. Please inform me.
      7. Remember, turn Virus protection back on and person with Administrative rights can clog out.

7. 2. If no, continue below:
8. Install AutoPIPE 25.00.01.213.
9. Repeat Test instructions above using AutoPIPE 25.
10. Does the reported error message appear?
    1. If yes, stop. Again, there is a fundamental difference between your system and standard installation. At this point the only option is to log exactly what your computer is trying to access by investigating all background process. Use an application like WinDBG application to log all process when using AutoPIPE Nozzle to the point where the error occurs and send the log file to AutoPIPE technical support for review. . 

• • • Please see instructions here to generate a WinDBG log file of you starting AutoPIPE Nozzle to the point where the error message appears, at which point stop Windbg, save log file.
    • Log a new case for AutoPIPE technical support, mention this KB article, and attach WinDBG log file for review. .
    • Remember, turn Virus protection back on and person with Administrative rights can clog out.

10. 2. If no, continue below:
11. If you have reached point, the application is working correctly. The problem is directly related to user permission and / or Virus protection. Please make any adjustments necessary.
12. Remember, turn Virus protection back on and person with Administrative rights can clog out.

See Also

Warnings, Errors, Crashed, Confirm Messages

Bentley AutoPIPE