Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 08:39:00 +0000



SC Gets Stuck During IB Historical Data Update

View Count: 1332

[2018-11-02 13:05:13]
jackw - Posts: 57
Using SC 1823. Just started this morning. When I connect to IB data feed, the 'Downloading Historical Data' message appears, and remains on the screen until I disconnect. Here's the log:

Software version: 1823 64-bit | 2018-11-02 08:56:07
Usage end date: 2018-11-16 | 2018-11-02 08:56:07
Enabled for: Advanced Features. | 2018-11-02 08:56:07
Enabled for: Sierra Chart Historical Data Service. | 2018-11-02 08:56:07
Allow Support for Sierra Chart Data Feeds is enabled. | 2018-11-02 08:56:07
Current selected Data/Trading service: Interactive Brokers | 2018-11-02 08:56:07
Chart Update Interval: 200 | 2018-11-02 08:56:07
Time Zone: -04:00:00 (EST-05EDT+01,M3.2.0/02:00,M11.1.0/02:00) | 2018-11-02 08:56:07
2018-11-02 08:56:07 Local computer time | 2018-11-02 08:56:07
2018-11-02 12:56:07 Local computer time in UTC | 2018-11-02 08:56:07
2018-11-02 08:56:07 Local computer time in SC Time Zone | 2018-11-02 08:56:07
2018-11-02 12:28:29 Server time in UTC | 2018-11-02 08:56:07
Local computer UTC time and Server UTC time difference: 0 seconds. | 2018-11-02 08:56:07
Program path: C:\SierraChart\ | 2018-11-02 08:56:07
Data Files path: C:\SierraChart\Data\ | 2018-11-02 08:56:07
OS Version Number: 6.3 | 2018-11-02 08:56:07
Locale Setting: C | 2018-11-02 08:56:07


