Unable to connect to Progress On-Premise from the Data Direct Cloud, again - Forum - DataDirect Cloud - Progress Community

Unable to connect to Progress On-Premise from the Data Direct Cloud, again

 Forum

Unable to connect to Progress On-Premise from the Data Direct Cloud, again

  • Experiencing another connection issue with our DDC and On-Premise connector the has previously been working and nothing changing on our end.  And I have actually, incorrectly, opened an issue with OE Support under 00260895.  My original post with this issue was turning into support case 00256502.


    Nothing has changed on our end, I can get to the server the On-Premise connector is on externally and internally on expected ports.  The database it is configured to run against is up and connectable.  The two error messages I get in a DDC test connect are:

    Your request has been timed out, could you try after some time

    Test connection failed, pelase try again later.

    Trying again later doesn't change the behavior.

  • Hi Jeff,

    We are looking into this issue. I will update this forum when I have more information.

    Regards,

    Rashmi

  • Hi Jeff,

    Have you tried to connect this morning? Are you still receiving the same error?

    Regards,

    Rashmi

  • I have not but will soon.  Our IT guys are putting in firewall changes for the issue with the not On-Premise connector needing ports open on the firewall.  Once that's completed, I'll try again.

  • We are still unable to connect.  Getting:

    Your request has been timed out, could you try after some time

  • Can you try to change the username stored in the following registry key to be lower case?  I have seen this resolve the timeout error in my own testing due to a known issue with the UI that is being resolved.

    HKEY_LOCAL_MACHINE\SOFTWARE\Progress Software Corporation\DDCloudOpAcc\ClientID

    Check out my world famous blog on data connectivity

  • Hi Jeff,

    Did Sumit's suggestion above resolve your issue or are you still having trouble connecting to your On-Premise OpenEdge database using DataDirect Cloud?

    Regards,

    Rashmi

  • Unfortunately no.  I did already have an id in there that was all lower case but retyped in my entry and there was still no connection.

  • Hi Jeff,
    Can you send me the On-Premise data host logs from your test connect attempt?

    The logs will be located in C:\Windows\System32\config\systemprofile\AppData\Roaming\Progress\DDCloudOpAcc.

    It might also help to change the Logging registry entry from 1 to 3 located under HKLM\SOFTWARE\Progress Software Corporation\DDCloudOpAcc.

    Regards,
    Rashmi

  • Here's the log:

    ==============================================================

    Client Build #Unknown Started: 2014-01-15T20-11-34

    ==============================================================

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Loading settings from registry key Software\Progress Software Corporation\DDCloudOpAcc

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key UdpServer, type REG_SZ, using value 'notification.datadirectcloud.com'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key UdpPort, type REG_SZ, using value '11235'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key ClientID, type REG_SZ, using value 'jbeisch'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key ConnectTimeoutSecsUdp, type DWORD, using value '60'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key ConnectTimeoutSecsTcp, type DWORD, using value '60'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key ConnectMaxErrorRetries, type DWORD, using value '2'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key ConnectFailedSleepSecs, type DWORD, using value '60'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key KeepAwakeIntervalUdp, type DWORD, using value '15'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key KeepAwakeIntervalTcp, type DWORD, using value '15'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key DeviceId, type REG_SZ, using value '07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key TcpServer, type REG_SZ, using value 'notification.datadirectcloud.com'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key TcpPort, type REG_SZ, using value '11235'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key RestServer, type REG_SZ, using value 'service.datadirectcloud.com'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key RestPort, type REG_SZ, using value 'https'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key ConnectionType, type DWORD, using value '1'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key OnPremiseDASPort, type REG_SZ, using value '10180'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key OnPremiseDAS, type REG_SZ, using value 'localhost'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key OnPremisePort, type REG_SZ, using value 'https'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key OnPremiseServer, type REG_SZ, using value 'opas.datadirectcloud.com'

    2014-01-15T20:11:34.0+00:00 INFO [CRegKeyEx::LoadValues] Result = 0 reading key RestServiceEntry, type REG_SZ, using value 'cloudservice/CloudSql'

    2014-01-15T20:11:34.0+00:00 DETAILS [CServerMonitor::startMonitor] Starting notification server monitor

    2014-01-15T20:11:34.0+00:00 DETAILS [CServerMonitor::asyncStartup] Setting timer for asynchronous startup in 100ms

    2014-01-15T20:11:34.0+00:00 DETAILS [serverMonitorWorkerFunc] Notification server monitor thread started, calling run to allow async operation

    2014-01-15T20:11:34.0+00:00 DETAILS [CServerMonitor::beginMonitor] Initializing monitor and calling asyncStartup()

    2014-01-15T20:11:34.0+00:00 DETAILS [CServerMonitor::getNotificationKey] Registering with ServiceAPI to get notification key

    2014-01-15T20:11:34.0+00:00 DETAILS [CServiceAPI::getDeviceNotificationKey] Device id = 07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2, payload = {"name":"DMSIDEVEL11","description":"Windows Server 2008 R2 Enterprise"}

    2014-01-15T20:11:34.0+00:00 DETAILS [CServiceAPI::authenticateClient] Authenticating client

    2014-01-15T20:11:34.0+00:00 DETAILS [CServiceAPI::authenticateUser] Authenticating user: jbeisch using HTTPS

    2014-01-15T20:11:35.0+00:00 DETAILS [CSecureSocket::connect] Calling resolver.resolve for host 'service.datadirectcloud.com', port 'https'

    2014-01-15T20:11:35.0+00:00 DETAILS [CSecureSocket::connect] Resolved endpoint = 107.23.123.251

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::authenticateUser] Authenticating userId

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] REST Request Headers:

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] POST /cloudservice/CloudSql/auth HTTP/1.1

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] Host: service.datadirectcloud.com

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] Connection: close

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders]

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readStatusLine] HTTP/1.1 200 OK

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readPayloadString] Processing non-chunked payload, contentLen = 290

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readPayloadString] ContentLen (or current chunk length) = 290

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readPayloadString] Bytes already available in the response object = 290

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readPayloadString] Bytes to read  (contentLen - available) = 0

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readPayloadString] BytesToRead is greater than 0 so setting bytesRead = contentLen = 0

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readPayloadString] Appending 0 bytes to payload string starting at offset 290

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::authenticateUser] Authentication result: '{"createdAt":"2014-01-15T20:11:35.451+0000","key":"CuYBLcE+2+fkVfyH4eRJQkBoFEZygYzoWKDpo1YiDv8UfRWOpuqJY61f+vL11JwMhC7i9tvKsv+2rDNsDqZtZ4dnP/7x1nSpDfVNKiIdAf/P14rfpKvEgvnE7dtpJgYRmz+JykvJsvAcTht2cAYFEB5AmS4F7XtAtWPGO7Agov+W9AmvLz9bn4vqc7W/5tg1","expiresAt":"2014-01-15T21:11:35.451+0000"}

    '

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::authenticateClient] New authentication good for 3601 seconds

    2014-01-15T20:11:35.0+00:00 DETAILS [CSecureSocket::connect] Calling resolver.resolve for host 'service.datadirectcloud.com', port 'https'

    2014-01-15T20:11:35.0+00:00 DETAILS [CSecureSocket::connect] Resolved endpoint = 107.21.50.14

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] REST Request Headers:

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] POST /cloudservice/CloudSql/devices/07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2 HTTP/1.1

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] Host: service.datadirectcloud.com

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] Accept: */*

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] Content-Type: application/json

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] X-DataDirect-Palette-AuthToken:CuYBLcE+2+fkVfyH4eRJQkBoFEZygYzoWKDpo1YiDv8UfRWOpuqJY61f+vL11JwMhC7i9tvKsv+2rDNsDqZtZ4dnP/7x1nSpDfVNKiIdAf/P14rfpKvEgvnE7dtpJgYRmz+JykvJsvAcTht2cAYFEB5AmS4F7XtAtWPGO7Agov+W9AmvLz9bn4vqc7W/5tg1

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] X-DataDirect-Easyl-AuthToken:CuYBLcE+2+fkVfyH4eRJQkBoFEZygYzoWKDpo1YiDv8UfRWOpuqJY61f+vL11JwMhC7i9tvKsv+2rDNsDqZtZ4dnP/7x1nSpDfVNKiIdAf/P14rfpKvEgvnE7dtpJgYRmz+JykvJsvAcTht2cAYFEB5AmS4F7XtAtWPGO7Agov+W9AmvLz9bn4vqc7W/5tg1

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] Content-Length: 72

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] X-Palette-Device: 07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] X-Easyl-Device: 07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders] Connection: close

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::logHeaders]

    2014-01-15T20:11:35.0+00:00 ERROR [CServiceAPI::readStatusLine] Response returned with HTTP status code 401

    2014-01-15T20:11:35.0+00:00 DETAILS [CServiceAPI::readStatusLine] HTTP/1.1 401 Unauthorized

    2014-01-15T20:11:35.0+00:00 ERROR [CServiceAPI::getDeviceNotificationKey] Failed reading response with HTTP error 401, socket error 0, The operation completed successfully

    2014-01-15T20:11:36.0+00:00 INFO [CServerMonitor::getNotificationKey] Authentication error when getting Device Notification Key, now doing a forced re-authenticate

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::authenticateClient] Authenticating client

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::authenticateUser] Authenticating user: jbeisch using HTTPS

    2014-01-15T20:11:36.0+00:00 DETAILS [CSecureSocket::connect] Calling resolver.resolve for host 'service.datadirectcloud.com', port 'https'

    2014-01-15T20:11:36.0+00:00 DETAILS [CSecureSocket::connect] Resolved endpoint = 107.23.123.251

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::authenticateUser] Authenticating userId

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] REST Request Headers:

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] POST /cloudservice/CloudSql/auth HTTP/1.1

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] Host: service.datadirectcloud.com

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] Connection: close

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders]

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readStatusLine] HTTP/1.1 200 OK

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readPayloadString] Processing non-chunked payload, contentLen = 290

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readPayloadString] ContentLen (or current chunk length) = 290

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readPayloadString] Bytes already available in the response object = 290

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readPayloadString] Bytes to read  (contentLen - available) = 0

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readPayloadString] BytesToRead is greater than 0 so setting bytesRead = contentLen = 0

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readPayloadString] Appending 0 bytes to payload string starting at offset 290

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::authenticateUser] Authentication result: '{"createdAt":"2014-01-15T20:11:36.463+0000","key":"CuYBLQC92gQ2AFXdwAumX2s0D/SfwpMV9LlI1jdGjNBeNy4wK2B+9NGfc8jqzDnTZDPLQRSKhniQ2+3kRHxcx6SbxkrjUXo92ZwQeVj8bQH5gNALPwCSgdd2Va0KBXiNbiirmjMgGjc7e5XSqLEjPMJnhyVfTeJBc/mh4wF0fwbC75aodPffaIcjzauNftDa","expiresAt":"2014-01-15T21:11:36.463+0000"}

    '

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::authenticateClient] New authentication good for 3600 seconds

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::getDeviceNotificationKey] Device id = 07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2, payload = {"name":"DMSIDEVEL11","description":"Windows Server 2008 R2 Enterprise"}

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::authenticateClient] Authentication still valid for 3600 seconds

    2014-01-15T20:11:36.0+00:00 DETAILS [CSecureSocket::connect] Calling resolver.resolve for host 'service.datadirectcloud.com', port 'https'

    2014-01-15T20:11:36.0+00:00 DETAILS [CSecureSocket::connect] Resolved endpoint = 107.21.50.14

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] REST Request Headers:

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] POST /cloudservice/CloudSql/devices/07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2 HTTP/1.1

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] Host: service.datadirectcloud.com

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] Accept: */*

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] Content-Type: application/json

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] X-DataDirect-Palette-AuthToken:CuYBLQC92gQ2AFXdwAumX2s0D/SfwpMV9LlI1jdGjNBeNy4wK2B+9NGfc8jqzDnTZDPLQRSKhniQ2+3kRHxcx6SbxkrjUXo92ZwQeVj8bQH5gNALPwCSgdd2Va0KBXiNbiirmjMgGjc7e5XSqLEjPMJnhyVfTeJBc/mh4wF0fwbC75aodPffaIcjzauNftDa

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] X-DataDirect-Easyl-AuthToken:CuYBLQC92gQ2AFXdwAumX2s0D/SfwpMV9LlI1jdGjNBeNy4wK2B+9NGfc8jqzDnTZDPLQRSKhniQ2+3kRHxcx6SbxkrjUXo92ZwQeVj8bQH5gNALPwCSgdd2Va0KBXiNbiirmjMgGjc7e5XSqLEjPMJnhyVfTeJBc/mh4wF0fwbC75aodPffaIcjzauNftDa

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] Content-Length: 72

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] X-Palette-Device: 07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] X-Easyl-Device: 07ea3e8a-0e81-4bf4-8cfc-de295aa04ba2

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders] Connection: close

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::logHeaders]

    2014-01-15T20:11:36.0+00:00 ERROR [CServiceAPI::readStatusLine] Response returned with HTTP status code 401

    2014-01-15T20:11:36.0+00:00 DETAILS [CServiceAPI::readStatusLine] HTTP/1.1 401 Unauthorized

    2014-01-15T20:11:36.0+00:00 ERROR [CServiceAPI::getDeviceNotificationKey] Failed reading response with HTTP error 401, socket error 0, The operation completed successfully

    2014-01-15T20:11:36.0+00:00 WARN [CServerMonitor::getNotificationKey] Call to api.getDeviceNotificationKey() failed

    2014-01-15T20:11:36.0+00:00 INFO [CServerMonitor::onDisconnect] Sleeping for 60 seconds before next retry

    It still errors and from the log it looks like something isn't connecting right to the DDC resources.  I have the same username and password in the On-Premise configuration as I use to log into the website to do the testing and view my DDC resources.

  • Hi Jeff,

    Based on the above log, can you wait until the Connector on the host computer is registered before attempting a connection? If you are still observing failures, please send all the log files that get generated for this issue with HKLM\SOFTWARE\Progress Software Corporation\DDCloudOpAcc set to 3.

    Regards,

    Rashmi