Precisely Enterworks

 View Only
Back to discussions
Expand all | Collapse all

EnterWorks Tech Talk: "ETT 176 - Finding Bad Decimal Attribute Values Using SQL" Published on Precisely University

  • 1.  EnterWorks Tech Talk: "ETT 176 - Finding Bad Decimal Attribute Values Using SQL" Published on Precisely University

    Employee
    Posted 04-01-2025 18:42

    EnterWorks uses a snapshot table for each repository to store a subset of the repository's attribute data in a relational format. This improves performance during searches, sorting, and displaying data. However, there are instances when one or more records in the repository do not have a corresponding entry in the snapshot table. One common cause for this includes a data truncation error occurred during the insertion of a record into the snapshot table.

    This session describes the consequences of the data truncation errors along with presenting a SQL stored procedure that can be used to report bad decimal values.

    Link: https://preciselyu.precisely.com/enterworks-ett-176-determining-the-appropriate-number-of-worker-processes-by-usage/2184265



    ------------------------------
    Brian Zupke
    Precisely Software Inc.
    ------------------------------