Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
AutoPIPE
  • Product Communities
AutoPIPE
AutoPIPE Wiki "Program failed to generate SQlite Database..." message appears in AutoPIPE
    • Sign In
    • -Pipe and Vessel Stress Analysis - Wiki
      • +ADL PIPE
      • -Bentley AutoPIPE
        • +- General Information about AutoPIPE
        • +- NEW User Guide for AutoPIPE
        • +- Technical Support - AutoPIPE
        • +Batch Processing, ITS, and ATS using AutoPIPE
        • AutoPIPE QA&R program
        • +Download - Install - Release Notes - AutoPIPE
        • +File / Model Management using AutoPIPE
        • +General - AutoPIPE
        • +Graphics - AutoPIPE
        • +Grids (Input & Results) - AutoPIPE
        • +Import and Export - AutoPIPE
        • +Known Issues in AutoPIPE (Enhancements, defects, etc..)
        • +Libraries - AutoPIPE
        • +License AutoPIPE -
        • +Loads and Load Sets - AutoPIPE
        • +Localization (Non-English Language) - AutoPIPE
        • +Modeling Approaches in AutoPIPE
        • +Modules (i.e. Flange Analysis, Spring Hanger Selection, Rotating Equip, TTA) in AutoPIPE
        • +Piping codes - AutoPIPE
        • +Post Processing - AutoPIPE
        • +Printing - AutoPIPE
        • +Reports - AutoPIPE
        • Security
        • +Settings - AutoPIPE
        • +Stress Isometrics - AutoPIPE
        • +Technology Productivity Capabilities
        • -Warnings, Errors, Crashed, Confirm, etc.. messages in AutoPIPE
          • "1 Interrupted Action" messages displayed while coping AutoPIPE file, why?
          • +"Alert" Messages displayed in AutoPIPE
          • +"AutoPIPE Licensing" Messages displayed in AutoPIPE
          • +"Autopipe.exe" Messages displayed in AutoPIPE
          • +"Beam Section" Messages displayed in AutoPIPE
          • -"Bentley AutoPIPE" Messages displayed in AutoPIPE
            • "Bentley OpenPLANT Isometrics Manager not found"... message appears when configuring AutoPIPE License, why?
            • "Cannot insert Component after a tee. Please insert a pipe run first"... message appears when modeling in AutoPIPE, why?
            • "Error in writing Point file.Type mismatch... " message appears in AutoPIPE , why?
            • "Error in writing Pres/Temp/PipeID file.Type mismatch... " message appears in AutoPIPE , why?
            • "Error in writing Section ID file.Type mismatch... " message appears in AutoPIPE , why?
            • "Error in writing Soil file.Type mismatch... " message appears in AutoPIPE , why?
            • "Error in writing Tee file.Type mismatch... " message appears in AutoPIPE , why?
            • "Error in writing Valve file.Type mismatch..." message appears in AutoPIPE , why?
            • "Error Opening file: xxxx.L001" message in AutoPIPE
            • "Error Writing Files...." message appears in AutoPIPE
            • "Error: Bentley CONNECT Licensing system is not installed"... message appears when configuring AutoPIPE License, why?
            • "H/D is greater than 14.0" - Bentley Message displayed in AutoPIPE
            • "Intergraph PDS translator not installed" message appears when trying to import a file into AutoPIPE.
            • "Please Analyze the Model First. The Load Table values can only be set if model analysis results exist" message appears in AutoPIPE
            • "Please select a valid test pressure case for B31.3 test pressure update." Bentley AutoPIPE message is displayed, why?
            • "Program failed to generate SQlite Database..." message appears in AutoPIPE
            • "Program has detected disconnect in selected Pipeline which is not supported..." message in AutoPIPE
            • "Query is too complex" - Bentley AutoPIPE message
            • "Report Generator Error: Program Failed to merge documents" message appears in AutoPIPE when creating a report
            • "RibbonUI.XML not found..." message appears when starting AutoPIPE, why?
            • "Ring components are not permitted in HDPE pipe system as per CC N-755-1"...message appears in AutoPIPE , why?
            • "Selection types different" message occurs when copy pasting to AutoPIPE
            • "SmartPlant translator not installed".. message appears when trying to open a PCF file in AutoPIPE, why?
            • "Stress Isometrics are only available with Nuclear or Advanced edition" - Bentley AutoPIPE message
            • "The Gasket Dimensions are not available for Gasket Type [Ring Joint] for Rating = 900 having Nominal Pipe Size of 36.000000 inch." - Bentley message in AutoPIPE
            • "The Gasket Material [SPIRAL-WOUND ALLOY WITH MINERAL FIBER FILL] is not available in the GasketMaterials Table." - Bentley message in AutoPIPE
            • "The required information is missing for this flange" - Bentley Message in AutoPIPE
            • "The value should be in range 0.010 to 10.000"... message appears when using AutoPIPE, why?
            • "Unable to generate Stress Isometric...." Bentley AutoPIPE dialog appears, why?
            • "Unable to open the asme2010.mdb database"... Bentley AutoPIPE message is displayed in the program?
            • "W88-24: Allowable based on cold yield Sy may be un-conservative" Bentley AutoPIPE message is displayed in the program?
          • +"Bentley Systems, Inc" Messages displayed in AutoPIPE
          • "Bentley.lictransmit for Windows has stopped working" message appears when using AutoPIPE program, why?
          • +"Blank" Messages displayed in AutoPIPE
          • +"Bolts*" Messages displayed in AutoPIPE
          • +"Confirm" Messages displayed in AutoPIPE
          • +"Error" messages displayed in AutoPIPE
          • +"Flange*" Messages displayed in AutoPIPE
          • +"Incorrect Data" messages displayed in AutoPIPE
          • +"Intel(r) Visual Fortran run-time error" messages displayed in AutoPIPE
          • +"Invalid Format" messages displayed in AutoPIPE
          • +"License Management Tool" Messages displayed in AutoPIPE
          • "Message from SofTrack" Messages displayed in AutoPIPE
          • +"Microsoft .NET Framework".. messages displayed in AutoPIPE
          • "Microsoft Visual C++ Runtime Library" message appears in AutoPIPE
          • "New Case Failed" Messages displayed in AutoPIPE
          • +"Note" Messages in AutoPIPE
          • +"PCFin" Messages displayed in AutoPIPE
          • +"Report Generator Error" Messages displayed in AutoPIPE
          • +"Reverse Segment" Messages displayed in AutoPIPE
          • +"SACS Export Error" messages displayed in AutoPIPE
          • +"Script Error" messages displayed in AutoPIPE
          • +"Text Node Editor" Messages displayed in when using OPIM from within AutoPIPE
          • "Unable to Import the Excel File..." Messages displayed in AutoPIPE
          • +"Warnings" Messages displayed in AutoPIPE
          • 01. "C:\Program Files (X86)\..." - Type mismatch dialog message appears when reviewing the results grids in AutoPIPE, why?
          • +Application Crashed or Freezes - AutoPIPE
          • AutoPIPE Report Viewer has stopped working
          • +Blank Messages displayed in AutoPIPE
          • +Issues that occur when exporting files from AutoPIPE
          • +Issues that occur when generating Reports from AutoPIPE
          • +Issues that occur when importing PXF files into AutoPIPE
          • +Known errors that occur when Installing / Uninstalling AutoPIPE
      • +Bentley AutoPIPE Nozzle (WinNOZL)
      • +Bentley AutoPIPE Vessel (powered by Microprotol)
      • +Bentley PlantFLOW
      • +Bentley PULS
    • Multi-lingual announcement from BENTLEY TECHNICAL SUPPORT.
    • Working at Home with AutoPIPE
    • +AutoPIPE Brand Learning Resources
    • +Attend a live meeting with an AutoPIPE Analyst

     
     Questions about this article, topic, or product? Click here. 

    "Program failed to generate SQlite Database..." message appears in AutoPIPE

    Applies To
    Product(s): AutoPIPE
    Version(s): ALL;
    Area: Report
    Date Logged
    & Current Version
    Sept. 2018
    11.04.00.10

    Problem:

    The following message appears when exporting a WORD report from AutoPIPE

    ---------------------------
    Bentley AutoPIPE
    ---------------------------
    Program failed to generate SQLite Database
    ---------------------------
    OK  
    ---------------------------

    Why and how to avoid it?

    Solution:

    Test to be sure that the program is running correctly, Perform the following:

    1. Open Example model Walkthru.dat. [File> Example> Archive (*.APC)>]

    2. Save file to a new folder on your desktop.

    3. Analyze the model.

    4. Select File> Export> SQLite database (.db)

    5. A dialog should appear, enable both Input, Output, and "Open in Bentley SQLite report manger" options only. Press OK.

    6. This action will create a database file in your folder on the desktop and open the report manager.

    7. After the report manager opens, select the Input or Output Reports tab, move as many sub-reports from the left column to the right column and now press the green lighting bolt to generate the report. In just a few moments the report viewer will automatically appear displaying your report

    8. Open the folder where the model was stored, there should be 2 new files,

    a. WALKTHRU.db

    b. WALKTHRU_SupportReport.xlsx

    Avoidance:

    First try to recreate the output report again. If the error message appears again, after 3 tries confirm the following:

    1. Check that the path name and file name does not contain non-ascii character. Try saving the model as Test.dat to a new folder on the desktop, run an analysis, and create a complete report.

    2. Review all component tag fields and Attachment ID fields, nothing can be start with a quote (1116320), example "B" OUTLET NOZZLE, suggested change OUTLET NOZZLE "B".

    3. There may be one or more sub-reports having an issue, perform the following:

    a. Analyze the model

    b. Create a model input listing report. move only one report from the Available column on the left to the Selected Reports column on the right. and Press OK. 

    c. Regardless of the report being created or not, open the Model Input listing report dialog again, remove the report from the right column and add the next report from the left column to the right. Again press OK to try and create a report.

    d. Repeat step above for all available reports. and document reports that were unsuccessful created (ex. Anchor).

    e. Knowing which report(s) were not created, remove all of those components from the model (ex. If Anchor report was not created, delete all anchors from the model)

    f. After deleting all components, try and re-run the analysis and create again a complete model input listing. 

    g. Try to reinsert the deleted components into the model, re-run the analysis, and create again a complete model input listing. 

    4. Computer Virus protection program has AutoPIPE listed as an authorized application or exception.

    5. If using AutoPIPE CONNECT v11.04.xx.xx, confirm decimal character was set to a "." dot, program will display message above where decimal character was set to "," or " ' ". Avoidance, change decimal character to a " . " (dot). For instructions to do this, google "change region decimal character" . 

    6. You may try to "run the application as an Admin" by right clicking on AutoPIPE icon to start the program, select Properties, and select " Run as Admin". Try the steps above.

    7. Reboot the computer and try again. 

    Note: If the the message above appears, try again to generate a report. IF the problem continues, log a Bentley Service Request and send in your model APC file for review. 

    See Also

    "Bentley AutoPIPE" Messages

    Bentley AutoPIPE

    • AutoPIPE
    • failed
    • message
    • Bentley AutoPIPE
    • Database
    • SQLite
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Tue, Oct 2 2018 4:55 PM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Wed, Dec 23 2020 10:06 AM
    • Revisions: 17
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies