cancel
Showing results for 
Search instead for 
Did you mean: 

Configuring Scheduled query in query manager

Former Member
0 Kudos

Im trying to configure a scheduled query, and i have an error. If you could help me about it ill apreciate it

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

What is your B1 version and PL? Is it the latest version?

Former Member
0 Kudos

im working with 8.81 pl 06 and pl 07 same error

Former Member
0 Kudos

Have you checked online help for the error message?

Former Member
0 Kudos

it doesnt have online help

Former Member
0 Kudos

Online help comes with each B1 installation. You can enter F1 to get it.

Former Member
0 Kudos

online help is loaded, but when i press f1 for that screen it doesnt appear

Former Member
0 Kudos

Check the help file folder setting. You may copy it to local drive.

Former Member
0 Kudos

Could you try if you can see help on this screen

Former Member
0 Kudos

I don't have the same version as you have. If help file works, it should apply to all screens.

Former Member
0 Kudos

This is very new functionality, it is possible that there is no help yet. Have you tried searching the SAP notes?

Former Member
0 Kudos

Guys, there is a SAP note related to errors with the schedule button.

I'm running 8.81 PL08 and I'm getting an error - not sure if this is fixed in 8.82 yet?

Cheers

Hayden

see SAP Note 1637980 - Schedule function in Query Manager does not work

former_member184708
Participant
0 Kudos

Amazing --- introduce the functionality and then it doesn't work!!

0 Kudos

Has anyone been able to figure out how to work the Scheduler? I've also tried to get access to the note 1637980 but I get an error saying that the document has not been released.

Reza

former_member186095
Active Contributor
0 Kudos

Hi,

I've tested the query schedule on SAP B1 8.82 and it is actually report execution scheduler.

See the following screen shot:

Salam / Rgds,

JimM

Former Member
0 Kudos

Hi, in Administration Print layout designer, have you added a printer to the Report? It will only work then

good luck

former_member186095
Active Contributor
0 Kudos

Hi Theodor,

You have replied to wrong person . Your reply should be to RezaRahman.

Rgds,

JimM

0 Kudos

Hi Theodor,

I couldn't find the Administration Print Layout Designer you were talking about. Are you talking about going into the Print Layout designer > Document Properties and selecting the Printer in the Paper Format tab? if so, I tried that, and it still doesn't work. I'm currently running 8.81 PL 10.

Thanks

Reza

Former Member
0 Kudos

Hi Reza, that is exactly what I meant. I checked my version I'm on 8.82, that might be the difference why mine works

0 Kudos

Hi Theodor,

I upgraded to 8.82 PL04 yesterday and I still can't get the report to execute. The email gets sent, but the attachment never comes with the email. This is the result from the log file:

Looking for first schedule to be executed before/on 20120416 14:28

Found Scheduled Report ID: 4

Added SRA2 entry

Handling schedule

XML configuration sent to SAP Business One Client:

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

<SR>

<R D="20120416" T="1428" O="N">4</R>

<L S="SAPB1SERVER" T="6" C="SBO_IEC_Production" LL="2" CU="RRehman" CP="6F5F4783DEBD49B16834D4635E93AA8B8092959226ABDE385763" LS="sapb1server: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)

StatusBar Success Message: No recurring transactions require posting today

Client and server dates match, 20120416

Starting Scheduled Report: Query

Error #-10 encountered

Executing XSLT transformation

XML Input is Empty

  adding: BusinessOneb1loggerPid5552_20120416142820.Pid5552 (188 bytes security) (deflated 79%)

*** 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: 172.160.2.3:25

Sender Email: SAP Server<Server email address>

Sending email to <my email address>

Schedule processed

------------------------------------

The only other thing that I can think off, is that the printer I have linked with my report in the Print Layout Designer is a network printer, as opposed to a physical printer. Could that have something to do with it?

Reza

Former Member
0 Kudos

Hi, my printer is local but not sure if that is the problam. Try to get Patch 10, I'm convinced it would work then, assuming the email client is corretly installed

Thedi

Former Member
0 Kudos

its not an error with the query, it happens with any query.

error is related with scheduled button in query manager.

Former Member
0 Kudos

What is the error message?

Former Member
0 Kudos

[Scheduled Error Actions-Remark] [message 530003502-8]

former_member227598
Active Contributor
0 Kudos

Hi,

Please post your query... so that i can tell you ... what is the error in that query ?

Regards

Kamlesh Naware

Former Member
0 Kudos

What is the error? If it is related to your query, post it here.

Thanks,

Gordon