JDBC Receiver

[Former Member]

Hi All,

I am doing a JDBC Receiver scenario.The JDBC driver has been configured in the XI system.

I have given the follwoing in the CC,

1. Database Driver Class Name - com.inet.tds.TdsDriver

2. JDBC Connection URL - jdbc:inetdae7://<DB_HOST_NAME>:1433;DatabaseName=<DB_NAME>

Now when I run the scenario ,

I get the error JDBC adapter receiver channel SVG_JDBC_Receiver not initialized. Unable to proceed due to null

The payload genearted looks fine,

<?xml version="1.0" encoding="UTF-8" ?>

<ns0:MT_TEST xmlns:ns0="http://kone.com/servigistics-integration">

<Statement>

<Test action="INSERT">

<table>TABLE1</table>

<Access>

<Field1>KM247850</Field1>

<Field2>FINJTIA</Field2>

</Access>

</Test>

</Statement>

</ns0:MT_TEST>

Can anyone suggest me what to do?

Thanks,

Venu

[Former Member · Accepted solution]

Stop channel in RWB. Make sure all unprocessed messages are canceled. Start the channel and rerun you message.

This should work!

Kai

[Former Member]

The issue was solved ,as the Host name(DNS Name ) was not registered inthe DB system ,so it was not able to connect to DB system

Anyways Thanks everyone,

Venu

[Former Member]

Hi

u r config

1. Database Driver Class Name - *com.inet.tds.TdsDriver*2. JDBC Connection URL - jdbc:inetdae7://<DB_HOST_NAME>:1433;DatabaseName=<DB_NAME>

use below

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>{code}

Srini

[Former Member]

Did you canceled the unprocessed messages after stopping the channel? This must be done! Then Start the channel form this clean state!

Kai

[Former Member]

Hi Srini,

Thanks for your reply ,I tried stopping and starting the CC.But when I restart it it gives me an error message saying,

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:inetdae7://eudnt038.konenet.com:1433/SVG_934_DB': com.inet.tds.SQLException: eudnt038.konenet.com

Moreover the Status is shown as Yellow 'Channel started but Inactive' whereas the CC is activated and is Status :Active in the CC configuration.

Could you please help me on this?

Thanks,

Venu

[Former Member]

Hi

for sql

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

check from XI Server : tnsping <sql ip>

rgds

srini

[Former Member]

Hi All,

How to stop the channel in RWB? Could yo please help?

Thanks,

Venu

[Former Member]

Hi

hI rwb --> Component Monitoring --> Adapter Engine --> CC monitoring --> Enter Adapter name --> Select --> Stop --> Start

rgds

srini

[Former Member]

SXI_CACHE

[Former Member]

Hi Srini,

The DB which we are using is MS SQL Server 2005.

Tcode for Cache Refresh?

Thanks,

Venu

[Former Member]

Hi All,

Else is there a way to test the connection to the DB?

I have given the JDBC Driver ,Connection and the User /Password , how should I validate that this connection is working.

else

So what should I ask the Basis guy to check?

Regards,

Venu

[Former Member]

Hi

From XI Server

try to run the command :

> tnsping <DB IP>

it shouls list u tns details if it is not working

make a entry in ur tnsname.ora file in XI and make a entry in "host" file

above everthing in u r XI server

rgd

srini

[Former Member]

Hi

can u specify u r DB to which u r connecting

rgs

srini

[Former Member]

Hi,

I made the CC inactive once and cancelled all the waiting messages.Now again I have activated the CC ,but it gives me the same error.

Can any one help me on this?

Thanks,

Venu

[Former Member]

Hi

Reactivate and do cache refresh

srini

[Former Member]

don't make it inactive. stop, cancel and start it.

[rajasekhar_reddy14]

Hi Venu,

Check once you configured JDBC Driver properlly,

Check once with your basis team class12.jar file configured or not.

Regards,

Raj