Solved

External table is not in the expected format

  • 11 April 2023
  • 6 replies
  • 99 views

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.

icon

Best answer by Thomas Lind 11 April 2023, 14:27

View original

6 replies

Userlevel 5
Badge +5

Hi Surendra

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

No, It’s a static perspective only 

Userlevel 5
Badge +5

Hi Surendra

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

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

Userlevel 5
Badge +5

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.

Userlevel 6
Badge +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