Trying to migrate from SpagoBI 5.2 to Knowage and after a few trial and error runs, we think we hit an error that we cannot sort out with the following detailed log. Any ideas and appreciate any help. Thank you.
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
t 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
