Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
Hi, During installation of Windchill PDMlink 10.1 M040 with Oracle 11g R2, it is failing with error message "Windchill loader failed'. Can any one support on this issue.
Solved! Go to Solution.
When I saw this on a DEV machine, it was down to a memory issue durnig teh load process. Basically Oracle was trying to use too much memory.
I resolved by limiting the memory targets on oracle to suit the machine.
Are you installing all the component or you are just installing any additional component over an existing installation ?
Hi ,
You have a problem in loading data into the database. There is a problem with your Oracle Installation.
Please exit the installation. Uninstall oracle properly (IMP : DONT DELETE THE APP FOLDER DIRECTLY) and then try again , Install oracle again with the correct settings.
Reply if you want to have a document with the correct Oracle installation procedure.
Procedure for Un-Installing Oracle :-
Instructions
Hope this helps!
Regards
Ishaan Nayyar
Can you pleasing send me the document for oracle installation.
Open a new thread this information as it is unrelated to this thread.
It is all covered in the installation guide.
Hi Ravi,
It will be good if you can share the logs. Apart from the information requested by Kaushik, can you specify at what stage the installer failed. If ALL components installed successfully then you can probably try loading the data manually. You can refer the Windchill Install and Config guide for more details.
Regards
~Syed
I'm installing only PDMLink with creo view, thumbnail generator and RFS support checked.
I have attached the snapshot. It throws after install all including thumbnail generator. At the stage of loading data to oracle but I'm sure there are no issues with oracle installation. It just went smooth and with default settings. No customization at all. I had installed successfully before.
For oracle uninstallation, i used deinstall and rebooted. Later deleted the the oracle folder remains.
I can uncheck and try the installation but help with the procedure / commands on how to load demo data.
One more doubt is there any version compatibility issue between windchill and oracle. Windchill is 10.1 M040
and oracle is 11g.
Do you need ocu installer log file.
Log a case with PTC Tech Support.
You can manually load windchill schema by executing sql script.
For Oracle 11.2.0.3 or higher patchsets in the 11.2.0.x series is supported. as for manual data load here are the commands
Database Schema (For Non Multi-byte install)
windchill --java=%JAVA_HOME%/bin/java.exe --javaargs=" -Dwt.tools.sql.autoCommit=true -Dwt.tools.sql.verbose=6 -Dwt.tools.sql.dbUser=<username> -Dwt.tools.sql.dbPassword=<password>"
wt.tools.sql.SQLCommandTool %WT_HOME%/db/sql/pdml/DDLBasic/Make_module_DDLBasic.sql
To load data run the following command:
windchill wt.load.WindchillLoader -Application=Windchill.PDMLink -Unattended -AbortOnError
Have you checked the logs under Windchill directory for any loader errors.
Hope that helps
Regards
~Syed
Here is a article https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS45319&posno=1&q=data%20loading%20manually&nav= about manually data loading.
The Windchill Loader is a PTC application to load Base data and Demo data into windchill. Base data are types, object initialization rules, and so on. Demo data are examples such as the Golf Cart product and part structure. It is unlikely to be an oracle problem.
The way to investigate is to review the Method Server logs for exceptions related to the Windchill Loader. Then you might need to open a case with customer support.
When I saw this on a DEV machine, it was down to a memory issue durnig teh load process. Basically Oracle was trying to use too much memory.
I resolved by limiting the memory targets on oracle to suit the machine.
succedded. correct Simon, it is becasue of lack of memory which application needs during loading schema / demo data. I could able to complete installation successfully by increasing the memory capacity.
Thanks for all of you for suggestions and supported me to fix this issue.
Thanks a lot.