Showing posts with label analysis. Show all posts
Showing posts with label analysis. Show all posts

Thursday, February 16, 2012

Cannot see the cube using Crystal Analysis 9

Hi,

I'm currently using SQL 2000 Analysis Manager to create a cube, and Crystal Analysis 9 to try to view the cube.

When I grant the role of the cube to "Everyone", there is no problem, CA is able to view the cube.

However, when the role is granted to a specific "domain account", the cube is NOT showing up in CA...

My settings are: SQL 2000 on one PC, and CA on another PC. Both are under the same domain, and both are logged in using the same domain account. Also, this domain account is already granted the "Administrator" rights in SQL 2000 PC.

Any idea why this is happening?

Anyone ran into this problem too?

Thanks very much in advance.

sendmehere.

Try to narrow problem a little bit.

Try and use another application to browse your AS2000 cubes. You can try Excel PivotTables for that. See if you can connect and see the cubes.

If Excel works for you, the problem is then with CA.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward, I'll try that on Monday!!!

Will let you know the result afterwards.

|||

bad news...

When I use EXCEL pivot table, it is able to connect to the cube with or without a proper domain account / password...

so I cannot proof that it is CA problem...

Or it may be the Analysis Manager's problem?

Anymore ideas?

Thanks!!!

|||

If Excel is able to connect, the problem is likely in the CA.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, February 12, 2012

Cannot run job created by SMO

I've create a SQL Agent job using C# SMO to process an Analysis Service Database (see code below). When I tried to start job from Management Studio, I get the following error message...any ideas?

TITLE: Microsoft.SqlServer.Smo

Start failed for Job 'Schedule Job OLAPProj'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1314.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Start+Job&LinkId=20476


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot start the job "Schedule Job OLAPProj" (ID 089BEE15-B060-466E-B59E-7F7DAB1EB8DB) because it does not have any job server or servers defined. Associate the job with a job server by calling sp_add_jobserver. (Microsoft SQL Server, Error: 14256)



Common.ServerConnection l_oServerConn = new Common.ServerConnection();

l_oServerConn.ServerInstance = txtServer.Text;

l_oServerConn.LoginSecure = true;

l_oServerConn.Connect();

Smo.Server l_oServer = new Smo.Server(l_oServerConn);

Agent.Job l_oJob = new Agent.Job(l_oServer.JobServer, "Schedule Job " + cboDB.Text);

l_oJob.IsEnabled = true;

l_oJob.Description = "Schedule Job Processing OLAP Cube: " + cboDB.Text;

l_oJob.OwnerLoginName = @."NT AUTHORITY\SYSTEM";

l_oJob.Create();

Agent.JobStep l_oJobStep = new Agent.JobStep(l_oJob, "Process " + cboDB.Text);

l_oJobStep.SubSystem = Agent.AgentSubSystem.AnalysisCommand;

string l_sCmd = @."<Process xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">";

l_sCmd = l_sCmd + "<Object><DatabaseID>" + cboDB.Text + "</DatabaseID></Object><Type>ProcessFull</Type>";

l_sCmd = l_sCmd + "<WriteBackTableCreation>UseExisting</WriteBackTableCreation></Process>";

l_oJobStep.Command = l_sCmd;

l_oJobStep.Server = txtServer.Text;

l_oJobStep.DatabaseName = @."master";

l_oJobStep.JobStepFlags = Agent.JobStepFlags.AppendToJobHistory;

l_oJobStep.OnSuccessAction = Agent.StepCompletionAction.QuitWithSuccess;

l_oJobStep.OnFailAction = Agent.StepCompletionAction.QuitWithFailure;

l_oJobStep.Create();


I have posted a sample here, which should clarify this. Please let me know if you have further issues after reading the sample.

|||Based on your sample, I've added the following which seemed to do the trick:

l_oJob.ApplyToTargetServer("(local)");

Initially I use "localhost\yukon" which is name of my instance but that failed and "(local)" worked. Thanks.

Cannot restore my .ABF file...with no meaningful error message.

This one is just frustrating. I'm trying to restore an .ABF file, but when I go into SQL Server Manager (against the Analysis Services), bring up the restore dialog and click "Browse", I get an error:

TITLE: Microsoft SQL Server 2005 Analysis Services Managed Code Module

The function failed because of the following error: The given path's format is not supported..

