New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot create my demo MySQL problem #191

Closed
jfmonteil opened this Issue Sep 13, 2018 · 3 comments

Comments

Projects
None yet
2 participants
@jfmonteil

jfmonteil commented Sep 13, 2018

Looks like an issue capturing my Mysql DB driver

part.previous.log

@jfmonteil

This comment has been minimized.

jfmonteil commented Sep 13, 2018

The system does not find the mysql driver for Madrid_smart_city...

C:\Program Files\part>part capture -create demo-smart-city -env local -element "/public/SmartCity/" -username admin -password password -v
C:\Users\jmonteil.part\part.log
INFO : PART command: capture
TRACE: SNIFF: Found postgres driver class on classpath
TRACE: SNIFF: Found hsqldb driver class on classpath
INFO : Capturing to folder: C:\Program Files\part\demo-smart-city
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1931
INFO : - Downloading JDBC configuration for 'AgileBI'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/AgileBI
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/AgileBI HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1798
DEBUG: JDBC Driver Info. Alias: AgileBI, jdbcUrl: jdbc:monetdb://localhost:50006/pentaho-instaview, username is null? 'false', password is null?: 'false'
ERROR: Problem creating SQL Connection
java.sql.SQLException: No suitable driver found for jdbc:monetdb://localhost:50006/pentaho-instaview
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:250)
at org.pentaho.part.Part.main(Part.java:196)
INFO : - Downloading JDBC configuration for 'Audit'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Audit
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Audit HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1546
WARN : Cannot fetch full JDBC info for JNDI connection: 'Audit'. Skipping...
INFO : - Downloading JDBC configuration for 'BaselineDemo'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/BaselineDemo
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/BaselineDemo HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1556
DEBUG: JDBC Driver Info. Alias: BaselineDemo, jdbcUrl: jdbc:postgresql://localhost:5432/demos, username is null? 'false', password is null?: 'false'
sept. 13, 2018 4:19:00 PM org.postgresql.Driver connect
GRAVE: Connection error:
org.postgresql.util.PSQLException: La tentative de connexion a ÚchouÚ.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:250)
at org.pentaho.part.Part.main(Part.java:196)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:140)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:109)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:67)
at org.postgresql.core.PGStream.receiveChar(PGStream.java:288)
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:418)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
... 10 more

