EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB287543: Error message appears when saving freeform SQL report after upgrade from version 9.4.1 to 10.1


Community Admin

• Strategy


SYMPTOM:
After the upgrade from Strategy 9.4.1 to Strategy 10.1, when saving a Freeform SQL report with a value prompt, the following error message appears:


Object with ID 'xxxxx' and type 15 (Table) is not found in the metadata. It may have been deleted

 
STEPS TO REPRODUCE:
To reproduce the issue in Tutorial Project:
1. Create a value prompt in Strategy Tutorial project in Strategy 9.4.1.
2. Create a Freeform SQL report with a value prompt as shown below:

ka04W000001MKwXQAW_0EM4400000029Ch.jpeg

3. Save the report.
4. Run the report in SQL view. Enter prompt answer and save the report with options below:

ka04W000001MKwXQAW_0EM4400000029Ci.jpeg

5. Upgrade the metadata to Strategy 10.1.
6. Edit the report in Strategy 10.1. Open Freeform SQL editor and then save the report without changing anything. The below error will pop up:
 

ka04W000001MKwXQAW_0EM4400000029Ce.jpeg

 
CAUSE:
This is a known issue in Strategy 10.1. This issue has been fixed in Strategy 10.2 Hotfix 1.
 
ACTION:
Upgrade to Strategy 10.2 Hotfix 1 to take advantage of the issue correction.


Comment

0 comments

Details

Knowledge Article

Published:

April 3, 2017

Last Updated:

April 3, 2017