virtual cube pada BI Server

17 views
Skip to first unread message
Message has been deleted

lisiana

unread,
Nov 30, 2009, 2:48:05 AM11/30/09
to Pentaho User Group Indonesia
Siang Pak Feris,

saya sudah memasukkan coding virtual cube dan langsung menjalankannya
pada BI Server. Kemudian error yang ada pada LOG BI Server seperti
ini.

Nov 30, 2009 11:39:08 AM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: C:\biserver-ce\jre\bin;.;C:\Windows\system32;C:
\Windows;C:\biserver-ce\jre\bin;C:\Windows\system32;C:\Windows;C:
\Windows\System32\Wbem;C:\Program Files\CyberLink\Power2Go;C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft
SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server
\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Windows
\System32\WindowsPowerShell\v1.0\;
Nov 30, 2009 11:39:08 AM org.apache.coyote.http11.Http11BaseProtocol
init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:39:08 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1406 ms
Nov 30, 2009 11:39:08 AM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Nov 30, 2009 11:39:08 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.26
Nov 30, 2009 11:39:08 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 30, 2009 11:39:14 AM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 11:39:33 AM org.apache.coyote.http11.Http11BaseProtocol
start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:39:33 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 30, 2009 11:39:33 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/22 config=null
Nov 30, 2009 11:39:33 AM org.apache.catalina.storeconfig.StoreLoader
load
INFO: Find registry server-registry.xml at classpath resource
Nov 30, 2009 11:39:33 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 25553 ms
Nov 30, 2009 11:43:03 AM org.apache.coyote.http11.Http11BaseProtocol
pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:43:04 AM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Nov 30, 2009 11:43:07 AM org.apache.coyote.http11.Http11BaseProtocol
destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:43:07 AM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: Failed shutdown of Apache Portable Runtime
Nov 30, 2009 11:43:17 AM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: C:\biserver-ce\jre\bin;.;C:\Windows\system32;C:
\Windows;C:\biserver-ce\jre\bin;C:\Windows\system32;C:\Windows;C:
\Windows\System32\Wbem;C:\Program Files\CyberLink\Power2Go;C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft
SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server
\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Windows
\System32\WindowsPowerShell\v1.0\;
Nov 30, 2009 11:43:17 AM org.apache.coyote.http11.Http11BaseProtocol
init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:43:17 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 566 ms
Nov 30, 2009 11:43:17 AM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Nov 30, 2009 11:43:17 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.26
Nov 30, 2009 11:43:17 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 30, 2009 11:43:19 AM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 11:43:34 AM org.apache.coyote.http11.Http11BaseProtocol
start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:43:34 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 30, 2009 11:43:34 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/17 config=null
Nov 30, 2009 11:43:34 AM org.apache.catalina.storeconfig.StoreLoader
load
INFO: Find registry server-registry.xml at classpath resource
Nov 30, 2009 11:43:35 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 17430 ms
Nov 30, 2009 11:52:15 AM org.apache.coyote.http11.Http11BaseProtocol
pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:52:16 AM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Nov 30, 2009 11:52:18 AM org.apache.coyote.http11.Http11BaseProtocol
destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:52:18 AM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: Failed shutdown of Apache Portable Runtime
Nov 30, 2009 11:52:26 AM org.apache.catalina.startup.Catalina
stopServer
SEVERE: Catalina.stop:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.catalina.startup.Catalina.stopServer
(Catalina.java:395)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.stopServer
(Bootstrap.java:
344)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
435)
Nov 30, 2009 11:52:51 AM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: C:\biserver-ce\jre\bin;.;C:\Windows\system32;C:
\Windows;C:\biserver-ce\jre\bin;C:\Windows\system32;C:\Windows;C:
\Windows\System32\Wbem;C:\Program Files\CyberLink\Power2Go;C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft
SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server
\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Windows
\System32\WindowsPowerShell\v1.0\;
Nov 30, 2009 11:52:51 AM org.apache.coyote.http11.Http11BaseProtocol
init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:52:51 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 545 ms
Nov 30, 2009 11:52:51 AM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Nov 30, 2009 11:52:51 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.26
Nov 30, 2009 11:52:51 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 30, 2009 11:52:53 AM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 11:53:08 AM org.apache.coyote.http11.Http11BaseProtocol
start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 30, 2009 11:53:08 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 30, 2009 11:53:08 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/17 config=null
Nov 30, 2009 11:53:08 AM org.apache.catalina.storeconfig.StoreLoader
load
INFO: Find registry server-registry.xml at classpath resource
Nov 30, 2009 11:53:08 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 16984 ms
Nov 30, 2009 11:59:28 AM org.apache.catalina.startup.HostConfig
checkResources
INFO: Undeploying context [/pentaho]
Nov 30, 2009 11:59:35 AM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 12:02:52 PM org.apache.coyote.http11.Http11BaseProtocol
pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:02:53 PM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Nov 30, 2009 12:02:55 PM org.apache.coyote.http11.Http11BaseProtocol
destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:02:55 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: Failed shutdown of Apache Portable Runtime
Nov 30, 2009 12:03:03 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: C:\biserver-ce\jre\bin;.;C:\Windows\system32;C:
\Windows;C:\biserver-ce\jre\bin;C:\Windows\system32;C:\Windows;C:
\Windows\System32\Wbem;C:\Program Files\CyberLink\Power2Go;C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft
SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server
\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Windows
\System32\WindowsPowerShell\v1.0\;
Nov 30, 2009 12:03:04 PM org.apache.coyote.http11.Http11BaseProtocol
init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:03:04 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 596 ms
Nov 30, 2009 12:03:04 PM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Nov 30, 2009 12:03:04 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.26
Nov 30, 2009 12:03:04 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 30, 2009 12:03:05 PM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 12:03:20 PM org.apache.coyote.http11.Http11BaseProtocol
start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:03:21 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 30, 2009 12:03:21 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/17 config=null
Nov 30, 2009 12:03:21 PM org.apache.catalina.storeconfig.StoreLoader
load
INFO: Find registry server-registry.xml at classpath resource
Nov 30, 2009 12:03:21 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 17085 ms
Nov 30, 2009 12:03:30 PM org.apache.coyote.http11.Http11BaseProtocol
pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:03:31 PM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Nov 30, 2009 12:03:34 PM org.apache.coyote.http11.Http11BaseProtocol
destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:03:34 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: Failed shutdown of Apache Portable Runtime
Nov 30, 2009 12:03:50 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: C:\biserver-ce\jre\bin;.;C:\Windows\system32;C:
\Windows;C:\biserver-ce\jre\bin;C:\Windows\system32;C:\Windows;C:
\Windows\System32\Wbem;C:\Program Files\CyberLink\Power2Go;C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft
SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server
\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Windows
\System32\WindowsPowerShell\v1.0\;
Nov 30, 2009 12:03:50 PM org.apache.coyote.http11.Http11BaseProtocol
init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:03:50 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 609 ms
Nov 30, 2009 12:03:50 PM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Nov 30, 2009 12:03:50 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.26
Nov 30, 2009 12:03:50 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 30, 2009 12:03:51 PM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 12:04:06 PM org.apache.coyote.http11.Http11BaseProtocol
start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:04:06 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 30, 2009 12:04:06 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/17 config=null
Nov 30, 2009 12:04:06 PM org.apache.catalina.storeconfig.StoreLoader
load
INFO: Find registry server-registry.xml at classpath resource
Nov 30, 2009 12:04:06 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 16382 ms
Nov 30, 2009 12:26:00 PM org.apache.coyote.http11.Http11BaseProtocol
pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:26:01 PM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Nov 30, 2009 12:26:05 PM org.apache.coyote.http11.Http11BaseProtocol
destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:26:05 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: Failed shutdown of Apache Portable Runtime
Nov 30, 2009 12:26:50 PM org.apache.catalina.startup.Catalina
stopServer
SEVERE: Catalina.stop:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.catalina.startup.Catalina.stopServer
(Catalina.java:395)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.stopServer
(Bootstrap.java:
344)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
435)
Nov 30, 2009 12:27:16 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: C:\biserver-ce\jre\bin;.;C:\Windows\system32;C:
\Windows;C:\biserver-ce\jre\bin;C:\Windows\system32;C:\Windows;C:
\Windows\System32\Wbem;C:\Program Files\CyberLink\Power2Go;C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft
SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server
\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Windows
\System32\WindowsPowerShell\v1.0\;
Nov 30, 2009 12:27:16 PM org.apache.coyote.http11.Http11BaseProtocol
init
SEVERE: Error initializing endpoint
java.net.BindException: Address already in use: JVM_Bind:8080
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint
(PoolTcpEndpoint.java:298)
at org.apache.coyote.http11.Http11BaseProtocol.init
(Http11BaseProtocol.java:139)
at org.apache.catalina.connector.Connector.initialize
(Connector.java:
1017)
at org.apache.catalina.core.StandardService.initialize
(StandardService.java:578)
at org.apache.catalina.core.StandardServer.initialize
(StandardServer.java:782)
at org.apache.catalina.startup.Catalina.load(Catalina.java:
504)
at org.apache.catalina.startup.Catalina.load(Catalina.java:
524)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:
267)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
432)
Nov 30, 2009 12:27:16 PM org.apache.catalina.startup.Catalina load
SEVERE: Catalina.start
LifecycleException: Protocol handler initialization failed:
java.net.BindException: Address already in use: JVM_Bind:8080
at org.apache.catalina.connector.Connector.initialize
(Connector.java:
1019)
at org.apache.catalina.core.StandardService.initialize
(StandardService.java:578)
at org.apache.catalina.core.StandardServer.initialize
(StandardServer.java:782)
at org.apache.catalina.startup.Catalina.load(Catalina.java:
504)
at org.apache.catalina.startup.Catalina.load(Catalina.java:
524)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:
267)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
432)
Nov 30, 2009 12:27:16 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 589 ms
Nov 30, 2009 12:27:16 PM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Nov 30, 2009 12:27:16 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.26
Nov 30, 2009 12:27:16 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 30, 2009 12:27:18 PM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 12:27:32 PM org.apache.coyote.http11.Http11BaseProtocol
start
SEVERE: Error starting endpoint
java.net.BindException: Address already in use: JVM_Bind:8080
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint
(PoolTcpEndpoint.java:298)
at org.apache.tomcat.util.net.PoolTcpEndpoint.startEndpoint
(PoolTcpEndpoint.java:313)
at org.apache.coyote.http11.Http11BaseProtocol.start
(Http11BaseProtocol.java:151)
at org.apache.coyote.http11.Http11Protocol.start
(Http11Protocol.java:
76)
at org.apache.catalina.connector.Connector.start
(Connector.java:1090)
at org.apache.catalina.core.StandardService.start
(StandardService.java:457)
at org.apache.catalina.core.StandardServer.start
(StandardServer.java:
700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:
552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
433)
Nov 30, 2009 12:27:32 PM org.apache.catalina.startup.Catalina start
SEVERE: Catalina.start:
LifecycleException: service.getName(): "Catalina"; Protocol handler
start failed: java.net.BindException: Address already in use:
JVM_Bind:
8080
at org.apache.catalina.connector.Connector.start
(Connector.java:1097)
at org.apache.catalina.core.StandardService.start
(StandardService.java:457)
at org.apache.catalina.core.StandardServer.start
(StandardServer.java:
700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:
552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
433)
Nov 30, 2009 12:27:32 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 16370 ms
Nov 30, 2009 12:27:32 PM org.apache.catalina.core.StandardServer await
SEVERE: StandardServer.await: create[8005]:
java.net.BindException: Address already in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(Unknown Source)
at java.net.ServerSocket.bind(Unknown Source)
at java.net.ServerSocket.<init>(Unknown Source)
at org.apache.catalina.core.StandardServer.await
(StandardServer.java:
363)
at org.apache.catalina.startup.Catalina.await(Catalina.java:
616)
at org.apache.catalina.startup.Catalina.start(Catalina.java:
576)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
433)
Nov 30, 2009 12:27:32 PM org.apache.coyote.http11.Http11BaseProtocol
pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:27:32 PM org.apache.catalina.connector.Connector pause
SEVERE: Protocol handler pause failed
java.lang.NullPointerException
at org.apache.jk.server.JkMain.pause(JkMain.java:679)
at org.apache.jk.server.JkCoyoteHandler.pause
(JkCoyoteHandler.java:
163)
at org.apache.catalina.connector.Connector.pause
(Connector.java:1032)
at org.apache.catalina.core.StandardService.stop
(StandardService.java:
489)
at org.apache.catalina.core.StandardServer.stop
(StandardServer.java:
734)
at org.apache.catalina.startup.Catalina.stop(Catalina.java:
602)
at org.apache.catalina.startup.Catalina
$CatalinaShutdownHook.run
(Catalina.java:645)
Nov 30, 2009 12:27:33 PM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Nov 30, 2009 12:29:27 PM org.apache.catalina.startup.Catalina
stopServer
SEVERE: Catalina.stop:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.catalina.startup.Catalina.stopServer
(Catalina.java:395)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.stopServer
(Bootstrap.java:
344)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
435)
Nov 30, 2009 12:30:12 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path: C:\biserver-ce\jre\bin;.;C:\Windows\system32;C:
\Windows;C:\biserver-ce\jre\bin;C:\Windows\system32;C:\Windows;C:
\Windows\System32\Wbem;C:\Program Files\CyberLink\Power2Go;C:\Program
Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft
SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server
\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Windows
\System32\WindowsPowerShell\v1.0\;
Nov 30, 2009 12:30:12 PM org.apache.coyote.http11.Http11BaseProtocol
init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:30:12 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 587 ms
Nov 30, 2009 12:30:12 PM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Nov 30, 2009 12:30:12 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.26
Nov 30, 2009 12:30:12 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 30, 2009 12:30:14 PM org.apache.catalina.startup.ContextConfig
validateSecurityRoles
WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint>
without being defined in a <security-role>
Nov 30, 2009 12:30:28 PM org.apache.coyote.http11.Http11BaseProtocol
start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 30, 2009 12:30:28 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 30, 2009 12:30:28 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/18 config=null
Nov 30, 2009 12:30:29 PM org.apache.catalina.storeconfig.StoreLoader
load
INFO: Find registry server-registry.xml at classpath resource
Nov 30, 2009 12:30:29 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 16295 ms

