SAP Business One 10.0 PL02 Mail Sending Problem

[mehmet_gunes]

Dear Experts,

The mail does not go when we send e-mails from SAP business one.

Mail is waiting in outbox. This is the log file on the server.

Do you have a suggestion?

var/log/SAPBusinessOne/ServerTools/Mailer.Log

2020-09-18 14:58:37 ERROR [Job Service - schedule job pool 2] com.sap.sbo.mailer.util.DbUtils - Connect to COZUM failed, user name: SAPB1_DB_USER_COZUM. com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [10]: authentication failed at com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException.createException(SQLInvalidAuthorizationSpecException.java:40) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:301) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185) at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:101) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1031) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:820) at com.sap.db.util.security.AbstractAuthenticationManager.connect(AbstractAuthenticationManager.java:43) at com.sap.db.jdbc.ConnectionSapDB.openSession(ConnectionSapDB.java:568) at com.sap.db.jdbc.ConnectionSapDB.doConnect(ConnectionSapDB.java:421) at com.sap.db.jdbc.ConnectionSapDB.<init>(ConnectionSapDB.java:173) at com.sap.db.jdbc.ConnectionSapDBFinalize.<init>(ConnectionSapDBFinalize.java:13) at com.sap.db.jdbc.Driver.connect(Driver.java:303) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at com.sap.sbo.mailer.util.DBConnectionCreator4HANA.createConnection(DBConnectionCreator4HANA.java:97) at com.sap.sbo.mailer.util.DBConnectionFactory.createConnection(DBConnectionFactory.java:34) at com.sap.sbo.mailer.util.DbUtils.createDbConnection(DbUtils.java:154) at com.sap.sbo.schedulejob.service.TaskScheduler.getCompanyConn(TaskScheduler.java:536) at com.sap.sbo.schedulejob.service.TaskScheduler.getAvaliableJobs(TaskScheduler.java:185) at com.sap.sbo.schedulejob.service.TaskScheduler.pickTasks(TaskScheduler.java:498) at com.sap.sbo.schedulejob.service.ScheduleJobWorker.run(ScheduleJobWorker.java:258) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:836) 2020-09-18 14:58:37 ERROR [Job Service - mail pool 5] com.sap.sbo.mailer.util.DbUtils - Connect to COZUM failed, user name: SAPB1_DB_USER_COZUM. com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [10]: authentication failed at com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException.createException(SQLInvalidAuthorizationSpecException.java:40) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:301) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185) at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:101) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1031) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:820) at com.sap.db.util.security.AbstractAuthenticationManager.connect(AbstractAuthenticationManager.java:43) at com.sap.db.jdbc.ConnectionSapDB.openSession(ConnectionSapDB.java:568) at com.sap.db.jdbc.ConnectionSapDB.doConnect(ConnectionSapDB.java:421) at com.sap.db.jdbc.ConnectionSapDB.<init>(ConnectionSapDB.java:173) at com.sap.db.jdbc.ConnectionSapDBFinalize.<init>(ConnectionSapDBFinalize.java:13) at com.sap.db.jdbc.Driver.connect(Driver.java:303) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at com.sap.sbo.mailer.util.DBConnectionCreator4HANA.createConnection(DBConnectionCreator4HANA.java:97) at com.sap.sbo.mailer.util.DBConnectionFactory.createConnection(DBConnectionFactory.java:34) at com.sap.sbo.mailer.util.DbUtils.createDbConnection(DbUtils.java:154) at com.sap.sbo.mailer.mail.CompanyTask.getMessageCode(CompanyTask.java:116) at com.sap.sbo.mailer.mail.CompanyTask.handleMail(CompanyTask.java:87) at com.sap.sbo.mailer.mail.CompanyTask.run(CompanyTask.java:55) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:836) 2020-09-18 14:58:37 ERROR [Job Service - mail pool 5] com.sap.sbo.mailer.mail.CompanyTask - getMessageCode failed for connecting company DB failed

/var/log/SAPBusinessOne/ServerTools/schedulejob.Log

020-09-18 14:58:37 ERROR [Job Service - schedule job pool 2] com.sap.sbo.schedulejob.service.TaskScheduler - TaskScheduler(COZUM) : get avaliable jobs Failed java.lang.NullPointerException: while trying to invoke the method java.sql.Connection.prepareStatement(java.lang.String) of a null object returned from com.sap.sbo.schedulejob.service.TaskScheduler.getCompanyConn() at com.sap.sbo.schedulejob.service.TaskScheduler.getAvaliableJobs(TaskScheduler.java:185) at com.sap.sbo.schedulejob.service.TaskScheduler.pickTasks(TaskScheduler.java:498) at com.sap.sbo.schedulejob.service.ScheduleJobWorker.run(ScheduleJobWorker.java:258) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:836) 2020-09-18 14:58:38 ERROR [Job Service - schedule job pool 1] com.sap.sbo.schedulejob.service.TaskScheduler - TaskScheduler(HAZIRLIK) : company connection is invalid 2020-09-18 14:58:38 ERROR [Job Service - schedule job pool 1] com.sap.sbo.schedulejob.service.TaskScheduler - TaskScheduler(HAZIRLIK) : GetCurrentTime Failed java.lang.NullPointerException: while trying to invoke the method java.sql.Connection.createStatement() of a null object returned from com.sap.sbo.schedulejob.service.TaskScheduler.getCompanyConn() at com.sap.sbo.schedulejob.service.TaskScheduler.getCurrentTime(TaskScheduler.java:389) at com.sap.sbo.schedulejob.service.ScheduleJobWorker.run(ScheduleJobWorker.java:257) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:836) 2020-09-18 14:58:38 ERROR [Job Service - schedule job pool 1] com.sap.sbo.schedulejob.service.TaskScheduler - TaskScheduler(HAZIRLIK) : company connection is invalid 2020-09-18 14:58:38 ERROR [Job Service - schedule job pool 1] com.sap.sbo.schedulejob.service.TaskScheduler - TaskScheduler(HAZIRLIK) : get avaliable jobs Failed java.lang.NullPointerException: while trying to invoke the method java.sql.Connection.prepareStatement(java.lang.String) of a null object returned from com.sap.sbo.schedulejob.service.TaskScheduler.getCompanyConn() at com.sap.sbo.schedulejob.service.TaskScheduler.getAvaliableJobs(TaskScheduler.java:185) at com.sap.sbo.schedulejob.service.TaskScheduler.pickTasks(TaskScheduler.java:498) at com.sap.sbo.schedulejob.service.ScheduleJobWorker.run(ScheduleJobWorker.java:258) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:836)

[lucca_mello]

Dear Ahmet,

It seems that the issue you are facing could be related to the SAP Note below:

• 2825180 - Database Connection Is Lost When Logging on to SAP Business One

And due to that, you are also facing issues to send mails - because of the authentication with the database.

Please use the workaround in the SAP Note mentioned above, and in case the issue persists for a long time log a ticket under the SBO-BC component.

Have a great weekend ahead!

BR,

Lucca Mello

[mehmet_gunes]

Dear Lucca,

I tried the suggestions but the problem is not solved. I do not recived this message

Br,

AhmetC