Interactive Brokers | Connecting to 127.0.0.1:7496 | 2018-11-02 08:56:11
Socket (1) | Creating socket. | 2018-11-02 08:56:11
Socket (1) | Connecting to IP: 127.0.0.1. | 2018-11-02 08:56:11
Interactive Brokers | Sending API sign: API | 2018-11-02 08:56:12
Interactive Brokers | Sending client version: v100..136. Waiting for acceptance. | 2018-11-02 08:56:12
Interactive Brokers | TWS server version: 136 | 2018-11-02 08:56:12
Interactive Brokers | TWS time: 20181102 08:56:11 EST | 2018-11-02 08:56:12
Interactive Brokers | Connected. Sending Start API command. | 2018-11-02 08:56:12
Interactive Brokers | Waiting for account information. | 2018-11-02 08:56:12
IB Account information received. | 2018-11-02 08:56:12
Interactive Brokers | Received 2 Trade Accounts from TWS. | 2018-11-02 08:56:12
Interactive Brokers | Connected to Live account. | 2018-11-02 08:56:12
Interactive Brokers | Year-Month last connected to Live account: 2018-11 | 2018-11-02 08:56:12
Interactive Brokers | Connected to data and trading server. | 2018-11-02 08:56:12
Next valid order ID: 1 | 2018-11-02 08:56:12
Message from IB: Market data farm connection is OK:usfuture. IB Error Code: 2104. Request ID: -1. | 2018-11-02 08:56:12
Message from IB: Market data farm connection is OK:usfarm.us. IB Error Code: 2104. Request ID: -1. | 2018-11-02 08:56:12
Message from IB: Market data farm connection is OK:usfarm. IB Error Code: 2104. Request ID: -1. | 2018-11-02 08:56:12
Next valid order ID: 1 | 2018-11-02 08:56:12
Interactive Brokers | Starting real-time market data updates for: ES-201812-GLOBEX. ID: 1 | 2018-11-02 08:56:12
Interactive Brokers | Subscribing to Symbol: ES, SecurityType: FUT, Expiration: 201812, Exchange: GLOBEX, Primary Exchange: , Currency: , Multiplier: , CallPut: , Strike: , LocalSymbol: , TradingClass: | 2018-11-02 08:56:12
Interactive Brokers | Requesting security definition data for: ES-201812-GLOBEX. ID: 1 | 2018-11-02 08:56:12
Starting first historical Intraday data download. When complete another download will be done from the primary service. Symbol: ES-201812-GLOBEX | 2018-11-02 08:56:12
Intraday data recording state for symbol ES-201812-GLOBEX is set to download 'Pending'. | 2018-11-02 08:56:12
Delaying start of download for ES-201812-GLOBEX | 2018-11-02 08:56:12
Interactive Brokers | Market data type is Live for ES-201812-GLOBEX | 2018-11-02 08:56:12
Interactive Brokers | Requesting Trade Positions snapshot and updates (IB account data updates) for account: U200* | 2018-11-02 08:56:17
Interactive Brokers | Received Trade Positions download end message for account U200* | 2018-11-02 08:56:17
Interactive Brokers | Stopping automatic Trade Position updates for account: U200* | 2018-11-02 08:56:17
Interactive Brokers | Requesting Trade Positions snapshot and updates (IB account data updates) for account: U729* | 2018-11-02 08:56:17
Message from IB: API client has been unsubscribed from account data. IB Error Code: 2100. Request ID: -1. | 2018-11-02 08:56:17
Interactive Brokers | Received Trade Positions download end message for account U729* | 2018-11-02 08:56:17
Interactive Brokers | Stopping automatic Trade Position updates for account: U729* | 2018-11-02 08:56:17
Message from IB: API client has been unsubscribed from account data. IB Error Code: 2100. Request ID: -1. | 2018-11-02 08:56:17
HD Request # 16 | Downloading Intraday chart data for ES-201812-GLOBEX to the file ES-201812-GLOBEX.scid. Service: cme | 2018-11-02 08:56:17
HD Request # 16 | Download start date-time: 2018-11-02 08:43:00.000 | 2018-11-02 08:56:17
HD Request # 16 | Using server: ds7.sierracharts.com port 10149 | 2018-11-02 08:56:17
Socket (2) | Creating socket. | 2018-11-02 08:56:17
Socket (2) | Connecting to IP: 8.18.161.133. | 2018-11-02 08:56:17
HD Request # 16 | Setting DTC encoding to Binary VLS | 2018-11-02 08:56:17
HD Request # 16 | Sending historical data logon request message. | 2018-11-02 08:56:17
HD Request # 16 | Requesting Intraday data. Start date-time: 2018-11-02 08:43:00. Record interval: 60. Symbol: ESZ18 | 2018-11-02 08:56:17
HD Request # 16 | Decompressing data. | 2018-11-02 08:56:17
HD Request # 16 | Receiving Intraday data for ES-201812-GLOBEX starting at 2018-11-02 08:43:00 | 2018-11-02 08:56:17
HD Request # 16 | Timestamp of first Intraday data file record written: 2018-11-02 08:43:00 | 2018-11-02 08:56:17
Socket (2) | Signaling to core to close socket | 2018-11-02 08:56:17
Socket (2) | Shutdown started. Waiting for graceful close. | 2018-11-02 08:56:17
Historical data download thread signaled to stop. | 2018-11-02 08:56:17
HD Request # 16 | Received 4 records from 2018-11-02 08:43:00 to 2018-11-02 08:46:00 (3.0 minutes) and wrote 4 records for ES-201812-GLOBEX | 2018-11-02 08:56:17
HD Request # 16 | Completion time: 0s | 2018-11-02 08:56:17
HD Request # 16 | Intraday data download complete for ES-201812-GLOBEX. Unique request ID: 16 | 2018-11-02 08:56:17
Removed historical data download ID 16 | 2018-11-02 08:56:17
Real-time Intraday chart data file updates started for ES-201812-GLOBEX | 2018-11-02 08:56:17
Opened cached Intraday file: C:\SierraChart\Data\ES-201812-GLOBEX.scid | 2018-11-02 08:56:17
Intraday chart data file opened for ES-201812-GLOBEX | 2018-11-02 08:56:17
Interactive Brokers | Using primary service for historical data for ES-201812-GLOBEX | 2018-11-02 08:56:17
Intraday data recording state for symbol ES-201812-GLOBEX is set to download 'Pending'. | 2018-11-02 08:56:17