ERROR: Problem creating SQL Connection
org.postgresql.util.PSQLException: La tentative de connexion a ÚchouÚ.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:250)
at org.pentaho.part.Part.main(Part.java:196)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:140)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:109)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:67)
at org.postgresql.core.PGStream.receiveChar(PGStream.java:288)
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:418)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
... 10 more
INFO : - Downloading JDBC configuration for 'London Air'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/London%20Air
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/London%20Air HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1953
DEBUG: JDBC Driver Info. Alias: London Air, jdbcUrl: jdbc:postgresql://34.252.63.11:5432/londonair, username is null? 'false', password is null?: 'false'
INFO : - Downloading JDBC configuration for 'Madrid_smart_city'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Madrid_smart_city
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Madrid_smart_city HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 2254
DEBUG: JDBC Driver Info. Alias: Madrid_smart_city, jdbcUrl: jdbc:mysql://localhost:3306/telefonica, username is null? 'false', password is null?: 'false'
ERROR: Problem creating SQL Connection
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/telefonica
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:250)
at org.pentaho.part.Part.main(Part.java:196)
INFO : - Downloading JDBC configuration for 'Postgres'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Postgres
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Postgres HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1939
DEBUG: JDBC Driver Info. Alias: Postgres, jdbcUrl: jdbc:postgresql://localhost:5432/hibernate, username is null? 'false', password is null?: 'false'
INFO : - Downloading JDBC configuration for 'Postgres_demos'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Postgres_demos
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Postgres_demos HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1557
DEBUG: JDBC Driver Info. Alias: Postgres_demos, jdbcUrl: jdbc:postgresql://localhost:5432/demos, username is null? 'false', password is null?: 'false'
INFO : - Downloading JDBC configuration for 'SampleData'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/SampleData
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/SampleData HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1542
DEBUG: JDBC Driver Info. Alias: SampleData, jdbcUrl: jdbc:hsqldb:hsql://localhost:9001/SampleData, username is null? 'false', password is null?: 'false'
INFO : - Downloading JDBC configuration for 'Scrapbook'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Scrapbook
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/Scrapbook HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 2004
DEBUG: JDBC Driver Info. Alias: Scrapbook, jdbcUrl: jdbc:mysql://localhost:3306/Scrapbook, username is null? 'false', password is null?: 'false'
ERROR: Problem creating SQL Connection
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/Scrapbook
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:250)
at org.pentaho.part.Part.main(Part.java:196)
INFO : - Downloading JDBC configuration for 'live_logging_info'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/live_logging_info
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/live_logging_info HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1399
WARN : Cannot fetch full JDBC info for JNDI connection: 'live_logging_info'. Skipping...
INFO : - Downloading JDBC configuration for 'pentaho'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/pentaho
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/pentaho HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 2186
DEBUG: JDBC Driver Info. Alias: pentaho, jdbcUrl: jdbc:postgresql://localhost:5432/hibernate, username is null? 'false', password is null?: 'false'
INFO : - Downloading JDBC configuration for 'pentaho_operations_mart'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/pentaho_operations_mart
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/pentaho_operations_mart HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1578
WARN : Cannot fetch full JDBC info for JNDI connection: 'pentaho_operations_mart'. Skipping...
INFO : - Downloading JDBC configuration for 'postgres'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/postgres
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/jdbc/connection/postgres HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 1552
DEBUG: JDBC Driver Info. Alias: postgres, jdbcUrl: jdbc:postgresql://localhost:5432/demos, username is null? 'false', password is null?: 'false'
TRACE: Found JNDI JDBC element
DEBUG: JDBC Driver Info. Alias: Hibernate, jdbcUrl: jdbc:postgresql://localhost:5432/hibernate, username is null? 'false', password is null?: 'false'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: 665
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/ba-pom.xmi
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/ba-pom.xmi HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: -1
DEBUG: Discovered JDBC connection from Data Source Wizard XMI file: 'ba-pom.xmi' called: 'POM'
TRACE: DBType: org.dom4j.tree.DefaultAttribute@5fcd1f0a [Attribute: name value value "POSTGRESQL"], dbName: org.dom4j.tree.DefaultAttribute@7e64c1a9 [Attribute: name value value "PDI_Operations_Mart"], dbUsername: org.dom4j.tree.DefaultAttribute@7fda2001 [Attribute: name value value ""], dbPort: org.dom4j.tree.DefaultAttribute@162c1dfb [Attribute: name value value "5432"], dbHost: org.dom4j.tree.DefaultAttribute@21ae657b [Attribute: name value value "localhost"]
DEBUG: Found an embedded database connection within the XMI file: name: 'PDI_Operations_Mart', type: 'POSTGRESQL', host: 'localhost', port: '5432'
TRACE: No existing matching dependency, adding
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_FACT_SESSION'
DEBUG: - Translated virtual name to physical table name: 'fact_session'
TRACE: Looking for schema with connection name POM
TRACE: Creating new schema object for dbName POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_FACT_COMPONENT'
DEBUG: - Translated virtual name to physical table name: 'fact_component'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_COMPONENT'
DEBUG: - Translated virtual name to physical table name: 'dim_component'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_CONTENT_ITEM'
DEBUG: - Translated virtual name to physical table name: 'dim_content_item'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_DATE'
DEBUG: - Translated virtual name to physical table name: 'dim_date'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_SESSION'
DEBUG: - Translated virtual name to physical table name: 'dim_session'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_STATE'
DEBUG: - Translated virtual name to physical table name: 'dim_state'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_TIME'
DEBUG: - Translated virtual name to physical table name: 'dim_time'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_FACT_INSTANCE'
DEBUG: - Translated virtual name to physical table name: 'fact_instance'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_BATCH'
DEBUG: - Translated virtual name to physical table name: 'dim_batch'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: Discovered Table from Data XMI file: 'ba-pom.xmi' with virtual (Schema) table name: 'PT_DIM_INSTANCE'
DEBUG: - Translated virtual name to physical table name: 'dim_instance'
TRACE: Looking for schema with connection name POM
TRACE: Adding in XMI file configuration with name: 'ba-pom.xmi'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/steel-wheels.xmi
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/steel-wheels.xmi HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: -1
DEBUG: Discovered JDBC connection from Data Source Wizard XMI file: 'steel-wheels.xmi' called: 'SampleData'
TRACE: DBType: org.dom4j.tree.DefaultAttribute@1e466d [Attribute: name value value "HYPERSONIC"], dbName: org.dom4j.tree.DefaultAttribute@63243c8f [Attribute: name value value "SampleData"], dbUsername: org.dom4j.tree.DefaultAttribute@2ea4e762 [Attribute: name value value ""], dbPort: null, dbHost: org.dom4j.tree.DefaultAttribute@444c0f9a [Attribute: name value value "localhost"]
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_TRIAL_BALANCE'
DEBUG: - Translated virtual name to physical table name: 'TRIAL_BALANCE'
TRACE: Looking for schema with connection name SampleData
TRACE: Creating new schema object for dbName SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_TIME'
DEBUG: - Translated virtual name to physical table name: 'DIM_TIME'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_QUADRANT_ACTUALS'
DEBUG: - Translated virtual name to physical table name: 'QUADRANT_ACTUALS'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_PRODUCTS'
DEBUG: - Translated virtual name to physical table name: 'PRODUCTS'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_PAYMENTS'
DEBUG: - Translated virtual name to physical table name: 'PAYMENTS'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_ORDERS'
DEBUG: - Translated virtual name to physical table name: 'ORDERS'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_ORDERFACT'
DEBUG: - Translated virtual name to physical table name: 'ORDERFACT'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_ORDERDETAILS'
DEBUG: - Translated virtual name to physical table name: 'ORDERDETAILS'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_OFFICES'
DEBUG: - Translated virtual name to physical table name: 'OFFICES'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_EMPLOYEES'
DEBUG: - Translated virtual name to physical table name: 'EMPLOYEES'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_DEPARTMENT_MANAGERS'
DEBUG: - Translated virtual name to physical table name: 'DEPARTMENT_MANAGERS'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_CUSTOMER_W_TER'
DEBUG: - Translated virtual name to physical table name: 'CUSTOMER_W_TER'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: Discovered Table from Data XMI file: 'steel-wheels.xmi' with virtual (Schema) table name: 'PT_CUSTOMERS'
DEBUG: - Translated virtual name to physical table name: 'CUSTOMERS'
TRACE: Looking for schema with connection name SampleData
TRACE: Adding in XMI file configuration with name: 'steel-wheels.xmi'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/Air%20Quality%20Data.xmi
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/Air%20Quality%20Data.xmi HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: -1
DEBUG: Discovered JDBC connection from Data Source Wizard XMI file: 'Air Quality Data.xmi' called: 'postgres'
TRACE: DBType: org.dom4j.tree.DefaultAttribute@3b590f6a [Attribute: name value value "POSTGRESQL"], dbName: org.dom4j.tree.DefaultAttribute@1e160a9e [Attribute: name value value "hibernate"], dbUsername: org.dom4j.tree.DefaultAttribute@483ed60e [Attribute: name value value "pentaho_user"], dbPort: org.dom4j.tree.DefaultAttribute@9c5d76b [Attribute: name value value "5432"], dbHost: org.dom4j.tree.DefaultAttribute@7a14ab66 [Attribute: name value value "localhost"]
DEBUG: Found an embedded database connection within the XMI file: name: 'hibernate', type: 'POSTGRESQL', host: 'localhost', port: '5432'
TRACE: No existing matching dependency, adding
DEBUG: Discovered Table from Data XMI file: 'Air Quality Data.xmi' with virtual (Schema) table name: 'PT_AQD'
DEBUG: - Translated virtual name to physical table name: '"aqd"'
TRACE: Looking for schema with connection name postgres
TRACE: Creating new schema object for dbName postgres
TRACE: Adding in XMI file configuration with name: 'Air Quality Data.xmi'
DEBUG: Discovered Table from Data XMI file: 'Air Quality Data.xmi' with virtual (Schema) table name: 'PT_DAYS'
DEBUG: - Translated virtual name to physical table name: '"days"'
TRACE: Looking for schema with connection name postgres
TRACE: Adding in XMI file configuration with name: 'Air Quality Data.xmi'
DEBUG: Discovered Table from Data XMI file: 'Air Quality Data.xmi' with virtual (Schema) table name: 'PT_MONTHS'
DEBUG: - Translated virtual name to physical table name: '"months"'
TRACE: Looking for schema with connection name postgres
TRACE: Adding in XMI file configuration with name: 'Air Quality Data.xmi'
DEBUG: - GET url: http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/PDI_Operations_Mart.xmi
TRACE: executing request GET http://localhost:8080/pentaho/plugin/data-access/api/datasource/metadata/domain/PDI_Operations_Mart.xmi HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: -1
DEBUG: Discovered JDBC connection from Data Source Wizard XMI file: 'PDI_Operations_Mart.xmi' called: 'pentaho_operations_mart'
TRACE: DBType: org.dom4j.tree.DefaultAttribute@5bb1c104 [Attribute: name value value "POSTGRESQL"], dbName: org.dom4j.tree.DefaultAttribute@1184b542 [Attribute: name value value "pentaho_operations_mart"], dbUsername: org.dom4j.tree.DefaultAttribute@6bd5ca02 [Attribute: name value value ""], dbPort: org.dom4j.tree.DefaultAttribute@4758f533 [Attribute: name value value "5432"], dbHost: org.dom4j.tree.DefaultAttribute@12b4a53d [Attribute: name value value "localhost"]
DEBUG: Found an embedded database connection within the XMI file: name: 'pentaho_operations_mart', type: 'POSTGRESQL', host: 'localhost', port: '5432'
TRACE: No existing matching dependency, adding
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_FACT_EXECUTION'
DEBUG: - Translated virtual name to physical table name: 'fact_execution'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Creating new schema object for dbName pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_DIM_BATCH'
DEBUG: - Translated virtual name to physical table name: 'dim_batch'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_DIM_DATE'
DEBUG: - Translated virtual name to physical table name: 'dim_date'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_DIM_EXECUTION'
DEBUG: - Translated virtual name to physical table name: 'dim_execution'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_DIM_EXECUTOR'
DEBUG: - Translated virtual name to physical table name: 'dim_executor'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_DIM_TIME'
DEBUG: - Translated virtual name to physical table name: 'dim_time'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_FACT_JOBENTRY_EXECUTION'
DEBUG: - Translated virtual name to physical table name: 'fact_jobentry_execution'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_FACT_STEP_EXECUTION'
DEBUG: - Translated virtual name to physical table name: 'fact_step_execution'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_FACT_PERF_EXECUTION'
DEBUG: - Translated virtual name to physical table name: 'fact_perf_execution'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
DEBUG: Discovered Table from Data XMI file: 'PDI_Operations_Mart.xmi' with virtual (Schema) table name: 'PT_DIM_STEP'
DEBUG: - Translated virtual name to physical table name: 'dim_step'
TRACE: Looking for schema with connection name pentaho_operations_mart
TRACE: Adding in XMI file configuration with name: 'PDI_Operations_Mart.xmi'
TRACE: - XMI dependency: PDI_Operations_Mart
TRACE: - Found JDBC Data Source dependency
TRACE: - Adding dependency JDBC configuration from XMI to DB Util. Name: 'PDI_Operations_Mart'
DEBUG: JDBC Driver Info. Alias: PDI_Operations_Mart, jdbcUrl: jdbc:postgresql://localhost:5432/PDI_Operations_Mart, username is null? 'false', password is null?: 'false'
sept. 13, 2018 4:19:03 PM org.postgresql.Driver connect
GRAVE: Connection error:
org.postgresql.util.PSQLException: FATAL: aucun nom d'utilisateur PostgreSQL n'a ÚtÚ spÚcifiÚ dans le paquet de dÚmarrage (pgjdbc: autodetected server-encoding to be ISO-8859-1, if the message is not readable, please check database logs and/or host, port, dbname, user, password, pg_hba.conf)
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:297)
at org.pentaho.part.Part.main(Part.java:196)

