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

KB439115:"Failed to decompress definition of 33 object" when configuring a MicroStrategy 10.x Intelligence Server to a PostgreSQL metadata


Amanda Gordon

Quality Engineer, Senior • MicroStrategy


SYMPTOM:
When configuring a Strategy 10.x Intelligence Server to a metadata in a PostgreSQL 9.1 or later database, the following error may be seen:

ka02R000000kV4MQAU_0EM44000000Q8yD.png


Server Definition manipulations error
(Failed to decompress definition of 33 object '...' (ID: ...))

CAUSE:
The default value for the setting standard_conforming_strings was changed in PostgreSQL 9.1 and later versions.  In PostgreSQL 9.1, the default for this setting is on, but in earlier releases of PostgreSQL the default for this setting was off.  The standard_conforming_strings setting controls how backslashes are treated in string literals.  If the metadata shell was created prior to PostgreSQL 9.1, and the metadata was later upgraded to PostgreSQL 9.1 or later, backslashes in Strategy object definitions are not handled properly.
ACTION:
The standard_conforming_strings setting can be set to off.
On a Windows Intelligence Server, open Windows ODBC Administrator, edit the DSN, and go to the Advanced tab.  In the Initialization String box, input the following:

ka02R000000kV4MQAU_0EM44000000Q8yX.png


set standard_conforming_strings=off

On a Linux Intelligence Server, a line should be added to the metadata DSN entry in the odbc.ini file:

InitializationString=set standard_conforming_strings=off

  KB439115


Comment

0 comments

Details

Knowledge Article

Published:

November 29, 2017

Last Updated:

December 4, 2018