Wednesday, September 30, 2015

Open office dictionary missing / Not working

Open office document all showing red or underline because of spell check grammer is not working.

Issue - missing grammer for open office
Solution - add eglish grammer or any other grammer you want to add
how :

- Go to "Tool" open - "Extension Manager"
- Click on "Get more extension online"
- download the dictionary you want to add
- Downloaded file should have extension of OTX
- Now again move to "Extension Manager" window, click on "Add" button.
- Pop will open, and locate the downloaded file
oops
error

C:\Users\*****\AppData\Roaming\OpenOffice\4\user\uno_packages\cache\uno_packages\sv4ktqd.tmp_\dict-en.oxt does not exists.



- Move the path given by error
C:\Users\*****\AppData\Roaming\OpenOffice\4\user\uno_packages\cache\uno_packages

- What you will observe that the folder "sv4ktqd.tmp_" is missing.
- If yes, create new folder with same name and copy/paste downloaded file to same folder
- Now again move to pop-up window "Extension Manager"
- Now click on add button and locate the ****.otx file from above path.

Wednesday, September 23, 2015

ORA-12519, TNS:no appropriate service handler found

Error
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found

Error occured while trying to connect to the database


Reason
Listener is up and running
The listener could not find any available service handlers that are appropriate for the client connection. (from oracle)

Solution
Execute below commands using sys user.
alter system set processes=300 scope=spfile;
shu immediate
startup

Friday, September 4, 2015

Error retriving the viewpoint list

Error
[http-bio-8080-exec-2] 04 Sep 2015 16:21:29,366 ERROR it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.getSubObjectsList:876 - Error retriving the subObject list
java.lang.NullPointerException
at it.eng.spagobi.analiticalmodel.document.dao.SubObjectDAOHibImpl.getAccessibleSubObjects(SubObjectDAOHibImpl.java:57)
at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.getSubObjectsList(ExecuteBIObjectModule.java:873)
at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.initNewExecutionHandler(ExecuteBIObjectModule.java:280)
at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.service(ExecuteBIObjectModule.java:138)
at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:425)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.utilities.filters.AntiInjectionFilter.doFilter(AntiInjectionFilter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:82)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
[http-bio-8080-exec-2] 04 Sep 2015 16:21:29,448 ERROR it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.getViewpointList:1597 - Error retriving the viewpoint list
java.lang.NullPointerException
at it.eng.spagobi.analiticalmodel.document.dao.ViewpointDAOHimpl.loadAccessibleViewpointsByObjId(ViewpointDAOHimpl.java:412)
at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.getViewpointList(ExecuteBIObjectModule.java:1595)
at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.initNewExecutionHandler(ExecuteBIObjectModule.java:284)
at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.service(ExecuteBIObjectModule.java:138)
at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:425)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.utilities.filters.AntiInjectionFilter.doFilter(AntiInjectionFilter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:82)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)


Cause : Unknown


Solution
1. Delete "idx" directory from "apache-tomcat-7.0.59\resources\idx", it can contain stale index information, so let spagobi to rebuild the indexes.

2. I have fixed url as "ip:port/SpagoBI" in "server.xml" file
ex 192.168.1.1:8080/SpagoBI and i opened the SpagoBI on localhost instead of using IP.

So use correct URL you have defined in "server.xml" file.

3. I was having trouble with Chrome browser, so i switch to Firefox browser.
web stats