IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Azure cosmosdb connector supported SDK version

  • 1.  Azure cosmosdb connector supported SDK version

    Posted Thu March 14, 2024 08:18 AM

    Has anyone succeed to query or get documents/items from recently created cosmosdb instance ?
    Connector returns a SDK incompatibility message.

    Created last week a free cosmosdb instance : https://learn.microsoft.com/en-us/azure/cosmos-db/try-free?tabs=nosql
    And inserted a few records.

    Tried to get documents with cosmosdb connector but without success.

    imagehttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/1abdb9c5c1c66a26c8c7cf11354003b069b5f48f.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/1abdb9c5c1c66a26c8c7cf11354003b069b5f48f.png 2x" data-dominant-color="FAF9F9">
    image509×614 18.6 KB

    screenshot from cosmosdb with document id ‘10120529’
    image

    Getting following error

    image
    image1376×413 25.6 KB

    unfortunately I can’t control the version/sdk compatability of cosmosdb instance.
    cosmosdb has this version “apiVersion”: “2023-11-15”,

    [
    “Message: {"Errors":["The collection cannot be accessed with this SDK version as it was created with newer SDK version."]}\r\nActivityId: 630004a4-277f-44fc-94ee-39d07a9d3f68, Request URI: /apps/9d36599a-2af3-4892-9521-e0023dfe192f/services/50e19159-00cf-4f87-9b73-124784159140/partitions/ac86293a-9f99-45bc-a01e-c22981e8d6b1/replicas/133544502068195091p/, RequestStats: \r\nRequestStartTime: 2024-03-14T12:12:05.1307001Z, RequestEndTime: 2024-03-14T12:12:05.1523250Z, Number of regions attempted:1\r\n{"systemHistory":[{"dateUtc":"2024-03-14T12:11:11.0080209Z","cpu":0.488,"memory":650512612.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0308,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":487},{"dateUtc":"2024-03-14T12:11:21.0181431Z","cpu":0.749,"memory":650490576.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0619,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":487},{"dateUtc":"2024-03-14T12:11:31.0275460Z","cpu":0.483,"memory":650479576.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0554,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":487},{"dateUtc":"2024-03-14T12:11:41.0379424Z","cpu":0.386,"memory":650493068.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0387,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":487},{"dateUtc":"2024-03-14T12:11:51.0477541Z","cpu":0.241,"memory":650504420.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.052,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":488},{"dateUtc":"2024-03-14T12:12:01.0577745Z","cpu":0.520,"memory":650453612.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.039,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":482}]}\r\nRequestStart: 2024-03-14T12:12:05.1318172Z; ResponseTime: 2024-03-14T12:12:05.1523250Z; StoreResult: StorePhysicalAddress: rntbd://cdb-ms-prod-eastus1-fd55.documents.azure.com:14004/apps/9d36599a-2af3-4892-9521-e0023dfe192f/services/50e19159-00cf-4f87-9b73-124784159140/partitions/ac86293a-9f99-45bc-a01e-c22981e8d6b1/replicas/133544502068195091p/, LSN: 16, GlobalCommittedLsn: 16, PartitionKeyRangeId: 0, IsValid: True, StatusCode: 400, SubStatusCode: 0, RequestCharge: 0, ItemLSN: -1, SessionToken: 16, UsingLocalLSN: True, TransportException: null, BELatencyMs: 0.204, ActivityId: 630004a4-277f-44fc-94ee-39d07a9d3f68, RetryAfterInMs: , ReplicaHealthStatuses: [(port: 14004 | status: Unknown | lkt: 3/12/2024 4:45:56 PM),(port: 14010 | status: Unknown | lkt: 3/12/2024 4:45:56 PM),(port: 14025 | status: Unknown | lkt: 3/12/2024 4:45:56 PM),(port: 14412 | status: Unknown | lkt: 3/12/2024 4:45:56 PM)], TransportRequestTimeline: {"requestTimeline":[{"event": "Created", "startTimeUtc": "2024-03-14T12:12:05.1317575Z", "durationInMs": 0.0079},{"event": "ChannelAcquisitionStarted", "startTimeUtc": "2024-03-14T12:12:05.1317654Z", "durationInMs": 18.7642},{"event": "Pipelined", "startTimeUtc": "2024-03-14T12:12:05.1505296Z", "durationInMs": 0.0781},{"event": "Transit Time", "startTimeUtc": "2024-03-14T12:12:05.1506077Z", "durationInMs": 1.2271},{"event": "Received", "startTimeUtc": "2024-03-14T12:12:05.1518348Z", "durationInMs": 0.0717},{"event": "Completed", "startTimeUtc": "2024-03-14T12:12:05.1519065Z", "durationInMs": 0}],"serviceEndpointStats":{"inflightRequests":1,"openConnections":1},"connectionStats":{"waitforConnectionInit":"True","callsPendingReceive":0,"lastSendAttempt":"2024-03-14T12:12:05.1492057Z","lastSend":"2024-03-14T12:12:05.1492277Z","lastReceive":"2024-03-14T12:12:05.1500977Z"},"requestSizeInBytes":517,"responseMetadataSizeInBytes":215,"responseBodySizeInBytes":112};\r\n ResourceType: Document, OperationType: Read\r\n, SDK: Microsoft.Azure.Documents.Common/2.14.0”
    ]


    #webMethods
    #webMethods-io-Integration
    #webMethods-cloud


  • 2.  RE: Azure cosmosdb connector supported SDK version

    Posted Fri March 15, 2024 02:38 AM

    hi @camous,
    Can you please raise the support incident for same.

    Regards
    Vikash Sharma


    #webMethods-cloud
    #webMethods-io-Integration
    #webMethods


Related Content