Table/View 'IS_USER_TASKS' does not exist

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: http://tech.forums.softwareag.com/techjforum/posts/list/34795.page

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

This table should be created by default during the installation.

What is your wM version? If you are on 10.1, install DC_10.1_Embedded_Fix7 and IS_10.1_Core_Fix8 and check.

Thanks M@he$h, will try this.

Hi M@he$h,

I can’t find the fixes for: install DC_10.1_Embedded_Fix7 and IS_10.1_Core_Fix8. When I ran the SoftwareAG Update Manager it shows me higher version numbers:

Database Configuration:
DC_10.1_DCC_Fix1
DC_10.1_DBS_Fix10
DC_10.1_EmbeddedDBS_Fix10

Integration Server:
Integration Server Core 10.1 Fix 10

After applying the fix, I boot up the service then ran the ABE build.
The error still persists…

Hi Freddie,

after applying the Fixes you will have to run the Database Configurator and migrate the database schema to the new versions.

UpdateManager will always show the latest fix number available, except you provide the “-showallFixes true” command line parameter.

Regards,
Holger

That’s weird! You must still be able to use the derby database tables OOTB instead of using an External DB. I have a 10.3 instance running on the embedded database and I can view IS_USER_TASKS table which is hosted on embedded database.

Can you re-run a fresh installation?