Information

Title	User not authorized error while testing quartz cube in EP mid-tier Administrator

Summary	Error while testing a quartz cube in the EP mid-tier Administrator (or Jade administrator)

URL Name	Usernot-authorized-error-while-testing-quartz-cube-in-EP-mid-tier-Administrato

Resolution

1. Make sure that the Subcube mentioned, exists in the respective Quartz via the Admin Workbench (EPSAW)

2. Use the test connection checks in EPSAW to confirm

3. If 1 and 2 are okay go into SQLPLUS or SQL Developer connect to the new schema (= Quartz cube) and check :
3.1 The schema name is correct in table AT_BR_PRIVILEGES
3.2 The subcube name in table AT_SCOPT

Products	Enterprise Planning Client Edition; Enterprise Supply Planning

Module	EP Mid-Tier

Version	All

Error Message Code

pkbds.log

EQLnnn DSAPI ERROR: (1018) Invalid connection info or user 'plan_pp' is not authorized for database EPTEST:PLAN_PP:PLAN_PP

Cause

Subcube name does not match with that in the Quartz

Additional Information

Similar error can be seen in pkbds.log or EKB Message log, while MMM is being built, if the subcube information is inappropriate

Publication Status	Published

User not authorized error while testing quartz cube in EP mid-tier Administrator

Information