I’m trying to create the Integration Server configuration assets using ABE, unfortunately, it’s giving a “Table/View ‘IS_USER_TASKS’ does not exist” error.
It seems like it’s trying to connect to IS Embedded database but it can’t find the table “IS_USER_TASKS” as stated in this thread: Invalid object name'IS_USER_TASKS' - webMethods - Software AG Tech Community & Forums
I’m about to create the table ‘IS_USER_TASKS’ inside the embedded database but I don’t know which port to use. I’m assuming it’s using derby client to connect to it (might need to use ij).
By the way, this is the whole error message I’m getting:
[java] [1/11/19 5:53 PM][MESSAGE] ispackage.ispackage: Starting to read packages config.
2019-01-11T17:53:44.9588235Z [java] [1/11/19 5:53 PM][MESSAGE] ispackage.ispackage: Starting to read package [config].
2019-01-11T17:53:44.9697388Z [java] [1/11/19 5:53 PM][MESSAGE] ispackage.ispackage: [config] is not an Integration Server package.
2019-01-11T17:53:44.9976894Z [java] [1/11/19 5:53 PM][MESSAGE] ispackage.ispackage: Completed all packages.
2019-01-11T17:53:44.9978633Z [java] [1/11/19 5:53 PM][SUCCESS] isproperty.isproperty: Successfully extracted 1 isproperty.
2019-01-11T17:53:44.9979451Z [java] [1/11/19 5:53 PM][SUCCESS] isgroup.isgroup: Successfully extracted 2 isgroup.
2019-01-11T17:53:44.9979889Z [java] [1/11/19 5:53 PM][SUCCESS] isacl.isacl: Successfully extracted 8 isacl.
2019-01-11T17:53:44.9980298Z [java] [1/11/19 5:53 PM][SUCCESS] isuser.isuser: Successfully extracted 2 isuser.
2019-01-11T17:53:44.9980942Z [java] [1/11/19 5:53 PM][ERROR] istask.istask: java.sql.SQLSyntaxErrorException: Table/View ‘IS_USER_TASKS’ does not exist. com.wm.app.b2b.server.deployer.DeployerException: java.sql.SQLSyntaxErrorException: Table/View ‘IS_USER_TASKS’ does not exist.
2019-01-11T17:53:44.9981556Z [java] at com.wm.app.b2b.server.deployer.processors.ScheduledTaskDeployerImpl.extract(ScheduledTaskDeployerImpl.java:101)
2019-01-11T17:53:44.9982000Z [java] at com.wm.app.b2b.server.deployer.processors.DeployerProcessor.extract(DeployerProcessor.java:384)
2019-01-11T17:53:44.9982434Z [java] at com.wm.app.b2b.server.deployer.SolutionAssembler.exportRuntimeAssets(SolutionAssembler.java:246)
2019-01-11T17:53:44.9982842Z [java] at com.wm.app.b2b.server.deployer.SolutionAssembler.export(SolutionAssembler.java:298)
2019-01-11T17:53:44.9983224Z [java] at com.wm.app.b2b.server.deployer.SolutionAssembler.main(SolutionAssembler.java:403)
2019-01-11T17:53:44.9983618Z [java] Caused by: java.sql.SQLSyntaxErrorException: Table/View ‘IS_USER_TASKS’ does not exist.
2019-01-11T17:53:44.9984008Z [java] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
2019-01-11T17:53:44.9984378Z [java] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
2019-01-11T17:53:44.9984770Z [java] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
2019-01-11T17:53:44.9985169Z [java] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
2019-01-11T17:53:44.9985883Z [java] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
2019-01-11T17:53:44.9986384Z [java] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
2019-01-11T17:53:44.9986760Z [java] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source)
2019-01-11T17:53:44.9987120Z [java] at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source)
2019-01-11T17:53:44.9987492Z [java] at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source)
2019-01-11T17:53:44.9987864Z [java] at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(Unknown Source)
2019-01-11T17:53:44.9988503Z [java] at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
2019-01-11T17:53:44.9988967Z [java] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
2019-01-11T17:53:44.9989418Z [java] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
2019-01-11T17:53:44.9989792Z [java] at com.wm.app.b2b.server.deployer.processors.ScheduledTaskDeployerImpl.getScheduledTasks(ScheduledTaskDeployerImpl.java:441)
2019-01-11T17:53:44.9990233Z [java] at com.wm.app.b2b.server.deployer.processors.ScheduledTaskDeployerImpl.extract(ScheduledTaskDeployerImpl.java:98)
2019-01-11T17:53:44.9990675Z [java] … 4 more
2019-01-11T17:53:44.9994871Z [java] Caused by: java.sql.SQLException: Table/View ‘IS_USER_TASKS’ does not exist.
2019-01-11T17:53:45.0001354Z [java] at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
2019-01-11T17:53:45.0007420Z [java] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
2019-01-11T17:53:45.0014068Z [java] … 19 more
2019-01-11T17:53:45.0020358Z [java] Caused by: ERROR 42X05: Table/View ‘IS_USER_TASKS’ does not exist.
2019-01-11T17:53:45.0077906Z [java] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
2019-01-11T17:53:45.0084255Z [java] at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
2019-01-11T17:53:45.0090508Z [java] at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
2019-01-11T17:53:45.0096838Z [java] at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
2019-01-11T17:53:45.0103133Z [java] at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
2019-01-11T17:53:45.0109180Z [java] at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
2019-01-11T17:53:45.0115190Z [java] at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
2019-01-11T17:53:45.0136940Z [java] at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
2019-01-11T17:53:45.0144956Z [java] at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
2019-01-11T17:53:45.0151370Z [java] at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
2019-01-11T17:53:45.0157722Z [java] at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
2019-01-11T17:53:45.0164048Z [java] … 13 more