eazyBI 4.2 ORA-01861: literal does not match format string

Question

Here is the log. I tried to import with a custom date field and it failed. When I removed the custom date field, it went through properly.

2017-01-31 22:40:13 -0500 ERROR: [regular_import] Dwh.update failed: UPDATE "#5_JIRA_ISSUES" SET "ID" = 18739, "PROJECT_KEY" = 'GJI', "PROJECT_NAME" = 'GDC JIRA Initiative', "CREATED_AT" = '2016-10-20 23:23:53', "UPDATED_AT" = '2017-01-16 01:04:37', "UPDATED_AT_UTC" = TO_DATE('2017-01-16 06:04:37','YYYY-MM-DD HH24:MI:SS'), "RESOLVED_AT" = NULL, "CLOSED_AT" = NULL, "STATUS_UPDATED_AT" = '2016-10-20 23:23:53', "DUE_DATE" = NULL, "AGE_TS" = 1477020233, "RESOLUTION_SECONDS" = NULL, "REPORTER_NAME" = 'mm186146', "ASSIGNEE_NAME" = NULL, "ISSUE_TYPE_ID" = 2, "PRIORITY_ID" = 3, "STATUS_ID" = 1, "RESOLUTION_ID" = -1, "SECURITY_LEVEL_ID" = -1, "PARENT_ISSUE_KEY" = NULL, "UPDATED" = 1, "ISSUE_SUMMARY" = 'GJI-44 Create a workflow for SCB Staffing', "SUBTASK_PARENT_KEY" = 'GJI-44', "SUBTASK_PARENT_ID" = 18739, "SUBTASK_KEY" = NULL, "EPIC_PARENT_KEY" = 'GJI-44', "CUSTOMFIELD_10501" = 'Albert Marqueses', "CUSTOMFIELD_10503" = 'SCB', "CUSTOMFIELD_10155" = 'The objective is to provide all the stakeholders a view of the onboarding status of an individual, a team or an RR#', "CUSTOMFIELD_10500" = 'Manila', "CUSTOMFIELD_10502" = '2016-12-30T00:00:00.000-0500', "CUSTOMFIELD_10505" = '2016-12-30T00:00:00.000-0500', "CUSTOMFIELD_10504" = 7.0 WHERE "ISSUE_KEY" = 'GJI-44'

2017-01-31 22:40:13 -0500 ERROR: [regular_import] account 5 : Java::JavaSql::SQLDataException: ORA-01861: literal does not match format string

2017-01-31 22:40:13 -0500 ERROR:

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:445)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4CTTIoer.processError(oracle/jdbc/driver/T4CTTIoer.java:396)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4C8Oall.processError(oracle/jdbc/driver/T4C8Oall.java:879)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4CTTIfun.receive(oracle/jdbc/driver/T4CTTIfun.java:450)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4CTTIfun.doRPC(oracle/jdbc/driver/T4CTTIfun.java:192)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4C8Oall.doOALL(oracle/jdbc/driver/T4C8Oall.java:531)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4CPreparedStatement.doOall8(oracle/jdbc/driver/T4CPreparedStatement.java:207)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.T4CPreparedStatement.executeForRows(oracle/jdbc/driver/T4CPreparedStatement.java:1044)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(oracle/jdbc/driver/OracleStatement.java:1329)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.OraclePreparedStatement.executeInternal(oracle/jdbc/driver/OraclePreparedStatement.java:3584)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(oracle/jdbc/driver/OraclePreparedStatement.java:3665)

2017-01-31 22:40:13 -0500 ERROR:         from oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(oracle/jdbc/driver/OraclePreparedStatementWrapper.java:1352)

2017-01-31 22:40:13 -0500 ERROR:         from java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)

2017-01-31 22:40:13 -0500 ERROR:         from ActiveRecord::ConnectionAdapters::OracleEnhancedJDBCConnection::Cursor.exec_update(/appl1/jira_data/plugins/.osgi-plugins/felix/felix-cache/bundle209/version0.0/plugin.4919743343714716811.eazybi-jira-4.2.0_1485843934000.jar-lib/0/META-INF/gem.home/gems/activerecord-oracle_enhanced-adapter-1.4.2/lib/active_record/connection_adapters/oracle_enhanced_jdbc_connection.rb:362)

2017-01-31 22:40:13 -0500 ERROR:         from ActiveRecord::ConnectionAdapters::OracleEnhancedAdapter.exec_update(/appl1/jira_data/plugins/.osgi-plugins/felix/felix-cache/bundle209/version0.0/plugin.4919743343714716811.eazybi-jira-4.2.0_1485843934000.jar-lib/0/META-INF/gem.home/gems/activerecord-oracle_enhanced-adapter-1.4.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:753)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.config.initializers.jdbc.__ensure__(vendor/gems/eazybi/config/initializers/jdbc.rb:51)

2017-01-31 22:40:13 -0500 ERROR:         from ActiveRecord::ConnectionAdapters::OracleEnhancedAdapter.exec_update(/appl1/jira_data/plugins/.osgi-plugins/felix/felix-cache/bundle209/version0.0/plugin.4919743343714716811.eazybi-jira-4.2.0_1485843934000.jar-lib/0/META-INF/gem.home/gems/activerecord-oracle_enhanced-adapter-1.4.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:735)

