Six Stars

When I import excel for metadata facing system hanging problem

Hi Talend Folks,

                        I am facing system hanging problem. when I import 9 Mb excel for metadata. I cannot import large excel file in talend tool. What is the solution for system hanging problem.

I am using 8GB RAM 64bit

I also increased my Talend-Studio-win-x86_64.ini file

-vmargs
-Xms1024m
-Xmx4096m
-XX:MaxPermSize=512m
-Dfile.encoding=UTF-8
-Dosgi.requiredJavaVersion=1.8
-XX:+UseG1GC
-XX:+UseStringDeduplication

  • Sandbox
  • SDI
  • Talend Activity Monitoring Console
  • Talend Administration Center
  • Talend Artifact Repository
  • Talend Commandline
  • Talend Data Preparation
  • Talend Data Stewardship
  • Talend DQ Portal
  • Talend ESB
  • Talend Identify Management
  • Talend Installer
  • Talend Integration Cloud
  • Talend Job Server
  • Talend Log Server
  • Talend MDM Server
  • Talend MDM Web UI
  • Talend Metadata Manager
  • Talend Project Audit
  • Talend Remote Engine
  • Talend Repository Manager
  • Talend Runtime
  • Talend SAP RFC Server
  • Talend Studio
2 REPLIES
Moderator

Re: When I import excel for metadata facing system hanging problem

Hello,

What's the error message you are getting? Could you please indicate on which build version you got this issue?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: When I import excel for metadata facing system hanging problem

Hi Rajesh,

 

I had a similiar problem.

 

How many rows of data have you got in the excel sheet?

 

If it has got some VB script on the excel you may encounter this or anything other than data. 

 

If you could copy paste the whole content into the new sheet, save it and try using that file.

 

It should work.

 

Cheers!

Gatha