SAP Knowledge Base Article - Preview

3772226 - Stored procedure gem execution fails with error cannot locate the table 'ABXY' in region 'XY' - DIAO in SAP Incentive Management

Symptom

  • Pipeline fails in DIAO during stored procedure validation because BigQuery cannot locate the table 'ABXY' in region 'XY'.
  • Error message: googleapi: Error 400: Error validating procedure body: Query error: Not found: Table [project:dataset].ABXY was not found in location 'XY.


Read more...

Environment

  • SAP Sales Performance Management
  • SAP Incentive Management on Hyperscalers

Product

SAP Incentive Management all versions

Keywords

bigquery, prophecy, stored procedure, validation error, table not found, sc_pre_batch_log, error 400, googleapi, region mismatch, us-east4, dataset location, information_schema, missing table, procedure body validation , KBA , CEC-SAL-PROPH , Prophecy , CEC-SAL-COM , Incentive Management , CEC-SAL-COM-INT , Application Integration , CEC-SAL-COM-TITAN , SPM Titan Ref Architecture and Migration Incentive Mgmt , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.