on 07-31-2015 3:51 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.