on 11-23-2015 8:28 AM
Hello,
When I schedule a specific webi report to an FTP location or by Email it fails. But when i run the report, the webi runs under 1 minute, returns some 75,000 rows and 37 columns. Also when I schedule it to BI Inbox it works fine.
File details:
around 76000 rows and 37 columns.
Size is 40 MB
I ruled out the following issues:
1. No network issues. I can ping the FTP location fine from the servers.
2. No outages and all services are running fine.
3. Scheduled a couple other reports as EMAIL and FTP and they succeed fine.
4. This specific report runs fine when executed and runs in under 1 minute.
My BOBJ env: BOBJ 4.1 SP4, CMS: oracle, O/S: Linux REDHAT Enterprise.its a cluster.
Issue repetition is exactly the same on any server. for example on both nodes, the issue is the same.
Can anyone help out on zeroing in on what exactly can be the issue here?
Thanks,
Tsar
I suspect that the file is too big to email - most email servers will send a max of @5MB for attachments. I'm not sure what the FTP issue might be.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Take a look at the properties for the Web Intelligence Processing Server. Specifically look for the "Web Intelligence Common Service" which has two properties you may need to tweak - Maximum Character Stream Size (MB) and Binary Maximum Stream Size (MB). Depending on the output format you're using, you'll probably have to increase one or the other of these numbers to get the schedule to work.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tsar,
Could you please share the error what you have got for the failed Email and FTP destinations?
~Swapnil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.