Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error while using certificate chain

Anuj Dwivedi-OracleNov 24 2008 — edited Nov 24 2008
Hi,

I am using a certificate chain for SSL security and while sending message I am geting error. This error is coming when B2B tries to fetch private key from the wallet to sign the message. It says "certificate alias found" but then while creating message it gives error. Please find below the log for that particular portion

2008.11.24 at 09:19:24:150: Thread-13: B2B - (DEBUG) oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin:getPrivateKeyFromWallet Enter
2008.11.24 at 09:19:24:154: Thread-13: B2B - (DEBUG) oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin:getPrivateKeyFromWallet certificate alias found: Email=bis.business.solutions@bt.com,CN=BTGS B2BONRAMP,OU=Digital ID Class 1 - Microsoft Full Service,OU=Persona Not Validated,OU=www.verisign.com/repository/RPA Incorp. by Ref.\,LIAB.LTD(c)98,OU=VeriSign Trust Network,O=VeriSign\, Inc.
2008.11.24 at 09:19:24:159: Thread-13: B2B - (DEBUG) oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin:createMessage An exception during building create message
2008.11.24 at 09:19:24:161: Thread-13: B2B - (DEBUG) oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin:createMessage exception msg: null
2008.11.24 at 09:19:24:163: Thread-13: B2B - (DEBUG) oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin:createMessage exception stack trace: java.lang.NullPointerException
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.getPrivateKeyFromWallet(EBMSExchangePlugin.java:5967)
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.getPrivateKeyForSigning(EBMSExchangePlugin.java:5322)
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.signAttachment(EBMSExchangePlugin.java:5160)
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.createMessage(EBMSExchangePlugin.java:2130)
at oracle.tip.adapter.b2b.msgproc.Request.outgoingRequestPostColab(Request.java:1641)
at oracle.tip.adapter.b2b.msgproc.Request.outgoingRequest(Request.java:968)
at oracle.tip.adapter.b2b.engine.Engine.processOutgoingMessage(Engine.java:1147)
at oracle.tip.adapter.b2b.transport.AppInterfaceListener.onMessage(AppInterfaceListener.java:137)
at oracle.tip.transport.basic.jms.JMSMonitor.processMessages(JMSMonitor.java:610)
at oracle.tip.transport.basic.jms.JMSMonitor.run(JMSMonitor.java:236)

2008.11.24 at 09:19:24:168: Thread-13: B2B - (ERROR) java.lang.Exception: java.lang.NullPointerException
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.createMessage(EBMSExchangePlugin.java:2289)
at oracle.tip.adapter.b2b.msgproc.Request.outgoingRequestPostColab(Request.java:1641)
at oracle.tip.adapter.b2b.msgproc.Request.outgoingRequest(Request.java:968)
at oracle.tip.adapter.b2b.engine.Engine.processOutgoingMessage(Engine.java:1147)
at oracle.tip.adapter.b2b.transport.AppInterfaceListener.onMessage(AppInterfaceListener.java:137)
at oracle.tip.transport.basic.jms.JMSMonitor.processMessages(JMSMonitor.java:610)
at oracle.tip.transport.basic.jms.JMSMonitor.run(JMSMonitor.java:236)
Caused by: java.lang.NullPointerException
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.getPrivateKeyFromWallet(EBMSExchangePlugin.java:5967)
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.getPrivateKeyForSigning(EBMSExchangePlugin.java:5322)
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.signAttachment(EBMSExchangePlugin.java:5160)
at oracle.tip.adapter.b2b.exchange.ebms.EBMSExchangePlugin.createMessage(EBMSExchangePlugin.java:2130)
... 6 more


Does anyone have any idea that what could be the reason behind this error?

Please help.

Thanks & Regards,
Anuj Dwivedi
This post has been answered by 558353 on Nov 24 2008
Jump to Answer

Comments

user9540031
Answer

Hi,
It would be great if SQL Developer supported a convenient way to share user defined reports with other people on your team.
Then it is great, because that feature already exists.
image.pngEver noticed these?
But first, you must convert your reports into individual XML extensions. That's easy, and well explained in the following documents:
https://github.com/PhilippSalvisberg/sqldev/blob/main/workshop/010_create_report_xml_extension/README.md#create-report-as-xml-extension
https://github.com/oracle-samples/oracle-db-examples/tree/main/sqldeveloper/extension/xml/individual#sql-developer-examples
Don't forget to nest the main <display> element of your reports inside a <folder> element in order to group them into folders under Shared Reports. (See the example in the end of this post.)
Once you have done that, nothing prevents you from loading individual XML extensions from your local Git repository, making it possible to synchronize with your project's remote Git repository by just pulling from that remote, then restarting SQL Developer.
(It takes a bit of manual configuration work: each individual XML extension must be configured in Preferences. But once this is done, it just works. Restarting SQL Developer is required for changes to become available, though.)
Regards,

Marked as Answer by User_2H7WG · Jun 18 2022
User_2H7WG

👀
That's neat, not exactly obvious in the settings to find, but nice to know it's there!
Thanks,

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 22 2008
Added on Nov 24 2008
#b2b, #error, #integration-b2b, #integration-general, #soa-process-management
8 comments
640 views