Sigma Transition Issues

[Product_Support]

Issue

Sigma server fails when a Data Import is initiated during a Sigma transition into EcoStruxure Building Operation (EBO).

Product Line

EcoStruxure Building Operation, Satchwell Sigma

Environment

• Satchwell Sigma
• Building Operation Enterprise Server

Cause

The failure typically occurs due to data integrity issues within the Sigma database. These issues must be resolved before initiating the transition.

Resolution

Before transitioning Sigma into EBO, run the SigmaX Doctor utility to validate and clean the database. Address the following common issues:

1. Longtext File Issues

• Symptoms: Contains 'Mandarin'-type characters, likely from previous BAS/Sigma upgrades.
• Action:
  • Delete the longtext file located at C:\sigma\data.
  • The file will auto-recreate if needed.

2. Shorttext File Issues

• Symptoms: Contains incorrectly formatted entries.
• Action:
  • Use a binary search method to locate the faulty entry:
    • Delete entries 1–250. If the issue persists, check entries 251–500.
    • Continue halving the range until the problematic entry is found and corrected.

3. Index A Errors

• Types:
  • Looping Segment: Page references itself.
  • Multiple References: Page can be accessed via multiple routes.
• Action:
  • Use SigmaX Doctor to correct the index structure.

4. Object Corruption

• Symptoms: Object fails to open in Sigma.
• Action:
  • Open the object in Sigma and correct it using appropriate methods.
  • If unresolved, the server will fail during Data Import.

5. Log Sets Import Failure

• Symptoms: Log sets fail to import.
• Action:
  • Locate logset.rec in C:\sigma\data\server...folder.
  • Make a backup copy.
  • Delete 50% of log sets and retry the import.
    • If it fails, delete another 50%.
    • If it succeeds, the issue lies in the deleted portion.
  • Use the backup to reinstate and isolate the problematic log sets.

---

⚠️ Important Notice

Sigma is not supported in EBO 2022 and later.
To continue supporting Sigma devices, you can implement a multi-version system:

• Keep Enterprise Servers with Sigma devices on Building Operation 3.2.
• Add a Building Operation 2022 or later Enterprise Central
• Upgrade the rest of the system to Building Operation 2022 or later.

You will not be able to upgrade EcoStruxure Building Operation servers that contain unsupported protocols, objects, or devices. Attempting to do so will result in failed upgrades or loss of functionality.