We have tried the migration script from SpagoBI to Knowage and we got an error and the script was unable to continue.
We think we are running it with highest user privilege. i.e. 'root' credentials and running as administrator.
Any ideas?
Logs below:
LOG: - SpagoBI2Knowage - Start migrating SpagoBI version 5.2.0, tenant SPAGOBI
LOG: - SpagoBI2Knowage - Connections done to SpagoBI and Knowage DB
LOG: - CheckDestinationIsEmptyJob - Export version valid: 5.2.0
LOG: - CheckDestinationIsEmptyJob - Checked destination schema is empty: go ahead
LOG: - SpagoBI2Knowage - Map initialized - do the associations
LOG: - AssociationsJob - Connections done
TALEND ERROR: - AssociationsJob - java.sql.SQLException:user lacks privilege or object not found: SBI_DOMAINS
TALEND ERROR: - SpagoBI2Knowage - java.lang.RuntimeException:Child job running failed.
java.sql.SQLException: user lacks privilege or object not found: SBI_DOMAINS
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
at local_project.associationsjob_0_1.AssociationsJob.tJDBCInput_1Process(AssociationsJob.java:2992)
at local_project.associationsjob_0_1.AssociationsJob.tJDBCInput_2Process(AssociationsJob.java:20853)
at local_project.associationsjob_0_1.AssociationsJob.tWarn_1Process(AssociationsJob.java:24577)
at local_project.associationsjob_0_1.AssociationsJob.tJDBCConnection_4Process(AssociationsJob.java:24386)
at local_project.associationsjob_0_1.AssociationsJob.tJDBCConnection_3Process(AssociationsJob.java:23998)
at local_project.associationsjob_0_1.AssociationsJob.tPrejob_1Process(AssociationsJob.java:23795)
at local_project.associationsjob_0_1.AssociationsJob.runJobInTOS(AssociationsJob.java:28859)
at local_project.associationsjob_0_1.AssociationsJob.runJob(AssociationsJob.java:28518)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tRunJob_1Process(SpagoBI2Knowage.java:5548)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tWarn_1Process(SpagoBI2Knowage.java:5239)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tJava_1Process(SpagoBI2Knowage.java:5079)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tRunJob_11Process(SpagoBI2Knowage.java:4893)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tWarn_2Process(SpagoBI2Knowage.java:4520)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tJDBCConnection_2Process(SpagoBI2Knowage.java:4360)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tJDBCConnection_1Process(SpagoBI2Knowage.java:4162)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tWarn_13Process(SpagoBI2Knowage.java:3986)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tJava_3Process(SpagoBI2Knowage.java:3812)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tFileInputProperties_1Process(SpagoBI2Knowage.java:3621)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tFileExist_1Process(SpagoBI2Knowage.java:2712)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tJava_2Process(SpagoBI2Knowage.java:2531)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tLibraryLoad_4Process(SpagoBI2Knowage.java:2363)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tLibraryLoad_3Process(SpagoBI2Knowage.java:2182)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tLibraryLoad_2Process(SpagoBI2Knowage.java:2001)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tLibraryLoad_1Process(SpagoBI2Knowage.java:1820)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.tPrejob_1Process(SpagoBI2Knowage.java:1631)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.runJobInTOS(SpagoBI2Knowage.java:14934)
at local_project.spagobi2knowage_0_1.SpagoBI2Knowage.main(SpagoBI2Knowage.java:14579)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: SBI_DOMAINS
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getTable(Unknown Source)
at org.hsqldb.ParserDQL.readTableName(Unknown Source)
at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 29 more
EXECUTION FAILED