ERROR: Problem creating SQL Connection
org.postgresql.util.PSQLException: FATAL: aucun nom d'utilisateur PostgreSQL n'a ÚtÚ spÚcifiÚ dans le paquet de dÚmarrage (pgjdbc: autodetected server-encoding to be ISO-8859-1, if the message is not readable, please check database logs and/or host, port, dbname, user, password, pg_hba.conf)
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:297)
at org.pentaho.part.Part.main(Part.java:196)
TRACE: - XMI dependency: SampleData
TRACE: - Found JDBC Data Source dependency
TRACE: - XMI dependency: hibernate
TRACE: - Found JDBC Data Source dependency
TRACE: - Adding dependency JDBC configuration from XMI to DB Util. Name: 'hibernate'
DEBUG: JDBC Driver Info. Alias: hibernate, jdbcUrl: jdbc:postgresql://localhost:5432/hibernate, username is null? 'false', password is null?: 'false'
TRACE: - XMI dependency: pentaho_operations_mart
TRACE: - Found JDBC Data Source dependency
TRACE: - Adding dependency JDBC configuration from XMI to DB Util. Name: 'pentaho_operations_mart'
DEBUG: JDBC Driver Info. Alias: pentaho_operations_mart, jdbcUrl: jdbc:postgresql://localhost:5432/pentaho_operations_mart, username is null? 'false', password is null?: 'false'
sept. 13, 2018 4:19:03 PM org.postgresql.Driver connect
GRAVE: Connection error:
org.postgresql.util.PSQLException: FATAL: aucun nom d'utilisateur PostgreSQL n'a ÚtÚ spÚcifiÚ dans le paquet de dÚmarrage (pgjdbc: autodetected server-encoding to be ISO-8859-1, if the message is not readable, please check database logs and/or host, port, dbname, user, password, pg_hba.conf)
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:297)
at org.pentaho.part.Part.main(Part.java:196)

