Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

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

Marc Jason Mutuc
Marc Jason Mutuc
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
January 31, 2017

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

Answer
Watch
Like Be the first to like this
792 views

1 answer

0 votes
eazyBI Support
eazyBI Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
January 31, 2017

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

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events