Database login failed - Intergraph Smart Construction - Hotfix 14 - Help - Hexagon

Intergraph Smart Construction Help

Language
English
Product
Intergraph Smart Construction
Search by Category
Help
Smart Construction Version
8
SmartPlant Foundation / SDx Version
10

Error Message

Database login failed

Solution

  • If the report requires a driver, verify the correct driver is referenced. Using verbose tracing, you can view the log file to see if the correct driver is found.

  • Verify that the data generated by the report matches the data that the report template is expecting by generating some debugging files to inspect the XML format of the report:

    1. Set the SPCSaveDebugFiles property for your Smart Construction site to TRUE in SmartPlant Foundation Server Manager, and verify that the SPCDebugTempDataPath property is set to a valid path. Reset application pools, and run the report.

      The error displays again; however, XML files are now available at the path specified in the SPCDebugTempDataPath property.

    2. Open CG_ReportData.xml, and verify the structure in that file matches the structure of the XML used by the data source of the report template.

    3. If it doesn’t match, edit the data source to match the structure in CG_ReportData.xml, or use the driver to manipulate the XML to make it match what the data source is expecting.

      In some instances, the data is correct and the report runs; however, the report might fail because data is missing that is sometimes available in the report. For example, a report might expect nodes for a work step, but the generated report is for a work package that does not contain any work steps. This can be fixed by placing an empty placeholder node with the required properties into the XML so that it retains its correct structure.

For more information, see the Configure Smart Construction reports.