HD Request # 17 | Downloading Intraday chart data for ES-201812-GLOBEX to the file ES-201812-GLOBEX.scid. Service: interactive_brokers.trading | 2018-11-02 08:56:17
HD Request # 17 | Download start date-time: 2018-11-02 08:46:00.000 | 2018-11-02 08:56:17
HD Request # 17 | Requesting a total of 0 days and 5417 seconds. | 2018-11-02 08:56:17
HD Request # 17 | IB Backfill - Seconds requested: 5417. Seconds Remaining: 0. | 2018-11-02 08:56:17
HD Request # 17 | Requesting 5417 Seconds of data at 1 min with ending date-time at 2018-11-02 10:06:17 for ES-201812-GLOBEX. PriceType: TRADES | 2018-11-02 08:56:17
Socket (2) | Socket gracefully closed by remote side. | 2018-11-02 08:56:17
Socket (2) | Closed. | 2018-11-02 08:56:17
File >> Disconnect selected. | 2018-11-02 08:57:32
HD Request # 17 | Download canceled. | 2018-11-02 08:57:32
HD Request # 17 | Received 0 records from 00:00:00 to 00:00:00 (0.0 seconds) and wrote 0 records for ES-201812-GLOBEX | 2018-11-02 08:57:32
HD Request # 17 | Completion time: 1m 15s | 2018-11-02 08:57:32
HD Request # 17 | Intraday data download complete for ES-201812-GLOBEX. Unique request ID: 17 | 2018-11-02 08:57:32
Removed historical data download ID 17 | 2018-11-02 08:57:32

Socket (1) | Signaling to core to close socket | 2018-11-02 08:57:32
Interactive Brokers | Disconnected. | 2018-11-02 08:57:32
Socket (1) | Shutdown started. Waiting for graceful close. | 2018-11-02 08:57:32
Socket (1) | Socket gracefully closed by remote side. | 2018-11-02 08:57:32
Socket (1) | Closed. | 2018-11-02 08:57:32
[2018-11-02 14:40:59]
jackw - Posts: 57
'Downloading Historical Data' message eventually went away (after 10 minutes or so), but there is a hole in my data. Here is an updated log:

Software version: 1823 64-bit | 2018-11-02 10:25:27
Usage end date: 2018-11-16 | 2018-11-02 10:25:27
Enabled for: Advanced Features. | 2018-11-02 10:25:27
Enabled for: Sierra Chart Historical Data Service. | 2018-11-02 10:25:27
Allow Support for Sierra Chart Data Feeds is enabled. | 2018-11-02 10:25:27
Current selected Data/Trading service: Interactive Brokers | 2018-11-02 10:25:27
Chart Update Interval: 200 | 2018-11-02 10:25:27
Time Zone: -04:00:00 (EST-05EDT+01,M3.2.0/02:00,M11.1.0/02:00) | 2018-11-02 10:25:27
2018-11-02 10:25:26 Local computer time | 2018-11-02 10:25:27
2018-11-02 14:25:26 Local computer time in UTC | 2018-11-02 10:25:27
2018-11-02 10:25:26 Local computer time in SC Time Zone | 2018-11-02 10:25:27
2018-11-02 12:28:29 Server time in UTC | 2018-11-02 10:25:27
Local computer UTC time and Server UTC time difference: 0 seconds. | 2018-11-02 10:25:27
Program path: C:\SierraChart\ | 2018-11-02 10:25:27
Data Files path: C:\SierraChart\Data\ | 2018-11-02 10:25:27
OS Version Number: 6.3 | 2018-11-02 10:25:27
Locale Setting: C | 2018-11-02 10:25:27


