cancel
Showing results for 
Search instead for 
Did you mean: 

Report Scheduling Issue

keith_hitchner
Participant
0 Kudos

I am trying to run a very simple query to return the list of e-mail address for all of the people that we sent quotes to in the last week:

SELECT T1.[E_MailL] FROM OQUT T0  INNER JOIN OCPR T1 ON T0.[CntctCode] = T1.[CntctCode] WHERE T0.[DocDate] > getdate()-7 and T1.[E_MailL] IS NOT NULL

The query works fine and returns 60 lines.

When I schedule the report and it runs I get the following log:

Looking for first schedule to be executed before/on 20150731 10:35

Found Scheduled Report ID: 5

Added SRA2 entry

Handling schedule

XML configuration sent to SAP Business One Client:

<?xml version="1.0" encoding="UTF-16"?>

(I deleted my server and user info from this file)

Starting SAP Business One Client with configuration written to its stdin

Timeout set to 5 minutes

*** SAP Business One Client Log ***

*** SAP Business One Client Log ***

Process timeout; terminating client process

Process timeout; terminated

SAP Business One Client return code:-1

Distributing results

SAP B1 client did not update new scheduyle date and time! Deactivating the schedule to prevent infinite loop.

An error occured while creating report by SAP B1 Client

Schedule processed

I have tried sending as PDF, HTML and XML and all get the same error.  I am attaching screenshots of the Scheduler for you to see if I missed something.

Thank you,

Keith H

Accepted Solutions (1)

Accepted Solutions (1)

keith_hitchner
Participant
0 Kudos

Update - I am now able to generate the reports but cannot e-mail.

System returns an error.

*** SAP Business One Client Log ***

Process timeout; terminating client process

Process timeout; terminated

SAP Business One Client return code:-1

Distributing results

An error occurred while creating report by SAP B1 Client

Schedule Processed

Thanks,

Keith

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Did you set default email in Company details?

Thanks.

keith_hitchner
Participant
0 Kudos

Nagarajan,

The default e-mail for the company had already been set.  I changed it to my e-mail.  I know the system can e-mail because I received a message about pending approvals.  However I continue to get the error message and the report does not send.

Just as info I am on 9.0 PL 14 if this makes a difference.

Thank you for trying to help with this.

Keith

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check SAP note 1798434 - Report Scheduler Prerequisites


Thanks.

keith_hitchner
Participant
0 Kudos

Nagarajan,

I checked everything in note 1798434 and tried the exact query suggested and still had it fail.  When I look in the Scheduled Report Overview I can see the reports were generated but did not get sent through e-mail.  I am getting the same error.  I was able to send test e-mails with and without attachments before scheduling the report and I can still send them after the report ran.

Thanks,

Keith

Former Member
0 Kudos

Hi Keith,

Try this query:

SELECT T0.DocNum,T0.CardCode,T1.[E_MailL]

FROM OQUT T0

INNER JOIN OCPR T1 ON T0.[CntctCode] = T1.[CntctCode]

WHERE DateDiff(DD,getdate(),T0.[DocDate]) < 7 and T1.[E_MailL] IS NOT NULL

Thanks,

Gordon

keith_hitchner
Participant
0 Kudos

Gordon,

The report I have is working but the problem is the system is not e-mailing the report when I schedule it.  I do appreciate the input as this is a cleaner query.

Thanks,

Keith

Former Member
0 Kudos

Can you post the screenshot for your setup of this schedule?

keith_hitchner
Participant
0 Kudos

Here it is.

Former Member
0 Kudos

Is it a valid email address for recipient?

keith_hitchner
Participant
0 Kudos

Gordon,

Yes it is valid - it is my e-mail address.

Keith

Former Member
0 Kudos

Have you tried to use manager user?

keith_hitchner
Participant
0 Kudos

Gordon,

That worked - so now the question is - why did this work?  My account is a SU and I have Full Access to everything as far as I can tell.

Keith

Answers (2)

Answers (2)

keith_hitchner
Participant
0 Kudos

Nagarajan,

I followed the blog and the only thing I don't have is a printer connected to the server.  I am using Hyper-V and have no reason to connect a printer.  Does this really make a difference if I am only e-mailing the report?

Keith H

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Yes you need default printer for scheduling and emailing.

Thanks.

keith_hitchner
Participant
0 Kudos

Hi,

OK - I added a TCP/IP printer and the reports now generate but I am still receiving an error and no e-mail is sent.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check this blog,

Thanks.