Solution # 132067  
Type TPI 
Created Date 06-Feb-2006 
Last Updated 27-Jun-2007 
Title ildataloader DocResume failed. Message:"java.lang.NullPointerException at 
com.ptc.migration.util.InitializeHelper.getDBLinkName...." is received. 
Details Description
ildataloader DocResume failed. Message:"java.lang.NullPointerException at 
com.ptc.migration.util.InitializeHelper.getDBLinkName...." is received.

Resolution
Please follow the steps below and send the results:

1. On the Pro/INTRALINK 3.x dataserver machine run disable_il_for_migration 
to lock the intralink schema (if it is not already locked).

2. login to the dataserver using the command:

PROMPT> sqlplus pdm_migration/migchangeme (if you have changed the default 
"migchangeme" password yopu have to use the changed one)

3. Run the following queries and send results:

SQL> select * from user_db_links;

Find out the value for the column "db_link". 

SQL> select * from dual@value_of_db_link_column; 

(value_of_db_link_column is derived from the step above). 

4. Make sure you have not changed the name or the IP address of the Windchill 
and/or Pro/INTRALINK dataserver.

5. Check db.properties file in PDMLink server and make sure that the name of 
the server is NOT "localhost" but rather the real server name.

6. Check the pinging both ways of the PDMLink and Pro/INTRALINK machines. 
Make sure that the host names resolve to consistent IP addresses. For instance 
when pinging the PDMLink machine from itself by short host name, the returned 
IP address should match the IP address returned when pinging the PDMLink 
machine from the Pro/INTRALINK machine.

7. Make sure there are no firewalls enabled on both machines.

8. Make sure you have not run "cleanup mapping" and wiped out the dblink 
information from the target machine by running the following query:

PROMPT>sqlplus windchill_username/password
SQL> select dblinkname from migrationsite;

If you do not get any value that means you have cleaned up the mapping, in 
which case you should rerun the mapping again. 
Compare the result of this query with the value of db_link found on step 3 
above and make sure they are the same.

9. On the Pro/INTRALINK 3.x dataserver machine backup and edit the file 
<oracle_home>\network\admin\sqlnet.ora and change the value of 
SQLNET.AUTHENTICATION_SERVICES=(NTS)

to

SQLNET.AUTHENTICATION_SERVICES=(NONE)