Open Business Intelligence

La red del Business Intelligence

No muestra nada al copiar el xaction a la carpeta solution de pentaho

hola tengo un peuq problema  ya  tengo echo mi cubo con el  workberch   y ya publicado lo abro con el pentaho designer  y  configuro el origen del xml, el data set

y guardo el archivo (.xaction) pero no me muestra mi archivo action desde localhost:8080/pentaho cabe recalcar q ya copie el .xaction  dentro de la carpeta pentaho-solution 

nose si me podria ayudar  ya nose q hacer :S

Saludos

Visitas: 235

Respuestas a esta discusión

Permalink Responder para Mariano García Mattío el enero 9, 2012 a las 6:41pm

Tienes mal definido algo en el esquema, posiblemente las claves foráneas o definida una PK que no va.

A propósito, no se escribe kiero, se escribe quiero y rediceñe se escribe con "s".

No se al resto, pero a mi me mal predispone que se escriba de cualquier forma, asumo que la gran mayoría de esta red son profesionales, y definitivamente, los profesionales no escriben así.

Saludos

Mariano

Permalink Responder para vgv el enero 9, 2012 a las 8:10pm

gracias por el consejo.. :)

 en el log me sale ahora  jdbc:hsqldb:hsql://localhost:9001/hibernate en un war  pero yo uso mysql  nose si tengo que configurar algo previamente  en los archivos de  pentaho bi ??

saludos

Permalink Responder para Mariano García Mattío el enero 9, 2012 a las 9:24pm

por favor sube el log

Permalink Responder para vgv el enero 11, 2012 a las 7:18pm

hola  Mariano  aki esta el log

11:28:01,796 INFO  [HbmBinder] Mapping collection: org.pentaho.platform.engine.s
ecurity.userroledao.PentahoUser.roles -> GRANTED_AUTHORITIES
11:28:01,796 INFO  [HbmBinder] Mapping class: org.pentaho.platform.engine.securi
ty.userroledao.PentahoRole -> AUTHORITIES
11:28:01,796 INFO  [HbmBinder] Mapping collection: org.pentaho.platform.engine.s
ecurity.userroledao.PentahoRole.users -> GRANTED_AUTHORITIES
11:28:01,826 INFO  [HbmBinder] Mapping collection: org.pentaho.platform.reposito
ry.solution.dbbased.RepositoryFile.childrenFiles -> PRO_FILES
11:28:01,886 INFO  [AnnotationConfiguration] Hibernate Validator not found: igno
ring
11:28:02,116 INFO  [DriverManagerConnectionProvider] Using Hibernate built-in co
nnection pool (not for production use!)
11:28:02,116 INFO  [DriverManagerConnectionProvider] Hibernate connection pool s
ize: 10
11:28:02,116 INFO  [DriverManagerConnectionProvider] autocommit mode: false
11:28:02,377 INFO  [DriverManagerConnectionProvider] using driver: org.hsqldb.jd
bcDriver at URL: jdbc:hsqldb:hsql://localhost:9001/hibernate
11:28:02,377 INFO  [DriverManagerConnectionProvider] connection properties: {use
r=hibuser, password=password}
11:28:02,497 INFO  [SettingsFactory] RDBMS: HSQL Database Engine, version: 1.8.0