If I manually type in the name of the .ABF, I get:

TITLE: Microsoft SQL Server Management Studio

File system error: The following error occurred while opening the file ''.
The following system error occurred: . (Microsoft SQL Server 2005 Analysis Services)

Never knew that . was an error message. The frustrating part is I've done a restore before, and I can't for the life of me think of anything I've changed on the server. Anyone else seen this?

Hello there,

Would you be able to provide pathname fo the ABF file you are trying to restore? As much as I see from your description it looks like you used relative path that is not supported; you should specify absolute pathname to the file.

Another idea is to use XML/A instead of UI dialog, something like

<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<File>your_file_pathname.abf</File>
<Security>CopyAll</Security>
<AllowOverwrite>true</AllowOverwrite>
<Locations/>
</Restore>

Thanks,

Mike

|||There is an advanced property on the server called AllowedBrowsingFolders. It sounds like there is an invalid value in this particular property.|||

IT seems I'm actually experiencing two different problems. I still can't Browse (I've checked the "AllowedBrowsingFolders" property, and it seems to be okay:

C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log;C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Backup;d:\database

However, I was able to backup and restore one of my existing cubes. I noticed that the backup was placed in the location specified in my "BackupDir" property:

D:\database\

So I copied my .ABF to that directory, and attempted to restore using just the name of the file. This still failed. I then created a new .ABF file from the original server, and tried that, and this time it worked. That suggested that part of my problem was the backup file itself, but when I open the two files with a Hex editor, they look pretty identical; the header and footer information is all the same. Strange and annoying, but at least I've gotten the restore to work (even if I don't know how or why).

Friday, February 10, 2012

Cannot restore / Create Analysis Database

Hi everybody,

I've installed SSAS 2008.

When I try to create a new database or to restore a database, I've many errors :

Create Database :

Either the 'TLS\christophe.laporte' user does not have permission to create a new object in 'PC-LAPORTE', or the object does not exist.
(Microsoft.AnalysisServices)


Program Location:

at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update()
at Microsoft.AnalysisServices.ManagementDialogs.OlapCreateDB.SendDataToServer()

Restore Database when I click on browse button:

Database administrator or server administrator permissions are required to execute SystemGetLogicalDrives command. (Microsoft SQL Server code name "Katmai" Analysis Services)


Program Location:

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.AnalysisServices.Controls.FileSystemBrowser.Call(String function)
at

Any idea ?

I've installed Katmai on Vista. My account is in the administrators group on the computer. All services are started with a domain admin account ( and I'am too).

Maybe I've te setup katmai again ?

Thanks.

Christophe.

France.

Oups, sorry,

SSMS launched with administrator privileges is OK.

But why I get this error ? MMy account is administrator ...

And why SSMS don't query about privilege elevation when browsing for files or creating a database ?

Chrisstophe.

France.

|||

Chris,

I am not surprised that you have issues with SSAS on Vista PC. Actually on CTP download page Microsoft has a note regarding this:

The SQL Server 2008 June CTP has known compatibility issues with Windows Vista and Windows Server 2008 Beta. We do not recommend testing this CTP on this configuration. Instead, test this CTP on Windows Server 2003 Enterprise Edition with SP1 installed for 32-bit x86 and 64-bit x64 editions, and Windows XP Professional Edition with SP2 installed for 32-bit x86 and 64-bit x64 editions.

So I think you just will have to wait for future CTPs and see if they fixed issues on Vista.

Vidas Matelis

http://www.ssas2008-info.com

cannot rename instance of analysis server.missing reg key

when i use the rename instance tool i get this error saying it cannot find the regestry key

hkey_local_Machine\wow6432Node\Microsoft\Microsoft Sql Server\90

When i look for this key, it doesnt exist. My installation went perfectly. what is going wrong

There are 2 versions of ASInstanceRename utility. Make sure you use one that is installed with 64bit version of Analysis Server.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||but i am using the 32 bit version of sql server 2005, and its on a 32 bit pc. theres no way i can install the 64 bit version as my machine wont even run the setup file|||

You should use 64 bit version of asinstancerename utility on 64 bit machine to rename 32bit instances. It is intended to be able to handle 32bit instances.

To get 64bit version of asinstancerename, uninstall 32bit version SQL Tools from your machine and install them back using 64ibt CD.

That should get you going.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.