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

KB45946: "Unexpected Error. Invalid procedure call or argument" error message appears when using multisourcing and selecting a different database instance in the Warehouse Catalog in MicroStrategy 9.x.


Community Admin

• Strategy


"Unexpected Error. Invalid procedure call or argument" error message appears when using multisourcing and selecting a different database instance in the Warehouse Catalog in MicroStrategy 9.x.

SYMPTOM:
 
When using multisourcing a user opens up the Warehouse Catalog in Strategy 9.x and initially, everything appears to be fine.  However, upon selecting a different database instance the user encounters the following error message.
 

ka04W00000147rDQAQ_0EM440000002CUK.png

 


Unexpected Error. Invalid procedure call or argument

 
 
CAUSE:
 
One possible cause of this error is incorrect warehouse passthrough settings.  This error will occur if Strategy is passing the incorrect login information to the database that is being selected.  If the project has warehouse passthrough enabled, check the authentication settings to make sure they only apply to the desired databases. 
 
ACTION:
 
Go to Project Configuration ->Database instances->Authentication->Warehouse. If warehouse passthrough is needed only to some database instances but not all, make sure the second button is selected and only the desired database instances are checked.
 

ka04W00000147rDQAQ_0EM440000002CUH.png

If these settings are correct, other possible causes of this error are discussed in KB17343 , KB38024, KB439152 , KB413817.
If the situation is not addressed in any of the above articles, contact Strategy Technical Support for further assistance.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

June 21, 2019