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