11:28:02,497 INFO  [SettingsFactory] JDBC driver: HSQL Database Engine Driver, v
ersion: 1.8.0
11:28:02,657 INFO  [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect
11:28:02,697 INFO  [TransactionFactoryFactory] Using default transaction strateg
y (direct JDBC transactions)
11:28:02,707 INFO  [TransactionManagerLookupFactory] No TransactionManagerLookup
 configured (in JTA environment, use of read-write or transactional second-level
 cache is not recommended)
11:28:02,707 INFO  [SettingsFactory] Automatic flush during beforeCompletion():
disabled
11:28:02,707 INFO  [SettingsFactory] Automatic session close at end of transacti
on: disabled
11:28:02,717 INFO  [SettingsFactory] JDBC batch size: 15
11:28:02,717 INFO  [SettingsFactory] JDBC batch updates for versioned data: disa
bled
11:28:02,727 INFO  [SettingsFactory] Scrollable result sets: enabled
11:28:02,727 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
11:28:02,727 INFO  [SettingsFactory] Connection release mode: auto
11:28:02,727 INFO  [SettingsFactory] Default batch fetch size: 1
11:28:02,727 INFO  [SettingsFactory] Generate SQL with comments: disabled
11:28:02,727 INFO  [SettingsFactory] Order SQL updates by primary key: disabled
11:28:02,727 INFO  [SettingsFactory] Order SQL inserts for batching: disabled
11:28:02,727 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.AST
QueryTranslatorFactory
11:28:02,737 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
11:28:02,737 INFO  [SettingsFactory] Query language substitutions: {}
11:28:02,737 INFO  [SettingsFactory] JPA-QL strict compliance: disabled
11:28:02,737 INFO  [SettingsFactory] Second-level cache: enabled
11:28:02,737 INFO  [SettingsFactory] Query cache: enabled
11:28:02,737 INFO  [SettingsFactory] Cache provider: org.hibernate.cache.EhCache
Provider
11:28:03,038 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled
11:28:03,038 INFO  [SettingsFactory] Structured second-level cache entries: disa
bled
11:28:03,038 INFO  [SettingsFactory] Query cache factory: org.hibernate.cache.St
andardQueryCacheFactory
11:28:03,118 INFO  [SettingsFactory] Statistics: enabled
11:28:03,118 INFO  [SettingsFactory] Deleted entity synthetic identifier rollbac
k: disabled
11:28:03,118 INFO  [SettingsFactory] Default entity-mode: pojo
11:28:03,118 INFO  [SettingsFactory] Named query checking : enabled
11:28:03,618 INFO  [SessionFactoryImpl] building session factory
11:28:04,179 WARN  [ConfigurationFactory] No configuration found. Configuring eh
cache from ehcache-failsafe.xml  found in the classpath: jar:file:/C:/pentaho/ad
ministration-console/lib/ehcache-core-2.0.1.jar!/ehcache-failsafe.xml
11:28:05,191 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.subscription.SubscribeContent]; using defaults.
11:28:07,524 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.runtime.RuntimeElement]; using defaults.
11:28:07,844 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.subscription.Subscription]; using defaults.
11:28:07,955 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.subscription.Schedule]; using defaults.
11:28:08,035 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.usersettings.pojo.UserSetting]; using defaults.
11:28:08,155 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.content.ContentItemFile]; using defaults.
11:28:08,265 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.content.BackgroundExecutedContentId]; using defaults.
11:28:08,295 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.content.ContentItem]; using defaults.
11:28:08,365 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.solution.dbbased.RepositoryFile]; using defaults.
11:28:08,405 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.content.ContentLocation]; using defaults.
11:28:08,465 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.datasource.Datasource]; using defaults.
11:28:08,555 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.subscription.SubscribeContent.parameters]; using defaults.
11:28:08,565 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.solution.dbbased.RepositoryFile.childrenFiles]; using default
s.
11:28:08,616 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.solution.dbbased.RepositoryFile.accessControls]; using defaul
ts.
11:28:08,646 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.subscription.Subscription.schedules]; using defaults.
11:28:08,686 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.subscription.Subscription.parameters]; using defaults.
11:28:08,746 WARN  [EhCacheProvider] Could not find configuration [org.pentaho.p
latform.repository.subscription.SubscribeContent.schedules]; using defaults.
11:28:09,176 INFO  [SessionFactoryObjectFactory] Not binding factory to JNDI, no
 JNDI name configured
11:28:09,246 INFO  [SchemaUpdate] Running hbm2ddl schema update
11:28:09,246 INFO  [SchemaUpdate] fetching database metadata
11:28:09,377 INFO  [SchemaUpdate] updating schema
11:28:09,507 INFO  [TableMetadata] table found: PUBLIC.AUTHORITIES
11:28:09,507 INFO  [TableMetadata] columns: [authority, description]
11:28:09,507 INFO  [TableMetadata] foreign keys: []
11:28:09,507 INFO  [TableMetadata] indexes: [sys_idx_48]
11:28:09,507 INFO  [TableMetadata] table found: PUBLIC.BDPARAMS
11:28:09,507 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,507 INFO  [TableMetadata] foreign keys: [fk61733c48fa34bfdc]
11:28:09,517 INFO  [TableMetadata] indexes: [sys_idx_56, sys_idx_132]
11:28:09,517 INFO  [TableMetadata] table found: PUBLIC.BGCONTENTID
11:28:09,517 INFO  [TableMetadata] columns: [bguser, revision, bgcontid]
11:28:09,517 INFO  [TableMetadata] foreign keys: []
11:28:09,517 INFO  [TableMetadata] indexes: [sys_idx_58]
11:28:09,577 INFO  [TableMetadata] table found: PUBLIC.CONTENTITEM
11:28:09,577 INFO  [TableMetadata] columns: [extension, revision, contitemid, mi
metype, title, name, path, writemode, latestvernum, url, parent_id]
11:28:09,577 INFO  [TableMetadata] foreign keys: [fk692b5eec44f32395]
11:28:09,577 INFO  [TableMetadata] indexes: [sys_idx_63, sys_idx_sys_ct_62_65, s
ys_idx_134]
11:28:09,587 INFO  [TableMetadata] table found: PUBLIC.CONTENTLOCATION
11:28:09,697 INFO  [TableMetadata] columns: [revision, contentid, description, n
ame, solnid, dirpath]
11:28:09,697 INFO  [TableMetadata] foreign keys: []
11:28:09,697 INFO  [TableMetadata] indexes: [sys_idx_sys_ct_66_69, sys_idx_67]
11:28:09,707 INFO  [TableMetadata] table found: PUBLIC.CONTITEMFILE
11:28:09,707 INFO  [TableMetadata] columns: [revision, filesize, actname, contif
ileid, isinitialized, filedatetime, parent_id, ospath, osfilename]
11:28:09,717 INFO  [TableMetadata] foreign keys: [fk7fc3f44164d906f3]
11:28:09,717 INFO  [TableMetadata] indexes: [sys_idx_72, sys_idx_70]
11:28:09,717 INFO  [TableMetadata] table found: PUBLIC.CPLXPARAMS
11:28:09,727 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,727 INFO  [TableMetadata] foreign keys: [fkd6d6e97ffa34bfdc]
11:28:09,727 INFO  [TableMetadata] indexes: [sys_idx_136, sys_idx_74]
11:28:09,737 INFO  [TableMetadata] table found: PUBLIC.DATASOURCE
11:28:09,737 INFO  [TableMetadata] columns: [maxactconn, username, query, driver
class, name, wait, idleconn, password, url]
11:28:09,737 INFO  [TableMetadata] foreign keys: []
11:28:09,737 INFO  [TableMetadata] indexes: [sys_idx_46]
11:28:09,747 INFO  [TableMetadata] table found: PUBLIC.DTPARAMS
11:28:09,747 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,747 INFO  [TableMetadata] foreign keys: [fk7f994a16fa34bfdc]
11:28:09,747 INFO  [TableMetadata] indexes: [sys_idx_76, sys_idx_138]
11:28:09,747 INFO  [TableMetadata] table found: PUBLIC.GRANTED_AUTHORITIES
11:28:09,747 INFO  [TableMetadata] columns: [authority, username]
11:28:09,747 INFO  [TableMetadata] foreign keys: [fk7471775dd9edc77f, fk7471775d
41b6da97]
11:28:09,757 INFO  [TableMetadata] indexes: [sys_idx_52, sys_idx_50, sys_idx_130
]
11:28:09,757 INFO  [TableMetadata] table found: PUBLIC.LNGPARAMS
11:28:09,757 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,757 INFO  [TableMetadata] foreign keys: [fke304fccbfa34bfdc]
11:28:09,757 INFO  [TableMetadata] indexes: [sys_idx_78, sys_idx_140]
11:28:09,767 INFO  [TableMetadata] table found: PUBLIC.LSPARAMS
11:28:09,767 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,767 INFO  [TableMetadata] foreign keys: [fk89bc75cdfa34bfdc]
11:28:09,767 INFO  [TableMetadata] indexes: [sys_idx_142, sys_idx_80]
11:28:09,767 INFO  [TableMetadata] table found: PUBLIC.PARAMTYPESMAP
11:28:09,767 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,767 INFO  [TableMetadata] foreign keys: [fkd3eda1b0fa34bfdc]
11:28:09,767 INFO  [TableMetadata] indexes: [sys_idx_144, sys_idx_82]
11:28:09,777 INFO  [TableMetadata] table found: PUBLIC.PRO_ACLS_LIST
11:28:09,777 INFO  [TableMetadata] columns: [acl_position, recip_type, acl_mask,
 recipient, acl_id]
11:28:09,777 INFO  [TableMetadata] foreign keys: [fkb65646c2b23c5d30]
11:28:09,777 INFO  [TableMetadata] indexes: [sys_idx_84, sys_idx_146]
11:28:09,787 INFO  [TableMetadata] table found: PUBLIC.PRO_FILES
11:28:09,787 INFO  [TableMetadata] columns: [revision, directory, child_id, file
_id, data, lastmodified, filename, parent, fullpath]
11:28:09,787 INFO  [TableMetadata] foreign keys: [fk94a87e25cbbbb0ea, fk94a87e25
69fabf5e]
11:28:09,787 INFO  [TableMetadata] indexes: [sys_idx_91, sys_idx_86, sys_idx_sys
_ct_84_88, sys_idx_89]
11:28:09,787 INFO  [TableMetadata] table found: PUBLIC.PRO_SCHEDULE
11:28:09,787 INFO  [TableMetadata] columns: [scheddesc, revision, startdate, sch
eduleid, schedtitle, last_trigger, repeatinterval, groupname, enddate, repeatcou
nt, cronstring, schedref]
11:28:09,787 INFO  [TableMetadata] foreign keys: []
11:28:09,797 INFO  [TableMetadata] indexes: [sys_idx_93]
11:28:09,797 INFO  [TableMetadata] table found: PUBLIC.PRO_SUBCONTENT
11:28:09,797 INFO  [TableMetadata] columns: [revision, subcontid, subcontactref,
 subconttype]
11:28:09,797 INFO  [TableMetadata] foreign keys: []
11:28:09,807 INFO  [TableMetadata] indexes: [sys_idx_sys_ct_90_97, sys_idx_95]
11:28:09,807 INFO  [TableMetadata] table found: PUBLIC.PRO_SUBCONTPARMS
11:28:09,807 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,807 INFO  [TableMetadata] foreign keys: [fkf3ce4c47846761a]
11:28:09,807 INFO  [TableMetadata] indexes: [sys_idx_100, sys_idx_98]
11:28:09,817 INFO  [TableMetadata] table found: PUBLIC.PRO_SUBCONT_SCHEDLIST
11:28:09,817 INFO  [TableMetadata] columns: [scheduleid, schedid, elt]
11:28:09,817 INFO  [TableMetadata] foreign keys: [fkf0d3fbd69e226721, fkf0d3fbd6
2593bc9e]
11:28:09,817 INFO  [TableMetadata] indexes: [sys_idx_102, sys_idx_106, sys_idx_1
04]
11:28:09,817 INFO  [TableMetadata] table found: PUBLIC.PRO_SUBSCRIBE
11:28:09,817 INFO  [TableMetadata] columns: [subscrid, subscrtitle, subscruser,
revision, subscrdest, subscrtype, subscr_contid]
11:28:09,817 INFO  [TableMetadata] foreign keys: [fk5e7511f89d8ac376]
11:28:09,817 INFO  [TableMetadata] indexes: [sys_idx_108, sys_idx_110]
11:28:09,827 INFO  [TableMetadata] table found: PUBLIC.PRO_SUBSCRPARMS
11:28:09,827 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,827 INFO  [TableMetadata] foreign keys: [fk95dade9355dc7de8]
11:28:09,827 INFO  [TableMetadata] indexes: [sys_idx_114, sys_idx_112]
11:28:09,837 INFO  [TableMetadata] table found: PUBLIC.PRO_SUBS_SCHEDLIST
11:28:09,837 INFO  [TableMetadata] columns: [scheduleid, schedid, elt]
11:28:09,837 INFO  [TableMetadata] foreign keys: [fk2a8c749b7329c46c, fk2a8c749b
9e226721]
11:28:09,837 INFO  [TableMetadata] indexes: [sys_idx_118, sys_idx_116, sys_idx_1
20]
11:28:09,837 INFO  [TableMetadata] table found: PUBLIC.RTELEMENT
11:28:09,847 INFO  [TableMetadata] columns: [revision, created, solnid, parid, p
artype, readonly, instanceid]
11:28:09,847 INFO  [TableMetadata] foreign keys: []
11:28:09,847 INFO  [TableMetadata] indexes: [sys_idx_122]
11:28:09,847 INFO  [TableMetadata] table found: PUBLIC.SSPARAMS
11:28:09,857 INFO  [TableMetadata] columns: [paramkey, itemid, paramvalue]
11:28:09,857 INFO  [TableMetadata] foreign keys: [fk60e4afe6fa34bfdc]
11:28:09,857 INFO  [TableMetadata] indexes: [sys_idx_126, sys_idx_124]
11:28:09,857 INFO  [TableMetadata] table found: PUBLIC.USERS
11:28:09,857 INFO  [TableMetadata] columns: [enabled, username, description, pas
sword]
11:28:09,857 INFO  [TableMetadata] foreign keys: []
11:28:09,857 INFO  [TableMetadata] indexes: [sys_idx_54]
11:28:09,867 INFO  [TableMetadata] table found: PUBLIC.USER_SETTINGS
11:28:09,867 INFO  [TableMetadata] columns: [username, setting_value, user_setti
ngs_id, setting_name]
11:28:09,867 INFO  [TableMetadata] foreign keys: []
11:28:09,867 INFO  [TableMetadata] indexes: [sys_idx_128]
11:28:09,867 INFO  [SchemaUpdate] schema update complete
11:28:09,887 INFO  [UpdateTimestampsCache] starting update timestamps cache at r
egion: org.hibernate.cache.UpdateTimestampsCache
11:28:09,887 WARN  [EhCacheProvider] Could not find configuration [org.hibernate
.cache.UpdateTimestampsCache]; using defaults.
11:28:09,917 INFO  [StandardQueryCache] starting query cache at region: org.hibe
rnate.cache.StandardQueryCache
11:28:09,917 WARN  [EhCacheProvider] Could not find configuration [org.hibernate
.cache.StandardQueryCache]; using defaults.
11:28:14,184 INFO  [UpdateChecker] New update(s) found: 2.4.7 [http://www.terrac
otta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4]. Please chec
k http://ehcache.org for the latest version.

en la linea que esta resaltada me sale algo del driver, al usar mysql como repositorio es necesario cambiar algun archivo de la plataforma bi????

saludos

Permalink Responder para Mariano García Mattío el enero 12, 2012 a las 4:18am

Estimado/a: no veo errores.

Si estás utilizando mysql como repositorio de metadatos deberías inhabilitar hypersonic (hsqldb), lo haces desde el descriptor de despligue "web.xml" que se encuentra en .../tomcat/webapps/pentaho/WEB-INF/web.xml, debes inhabilitar el hilo que lo inicia:

<listener>
      <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class>
</listener>

Si no es así, te dará un error. 

Aclaración: el datawarehouse no es el repositorio de metadatos

Saludos

Mariano

Permalink Responder para vgv el enero 19, 2012 a las 9:05am

hola al inhabilitar  ese link ya no me accede  a http://claro:8080/pentaho/  y me da este error

Estado HTTP 404 -

type Informe de estado

mensaje

descripción El recurso requerido () no está disponible.

Apache Tomcat/6.0.29

adjunto el log  completo q me sale  cuando creo un nuevo analisis y sale vacio

Archivos adjuntos
Permalink Responder para Mariano García Mattío el enero 19, 2012 a las 2:10pm

Entonces no has configurado el repositorio en la otra base de datos. Me parece que te hace falta realizar lecturas un poco más avanzadas para seguir adelante, te recomiendo "Pentaho Solutions", si quieres salir andando un poco más rápido, aunque sin comprender mucho lo que haces puedes seguir alguna de las guías de Prashant Raju.

RSS

Distintivo

Cargando…

Obtener distintivo

© 2012   Creado por Emilio.   Tecnología de

Emblemas  |  Reportar un problema  |  Términos de servicio

Iniciar sesión en el chat