Dear Erman,
We are facing issue with bursting emails. Programs failing with below error. It worked earlier,all of sudden the issue is raised. We didnt do any changes from our end.
Not sure if it is related to SMTP. If it is related,then what all questions,we have to post with smtp vendor.
Have you seen this kind of error
Env:
====
R12.2.5 2 node shared apps tier and 2 node rac db
XML Publisher: Version : 12.2
XML/BI Publisher Version : 10.1.3.4.2
{user-variable:cp:territory=US, user-variable:cp:ReportRequestID=40373201, user-variable:cp:language=en, user-variable:cp:responsibility=54025, user-variable.OA_MEDIA=
http://erp.ttd.com:80/OA_MEDIA, burstng-source=EBS, user-variable:cp:DebugFlag=Y, user-variable:cp:parent_request_id=40373201, user-variable:cp:locale=en-US, user-variable:cp:user=SYSADMIN, user-variable:cp:application_short_name=XDO, user-variable:cp:request_id=40373206, user-variable:cp:org_id=1981, user-variable:cp:reportdescription=TTDAP HRMS-COC-ERP Interface Error Report, user-variable:cp:Dummy for Data Security=}
Start bursting process..
[011824_121225787][][STATEMENT] /usr/tmp
DEBUG SMTP: trying to connect to host "relay.Dummy.in", port 465, isSSL false
220 relayin465.nic.in ESMTP
DEBUG SMTP: connected to host "relay.Dummy.in", port: 465
EHLO app01.ttd.com
250-relayin465.nic.in
250-8BITMIME
250-SIZE 36700160
250 STARTTLS
DEBUG SMTP: Found extension "8BITMIME", arg ""
DEBUG SMTP: Found extension "SIZE", arg "36700160"
DEBUG SMTP: Found extension "STARTTLS", arg ""
STARTTLS
220 Go ahead with TLS
[011824_121227710][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler][STATEMENT] Could not convert socket to TLS
[011824_121227711][][EXCEPTION] java.lang.NullPointerException
at oracle.apps.xdo.delivery.DeliveryUtil.log(Unknown Source)
at oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler.submitRequest(Unknown Source)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(Unknown Source)
[011824_121227711][][EXCEPTION] Error!! Could not deliver the output for Delivery channel:null . Please check the Log for error details..
[011824_121227711][oracle.apps.xdo.batch.BurstingProcessorEngine][STATEMENT] ========================> startElement() ::: endDocument is entered <========================
Bursting process complete..
Generating Bursting Status Report..
[011824_121227723][][STATEMENT] /usr/tmp/011824_121225789 deleted successfully...
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
650
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 18-JAN-2024 12:12:27
+---------------------------------------------------------------------------+
Certificate not expired,we are able to run below command without any error in logs.
$AFJVAPRG -classpath .:$AF_CLASSPATH -Dprotocol=smtp -Ddbcfile=$FND_SECURE/PRODDB.dbc -Dserver=relay.Dummy.in -Dport=465 -Dsecurity=STARTTLS
-Dtruststore=$AF_JRE_TOP/lib/security/cacerts -DoutboundUser=*** -DoutboundPassword=***
-Dconnect_timeout=120 -Ddebug=Y -Djavax.net.debug=all -Dlogfile=SmtpTest.log oracle.apps.fnd.wf.mailer.Mailer > SmtpTest2024.out
Thank You,
SG
Locked
