Skip to Content
0
Former Member
Jan 20, 2010 at 09:56 AM

Re: Xclesius truncating rows after 512

34 Views

I have an xclesius document using a live office excel spreadsheet based on a Universe Query. The report produces 2500 rows and the live office insert/refresh works fine in excel.

I can import the spreadsheet model create my dashboard, view it and see all the data. But once I try to refresh the data using live office connector to refresh the live office content, I only get 512 rows.

I have set the max rows parameter to 3000. To resolve this issue we tried to install as you can see below. Step 1 till 8 works. The problem is the jar file in step 8 does not create the directory from step 9. \DSWS is missing. So there is no file for configure the properties.

Can anybody guide us?

-


X----


1. Navigate to the DSWS war file location.

(ie: F:\Program Files\Business Objects\deployment\workdir\tomcat55\application)

2. mkdir dswsbobje

3. cd dswsbobje

4. jar -xvf ..\dswsbobje.war

5. Navigate to directory containing dsws-common-provider.jar

cd WEB-INF\lib

6. mkdir dsws-liveoffice-provider

7. cd dsws-liveoffice-provider

8. jar -xvf ..\dsws-common-provider.jar

9. cd META-INF\BusinessObjects\DSWS

10. Type command. notepad liveoffice_config.properties ( use vim on Linux)

11.Change the following parms and save file.

maxRowCount=1024

maxColumnCount=1024

12. Change directories back to the root of dsws-liveoffice-provider.

cd ..\..\..\..

13. jar -uvf ..\dsws-liveoffice-provider.jar META-INF\BusinessObjects\DSWS\liveoffice_config.properties

adding: META-INF/BusinessObjects/DSWS/liveoffice_config.properties(in = 974) (out= 483)(deflated 50%)

14. Change directories back to the root of dswsbobje.

cd ..\..\..

15. jar -uvf ..\dswsbobje.war WEB-INF\lib\dsws-liveoffice-provider.jar

adding: WEB-INF/lib/dsws-liveoffice-provider.jar(in =1954779) (out= 1344659)(deflated 31%)

16. Stop Tomcat

17. Navigate to <tomcat>\webapps\ (ie: F:\Program Files\Business Objects\Tomcat55\webapps)

18. Rename dswsbobje folder to OLD_dswsbobje.

19. Start Tomcat.

20. After app is redeployed, navigate to the lib folder (ie: F:\Program Files\Business Objects\Tomcat55\webapps\dswsbobje\WEB-INF\lib)

dsws-liveoffice-provider.jar file should have a new timestamp relative to the time you ran the jar -uvf command.

21. You can run jar -xvf dsws-liveoffice-provider.jar to verify the contents and that the new parms are in the newly deployed liveoffice_config.properties

mkdir dsws-liveoffice-provider

cd dsws-liveoffice-provider

jar -xvf ..\dsws-liveoffice-provider.jar cd META-INF\BusinessObjects\DSWS\ notepad liveoffice_config.properties

21. In Xcelsius. Go to File -> Preferences and check your Excel options. Change Max Number of Rows setting.

-


X----