Interactive Brokers | Connecting to 127.0.0.1:7496 | 2018-11-02 10:25:51
Socket (1) | Creating socket. | 2018-11-02 10:25:51
Socket (1) | Connecting to IP: 127.0.0.1. | 2018-11-02 10:25:51
Interactive Brokers | Sending API sign: API | 2018-11-02 10:25:52
Interactive Brokers | Sending client version: v100..136. Waiting for acceptance. | 2018-11-02 10:25:52
Interactive Brokers | TWS server version: 136 | 2018-11-02 10:25:52
Interactive Brokers | TWS time: 20181102 10:25:50 EST | 2018-11-02 10:25:52
Interactive Brokers | Connected. Sending Start API command. | 2018-11-02 10:25:52
Interactive Brokers | Waiting for account information. | 2018-11-02 10:25:52
IB Account information received. | 2018-11-02 10:25:52
Interactive Brokers | Received 2 Trade Accounts from TWS. | 2018-11-02 10:25:52
Interactive Brokers | Connected to Live account. | 2018-11-02 10:25:52
Interactive Brokers | Year-Month last connected to Live account: 2018-11 | 2018-11-02 10:25:52
Interactive Brokers | Connected to data and trading server. | 2018-11-02 10:25:52
Next valid order ID: 1 | 2018-11-02 10:25:52
Message from IB: Market data farm connection is OK:usfuture. IB Error Code: 2104. Request ID: -1. | 2018-11-02 10:25:52
Message from IB: Market data farm connection is OK:usfarm.us. IB Error Code: 2104. Request ID: -1. | 2018-11-02 10:25:52
Message from IB: Market data farm connection is OK:usfarm. IB Error Code: 2104. Request ID: -1. | 2018-11-02 10:25:52
Next valid order ID: 1 | 2018-11-02 10:25:52
Interactive Brokers | Starting real-time market data updates for: ES-201812-GLOBEX. ID: 1 | 2018-11-02 10:25:52
Interactive Brokers | Subscribing to Symbol: ES, SecurityType: FUT, Expiration: 201812, Exchange: GLOBEX, Primary Exchange: , Currency: , Multiplier: , CallPut: , Strike: , LocalSymbol: , TradingClass: | 2018-11-02 10:25:52
Interactive Brokers | Requesting security definition data for: ES-201812-GLOBEX. ID: 1 | 2018-11-02 10:25:52
Starting first historical Intraday data download. When complete another download will be done from the primary service. Symbol: ES-201812-GLOBEX | 2018-11-02 10:25:52
Intraday data recording state for symbol ES-201812-GLOBEX is set to download 'Pending'. | 2018-11-02 10:25:52
Delaying start of download for ES-201812-GLOBEX | 2018-11-02 10:25:52
Interactive Brokers | Market data type is Live for ES-201812-GLOBEX | 2018-11-02 10:25:52
Interactive Brokers | Requesting Trade Positions snapshot and updates (IB account data updates) for account: U200* | 2018-11-02 10:25:57
Interactive Brokers | Received Trade Positions download end message for account U200* | 2018-11-02 10:25:57
Interactive Brokers | Stopping automatic Trade Position updates for account: U200* | 2018-11-02 10:25:57
Interactive Brokers | Requesting Trade Positions snapshot and updates (IB account data updates) for account: U729* | 2018-11-02 10:25:57
Message from IB: API client has been unsubscribed from account data. IB Error Code: 2100. Request ID: -1. | 2018-11-02 10:25:57
Interactive Brokers | Received Trade Positions download end message for account U729* | 2018-11-02 10:25:57
Interactive Brokers | Stopping automatic Trade Position updates for account: U729* | 2018-11-02 10:25:57
Message from IB: API client has been unsubscribed from account data. IB Error Code: 2100. Request ID: -1. | 2018-11-02 10:25:57
HD Request # 21 | Downloading Intraday chart data for ES-201812-GLOBEX to the file ES-201812-GLOBEX.scid. Service: cme | 2018-11-02 10:25:57
HD Request # 21 | Download start date-time: 2018-11-02 08:50:00.000 | 2018-11-02 10:25:57
HD Request # 21 | Using server: ds1.sierracharts.com port 10150 | 2018-11-02 10:25:57
Socket (2) | Creating socket. | 2018-11-02 10:25:57
Socket (2) | Connecting to IP: 8.18.161.135. | 2018-11-02 10:25:57
HD Request # 21 | Setting DTC encoding to Binary VLS | 2018-11-02 10:25:57
HD Request # 21 | Sending historical data logon request message. | 2018-11-02 10:25:57
HD Request # 21 | Requesting Intraday data. Start date-time: 2018-11-02 08:50:00. Record interval: 60. Symbol: ESZ18 | 2018-11-02 10:25:57
HD Request # 21 | Decompressing data. | 2018-11-02 10:25:57
HD Request # 21 | Receiving Intraday data for ES-201812-GLOBEX starting at 2018-11-02 08:50:00 | 2018-11-02 10:25:57
HD Request # 21 | Timestamp of first Intraday data file record written: 2018-11-02 08:50:00 | 2018-11-02 10:25:57
Socket (2) | Signaling to core to close socket | 2018-11-02 10:25:57
Socket (2) | Shutdown started. Waiting for graceful close. | 2018-11-02 10:25:57
Historical data download thread signaled to stop. | 2018-11-02 10:25:57
HD Request # 21 | Received 86 records from 2018-11-02 08:50:00 to 2018-11-02 10:15:00 (85.0 minutes) and wrote 86 records for ES-201812-GLOBEX | 2018-11-02 10:25:57
HD Request # 21 | Completion time: 0s | 2018-11-02 10:25:57
HD Request # 21 | Intraday data download complete for ES-201812-GLOBEX. Unique request ID: 21 | 2018-11-02 10:25:57
Removed historical data download ID 21 | 2018-11-02 10:25:57
Real-time Intraday chart data file updates started for ES-201812-GLOBEX | 2018-11-02 10:25:57
Opened cached Intraday file: C:\SierraChart\Data\ES-201812-GLOBEX.scid | 2018-11-02 10:25:57
Intraday chart data file opened for ES-201812-GLOBEX | 2018-11-02 10:25:57
Interactive Brokers | Using primary service for historical data for ES-201812-GLOBEX | 2018-11-02 10:25:57
Intraday data recording state for symbol ES-201812-GLOBEX is set to download 'Pending'. | 2018-11-02 10:25:57

