Article - CS353989

Migration from Oracle to SQL Server claims that "Invalid Password" in Windchill PDMLink 12

Modified: 29-Mar-2024   


Applies To

  • Windchill PDMLink 12.0 to 12.1

Description

  • Despite typing correct password during migration from Oracle to SQL Server Windchill Database Migration Tool has error 
Invalid Password
  • DB_Migration.log reads:
- INFO  Oracle_SQLServer_Dynamic_Mig.ui.MainForm.checkORAPassword():360 - Checking Oracle password ...
- ERROR Oracle_SQLServer_Dynamic_Mig.DataSource.checkOraConnection():172 - System.Data.OleDb.OleDbException (0x80004005): ORA-28759: failure to open file
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Oracle_SQLServer_Dynamic_Mig.DataSource.checkOraConnection() in n:\SQLMigration\modules\O2S\src_native\Oracle_SQLServer_Dynamic_Mig\database\DataSource.cs:line 172
- ERROR Oracle_SQLServer_Dynamic_Mig.DataSource.checkOraConnection():172 - Connection 'Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = <hostname>)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = wind)));User ID=<dbuser>;Password=<password>;Provider=OraOLEDB.Oracle.1;Connection Timeout=120;' Failed.
- Error: ORA-28759: failure to open file

 
This is a printer-friendly version of Article 353989 and may be out of date. For the latest version click CS353989