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

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::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 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 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::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::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 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.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.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.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.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.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_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.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.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.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.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.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.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.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.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 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.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.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 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

1 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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Monday in Jira Ops

Jira Ops Early Access Program Update #1: Announcing our next feature and a new integration

Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...

320 views 0 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you