HD Request # 22 | Downloading Intraday chart data for ES-201812-GLOBEX to the file ES-201812-GLOBEX.scid. Service: interactive_brokers.trading | 2018-11-02 10:25:57
HD Request # 22 | Download start date-time: 2018-11-02 10:15:00.000 | 2018-11-02 10:25:58
HD Request # 22 | Requesting a total of 0 days and 5457 seconds. | 2018-11-02 10:25:58
HD Request # 22 | IB Backfill - Seconds requested: 5457. Seconds Remaining: 0. | 2018-11-02 10:25:58
HD Request # 22 | Requesting 5457 Seconds of data at 1 min with ending date-time at 2018-11-02 11:35:57 for ES-201812-GLOBEX. PriceType: TRADES | 2018-11-02 10:25:58
Socket (2) | Socket gracefully closed by remote side. | 2018-11-02 10:25:58
Socket (2) | Closed. | 2018-11-02 10:25:58
ES-201812-GLOBEX 30 Min #1 | Reloading chart. | 2018-11-02 10:25:58
HD Request # 22 | Error downloading historical Intraday data for ES-201812-GLOBEX. The download timed out. | 2018-11-02 10:29:00
HD Request # 22 | Received 0 records from 00:00:00 to 00:00:00 (0.0 seconds) and wrote 0 records for ES-201812-GLOBEX | 2018-11-02 10:29:00
HD Request # 22 | Completion time: 3m 3s | 2018-11-02 10:29:00

