Communication Channel Problem while reading from database

[Former Member]

Hi,

I have a JDBC to IDoc scenario.

The database here is AS400 and i need to read data from AS400 tables and send it to SAP IDocs.

The communication channel picks up the data from AS400 based on the query and builds the IDocs.

Suddenly the channel stops working and it doesnt pick up the data from AS400. When we change the name of the Communication Channel, it again starts picking up the data but again for some period.

It sounds really strange as this is happening only with AS400 database and not it works perfectly when connecting to an SQL Server database.

Please help me out in resolving this issue.

Regards

Kiran.

[dharamveer_gaur2 · Accepted solution]

Hi

Check wheather your Adapter is locked ?

Check in the Visual Admin >Cluster> "LOCKING ADAPTER"

we get a option of Display Locks .Check for an entry with

NAME : $XIDBAD.CommuncationChannel

reset the locks and restart the CC ,now it works fine.

Note 1083488 - XI FTP/JDBC sender channel stop polling indefinitely(04/04S).

Also select option Disconnect After each processing option in JDBC adapter.

[Former Member]

Hi All,

The problem still persists. Now, we have transported from Dev to Testing environment.

Again in Testing environment, the sender jdbc communication channel is not picking the data from the AS400 tables.

This problem is only with AS400 database tables and not with SQL Server tables.

Please let me know your helpful views / comments.

Thanks in Advance & Regards

Kiran.

[Former Member]

Hi Kiran

Can you check the Notes 717376 ,990892 and try to implement.

Some tips:

This error is caused by some optimization in the IBM VM for AS400 which can be disabled through the JIT compiler settings. The following VM setting -Dos400.run.mode=jitc must be set, according to note 717376. Any other value for this setting, as e.g. jitc_de can cause the described problem

Also, please share the trace, so that, it would help to identify the problem.

Also try to change the property in Vis Admin

"cluster-data" -> "Global server configuration" -> "managers" -> "ApplicationThreadManager" -> "MaxThreadCount" ( like 400)

Regards

Chilla

[Former Member]

Hi Kiran

Please refresh CPA Cache by following url

http://<hostname>:<port>/CPACache/refresh?mode=full

You should have rights for this.

Regards

Chilla

[Former Member]

Hi Kiran,

Can you check the JTopen 6.3 is deployed with version 1.6, which is not supported by XI.

also check the jt400.jar whether it may be compatable to 1.4.2 or not?

Regards