Scheduled Query Report - Unable to extract PDF report output to file C:\Windows\TEMP\Report.pdf Error code:-2028

[Former Member]

I successfully ran a saved query but when when I send it as an email attachment via the Query Report Scheduler, the Status on the Scheduled Report Overview says it was successfully emailed but there was no attachments in the email.

The log says that there was no service device found, yet in the SAP B1 Service Manager settings for SBO Mailer there is no configuration field for a printer.  Please advise me where I can find the configuration for the printer in the SAP B1 Service Manager.

Also, we could not extract the PDF, XML or HTML report output. Is this related to the printer error message?

Here's part of the Scheduled Report Overview Log:

***

SAP Business One Client Log ***
StatusBar Success Message: This use of the software is subject to the End User License Agreement (EULA)
StatusBar Warning Message: No recurring postings require posting today  [Message 680-15]
Starting Scheduled Report: Query
StatusBar Error Message: No printer device found
Error #-10 encountered
Executing XSLT transformation
XML Input is Empty
Warning: ORB::BOA_init: hostname lookup returned `localhost' (127.0.0.1/::1)
Use the -OAhost option to select some other hostname
  adding: BusinessOneb1loggerPid6168_20130613123436.Pid6168 (188 bytes security) (deflated 82%)

*** SAP Business One Client Log ***
SAP Business One Client return code:0
Distributing results
Unable to extract HTML report output to file C:\Windows\TEMP\Report.html Error code:-2028
Unable to extract PDF report output to file C:\Windows\TEMP\Report.pdf Error code:-2028
Unable to extract XML report output to file C:\Windows\TEMP\Report.xml Error code:-2028
Sending email to debbiep@artistree.com
Sending email to paml@artistree.com
Sending email to ron@mcsgroup.com
SAP B1 client did not update new scheduyle date and time! Deactivating the schedule to prevent infinite loop.
Schedule processed

Thank you.

[Former Member]

hi Ron Chin

  Me too getting the same error but i receive mail without attachment :

Looking for first schedule to be executed before/on 20131231 2:31

Found Scheduled Report ID: 3

Added SRA2 entry

Handling schedule

XML configuration sent to SAP Business One Client:

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

<SR>

<R D="20131231" T=" 231" O="N">3</R>

<L S="SERVER2" T="6" C="GH_LIVE1314" LL="2" CU="manager" CP="6F5F4783DEBD49B16834D4635E90AAC880D2959526ABDE35" LS="server2:30000" LC="3"/>

</SR>

Starting SAP Business One Client with configuration written to its stdin

Timeout set to 5 minutes

*** SAP Business One Client Log ***

Command line parsed

StatusBar Success Message: This use of the software is subject to the End User License Agreement (EULA)

Client and server dates match, 20131231

Starting Scheduled Report: Query

StatusBar Error Message: No printer device found

Error #-10 encountered

Executing XSLT transformation

XML Input is Empty

  adding: BusinessOneb1loggerPid4808_20131231023150.Pid4808 (124 bytes security) (deflated 82%)

*** SAP Business One Client Log ***

SAP Business One Client return code:0

Distributing results

Unable to extract HTML report output to file C:\Windows\TEMP\Report.html

Unable to extract PDF report output to file C:\Windows\TEMP\Report.pdf

Unable to extract XML report output to file C:\Windows\TEMP\Report.xml

SMTP Server: Mail.Server-141.com:25

Sender Email: xxx@abc.com>

Sending email to aaa@gmail.com

Sending email to bbb@gmail.com

Schedule processed

[Former Member]

Good Morining,

When not attached and not add the option in March HTML couple body of the email the email is sent successfully.

When I add the attachment I get the error reported.

I got a call at SAP, as well as possible post the result.

[Former Member]

Hi,

Have you got the solution for this SBO mailer problem. I am also facing the same problem. please help me to solve it,If you got the solution

Thanks & Regards

Aswathy

[Former Member]

Hi,

  Its working for me... you first do page setup in PLD  set to A4 and also select your printer... before that pls check in services whether SAP Messaging Service started.

Warm regards,

Guhan

[Former Member]

Hi Ron Chin,

Please check document in special the step (Mail Settings):

http://scn.sap.com/community/business-one/reporting-and-printing/blog/2013/06/01/how-to-schedule-rep...

Regards,

Marcelo Silva Santos

[Former Member]

Marcelo, Everything was set up correctly in the SAP B1 Service Manager and the correct email recipients were added. The PDF, XML and HTML boxes were also checked.

So, yes this is still an issue but I'm going to send this to SAP Support and see what they have to say.

[Former Member]

good afternoon,

obeteve you success with this problem?

I'm having the same problem

*** SAP Business One Client Log ***

Command line parsed

StatusBar Success Message: This use of the software is subject to the End User License Agreement (EULA)

StatusBar Success Message: No recurring transactions require posting today

Client and server dates match, 20131223

Starting Scheduled Report: Query

StatusBar Error Message: No printer device found

Error #-10 encountered

Executing XSLT transformation

XML Input is Empty

  adding: BusinessOneb1loggerPid4376_20131223163851.Pid4376 (188 bytes security) (deflated 82%)

*** SAP Business One Client Log ***

SAP Business One Client return code:0

Distributing results

Unable to extract HTML report output to file C:\Windows\TEMP\Report.html Error code:-2028

Unable to extract PDF report output to file C:\Windows\TEMP\Report.pdf Error code:-2028

Unable to extract XML report output to file C:\Windows\TEMP\Report.xml Error code:-2028

SMTP Server: smtp.zethos.com.br:587

Sender Email: SAP_B1:<teste@zethos.com.br>

Sending email to ted@zethos.com.br

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

Schedule processed