HD Request # 23 | Downloading Intraday chart data for ES-201812-GLOBEX to the file ES-201812-GLOBEX.scid. Service: interactive_brokers.trading | 2018-11-02 10:29:00
HD Request # 23 | Download start date-time: 2018-11-02 10:15:00.000 | 2018-11-02 10:29:00
HD Request # 23 | Requesting a total of 0 days and 5640 seconds. | 2018-11-02 10:29:00
HD Request # 23 | IB Backfill - Seconds requested: 5640. Seconds Remaining: 0. | 2018-11-02 10:29:00
HD Request # 23 | Requesting 5640 Seconds of data at 1 min with ending date-time at 2018-11-02 11:39:00 for ES-201812-GLOBEX. PriceType: TRADES | 2018-11-02 10:29:00
Message from IB: Historical Market Data Service error message:API historical data query cancelled: 200002. IB Error Code: 162. Request ID: 200002. | 2018-11-02 10:29:00
HD Request # 23 | Error downloading historical Intraday data for ES-201812-GLOBEX. The download timed out. | 2018-11-02 10:32:00
HD Request # 23 | Received 0 records from 00:00:00 to 00:00:00 (0.0 seconds) and wrote 0 records for ES-201812-GLOBEX | 2018-11-02 10:32:00
HD Request # 23 | Completion time: 3m | 2018-11-02 10:32:00

HD Request # 24 | Downloading Intraday chart data for ES-201812-GLOBEX to the file ES-201812-GLOBEX.scid. Service: interactive_brokers.trading | 2018-11-02 10:32:00
HD Request # 24 | Download start date-time: 2018-11-02 10:15:00.000 | 2018-11-02 10:32:00
HD Request # 24 | Requesting a total of 0 days and 5820 seconds. | 2018-11-02 10:32:00
HD Request # 24 | IB Backfill - Seconds requested: 5820. Seconds Remaining: 0. | 2018-11-02 10:32:00
HD Request # 24 | Requesting 5820 Seconds of data at 1 min with ending date-time at 2018-11-02 11:42:00 for ES-201812-GLOBEX. PriceType: TRADES | 2018-11-02 10:32:00
Message from IB: Historical Market Data Service error message:API historical data query cancelled: 200003. IB Error Code: 162. Request ID: 200003. | 2018-11-02 10:32:00
HD Request # 24 | Error downloading historical Intraday data for ES-201812-GLOBEX. The download timed out. | 2018-11-02 10:35:00
HD Request # 24 | Received 0 records from 00:00:00 to 00:00:00 (0.0 seconds) and wrote 0 records for ES-201812-GLOBEX | 2018-11-02 10:35:00
HD Request # 24 | Completion time: 3m | 2018-11-02 10:35:00
HD Request # 24 | Intraday data download complete for ES-201812-GLOBEX. Unique request ID: 22 | 2018-11-02 10:35:00
Removed historical data download ID 22 | 2018-11-02 10:35:00
Real-time Intraday chart data file updates started for ES-201812-GLOBEX | 2018-11-02 10:35:00
Opened cached Intraday file: C:\SierraChart\Data\ES-201812-GLOBEX.scid | 2018-11-02 10:35:00
Intraday chart data file opened for ES-201812-GLOBEX | 2018-11-02 10:35:00

Message from IB: Historical Market Data Service error message:API historical data query cancelled: 200004. IB Error Code: 162. Request ID: 200004. | 2018-11-02 10:35:00
ES-201812-GLOBEX 30 Min #1 | Reloading chart. | 2018-11-02 10:35:20
ES-201812-GLOBEX 30 Min #1 | Reloading chart. | 2018-11-02 10:35:28
Date Time Of Last Edit: 2018-11-02 14:41:37
[2018-11-02 17:02:35]
Sierra Chart Engineering - Posts: 104368
You need to follow the instructions here:
Interactive Brokers Trading Service: Slow Historical Data Downloading (Slow Historical Data Downloading)
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account