Forum Discussion

Globalcitizen31's avatar
Globalcitizen31
Regular Visitor
3 years ago

Not able to run Table.Profile for oracle database tables. ErrorCode=-2147467259

Hello, 

 

I am connected to Oracle data source in the backend and trying to run Table.Profile(mytable) for some of the tables being imported. I am getting below error. I am able to run table.profile for all excel connected sources though.  

 

The interesting thing here is table.schema(mytable) runs perfectly well for any data source.

Can someone suggest what is the issue here and any possible solutions i can try out ?

 

DataSource.Error: Oracle: ORA-00904: "STDEV": invalid identifier
Details:
DataSourceKind=Oracle
DataSourcePath=j******:15**/**** [masked]
Message=ORA-00904: "STDEV": invalid identifier
ErrorCode=-2147467259

No RepliesBe the first to reply