Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • You may be familiar with Communities' brand new layout from SE.com.
  • Don't forget to update your bookmarks and saved links with our new address (https://community.se.com/).
  • If you encounter any issues, please contact SchneiderCommunity.Support@se.com.
Close
Sign In Help
Important Announcement: WELCOME to the Schneider Electric Community! We have moved to a new address: community.se.com — bookmark it today and contact SchneiderCommunity.Support@se.com if you have any questions!
Schneider Electric
Help
Ask the Community Community Guidelines Community User Guide How-To & Best Practices Contact Support
Login / Register
Community Menu
  • Community Home
  • Forums
    • By Topic
        • Support
          • Ask the Community
        • EcoStruxure Building
          • SmartConnector Forum
          • Field Devices Forum
        • EcoStruxure Power & Grid
          • EcoStruxure Energy Hub User Group
          • Gateways and Energy Servers
          • Metering & Power Quality
        • APC UPS, Critical Power, Cooling and Racks
          • APC UPS Data Center & Enterprise Solutions Forum
          • APC UPS for Home and Office Forum
        • EcoStruxure IT
          • EcoStruxure IT forum
        • Remote Operations
          • EcoStruxure Geo SCADA Expert Forum
          • Remote Operations Forum
        • Industrial Automation
          • Industry Automation and Control Forum
          • Industrial Edge Computing Forum
          • Alliance System Integrators Forum
          • Machine Automation Forum
          • EcoStruxure Automation Expert / IEC 61499 Forum
          • AVEVA Plant SCADA Forum
          • Modicon PAC Forum
          • Harmony Control Customization Forum
          • Level and Pressure Instrumentation Forum
          • PLC Club Indonesia
          • Fabrika ve Makina Otomasyonu Çözümleri
          • Motorabgangstechnik & Antriebstechnik Forum
          • Korea Industrial Automation Forum
        • Schneider Electric Wiser
          • Schneider Electric Wiser Forum
        • Power Distribution IEC
          • Power Distribution and Digital
          • Solutions for Motor Management
          • Paneelbouw & Energie Distributie
          • Eldistribution & Fastighetsautomation
          • Elektrik Tasarım Dağıtım ve Uygulama Çözümleri
          • Електропроектанти България
          • Specifiers Club ZA Forum
        • Power Distribution NEMA
          • Power Monitoring and Energy Automation NAM
        • Power Distribution Software
          • EcoStruxure Power Design Forum
          • LayoutFAST User Group Forum
        • Solutions for your Business
          • Solutions for your Business Forum
      • Support
        • Ask the Community
      • EcoStruxure Building
        • SmartConnector Forum
        • Field Devices Forum
      • EcoStruxure Power & Grid
        • EcoStruxure Energy Hub User Group
        • Gateways and Energy Servers
        • Metering & Power Quality
      • APC UPS, Critical Power, Cooling and Racks
        • APC UPS Data Center & Enterprise Solutions Forum
        • APC UPS for Home and Office Forum
      • EcoStruxure IT
        • EcoStruxure IT forum
      • Remote Operations
        • EcoStruxure Geo SCADA Expert Forum
        • Remote Operations Forum
      • Industrial Automation
        • Industry Automation and Control Forum
        • Industrial Edge Computing Forum
        • Alliance System Integrators Forum
        • Machine Automation Forum
        • EcoStruxure Automation Expert / IEC 61499 Forum
        • AVEVA Plant SCADA Forum
        • Modicon PAC Forum
        • Harmony Control Customization Forum
        • Level and Pressure Instrumentation Forum
        • PLC Club Indonesia
        • Fabrika ve Makina Otomasyonu Çözümleri
        • Motorabgangstechnik & Antriebstechnik Forum
        • Korea Industrial Automation Forum
      • Schneider Electric Wiser
        • Schneider Electric Wiser Forum
      • Power Distribution IEC
        • Power Distribution and Digital
        • Solutions for Motor Management
        • Paneelbouw & Energie Distributie
        • Eldistribution & Fastighetsautomation
        • Elektrik Tasarım Dağıtım ve Uygulama Çözümleri
        • Електропроектанти България
        • Specifiers Club ZA Forum
      • Power Distribution NEMA
        • Power Monitoring and Energy Automation NAM
      • Power Distribution Software
        • EcoStruxure Power Design Forum
        • LayoutFAST User Group Forum
      • Solutions for your Business
        • Solutions for your Business Forum
      • Food & Beverage
      • Healthcare
  • Knowledge Center
    • Building Automation Knowledge Base
    • Geo SCADA Knowledge Base
    • Industrial Automation How-to videos
    • Digital E-books
    • Success Stories Corner
  • Success Stories
  • Events & Webinars
    • All Events
    • Innovation Talks
    • Innovation Summit
    • Let's Exchange Series
    • Technology Partners
    • Power Events & Webinars 
    • Partner Success
    • Process Automation Talks 
  • Ideas
        • Remote Operations
          • EcoStruxure Geo SCADA Expert Ideas
          • Remote Operations Devices Ideas
        • Industrial Automation
          • Modicon Ideas & new features
  • Blogs
    • By Topic
        • EcoStruxure Power & Grid
          • Backstage Access Resources
        • Remote Operations
          • Remote Operations Blog
        • Industrial Automation
          • Industry 4.0 Blog
          • Industrie du Futur France
        • Power Distribution NEMA
          • NEMA Power Foundations Blog
        • Knowledge Center
          • Geo SCADA Knowledge Base
          • Industrial Automation How-to videos
          • Digital E-books
          • Success Stories Corner
      • EcoStruxure Power & Grid
        • Backstage Access Resources
      • Remote Operations
        • Remote Operations Blog
      • Industrial Automation
        • Industry 4.0 Blog
        • Industrie du Futur France
      • Power Distribution NEMA
        • NEMA Power Foundations Blog
      • Knowledge Center
        • Geo SCADA Knowledge Base
        • Industrial Automation How-to videos
        • Digital E-books
        • Success Stories Corner
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
  • Communities
  • :
  • Knowledge Center
  • :
  • Building Automation Knowledge Base
  • :
  • StruxureWare ETL tool locks up or takes a long time while loading sources