Berikut coding virtual cube pada XML yang di copy :

<VirtualCube enabled="true" name="Revenue Actual vs Target">
<CubeUsages>
<CubeUsage cubeName="Actual_Revenue"
ignoreUnrelatedDimensions="true">
</CubeUsage>
<CubeUsage>
<CubeUsage cubeName="Target_Revenue"
ignoreUnrelatedDimensions="false">
</CubeUsages>
<VirtualCubeDimension name="Divisi">
</VirtualCubeDimension>
<VirtualCubeDimension name="Time">
</VirtualCubeDimension>
<VirtualCubeDimension name="Product">
</VirtualCubeDimension>
<VirtualCubeMeasure cubeName="Actual_Revenue" name="[Measures].
[Amount Actual Revenue]" visible="true">
</VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Target_Revenue" name="[Measures].
[Amount Target Revenue]" visible="true">
</VirtualCubeMeasure>
<CalculatedMember name="Selisih" formula="[Measures].[Amount
Actual Revenue]-[Measures].[Amount Target Revenue]"
dimension="Measures" visible="true">
</CalculatedMember>
</VirtualCube>

Di coba dengan coding virtual cube dibawah ini pun sama
errornya :

<VirtualCube name="Revenue Actual vs Target">
<CubeUsages>
<CubeUsage cubeName="Actual_Revenue"
ignoreUnrelatedDimensions="true"/>
<CubeUsage cubeName="Target_Revenue"
ignoreUnrelatedDimensions="false"/>
</CubeUsages>
<VirtualCubeDimension cubeName="Actual_Revenue"
name="Divisi"/>
<VirtualCubeDimension cubeName="Actual_Revenue" name="Product"/>
<VirtualCubeDimension cubeName="Actual_Revenue" name="Time"/>
<VirtualCubeDimension cubeName="Target_Revenue" name="Time"/>
<VirtualCubeDimension cubeName="Target_Revenue" name="Divisi"/>
<VirtualCubeDimension cubeName="Target_Revenue" name="Product"/>

<VirtualCubeMeasure cubeName="Actual_Revenue" name="[Measures].
[Amount Actual Revenue]"/>
<VirtualCubeMeasure cubeName="Target_Revenue" name="[Measures].
[Amount Target Revenue]"/>

<CalculatedMember name="Selisih" dimension="Measures">
<Formula>[Measures].[Amount Actual Revenue] - [Measures].
[Amount Target Revenue]</Formula>
</CalculatedMember>-->
</VirtualCube>

</Schema>

Berikut isi file analysis_trafik.analysisview.xaction yang harus
diubah :

<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
<name>analysis_trafik.xaction</name>
<title>%title</title>
<version>1</version>
<logging-level>ERROR</logging-level>
<documentation>
<author>M-stars Developer</author>

<model><![CDATA[M-Stars/virtual cube Revenue.xml]]></model>
<!-- connection>jdbc/SampleData</connection -->
<!-- query>default</query -->

<jndi>M-stars</jndi>
<query><![CDATA[select {[Measures].[Amount Actual Revenue]} ON
COLUMNS,
Hierarchize({[Divisi].[All Divisi]}) ON ROWS
from [virtual cube Revenue]
]]></query>

Berikut potongan isi file context.xml :

<Resource name="jdbc/Report" auth="Container"
type="javax.sql.DataSource"

factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="20" maxIdle="5"
maxWait="10000" username="sa" password="1234"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://127.0.0.1:1433/OLAP_Magang"
validationQuery="select {[Measures].[Amount Actual
Revenue]} on
columns,
{[Divisi].[All Divisi]} on rows
from virtual cube Revenue"/>

ini kesalahannya ada di mana ya pak?
saya memakai Apache Software Foundation, apakah berpengaruh?seperti
bentrok degan bi servernya mungkin...
karena pada saat saya menjalankan bi server, apache tomcatnya harus
dimatikan dahulu...
kemudian karena saya memakai windows vista, apakah itu juga
berpengaruh?
Terima Kasih

Feris Thia

unread,
Nov 30, 2009, 12:09:08 PM11/30/09
to penta...@googlegroups.com
Hi Lisiana,

Wah... ini saya mesti jawab dengan potongan2 email kali ya. Pertama, di context.xml validation querynya salah besar :p

Context.xml isinya untuk definisi koneksi ke database server kita dan belum mengenal "MDX". Perhatikan query yang ada di atribut 
"Validation Query" di bawah... harusnya hanya "SQL" yang berlaku, misalkan :

Select top 1 * from table_fact;

Semoga membantu ya... Akan saya coba lihat error lainnya.

Regards,

