[java] INFO: Type match assertion disabled; set "checkTypes" to true to enable [java] INFO: Data export files will be read from 'data\dump\tran_man\' [java] INFO: Using 4 threads for import [java] 0 [main] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect [java] .\data\namespace\tran_man.p2o [java] 245 [main] INFO org.hibernate.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {4.0.1.Final} [java] 270 [main] INFO org.hibernate.Version - HHH000412: Hibernate Core {4.1.8.Final} [java] 275 [main] INFO org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found [java] 278 [main] INFO org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist [java] 387 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlCustomfilterImpl.hbm.xml [java] 678 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlGlossaryImpl.hbm.xml [java] 702 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlGlossdetImpl.hbm.xml [java] 724 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlInstanceImpl.hbm.xml [java] 748 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlInvalidImpl.hbm.xml [java] 759 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlKitImpl.hbm.xml [java] 776 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlKitProcImpl.hbm.xml [java] 793 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlLanguageImpl.hbm.xml [java] 809 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlProcedureImpl.hbm.xml [java] 825 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlProjectImpl.hbm.xml [java] 858 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlSelectedfilterImpl.hbm.xml [java] 875 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlStringInfoImpl.hbm.xml [java] 891 [main] INFO org.hibernate.cfg.Configuration - HHH000221: Reading mappings from resource: com/goldencode/testcases/dmo/tran_man/impl/XlTranslationImpl.hbm.xml [java] 1013 [main] INFO org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator - HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider [java] 1014 [main] INFO org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider - HHH010002: C3P0 using driver: org.h2.Driver at URL: jdbc:h2:C:\Progress\workspace\testcases/deploy/db/tran_man;MV_STORE=FALSE;LOG=0;CACHE_SIZE=65536;LOCK_MODE=0;UNDO_LOG=0 [java] 1014 [main] INFO org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider - HHH000046: Connection properties: {user=fwd_user, password=****} [java] 1015 [main] INFO org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider - HHH000006: Autocommit mode: false [java] SLF4J: Class path contains multiple SLF4J bindings. [java] SLF4J: Found binding in [jar:file:/C:/Progress/workspace/testcases/deploy/lib/slf4j-jdk14-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] [java] SLF4J: Found binding in [jar:file:/C:/Progress/workspace/testcases/deploy/lib/slf4j-simple-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] [java] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. [java] SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory] [java] Feb 21, 2020 1:44:00 PM com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log [java] INFO: MLog clients using slf4j logging. [java] Feb 21, 2020 1:44:01 PM com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log [java] INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10] [java] Feb 21, 2020 1:44:01 PM com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger log [java] INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@840564f1 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@1fcb6a17 [ acquireIncrement -> 8, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> 2rwcn5a8sqg4xac130i0|73302995, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 24, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 8, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@6c9bd181 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 2rwcn5a8sqg4xac130i0|6d026701, jdbcUrl -> jdbc:h2:C:\Progress\workspace\testcases/deploy/db/tran_man;MV_STORE=FALSE;LOG=0;CACHE_SIZE=65536;LOCK_MODE=0;UNDO_LOG=0, properties -> {user=******, password=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 2rwcn5a8sqg4xac130i0|345f69f3, numHelperThreads -> 3 ] [java] Feb 21, 2020 1:44:01 PM com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger log [java] WARNING: Bad pool size config, start 3 < min 8. Using 8 as start. [java] 2836 [main] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect [java] 2858 [main] INFO org.hibernate.engine.transaction.internal.TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC transactions) [java] 2862 [main] INFO org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory [java] 2863 [main] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JH2Dialect [java] 2918 [main] INFO org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory [java] IMPORT ORDER: [java] 1) XlGlossdetImpl:421512.0 [210756 bytes] [java] 2) XlCustomfilterImpl:6398.0 [3199 bytes] [java] 3) XlSelectedfilterImpl:4468.0 [2234 bytes] [java] 4) XlTranslationImpl:3632.0 [1816 bytes] [java] 5) XlInstanceImpl:2450.0 [1225 bytes] [java] 6) XlStringInfoImpl:1338.0 [669 bytes] [java] 7) XlProjectImpl:884.0 [442 bytes] [java] 8) XlKitProcImpl:718.0 [359 bytes] [java] 9) XlProcedureImpl:648.0 [324 bytes] [java] 10) XlKitImpl:584.0 [292 bytes] [java] 11) XlGlossaryImpl:578.0 [289 bytes] [java] 12) XlInvalidImpl:454.0 [227 bytes] [java] 13) XlLanguageImpl:440.0 [220 bytes] [java] BEGIN xl_translation (xl_tran.d) [java] BEGIN xl_selectedfilter (xl_sel.d) [java] BEGIN xl_customfilter (xl_cust.d) [java] BEGIN xl_glossdet (xl_glsdt.d) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_translation_seq_inst [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_customfilter_rectype_filter [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_glossdet_glossnamesrctarg [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_selectedfilter_mode_item_stmnt [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_customfilter_filteridx [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_selectedfilter_statementidx [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_translation_languageidx [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_translation_seq_lang [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_translation_seq_inst on xl_translation (sequence_num, instance_num, __ilang_name) [java] Unable to read PSC footer. Using defaults. [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_translation_languageidx on xl_translation (__ilang_name, id) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_customfilter_rectype_filter on xl_customfilter (__irectype, __ifilter, id) [java] END xl_selectedfilter; 80 records imported [java] 1.00607% complete: 80 recs in 0:00:00.972 (82/sec, 4938/min, 296296/hr) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_selectedfilter_mode_item_stmnt on xl_selectedfilter (__imode, __istatement, id) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_selectedfilter_statementidx on xl_selectedfilter (__istatement, __iitem, id) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_translation_seq_lang on xl_translation (sequence_num, __ilang_name, id) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_instance_needscomp [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_instance_instance_num [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_instance_last_pop [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_customfilter_filteridx on xl_customfilter (__ifilter, id) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_string_info_string_key [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_instance_old_inst_of_proc [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_project_namerevision [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_string_info_last_change [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_string_info_sequence_num [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_instance_sequenceinst [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_project_namerevision on xl_project (__iprojectname, __iprojectrevision) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_string_info_sequence_num on xl_string_info (sequence_num) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_instance_instance_num on xl_instance (instance_num) [java] Unable to read PSC footer. Using defaults. [java] BEGIN xl_instance (xl_inst.d) [java] END xl_translation; 36 records imported [java] 1.82390% complete: 116 recs in 0:00:01.027 (112/sec, 6777/min, 406621/hr) [java] BEGIN xl_string_info (xl_str.d) [java] END xl_customfilter; 113 records imported [java] 3.26455% complete: 229 recs in 0:00:01.065 (215/sec, 12901/min, 774084/hr) [java] BEGIN xl_project (xl_proj.d) [java] END xl_project; 1 records imported [java] 3.46360% complete: 230 recs in 0:00:01.243 (185/sec, 11102/min, 666130/hr) [java] END xl_string_info; 10 records imported [java] 3.76488% complete: 240 recs in 0:00:01.284 (186/sec, 11214/min, 672897/hr) [java] BEGIN xl_kit_proc (xl_kit-p.d) [java] END xl_instance; 15 records imported [java] 4.31656% complete: 255 recs in 0:00:01.313 (194/sec, 11652/min, 699162/hr) [java] BEGIN xl_procedure (xl_proc.d) [java] END xl_kit_proc; 4 records imported [java] 4.47823% complete: 259 recs in 0:00:01.410 (183/sec, 11021/min, 661276/hr) [java] BEGIN xl_kit (xl_kit.d) [java] END xl_kit; 2 records imported [java] 4.60973% complete: 261 recs in 0:00:01.459 (178/sec, 10733/min, 644002/hr) [java] BEGIN xl_glossary (xl_glsry.d) [java] BEGIN xl_invalid (xl_inval.d) [java] END xl_procedure; 2 records imported [java] 4.75564% complete: 263 recs in 0:00:01.499 (175/sec, 10527/min, 631621/hr) [java] END xl_glossary; 2 records imported [java] 4.88579% complete: 265 recs in 0:00:01.518 (174/sec, 10474/min, 628458/hr) [java] BEGIN xl_language (xl_lang.d) [java] END xl_invalid; 2 records imported [java] 4.98802% complete: 267 recs in 0:00:01.539 (173/sec, 10409/min, 624561/hr) [java] END xl_language; 3 records imported [java] 5.08710% complete: 270 recs in 0:00:01.571 (171/sec, 10311/min, 618714/hr) [java] Unable to read PSC footer. Using defaults. [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_instance_sequenceinst on xl_instance (sequence_num, __iproc_name, justification, maxlength) [java] Feb 21, 2020 1:44:03 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_string_info_string_key on xl_string_info (__skeyofstring, id) [java] Unable to read PSC footer. Using defaults. [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_string_info_last_change on xl_string_info (last_change, id) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_instance_needscomp on xl_instance (needs_compile, __iproc_name, id) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_kit_proc_kit_file [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_instance_last_pop on xl_instance (sequence_num, last_change, id) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_kit_proc_file_kit [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_instance_old_inst_of_proc on xl_instance (__iproc_name, last_change, id) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_kit_proc_kit_file on xl_kit_proc (__ikitname, __ifilename, __idirectory) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_procedure_dir_file [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_procedure_procidx [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_kit_proc_file_kit on xl_kit_proc (__ifilename, __idirectory, __ikitname) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_kit_kitname [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_procedure_dir_file on xl_procedure (__idirectory, __ifilename) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_kit_kitname on xl_kit (__ikitname) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_procedure_procidx on xl_procedure (__ifilename, id) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_glossary_glossname [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_glossary_glossname on xl_glossary (__iglossaryname) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_invalid_glossnametrgt [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_invalid_glossnametrgt on xl_invalid (__iglossaryname, __itargetphrase) [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library dropIndex [java] INFO: SQL: drop index if exists idx__xl_language_lang_name [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create unique index idx__xl_language_lang_name on xl_language (__ilang_name) [java] Unable to read PSC footer. Using defaults. [java] Feb 21, 2020 1:44:04 PM com.goldencode.p2j.schema.ImportWorker$Library createIndex [java] INFO: SQL: create index idx__xl_glossdet_glossnamesrctarg on xl_glossdet (__iglossaryname, __ishortsrc, __ishorttarg, id) [java] END xl_glossdet; 2360 records imported [java] 100.00000% complete: 2630 recs in 0:00:01.842 (1427/sec, 85667/min, 5140065/hr) [java] Total records processed: 2630 in 0:00:01.839 (1430.125 records/sec) [java] Total sequences initialized: 0. [java] Reading merge DMO definitions... [java] Elapsed job time: 00:00:06.062