1. Home
  2. Support
Article - CS100167

Data Extraction returns ORA-01017: invalid username/password; logon denied in Windchill Bulk Migrator

Modified: 18-Dec-2024   


Applies To

  • Windchill Bulk Migrator 2.1 to 12.1

Description

  • Data Extraction returns:
    • com.ptc.windchill.migration.wbm.wc2wc.util.WBMException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
  • Data extraction fails with error
com.ptc.windchill.migration.wbm.wc2wc.util.WBMException: java.lang.IllegalArgumentException: Null input buffer
        at com.ptc.windchill.migration.wbm.wc2wc.util.WBMExceptionHandler.throwException(WBMExceptionHandler.java:32)
        at com.ptc.windchill.migration.wbm.wc2wc.extractor.client.ExtractProperties.getStaging_DB_PW(ExtractProperties.j
ava:398)
        at com.ptc.windchill.migration.wbm.wc2wc.util.wbmutil.JDBCUtil.getWBMStagingConnectionNoAutoCommit(JDBCUtil.java
:163)
        at com.ptc.windchill.migration.wbm.wc2wc.extractor.ExtractHelper.getSequenceRange(ExtractHelper.java:320)
        at com.ptc.windchill.migration.wbm.wc2wc.extractor.client.WindchillDataExtractor.getSessionId(WindchillDataExtra
ctor.java:239)
        at com.ptc.windchill.migration.wbm.wc2wc.extractor.client.WindchillDataExtractor.main(WindchillDataExtractor.jav
a:70)
  • How to update data.extract.Target_Staging_DB_PW properties in <Windchillhome>\codebase\com\ptc\windchill\migration\wbm\wc2wc\extractor\extract.properties ?
  • Executing command windchill com.ptc.windchill.migration.wbm.wc2wc.mapping.client.WBMMappingClient -u username -p password fails with "ORA-01017: invalid username/password" error:
ERROR client.WBMMappingClient - Exception Occured
ERROR client.WBMMappingClient - (com.ptc.windchill.migration.wbm.wc2wc.mapping.server.WBMOrgMappingServerHelper/0) wt.util.WTException: Message: Resource bundl
e/Message key = com.ptc.windchill.migration.wbm.wc2wc.mapping.server.WBMOrgMappingServerHelper/0
Nested exception is: com.ptc.windchill.migration.wbm.wc2wc.util.WBMException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
This is a printer-friendly version of Article 100167 and may be out of date. For the latest version click CS100167