41288members
184238posts

Sigma Transition Issues

Sigma Transition Issues

Issue

Sigma Transition issues upon Data Import the Sigma Server fails

Product Line

EcoStruxure Building Operation, Satchwell Sigma

Environment

  • Sigma
  • EBO

Cause

Sigma server fails when an EBO data import is initiated.

Resolution

It is important that the Sigma Database is checked with the Doctor utility (found in SigmaX) before a Sigma transition into EBO is undertaken.

  1. Longtext - Longtext file contains 'mandarin' type characters - probably from previous BAS/Sigma upgrades. If the file contains these, then Longtext has probably not been used in the past or currently. Delete File, it will self re-create.
  2. Shorttext - Shorttext contains an incorrectly formatted entry. Find entry and correct. To find, delete 1 -250, if it continues to fails, the entry in question will be in the range 251 to 500 and keep halving until the entry is found.
  3. Index A errors - index contains a looping segment, where the page references itself. Correct index as necessary.
  4. Index A errors - page is referenced more than once, i.e. the index page can be opened via two (or more) routes. Correct Index as necessary.
    Note: the Index should be checked with SigmaX before a transition.
  5. Object corruption - open object in Sigma, if it fails to open, then correct by whatever means that is required. Note, Sigma server will fail at a point during the Data Import.
Tags (2)
No ratings