Error migrate to Oracle database
Hi there,
I am trying to migrate to Oracle database. However, when I run the migrateDB.bat, I always get the ETL_DATA_ELEMENTS error. Here is the error from the log file:
Using propeties file 'dbMigration.properties'.
Fri Jan 16 11:01:28 EST 2009 Connecting to the target database jdbc:oracle:thin:@lxnexdev1:1521:oradods1
Fri Jan 16 11:01:31 EST 2009 CLEARING TARGET DATABASE (
TABLES FOUND: (21)) [agent, agent_sources_version, build_checkout_rules, build_labels, build_revisions, build_type_vcs_change, comments, compiler_output, downloaded_artifacts, history, remember_me, server, server_property, stats, user_blocks, user_notification_events, user_property, user_roles, user_watch_type, users, vcs_changes]
Fri Jan 16 11:01:33 EST 2009 Initializing schema...
TABLES to be converted: (21) [[agent, agent_sources_version, build_checkout_rules, build_labels, build_revisions, build_type_vcs_change, comments, compiler_output, downloaded_artifacts, history, remember_me, server, server_property, stats, user_blocks, user_notification_events, user_property, user_roles, user_watch_type, users, vcs_changes]]
Fri Jan 16 11:01:42 EST 2009 Exporting D:\TeamCity\bin\export\targetSchema.sql
Fri Jan 16 11:01:42 EST 2009 Importing from D:\TeamCity\bin\export
Fri Jan 16 11:01:42 EST 2009 table : rows : progress
Fri Jan 16 11:01:43 EST 2009 agent : 1 : 100% Error importing data. Last processed row #2
Caused by: ETL_DATA_ELEMENTS
Can somebody help me out?
Thanks
Jack
Please sign in to leave a comment.
Hi!
Can you please provide additional information:
- TeamCity version/build number
- Oracle version
- content of the migration*.log files saved in the bin directory
Please clean the target database, add the following line into your dbMigration.properties file:
debug=true
then rerun the migration and provide the logs.
--
Best regards,
Yegor Yarko
Project Manager (TeamCity)
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"
Hi there,
I am using Oracle 10.2.0.3. Team city 4.0.
What I found is that whenever the source cvs has 1 record, it will be failed. I also tried to change the file encoding as well as the file format to windows/unix. It does not help. It must be a bug in the parser. Finally I tried to use RazorSql to dump HSQLDB into sql insert statement and load it using SQL Plus. It seems to work for now.
Another question, when I build the application using MSBuild, it hangs. It works for teamcity 3.1.2
Jack