Forum Discussion

pjk_'s avatar
pjk_
New Member
1 year ago
Solved

Tibco MFT to Lakehouse

Hi all,

 

Wondering if anyone can help on this issue.

 

I have a requirement for data to be dropped into a bronze lakehouse Files location. The tool chosen for this is Tibco MFT, which I have no access to and no prior knowlege of. 

 

When the team responsible for setting up the transfer attempt to send the file they receieve a 400 OutOfRangeInput error stating "One of the request inputs is out of range".
Initially I assumed it was the container/workspace name case sensitivity but it was not. We have tried using https and abfss URIs.

 

I cannot find any good documentation on configuring Tibco for this task and I cannot replicate the issue, I have written test scripts in C#, Python and Java and they all work. I have targetted onelake and a storage account in the datalake configuration.

 

We are using client id and secret for auth.

 

Any pointers would be great, thanks.

lakehouse
  • pjk_'s avatar
    pjk_
    1 year ago

    Thanks nielsvdc the team were setting that up but getting the 400 error. 

    They have switched to azcopy now which works well.

     

4 Replies

  • nielsvdc's avatar
    nielsvdc
    Icon for Super User rankSuper User
    1 year ago

    You will need to use the Azure Data Lake Storage adapter in Tibco. From the lakehouse Files folder, get the ABFS path and use this in the adapter. You can authenticate using a service principal and secret, after you give this service principal permissions to the lakehouse. Hope this will help.

     

    • pjk_'s avatar
      pjk_
      New Member
      1 year ago

      Thanks nielsvdc the team were setting that up but getting the 400 error. 

      They have switched to azcopy now which works well.

       

      • v-lgarikapat's avatar
        v-lgarikapat
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi pjk_ ,

        Thanks for reaching out to the Microsoft fabric community forum.

        nielsvdc ,

        Thanks for your prompt response

        pjk_

        Thank you for confirming that you've switched to AzCopy, and that it’s working well.

        If your issue has been resolved, please consider marking the most helpful reply as the accepted solution. This helps other community members find answers more easily.

        If you’re still experiencing any issues, feel free to let us know  we’ll be happy to assist you further.

        Looking forward to your response.

        Best regards,
        LakshmiNarayana.