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

KB439305: Report SQL retains the old database table Prefix name after moving it from a test environment using Microstrategy Object manager


Maria Lourdes Rodriguez Pedrido

Manager, Technical Support • Strategy


This article explains the reason why an old database table Prefix name shows in a report SQL after moving a report from a test environment using Object Manager.

SYMPTOM:
When a report package is created (with its dependents) with Strategy Object Manager to move the report from test to production environments, once the package is imported in production the report's SQL still show the test environment table prefix.
CAUSE:
This issue is caused because the Schema is not updated after importing the package.
When copying any schema objects (in this case the table which is set to "replace" in the package) users must update the destination project’s schema.
ACTION:
Please select update schema from the destination project in Strategy Developer:

ka044000000kPBMAA2_0EM44000000QCgw.png

or select the options under "Update Schema" when creating the Package in Object Manager:

ka044000000kPBMAA2_0EM44000000QCh1.png

KB439305


Comment

0 comments

Details

Knowledge Article

Published:

December 22, 2017

Last Updated:

December 31, 2018