We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Unable to connect via SAP connector

Comments

5 comments

  • Avatar
    Christina Costello
    Hi Karlis, you may need to move the sapjco3.dll and sapjco3.jar files. Could you put them in
    C:\Users\<username>\AppData\Local\Data360Analyze\site\lib\java?
     
    Which node are you using?
    0
    Comment actions Permalink
  • Avatar
    Karlis Majevskis

    Hello

     

    I'm using Extract ERP table node

    I've placed files under C:\ProgramData\Data360Analyze\site\lib\java and it seems that this is the right pace. 

    Your recommended folder even did not exist. I've created it and moved the files there and got an error:

    0
    Comment actions Permalink
  • Avatar
    Karlis Majevskis

    Is this here official support or community support?

    0
    Comment actions Permalink
  • Avatar
    Paul Rasmussen

    I am assuming you are using the desktop version, not the server.  If so, the directories vary depending on what you select during the installation process.  You can always see what has been configured by looking in your site.prop file.  This file is always present in the installation directory and almost always in C:\Program Files\Data360Analyze\conf

    In this file, there is a key/value pair named ls.appDataDir.  This will tell you where your site directory resides. For example:  

    ls.appDataDir="C:/Users/username/AppData/Local/Data360Analyze/site"

    Can you double check you put the SAP files sapjco3.jar and sapjco3.dll in the ls.appDataDir/lib/java?  

    If this doesn't work, you can always put them directly in the installation directory.

    • sapjco3.jar in C:\Program Files\Data360Analyze\lib\java
    • sapjco3.dll  in C:\Program Files\Data360Analyze\lib\windows-x86-64

     

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    For case 1)  Is there any further information in the detail of the error message that could indicate the root cause?, e.g.

    "Initialization of repository destination xxxxx failed: Opening connection to backend failed: Opening connection denied."

    or

    "Initialization of repository destination xxxxx failed: Connect to message server on host xx,xx,xx,xx failed"

    The error appears to indicate a mis-configuration on the SAP side rather than an issue with the SAP connector per se.

    For case 2) This seems to indicate it is an authorization issue. Can you check the service user has appropriate rights and roles on the SAP instance to execute the RFC_READ_TABLE.

    0
    Comment actions Permalink

Please sign in to leave a comment.