Good morning,

Customer´s AppManager 8.2 with Analysis Center 2.9.
Disk where AC_OLAP folder run out of space and OLAP process got
corrupted files. I erased some files to give some space.
And then I tryed to regenarate Analysis Center process, erasing data
source from Analysis Center Console, and creating it again.
Then, I try to add a new data source but with the same database "data
mart" name.
Then the process "Create Source Data Marts" is executed correctly. And
then ETL process is executed also correctly.
Then I launch OLAP processing, but it fails on step 9:

Date 11/04/2017 13:04:31
Log Job History (Analysis Center (OLAP Processing))

Step ID
Job Name Analysis Center (OLAP Processing)
Step Name
Duration 00:00:13
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Executed as user: "DOMAIN\SERVICE_USER"
XML CHECK IN Utility Version[]
Event Log Trace Level Off
File Log Trace Level Verbose
Start: 11/04/2017 13:04:43
Command Line: "D:\Appsys\NetIQ\Analysis Center\bin\XmlCheckIn"
Argument: -XMLAPROC:GetCubeProcessXMLA**
Error [NQOLAP110] <return
xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages
Description="Errores del administrador de metadatos. dimension con id.
&#39;DimKnowledgeScript&#39; no existe en database con id.
&#39;AC_OLAP&#39; o el usuario no tiene permisos de acceso al objeto."
Source="Microsoft SQL Server 2012 Analysis Services"
HelpFile="" /></Messages></root></return>
Exception: NetIQ.Diagnostics.NQException: Error in the application. **
Error [XmlCheckIn] Completed with Exception
Exception: NetIQ.Diagnostics.NQException: Error in the application.
at NetIQ.XmlCheckInLib.CheckIn.SetParameter(String arg) at
NetIQ.XmlCheckIn.XmlCheckIn.Main(String[] args).
Process Exit Code 2.
The step failed.

The error says there´s no database with id. &#39;AC_OLAP&#39, or that
user hasn´t got permissions to access the object.
I´ve checked the user SERVICE_USER is administrator at the server, and
at SQL SERVER, SERVICE_USER is dbo of Data Mart,

How could I solve this problem?,

thank you.

Foliveirag's Profile:
View this thread: