#48 Delete script stops when a pseudo-column is used with local a database

[Anonymous]

when I want to create a delete script (export script is working fine) I get the appended error message.
Versions where I can reproduce it are 12.1.2 and 10.3.2. I have to use a local database.
Thanks in advance.

best
Frank

export "tmp\em-12-27-57-253.jm" com.ibm.db2.jcc.DB2Driver
jdbc:db2://cp15.gerling.com:5025/DB2A u31051 - "<password>" -jdbcjar "C:\Program
Files\DbVisualizer\jdbc\db2\db2jcc4.jar" -e
"C:\TEMP\Voss_2022_01_25_save_acct5.sql" -d
"C:\TEMP\Voss_2022_01_25_del_acct5.sql" -isolation-level 1 -UTF8 -upsert-only
-threads 4 -entities 50 -format SQL -schemamapping ACCT5=ACCT5
-source-schemamapping ACCT5=ACCT5 -deletion-schemamapping ACCT5=ACCT5 -scope
LOCAL_DATABASE -datamodel "C:\Users\031051.jailer\datamodel\Partner"</password>

Help Desk: https://sourceforge.net/p/jailer/discussion/
Mail: rwisser@users.sourceforge.net

Jailer 12.1.2

java.lang.IllegalArgumentException: Unsupported use of pseudo-columns in condition:
"(A.REGISTRATION_ID = B.REFERENZ_ID and A.STATUS_CD = B.STATUS_CD and A.MANDANT = B.MANDANT) and (B.$DISTANCE <= 2)"
(Table ACCT5.TBAA_AGREEMENT)

When generating delete-scripts, the pseudo-columns $DISTANCE and $IS_SUBJECT are currently not supported if the "working table scope" is "local database". It works with "global tables" or "temporary tables".
at net.sf.jailer.entitygraph.local.LocalEntityGraph.checkPseudoColumns(LocalEntityGraph.java:456)
at net.sf.jailer.entitygraph.local.LocalEntityGraph.removeAssociatedDestinations(LocalEntityGraph.java:1231)
at net.sf.jailer.subsetting.SubsettingEngine$16.run(SubsettingEngine.java:1982)
at net.sf.jailer.util.JobManager$JobRunner.run(JobManager.java:99)
at java.base/java.lang.Thread.run(Thread.java:834)

[Ralf Wisser]

I am sorry, but the combination

• create delete script
• use $DISTANCE
• and use "local database"
  is indeed - as mentioned in the error message - not supported. It was too difficult to implement unfortunately.

[Ralf Wisser]

If you can't use the schema you generate the scripts from, maybe you could use a dedicated schema for the working tables instead of a local database?

[Anonymous]

Thanks for your quick response. I'll try to use an extractionmodell without the $Distance or try to change the query.
Best
Frank