It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

1,099 views 7 0
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you