https://ptc.com/appserver/cs/view/call.jsp?n=5296073

Description When running "ildataloader Link 2", customer get the error output below. ORA-01652: unable to extend temp segment by 128 in tablespace TEMP 
Resolution Recommended to use "autoextend on" for all data and temp tables in Pro/INTRALINK and PDMLink during migration. 

Advanced Search Country / Region United States | Log out 
Products
 Pro/ENGINEER
 Windchill
 Arbortext
 All ProductsSolutions
 Product Development Solutions
 Industry Solutions
 Global Product Development
 Small & Medium Business MCAD
 Small & Medium Business Product DevelopmentServices & Training
 Implementation Services
 Consulting Services
 Training Services
 Product Development System Adoption ServicesCustomer Resources
 PTC.com Accounts
 E-mail Newsletters
 Free Downloads
 Product Promotions
 Tools & Tutorials
 PTC PLM On Demand
 Images & AwardsPartners
 Resellers
 Find A Partner
 For Our Partners
 Partner PortalsAbout PTC
 Career Opportunities
 Customer Successes
 Contact Us
 Education Program
 Events
 Executive Team
 Investor Relations
 NewsSupport
 Technical Support
 Order and License Support
 Platform Support
 Customer Care
 Global Maintenance Support
 Business Asset Summary Tool 
Home » Support 
Support
 E-mail this page 
 Print version  
Customer Information
Company Name LINCOLN FOODSERVICE PRODUCTS INCORPORATED 
Customer Number 108756 


Call Details
Note: It may take a few minutes for recent changes to be visible. Refresh Data 

Number 5296073 
Status Closed  
Priority Critical 
Change call priority  
Escalation Status Not Available 
Escalate this call  
ITAR No 
Created Date 27-Jul-2006 
Last Updated 27-Jul-2006 
Closed Date 27-Jul-2006 
Call Type Technical Support 
Caller Name JETT, LAWRENCE (ljett@lincolnfp.com) 
Assignee Name PERCHENOK, ARKADIY  
Description When running "ildataloader Link 2", customer get the error output below. ORA-01652: unable to extend temp segment by 128 in tablespace TEMP 
Resolution Recommended to use "autoextend on" for all data and temp tables in Pro/INTRALINK and PDMLink during migration. 


Affected Products
Product Pro/INTRALINK Data Migrator 
Module Data Migration 
Release 8.0 
Datecode M020 


Workstation Keywords
Category Type Value 
HW- Software Web Browser - External IE 6.0 SP1 


Related Documents
Type Number Status Description 

None Available

 


Notes
To add a note to this call please use the following link. 
Add a new note 
Date Description 
27-Jul-2006 
Hello

When running "ildataloader Link 2", I get the error output below.

Start migrating-
com.ptc.migration.loadercontroller.DependencyController...

1468 INFO [main] IntralinkDictionary - Loading Dictionary ...
1875 INFO [main] IntralinkDictionary - Dictionary is loaded.
1875 INFO [main] IntralinkDictionary - Updating Virtual Tables ...
1875 INFO [main] IntralinkDictionary - Virtual Tables are updated.
1890 INFO [main] InitializeHelper - Source is Pro/INTRALINK 3.3
Target is PDMLink 8.0.
1890 INFO [main] InitializeHelper - Source and target versions are 
compatible
for migration.
Introspection Runtime Mode = true
3515 INFO [main] MappingContextHelper - Found 23 LCTs.
3546 INFO [main] MappingContextHelper - Found 1 organizations.
3796 INFO [main] MappingContextHelper - The property 
migration.admin.contextDe
limiter is set to:.
4156 INFO [main] MigrationIBALoader - verOrgName:TestOrganizer
4171 INFO [main] MigrationIBALoader - nonverOrgName:TestOrganizer
4171 INFO [main] MigrationIBALoader - depOrgName:TestOrganizer
4937 INFO [main] InitializeHelper - Finished initializing:3 seconds.
6468 INFO [main] JdbcHelper - 55531 Rows Inserted in 1 seconds in 
PIToWCStatus

9046 INFO [main] JdbcHelper - 107439 Rows Inserted in 2 seconds in 
PIVToWCStat
us
9250 INFO [main] JdbcHelper - 0 Rows Inserted in 0 seconds in 
DepToWCStatus
355154 ERROR [main] MigrationException -
com.ptc.migration.util.MigrationException: wrapped Exception
Nested exception is:
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 
in tables
pace TEMP


        at oracle.jdbc.dbaccess.DBError.throwSqlException

(DBError.java:134)

        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
        at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery

(OracleStatement.jav
a:2400)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout

(OracleStateme
nt.java:2672)

        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate

(OraclePrepar
edStatement.java:589)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery

(OraclePrepare
dStatement.java:527)

        at 

com.ptc.migration.loadercontroller.DependencyController.getDeps(Depen
dencyController.java:224)

        at 

com.ptc.migration.loadercontroller.DependencyController.extractILData
ForOneThread(DependencyController.java:103)

        at 

com.ptc.migration.base.ILBasicController.fireOneThreadIfNeeded(ILBasi
cController.java:216)

        at com.ptc.migration.base.ILBasicController.fireThreads

(ILBasicControlle
r.java:237)

        at com.ptc.migration.base.ILBasicController.run

(ILBasicController.java:1
83)

        at com.ptc.migration.base.ILBasicController.controllerRun

(ILBasicControl
ler.java:165)

        at com.ptc.migration.base.ILBasicController.controllerMain

(ILBasicContro
ller.java:111)

        at com.ptc.migration.loadercontroller.DependencyController.main

(Dependen
cyController.java:89)
355216 ERROR [main] ILBasicController -
com.ptc.migration.util.MigrationException: wrapped Exception
Nested exception is:
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 
in tables
pace TEMP

====

at end:

355919 INFO [main] ILBasicController - Migration takes 350 seconds.
355919 INFO [main] ILBasicController - There were problems. 
Run "MigrationStatu
s -report" for more details.
355919 INFO [main] ILBasicController - Some objects are not migrated.
Done!

I then ran as they suggested:

D:\wt\ILMigration\bin>MigrationStatus -report
'MigrationStatus' is not recognized as an internal or external command,
operable program or batch file.

I did a search for "MigrationStatus" & found nothing.

=================

There were no reports in the std error reporting folder:

D:\wt\ILMigration\loadXMLFiles\ilwcmigration\reports

Thank You
Lawrence Jett
260-459-8212
SCN: 2a125869
Lincoln FP

-----------------------------------------------------------
 


File Upload Summary
To add data to this call please use the following links based on file size. 
Files up to 10 MB 
Files greater than 10 MB 
Date Name Size (bytes) Description 

None Available

 
 

Products | Solutions | Services & Training | Customer Resources | Partners | About PTC | Support
Contact Us | Search & Site Guide | Legal Policies & Guidelines | 

Copyright © 2006 Parametric Technology Corporation
 
