cancel
Showing results for 
Search instead for 
Did you mean: 

Problem JDBC lookup PI 7.1

Former Member
0 Kudos

Hello everybody,

I have a scenario where the PI interface that were 7, were migrated to the PI 7.1 SP 05.

With this, we are having problems in PI 7.1, JDBC Lookup.

If I use the JDBC Lookup that exists in PI 7.1, it works.

Plus the problem, I have many interfaces, which were made by the JDBC Lookup IP 7, and error is happening in the IP 7.1, the error is

Error when calling an adapter by using the communication channel CC_EAI_JDBC_CADASTRO_Receiver (Party: , Service: BS_MSSQL_DEV, Object ID: 574a4888bf11379d99fa7359026ddb7c) The channel with object ID 574a4888bf11379d99fa7359026ddb7c could not be found in the Integration Server Java Cache. Check if the channel exists in the Integration Builder Directory and execute a refresh of the Java Cache.

The error happens in the line of code Featured:

/ / Set channel According to config Directory

channel = LookupService.getChannel (BS_MSSQL_DEV "," CC_EAI_JDBC_CADASTRO_Receiver ");

/ / Set database accessor

accessor = LookupService.getDataBaseAccessor (channel);

Its in PI 7.1, still be done this type of JDBC Lookup??

How can I solve this problem??

Thanks,

Marlon

Accepted Solutions (1)

Accepted Solutions (1)

stefan_grube
Active Contributor
0 Kudos

check sure, that you hve not created the channel with party *

As this is default value, it happens often.

Former Member
0 Kudos

Yes, my Communication Channel, is not created with Party.

I deleted it and created again, even more so does not work.

I made a CPACache mode = full, and also not solved.

I'm waiting for some more help.

And thanks for the replies.

Marlon

Former Member
0 Kudos

Marlon..

Just to make sure what Stefan advising is, sometimes there will be a value " * " for the party, even though you did not define party for your communication channel.

Make sure that the value for the Party in the communication channel is empty and not filled with value ' * '

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi stefan,you have just done it. you reach the 10.000 forum points. congratulations

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello,

Stefan and Guru, had not noticed the '*' in the Party's CC.

I created another CC without the '*', and it worked.

Thank you all for your help.

Marlon

Edited by: Marlon Sperandio Monteiro on Sep 15, 2010 3:54 PM

Edited by: Marlon Sperandio Monteiro on Sep 15, 2010 3:54 PM

Former Member
0 Kudos

Malron

On a lighter note, not sure if this is typo or is it defined like that in JDBC Look Up.. I see incorrect Quotations (") in the following statements..Can you please check for the Business System

channel = LookupService.getChannel (BS_MSSQL_DEV "," CC_EAI_JDBC_CADASTRO_Receiver ");

sunil_singh13
Active Contributor
0 Kudos

Marlon,

Try to reselect and reactivate the communication channel in ID.

Thanks,

Sunil

VijayKonam
Active Contributor
0 Kudos

As the error suggests. did you do a complete java cache refresh on the server? Did you check the channel's GUID is as mentioned in the error? You can find this in the channel properties.

VJ