Feris


On Mon, Nov 30, 2009 at 2:48 PM, lisiana <lisiana...@gmail.com> wrote:
Berikut potongan isi file context.xml :

<Resource name="jdbc/Report" auth="Container"
type="javax.sql.DataSource"

factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="20" maxIdle="5"
               maxWait="10000" username="sa" password="1234"
               driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://127.0.0.1:1433/OLAP_Magang"
               validationQuery="select {[Measures].[Amount Actual
Revenue]} on
columns,
       {[Divisi].[All Divisi]} on rows
       from virtual cube Revenue"/>

ini kesalahannya ada di mana ya pak?
saya memakai Apache Software Foundation, apakah berpengaruh?seperti
bentrok degan bi servernya mungkin...
karena pada saat saya menjalankan bi server, apache tomcatnya harus
dimatikan dahulu...
kemudian karena saya memakai windows vista, apakah itu juga
berpengaruh?



--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483
Mobile : +628176-474-525
http://www.phi-integration.com
http://pentaho.phi-integration.com

Feris Thia

unread,
Nov 30, 2009, 12:16:18 PM11/30/09
to penta...@googlegroups.com
Malam Lisiana,

Wow... errornya pusing juga bacanya :p hehehe

Btw, dari yang saya lihat ada error dimana port 8080 sudah digunakan. Coba pastikan tidak ada port dari server lain yang menggunakan port 8080 atau ganti port BI Server di file [BI-SERVER]/tomcat/conf/server.xml.

Semoga membantu ya...

Regards,

Feris

On Mon, Nov 30, 2009 at 1:12 PM, lisiana <lisiana...@gmail.com> wrote:
Siang Pak Feris,

saya sudah memasukkan coding virtual cube dan langsung menjalankannya
pada BI Server. Kemudian error yang ada pada LOG BI Server seperti
ini.



Reply all
Reply to author
Forward
0 new messages