Error occurred while attempting to connect to database (LOOKUPEXCEPTION)

[Former Member]

I want to test the new features enhanced which support JDBC lookup the data structure from database and import to External Definition in ESR,but i encountered the error when i do the table display in ESR,i'm not sure if it's the issue of JDBC receiver channel in ID...

Database Connection parameters as below:

JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection : jdbc:microsoft:sqlserver://<mymachineID>:1433;databaseName=pubs

User Name : <my windows Login ID> --coz i choosed Windows Authentic as the Authentification Model

Password : <my windows Login psw>

the error msg as below:

Error occurred while attempting to connect to database (LOOKUPEXCEPTION)

Exception during processing the payload. Error when

calling an adapter by using the communication channel

CC_JDBCLookup_Receiver (Party: , Service: BC_JDBC_Receiver,

Object ID: 39ba7ca82df138a094576f6724e74191) XI AF

API call failed. Module exception: (No information

available). Cause Exception: 'Error when attempting

to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException:

Unable to create new pooled resource: DriverManagerException:

Can not establish connection:: SQLException: [Microsoft][SQLServer

2000 Driver for JDBC]Error establishing socket.'.

com.sap.aii.mapping.lookup.LookupException:

Error when calling an adapter by using the communication

channel CC_JDBCLookup_Receiver (Party: , Service: BC_JDBC_Receiver,

Object ID: 39ba7ca82df138a094576f6724e74191) XI AF

API call failed. Module exception: (No information

available). Cause Exception: 'Error when attempting

to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException:

Unable to create new pooled resource: DriverManagerException:

Can not establish connection:: SQLException: [Microsoft][SQLServer

2000 Driver for JDBC]Error establishing socket.'.

...

anybody help me with it?any idea should be appreciated:)

Best regards!!!

Rajesh Vishwar

[Former Member · Accepted solution]

Hi,

It also looks like that the target structure is having some issue. Please reconfirm with this link..

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Sarvesh

[former_member200962]

Check your Lookup configuration with this: /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

Unable to create new pooled resource: DriverManagerException:
Can not establish connection:: SQLException: Microsoft[SQLServer
2000 Driver for JDBC]Error establishing socket.

The above error text means that there was some issue with the firewall...just check if the port that you have used (1433)between PI and DB is able to pass the firewall settings....contact the network admin guys for this....also try with the IP of the machine instead of mymachinename

Regards,

Abhishek.

[Former Member]

yes,it's the firewall blocking issue actually,,but now the issue said

" Can't start a cloned connection while in manual transaction mode...."

the error msg as below:

Exception during processing the payload. Error when

calling an adapter by using the communication channel

CC_JDBCLookup_Receiver (Party: , Service: BC_JDBC_Receiver,

Object ID: 39ba7ca82df138a094576f6724e74191) XI AF

API call failed. Module exception: (No information

available). Cause Exception: 'Error processing request

in sax parser: Error when executing statement for table/stored

proc. 'metadataRequest' (structure 'statement'): java.sql.SQLException:

[Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.'.

com.sap.aii.mapping.lookup.LookupException: Error when

calling an adapter by using the communication channel

CC_JDBCLookup_Receiver (Party: , Service: BC_JDBC_Receiver,

Object ID: 39ba7ca82df138a094576f6724e74191) XI AF

API call failed. Module exception: (No information

available). Cause Exception: 'Error processing request

in sax parser: Error when executing statement for table/stored

proc. 'metadataRequest' (structure 'statement'): java.sql.SQLException:

[Microsoft][SQLServer 2000 Driver for JDBC]Can't start

a cloned connection while in manual transaction mode.'.

.........

[former_member181962]

Try setting AutoCommit = true (Check box in the JDBC adapter)

Regards,

Ravi

[Former Member]

it resolved....the point is to add an extra string which "SelectMethod=Cursor" to the connection URL.