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

2 comments
Comment actions Permalink

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!"

0
Comment actions Permalink

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

0

Please sign in to leave a comment.