Skip to main content
Solved

External table is not in the expected format


We have a project perspective called 'Reference' which contains ODX tables. When we are executing it through the execution package it is throwing an error 

 

but when we try executing manually it is executing successfully.

the file format which we are extracting is  XLSX.

 

can you please help us to resolve this issue.

Best answer by Thomas Lind

Hi Surendra

If you locate the excel data source, can you make sure it is set up like so in the Table Settings.

For Excel data sources you can get issues if it runs in more than one thread.

Let me know if this resolves the issue.

View original
Did this topic help you find an answer to your question?

6 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1037 replies
  • April 11, 2023

Hi Surendra

How is the perspective set up? Does it use dynamic references?


  • Author
  • Starter
  • 2 replies
  • April 11, 2023

No, It’s a static perspective only 


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1037 replies
  • April 11, 2023

Hi Surendra

Do you get the error if you manually start the package, not just the perspective?


  • Author
  • Starter
  • 2 replies
  • April 11, 2023

if I manually run the package also I am getting the error.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1037 replies
  • Answer
  • April 11, 2023

Hi Surendra

If you locate the excel data source, can you make sure it is set up like so in the Table Settings.

For Excel data sources you can get issues if it runs in more than one thread.

Let me know if this resolves the issue.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @Surendra did Thomas’ answer resolve your issue? If so can you please help us by marking it as best answer above. Please let us know if you have any follow up questions


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings