3030127 - Error During Check in: Query While Activating the Add-On Solution

You are getting below errors when you try to Activate/Check/Assemble the solution in SDK

Error During Check in: Query

Runtime objects are not up to date. Please activate the item XYZ-SelectAll.qry, where XYZ is the query file path

There is an error in query XYZ-SelectAll.qry.

SAP Cloud Application Studio

1. Login to SDK
2. Open the relevant Solution and File path
3. Right click and select Check
4. Error appears

or

1. Right click on the solution
2. Check-> All Items and Runtime Objects
3. Error appears

or

JSON communication error.HHTP response code: 504(Gateway Time-out)

This error is due to the naming convention of the query file. The query file is created with the name SelectAll. Select All is a standard query and is not supposed to use in custom developments as a new file.

Note: This is the scenario with all the standard actions, events or queries. The names are reserved for standard use or reuse as it is.

You need to follow the below steps to resolve this issue:-

1. First you should remove all the references where the query file is being used in the solution.
2. Delete the query file.
3. Activate the BO.
4. Re-create query file with different name other than the standard query names.

Error in query;wrong naming convention;inactive query;referenced query;JSON communication error;HHTP response code: 504(Gateway Time-out) , KBA , query error , query/view is not active , dump due to query , AP-RC-BDS-QRY , ByDesign Studio BO Queries , BC-SRV-FSI , Fast Search Infrastructure , Problem

SAP Business ByDesign all versions ; SAP Cloud Applications Studio all versions ; SAP Cloud for Customer add-ins all versions