ERROR: Problem creating SQL Connection
org.postgresql.util.PSQLException: FATAL: aucun nom d'utilisateur PostgreSQL n'a ÚtÚ spÚcifiÚ dans le paquet de dÚmarrage (pgjdbc: autodetected server-encoding to be ISO-8859-1, if the message is not readable, please check database logs and/or host, port, dbname, user, password, pg_hba.conf)
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.pentaho.part.utility.RDBMSUtility$DatabaseInfo.(RDBMSUtility.java:880)
at org.pentaho.part.utility.RDBMSUtility.addDatabase(RDBMSUtility.java:140)
at org.pentaho.part.commands.CaptureCommand.execute(CaptureCommand.java:297)
at org.pentaho.part.Part.main(Part.java:196)
DEBUG: Element: /public/SmartCity/
INFO : Downloading Repository element '/public/SmartCity/'
DEBUG: - GET url: http://localhost:8080/pentaho/api/repo/files/%3Apublic%3ASmartCity%3A/download?withManifest=false
TRACE: executing request GET http://localhost:8080/pentaho/api/repo/files/%3Apublic%3ASmartCity%3A/download?withManifest=false HTTP/1.1
TRACE: ----------------------------------------
TRACE: HTTP/1.1 200
TRACE: Response content length: -1
TRACE: Creating file: 'C:\Program Files\part\demo-smart-city.tmp\repository\public\SmartCity'
INFO : Finished initial specified element(s) download from the Enterprise Repository
TRACE: - Processing virtual path: '/public/SmartCity/', file: 'C:\Program Files\part\demo-smart-city.tmp\repository\public\SmartCity'
DEBUG: Checking for dependencies for element 'Dependency /public/SmartCity/ of type Repository sub type Data with temporary file C:\Program Files\part\demo-smart-city.tmp\repository\public\SmartCity'
TRACE: determineDependencies for dep nameOrPath: /public/SmartCity/
TRACE: tmpFile path: C:\Program Files\part\demo-smart-city.tmp\repository\public\SmartCity
DEBUG: Additional Dependencies currently:-
DEBUG: Dependencies:-
DEBUG: - /public/SmartCity/ [Repository:Data]
DEBUG: Additional Dependencies after converting mondrian schema to rdbms schema:-
DEBUG: Dependencies:-
DEBUG: - /public/SmartCity/ [Repository:Data]
DEBUG: NEW Additional Dependencies now:-
DEBUG: Dependencies:-
DEBUG: - /public/SmartCity/ [Repository:Data]
INFO : Dependencies found! Do you want to [V]iew, [R]eview and confirm, or auto [F]etch dependencies? Default [F]:
V
INFO : Viewing all dependencies first
DEBUG: Dependencies:-
DEBUG: - /public/SmartCity/ [Repository:Data]
INFO : Dependencies found! Do you want to [V]iew, [R]eview and confirm, or auto [F]etch dependencies? Default [F]:
F
INFO : Fetching all dependencies automatically
INFO : Adding JDBC Connection dependencies for found Table instances
INFO : Captured all elements and dependencies. Moving all items to target folder
DEBUG: Copying over Repository dependency '/public/SmartCity/' required by '[]'
TRACE: Copying src file: 'C:\Program Files\part\demo-smart-city.tmp\repository\public\SmartCity', to dest file: 'C:\Program Files\part\demo-smart-city\solution\repository\public\SmartCity'
DEBUG: - /public/SmartCity/ copied to destination folder
WARN : There are external dependencies that require manual installation on the target by the user. Read solution/external-dependencies-list.txt for details
WARN : Dependency GRANT select ON to pentaho_user for ALL tables that have Dashboard Prompts of type RDBMSSchema sub type Schema
WARN : Dependency pentaho_operations_mart of type DataSource sub type JDBC
WARN : Dependency live_logging_info of type DataSource sub type JDBC
WARN : Dependency Audit of type DataSource sub type JDBC
DEBUG: Cleaning up temporary files
INFO : capture successfully completed
INFO : capture completed in 24,122 seconds

@adamfowleruk

This comment has been minimized.

Contributor

adamfowleruk commented Sep 13, 2018

Likely a version number issue. read the /usr/local/part/part.sh file (or similar on your system). Ensure the myself JAR version number matches your system, and that the file exists in PENTAHO_HOME/server/pentaho-server/tomcat/lib/

Also check other issues mentioned here: https://github.com/Pentaho-SE-EMEA-APAC/part/blob/master/documentation/proc-add-other-db.md

@adamfowleruk

This comment has been minimized.

Contributor

adamfowleruk commented Sep 13, 2018

User reported fixed with correcting the version number as per documentation

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment