Problem with OSB's File adaptor Valve for pre-processing

3709314

Hello Everyone,

I am buiding an OSB (12.2.1.2.0) service to read an Mircosoft Excel file. As OSB do-not support the same (out of the box), i want to hook the file adaptor with 'a Valve' to do the pre-processing.

The valve i have written will simply read the cells & convert into a CSV File. File adaptor can take care of doing processing the CSV content. Though, i could get this working using SOA. i could not get this done using OSB.

Below are the two error line i see in server :

<oracle.tip.pc.services.translation.xlators.nxsd.NXSDTranslatorImpl> <NXSDTranslatorImpl> <readNativeData> <readNativeData call failed ...>

<oracle.tip.pc.services.translation.xlators.nxsd.NXSDTranslatorImpl> <NXSDTranslatorImpl> <processScalarType> <processScalarType call failed...>

It looks like the pipelines values are not executing before proxy kicks in & NXSD seems to be failing while parsing the content of the file. Attached are the snapshot of the jca file (with pipeline property) and pipeline file content.

Could someone help me to understand what am i doing wrong ? @Martien van den Akker

-Thanks,

Siva V

3709314

Thanks, @Martien van den Akker.

Fixed the problem !

Adding the jar in the project did-not help me. I still have the fat-jar in the domain's lib folder.

The trick is in the name of the property in the jca file. 'PipelineFile' seems to be not working but, PipelineValves seems to work now.

I do-not know the exact for that. I got the hint from the Oracle's documentation: Link.

I am attaching the snap of the jca fine which is working now. I hope this may help others.

Some more details are here : https://allaboutintegration.wordpress.com/2019/10/18/osb-12c-reading-excel-file-using-ftps-valves/

-Thanks.

Martien van den Akker

Hi Siva,

How did you deploy the code with your valve? I'd try to add the jar to the OSB project.

Can you show the detailed error message and stack? Could you lookup the error in the server.log, and show that to us?

Regards,
Martien

3709314

Hi @Martien van den Akker,

I loaded the value(as a jar) in the Domain's lib directory. I see the logs that the lib is added as part of the weblogic's class path. As the bpel is running in the same server(my local integrated server), i think the class the loaded into weblogic.

I want to try to have the jar as part of the osb project. But having just part of the project would do ? or any other specific folder is needed.

There are no server logs other than the two statements.

looking forward for your response.

-Thanks.

Martien van den Akker

Hi,

I think that putting the jar in the domain's lib folder wouldn't suffice, that might be the problem. It has to do with different class loaders in Weblogic/OSB.

Try with creating a lib (or any other) folder in the project and put the jar file in there. For a SOA Suite project the SCA-INF folder is typically used for this. This might be there for a OSB project as well.

Kind regards,
Martien

3709314

Thanks, @Martien van den Akker.

Fixed the problem !

Adding the jar in the project did-not help me. I still have the fat-jar in the domain's lib folder.

The trick is in the name of the property in the jca file. 'PipelineFile' seems to be not working but, PipelineValves seems to work now.

I do-not know the exact for that. I got the hint from the Oracle's documentation: Link.

I am attaching the snap of the jca fine which is working now. I hope this may help others.

Some more details are here : https://allaboutintegration.wordpress.com/2019/10/18/osb-12c-reading-excel-file-using-ftps-valves/

-Thanks.

Martien van den Akker

Good job!