2017-01-31 22:40:13 -0500 ERROR:         from ActiveRecord::ConnectionAdapters::DatabaseStatements.update(/appl1/jira_data/plugins/.osgi-plugins/felix/felix-cache/bundle209/version0.0/plugin.4919743343714716811.eazybi-jira-4.2.0_1485843934000.jar-lib/0/META-INF/gem.home/gems/activerecord-3.2.18/lib/active_record/connection_adapters/abstract/database_statements.rb:96)

2017-01-31 22:40:13 -0500 ERROR:         from ActiveRecord::ConnectionAdapters::AbstractAdapter.update(/appl1/jira_data/plugins/.osgi-plugins/felix/felix-cache/bundle209/version0.0/plugin.4919743343714716811.eazybi-jira-4.2.0_1485843934000.jar-lib/0/META-INF/gem.home/gems/activerecord-3.2.18/lib/active_record/connection_adapters/abstract/query_cache.rb:19)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.dwh.update(vendor/gems/eazybi/app/models/dwh.rb:895)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.dimension_table.update(vendor/gems/eazybi/app/models/source_application/dimension_table.rb:99)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.dimension_table.upsert(vendor/gems/eazybi/app/models/source_application/dimension_table.rb:107)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.dimension_table.create_and_lookup_id_internal(vendor/gems/eazybi/app/models/source_application/dimension_table.rb:233)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.dimension_table.synchronize(vendor/gems/eazybi/app/models/source_application/dimension_table.rb:255)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.dimension_table.create_and_lookup_id_internal(vendor/gems/eazybi/app/models/source_application/dimension_table.rb:228)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.dimension_table.create_and_lookup_id_without_synchronize(vendor/gems/eazybi/app/models/source_application/dimension_table.rb:160)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.jira_application.issue_importer.get_issue_id(vendor/gems/eazybi/app/models/source_application/jira_application/issue_importer.rb:552)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.jira_application.issue_importer.import(vendor/gems/eazybi/app/models/source_application/jira_application/issue_importer.rb:51)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.jira_application.import_one_issue(vendor/gems/eazybi/app/models/source_application/jira_application.rb:1902)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.jira_application.get_and_import_issues(vendor/gems/eazybi/app/models/source_application/jira_application.rb:1784)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.base_application.with_dwh(vendor/gems/eazybi/app/models/source_application/base_application.rb:351)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.dwh.__ensure__(vendor/gems/eazybi/app/models/dwh.rb:111)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.base_application.with_dwh(vendor/gems/eazybi/app/models/source_application/base_application.rb:350)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.source_application.jira_application.get_and_import_issues(vendor/gems/eazybi/app/models/source_application/jira_application.rb:1783)

2017-01-31 22:40:13 -0500 ERROR:         from org.jruby.RubyProc.call(org/jruby/RubyProc.java:281)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.worker_pool.perform_work(vendor/gems/eazybi/app/models/worker_pool.rb:228)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.worker_pool.worker_loop(vendor/gems/eazybi/app/models/worker_pool.rb:198)

2017-01-31 22:40:13 -0500 ERROR:         from vendor.gems.eazybi.app.models.worker_pool.initialize_threads(vendor/gems/eazybi/app/models/worker_pool.rb:183)

2017-01-31 22:40:13 -0500 ERROR:         from java.lang.Thread.run(java/lang/Thread.java:745)

2017-01-31 22:40:14 -0500 INFO: [regular_import] *** done: SourceApplication id=5 perform_import()

2017-01-31 22:40:19 -0500 INFO: [application_import] account 8 : import_projects DM, GDCE

2017-01-31 22:40:19 -0500 INFO: [application_import] account 8 : import_all_components

2017-01-31 22:40:19 -0500 INFO: [application_import] account 8 : import_issues

2017-01-31 22:40:46 -0500 INFO: [application_import] account 8 : each_search_result (jira_search 0.859 sec, issue_as_json 9.603 sec, yield_issue 16.775 sec)

2017-01-31 22:40:52 -0500 INFO: [application_import] account 8 : import_issues imported 996 issues (33.164 sec)

2017-01-31 22:40:52 -0500 INFO: [application_import] account 8 : update_issue_subtask_keys

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : insert_issue_subtask_measures

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : insert_issue_subtask_measures updated 0 parent issues

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : delete_measures_without_dimension_value

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : delete_old_changelog_measures

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : update_status_categories

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : update_duplicate_security_level_names

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : update_duplicate_user_display_names

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : check_tempo_custom_fields_consistency

2017-01-31 22:40:53 -0500 INFO: [application_import] account 8 : gather_database_statistics

2017-01-31 22:41:01 -0500 INFO: [application_import] account 8 : Completed

2017-01-31 22:41:19 -0500 INFO: [application_import] *** done: SourceApplication id=8 perform_import()

ORA-01861: literal does not match format string

eazyBI Support · Answer

Hi,

Unfortunately, eazyBI version 4.2.0 has a bug related to date type custom fields.

Import will end with the error on ORACLE and MS SQL databases.

This week we are planning to release new eazyBI version with this issue fix included.

Best regards,

Janis