Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SAP BEx Query - Errors On Refresh

When refreshing a BEx query I'm notified that i have 107 errors but it appears that everything loaded.    When I click on View Errors the query editor window loads and I know have a new query...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    From the screenshots, it seems that you used the Keep Errors. Please go to the original query Production without clicking the View errors, in Applied Steps, find the step Keep Errors or select the steps one by one to see the results. Also you can try to use Remove Errors: Table.RemoveRowsWithErrors.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

From the screenshots, it seems that you used the Keep Errors. Please go to the original query Production without clicking the View errors, in Applied Steps, find the step Keep Errors or select the steps one by one to see the results. Also you can try to use Remove Errors: Table.RemoveRowsWithErrors.

 

Best Regards,
Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I'm closing this ticket. I can't recall what the issue was but this is no longer an issue. If I recall correctly I just added a few columns and then added 1 column at a time until I recieved the error in order to identify the column that was causing the issues. If memory servers me correctly there was bad data coming from the source. My applogies for letting this hang out there so long.