How can we help?
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
82794members
350631posts

StruxureWare ETL tool locks up or takes a long time while loading sources

Back to Building Automation Knowledge Base
Options
  • Article History
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content
0 Likes
2613 Views
Trying to translate this page to your language?
Select your language from the translate dropdown in the upper right. arrow
Translate to: English
  • (Français) French
  • (Deutsche) German
  • (Italiano) Italian
  • (Português) Portuguese
  • (Русский) Russian
  • (Español) Spanish
Share

StruxureWare ETL tool locks up or takes a long time while loading sources

Picard Product_Support
‎2018-09-10 04:16 AM

Last Updated: Administrator CraigEl Administrator 2 weeks ago

Issue

The ETL job configuration tool freezes when running the load sources task under the mappings tab.

Product Line

EcoStruxure Building Operation

Environment

  • Extract Transform Load Administration Tool (ETL)
  • Power Manager for SmartStruxure
  • EcoStruxure Web Services (EWS)
  • Enterprise Server
  • Automation Server

Cause

The ETL default HTTP query size is set to 10 which in some cases can impact the performance of the tool.

Resolution

Make sure that you read through Energy Expert (Power Manager for SmartStruxure): Best Practices. This article will provide a lot of tips to avoid issues or improve system performance.

ETL locks up while loading sources

Adjust the HTTP query size to a higher value. This will reduce the number of queries between ETL and the SBO Server.

  1. Close ETL.
  2. Go to the location where ETL is installed. The default path is C:\Program Files\Schneider Electric\ETL X.X (SBO to PME).
  3. Under the Jobs folder there is a project file named "JOB_ETLProjectName.xml". Open this XML file with a text editor.
  4. Search for the setting called "ContainerQueryBatchSize". It is set to 10 by default, change it to 100 and save the job.
  5. Open the ETL user interface again and try running the Load Sources task. The folder count at the bottom of the screen will increase slower then before because each call is gathering ten times as much data.

Note: If the ETL tool locks up again with the query size set to 100, try other values until it is able to complete the task such as 50, 25, etc.


ETL takes a very long time to load sources

When dealing with very large systems it can take hours for ETL to search through the entire database for all trends. To help reduce the searching time filters can be created to restrict what is exposed to EWS.

  1. Go to the System folder EcoStruxure Web Services > EWS Server Configuration. Click on the Filter Hardware Folder tab.
  2. Under the "Filter Hardware Folder by Path" section, click on the green addition symbol. In the pop up window, name the path filter and click create.
  3. Select the newly created filter path and click on the edit symbol. Enter the path of the folder or item in the database that you want to exclude from EWS. Click Okay.
    Note: All filter paths created here will NOT be searched by the ETL tool.
  4. Save changes.
  5. Once the ETL tool has loaded sources and the project has been created, the EWS filters may be removed.
Labels (1)
Labels:
  • EcoStruxure Building Operation
Tags (6)
  • Find more articles tagged with:
  • 18672
  • error
  • finish
  • stops
  • tags
  • working
Was this article helpful? Yes No
100% helpful (1/1)
Share

Related Forums

  • Field Devices Forum
Previous Next
Contributors
  • DavidFisher
    DavidFisher
  • Product_Support
    Product_Support
  • CraigEl
    CraigEl
  • Cody_Failinger
    Cody_Failinger
Invite a Colleague
Found this content useful? Share it with a Colleague!
Invite a Colleague

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practices
  • Experts Leaderboard
  • Contact Support
 
  • twitter
  • facebook
  • linkedin
  • youtube
  • blog
  • instagram
Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account..

Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account?Login

Privacy Notice Terms of Use Customize Preferences
© 2022, Schneider Electric