Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unable to read payload from the message object in XI

Hello Guys,

Please help me about my problem in XI version 7.0.im quite new here.

im trying to test my config but error message occured. "Unable to read payload from the message object"

when i checked the comm channel this is the error message :

Error during database connection to the database URL 'jdbc:sqlserver://172.16.40.20:1433;databasename=TRAVEL:SelectMethod=cursor' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://172.16.40.20:1433;databasename=TRAVEL:SelectMethod=cursor': com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "TRAVEL:SelectMethod=cursor" requested by the login. The login failed.'

when i tried my login in sql it works...but in this message the login is failed..what shall i do..

Please advice.

Thanks in advance

aVaDuDz

Former Member
Former Member replied

Hi

Check with the connection string & Authorization of user you have used.

MSSQL string is

jdbc:microsoft:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor

While doing JDBC its good to refer Note 831162 lot of problems can be resolved.

Thanks

Gaurav

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question