Error on Lum IV Migration
Wed, 2008-03-12 17:00 — ksmith8
I am trying to migrate data from Lum III.3.3 to Lum IV and hit an error. When I run the migration script to import data into Lum IV, it tries to connect to the database on port 1521. I have verified in all the configs I can find that the port is 1522. When the migrator calls Import_GT... and creates the connection.properties temporary file, it outputs 1521 as the port. Is this a default that I missed somewhere? How can I force it to use 1522?
- ksmith8's blog
- Login or register to post comments
Hack Your Knowledge
Recent blog posts
- Help!! Luminis 4.1
- Portal for Prospects - facilitation of user accounts from Banner
- receiving error while installing on Solaris
- PermGen space on Windows
- Luminis IV integration with Lotus applications
- Anyone do a complete SunONE migration to Exchange?
- SAF: Is it required if using ILM and Active Directory
- Calendar Migration: SunOne to Exchange 2007
- IMAP on Luminis IV
- cptool list sessions via JSP
Developer Links
Poll
What is your estimated peak concurrent usage (sessions) on Luminis at your institution?
More than 2500
23%
Between 2000-2499
0%
Between 1500-1999
5%
Between 1200-1499
15%
Between 900-1199
5%
Between 500-899
23%
Fewer than 500
30%
Total votes: 40
- Login or register to post comments
- Older polls
Syndicate
Comments
luminis.database.port
Try configman -s luminis.database.port 1522 command to setup your database port. Our database is on a non-standard port. I defined the luminis.database.port parameter in install.conf file, and didn't have any problem during migration.
You can also try from you database side to change the listening port on 1521.
Steven
Working
I got it to work with a hint from gskinner. I was specifying too much in the import properties file. However, I hit yet another error. When importing the uportal rdb I got this:
INFO: Performing the uPortal Framed Tab migration....
ERROR The Sql Error Code is 1427
ERROR Exception while performing the uPortal Framed Tab migration.
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:961)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
at com.sct.pipeline.migration.rdb.MigrationRDBUtil.migrateFramedTabs(MigrationRDBUtil.java:1150)
at com.sct.pipeline.migration.rdb.Up_RdbHandler.main(Up_RdbHandler.java:565)
migrator encountered an error: operation ImportUP_RDB encountered an error
Any ideas?
Get the latest migration jar
You are running old migration code. Get the latest migration jar, script and config file which address a number of issues.