I am trying to save a webI document but I keep getting the error cannot save the document API error The only thing different about this document is it has almost 60 result objects.
Is 3.3M rows and 60 objects too much to store on a webI report , not that I could run it using DESKI I get a memory violation is there a setting or configuration in WEBI XIR2 I could change to accomdate the saving of such huge reports
Any thoughts?
Thanks
Manasi (BOB member since 2004-12-17)
Increase the Maximum Binary File Size paramter of Web_IntelligenceReportServer. It’s default value is 50 MB.
Also have a look at maximum Character File Size paramter. It’s default value is 5 MB.
-Dhirendra
AskMe(Dhirendra) (BOB member since 2005-05-13)
Did both the steps mentioned still no luck, any more ideas
Thanks.
Manasi (BOB member since 2004-12-17)
Could you verify that Input and Output FRS’s, and Temp folders have enough free space?
AskMe(Dhirendra) (BOB member since 2005-05-13)
I did check for the free space in the CMC it says both in Input and Output FRS 51.9% of space is left is this the thing you wanted me to check also free disk space in root directory is 99.2 GB.
I am not sure where I could find the Temp folders are they on the server?.
Manasi (BOB member since 2004-12-17)
The OS temp folder location can be found by looking at environment variable TMP and TEMP.
The BO temp folder location can be found in CMC ( CMC > Servers > and then go to properties of each server and look for temp dir settings)
By default, these BO temp folders are located under BOInstall folder tree.
Seems like you got plenty of hard disk space available. Therefore lake space could not be a problem.
i am puzzled what could be causing this.
AskMe(Dhirendra) (BOB member since 2005-05-13)
Just a thought here, did you restart the WebIntelligenceReportServer after the change? In all honesty, I would shutdown all servers (BO’s services), restart the box, and then bring all the services back up to make sure that your WebIntelligenceReportServer changes were effected.
DJ
DJ06482 
(BOB member since 2002-11-22)
Just another thought, does the ID you’re using to run the BO servers have read/write/create privileges to that filestore? Sometimes people have their FRS hosted remotely, and the ID that’s running BO may not have the appropriate access to that network folder.
DJ
DJ06482 
(BOB member since 2002-11-22)
3.3 M Rows and 60 objects in a report 
… That is asking too much to a poor webintelligence report server.
I think you are trying to use this a a basedata (datadump) for some other application. If that is the case then try to use a ETL tool instead.
BO never suggests to have files (.rep, wid) of more than 50 MB .
Please let me know if you get a resolution.
Sanjit
Sanjit (BOB member since 2004-04-05)
No I am not using it to populate any other database or application its just the way data is structured and they wanted it on report however we found a work around by restricting the data to only one day’s worth thereby reducing the size of document and save it .
But totally agree with you on
Manasi (BOB member since 2004-12-17)