.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Error in MDX query

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server
 

Hi Vinu,

            Thanks for your previous response.

 

Now i have another issue the Following MDX query is working fine in MDX query analyzer.

 

call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=TMDEVDWHSRV01;Integrated Security=SSPI;Initial Catalog=BankingDWHStg"
    ,"Exec DecryptPANKey 1")

 

SQLQuery  means Assemblyname

 

 

but in Adhoc report i want to use with select statment for the above MDX query.

 

In Adhoc report MDX is not supporting the above query

 

call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=TMDEVDWHSRV01;Integrated Security=SSPI;Initial Catalog=BankingDWHStg"
    ,"Exec DecryptPANKey 1")

Please help to


View Complete Post


More Related Resource Links

Syntax error (missing operator) in query expression

  
Good Day Gurus!

I have a Excel user application which has a user form (named 'Registo') that displays criteria and an image that has been entered in it's corresponding spreadsheet. This works the way it should.  There's also the ability to search the spreadsheet via a form (by clicking 'Pesquisar' button) this opens a search form. However, I having a bit of a problem with it. When I try to search for something it basically doesn't do anything at all. It just sits there. So I tried to debug it and I think I'm having a problem with either the JET db engine or somethign with teh query or maybe I don't have the correct reference.

I 'borrowed' this Excel application from another forum because it's exactly what I'm looking for! However, I suck at vb.

So I was hoping somebody could take a look at the code and see if I'm missing something?  I'm kinda' desparate to get this working because I'm been trying to figure it out for days and I'm running out of time.  Cry
 
Option Explicit

'constantes para auxiliar na verificação do código
Private Const Ascendente As Byte = 0

Query Time out error?

  
Iam getting the querey time out error, when processing dimension in SSAS? The error Details is: OLE DB or ODBC error: Query timeout expired; HYT00; Unknown token received from SQL Server; HY000.\ can any one help me on this....how to resolve this?

Analysis Services - Query returns a #error result

  
Hi, I have a cube - which i had backed up and just retored it. After the restoration, when i try to reply the cube e.g: select [Time].&[200503] on 0 , {[Process].[All process]} on 1 from [myConsolidations] - i recieve an a result showing #error only. What could be the cause of this?

Content Query Web Part Error

  
Hi,I get the following error when i try to add a ContentByQuery.webpart using SharePoint Server 2007:   "Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator."   I've seen a lot of people having this problem when they aren't on an admin account, but I am, and this error happens before I can do any configuration at all to the webpart.   The webpart didn't show up in the webpart list at first, so I added it from the webparts gallery. The actual name of the part is Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.Is this the wrong kind of webpart or what seems to be the problem? I don't have much experience in Sharepoint since before, as you might can tell.Help would be VERY appreciated, thanks in advance.

Can anybody Identify whats the error in this update query ??

  
I am getting error as Invalid Column name 'JAVA' when i am havin a value JAVA in txtExamName text box.In my database ExamName field is having a data type nvarchar(25)."UPDATE Exam SET ExamName=' " + txtExamName.Text + " ',SubjectId=" + SubId + ",StartDate=' " + txtDate.Text + " ',StartTime=' " + txtHour.Text + ":" + txtMinutes.Text + " ',EndTime=' " + txtHour0.Text + ":" + txtMinutes0.Text + " ',ExamDescription=' " + txtDescri.Text + " ',TotalNoOfQuestion=" + txtQue.Text + ",MarkofCorrectAns=" + txtPoint.Text + ",MarkofWrongAns=" + txtExamName.Text + " WHERE ExamId=" + Convert.ToInt32(Session["ExamId"])

Error in select query

  
Hi, I am tring to use the following command but getting the following error message --Query Select * from CTOR_DBPF\Amord_wrk\dbo.rate2010 Server:   CTOR_DBPF Database: Amord_wrk Table:    rate2010 --Error message Line 1: Incorrect syntax near '\'.

Error in SQL server 2000 after the migration (internal query processor error)

  
I just moved a couple of databases from one instance of SQL 2000 from different hardware to SQL 2000 instance of other hardware and after the move from the application side the app team gets an error -2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X. Does any one have any idea about this. I took a trace while they were testing and I found out this in the trace. exec usp_DlyPrc_LogProcessEvent '-2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X An idea or direction on this will be greatly appreciated. Thanks hash

Having error in SSRS using oracle query

  

Hi ,

I have to create report based on date filter but when i used below query ,an error has occured

ORA - 01745 : invalid host/bind variable name.

 

query is

 

select top 2* from tablename where prodate>=:date and prodate<:date +1

 

 

Shraddha


Using CROSS APPLY in a data source query causes ARITHABORT error

  

I have an issue where the following query as an OLEDB data source throws the following error:

SELECT XmlNode.value('SomeValue[1]', 'varchar(10)') as SomeValue

FROM (SELECT CAST('<TestXML><SomeValue>123</SomeValue></TestXML>' AS XML

Search error-Query component status initialzing

  

When I try to search anything on my sharepoint site its is showing Internal Server Exception.

When I looked into the Central Administartion->Search Service:Search Administration,the Query Component 0 status is stuck on

initilialzing.So how can I solve this and make the query component 0 online.


SQL query giving Sytnax Error

  

Hey

 I have a query which I would like to execute however since im not a real specialist Im unable to find what is exactly wrong in it.

If anyone of the experienced DBAs could give me some tipos would be appreciated

(query is not mine - it has been created by someone else)

 

ALTER PROCEDURE dbo.CH_SyncClientSummary 
AS 
BEGIN 
  SET NOCOUNT ON 
  declare @UTCdiff int 
  set @UTCdiff = DateDiff(mi, GetDate(), GetUTCDate()) 
  declare @currentsite varchar(3) 
  select @currentsite = ThisSiteCode from SMSData 
  
  Insert into CH_ClientSummary(MachineID) 
  Select MachineID 
  From MachineIdGroupXRef

collation conflict error in BCP Query out

  

I am using BCP out command to export data to text file from SQL Server database using code below 

select @sql = 'bcp <tableName> out C:\bcp\image.txt -c -t$$ -b 10000 -UDBA -Pxxxx -S'+@@servername

Exec master..xp_cmdshell @sql, no_output 

I am getting the following error sporadically 

SQLState = 37000,

Error in Adhoc report MDX query

  

Hi Experts,          

Now i have another issue the Following MDX query is working fine in MDX query analyzer.

 

call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=TMDEVDWHSRV01;Integrated Security=SSPI;Initial Catalog=BankingDWHStg"
    ,"Exec DecryptPANKey 1")

 

SQLQuery  means Assemblyname

 

 

but in Adhoc report i want to use with select statment for the above MDX query.

 

In Adhoc report MDX is not supporting the above query

 

call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=TMDEVDWHSRV01;Integrated Security=SSPI;Initial Catalog=BankingDWHStg"
    ,"Exec DecryptPANKey 1")

 

Please help to use the above query in ADHOC report MDX.

 

 

"Access Denied" Error for WMI Reader Task Query

  

I am using SSIS to query all servers for their disk space from a remote machine using the WMI Reader Task by providing the Administrator user credentials to access all servers. The package execution fails and I get the following error in the Execution Results pane:

[WMI Data Reader Task] Error: An error occurred with the following error message: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))".

However, I do get the results for the Development and Staging servers but the Production servers come back with an Access Denied message. The user credentials for the Dev and Staging servers belong to the "Administrator" group whereas for the Production, the user belongs to the "Administrator" and the "User" group as well.

I am pretty much sure that it has something to do with access to running WMI queries on the servers but I could not find a forum that discussed this issue elsewhere. I even checked for the DCOM Security settings after a few searches led me to a post about "Connecting to WMI on a Remote Computer" on an msdn forum but they seem to be enabled for all environments.

My production database sits on a cluster, so does that make any difference? I have not used the WMI ta

The mdx-query MMSM works - BIDS error

  

for me it's very strange, the following mdx-query

SELECT 
 NON EMPTY 
  exists([Date].[Month].[Month].ALLMEMBERS,[Current FY]) ON COLUMNS
 ,NON EMPTY 
  {
    [Company].[Company].[Company].ALLMEMBERS*
    [Country].[Country].[Country].ALLMEMBERS*
    nonempty({[City].[City].[City].ALLMEMBERS},{[Measures].[Budget]})*
    {
     [Measures].[Fee]
     ,[Measures].[Broker]
     ,[Measures].[Income]
     ,[Measures].[FeeS]
     ,[Measures].[Comm]
     ,[Measures].[Budget]
    }
  } ON ROWS
FROM 
(
 SELECT 
  {[Company].[Company].[All]} ON COLUMNS
 FROM 
 (
  SELECT 
   {[City].[City].&[ADR]} ON COLUMNS
  FROM 
  (
   SELECT 
    {[Company].[Company].&[ASZ]} ON COLUMNS
   FROM [Cube]
  )
 )
);

the query works fine in SSMS and returns correct result but in SSRS BIDS returns error

TITLE: Microsoft Visual Studio
------------------------------

Query preparation failed.

------------------------------
ADDITIONAL INFORMATION:

The query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension..
Parameter name: mdx (MDXQueryGenerator)

 


Content query web part error

  

Hi,

I got the following error when i am displaying a list

Cannot save all of the property settings for this Web Part. There is a problem with one or more of the field values below.


extra token error on linked server query

  

I am writing a query across a linked server in SQL Server 2005 and am getting the error below about an extra token.

 

 

OLE DB provider "MSDASQL" for linked server "Live_Navision" returned message "[Navision a/s][Navision Attain ODBC Driver]Unexpected extra token: .".

Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing the query "select ManitouSerialno from Navision.dbo.InterfaceSecuritySystemsLLC$CustomerTable" for execution against OLE DB provider "MSDASQL" for linked server "Live_NAVISION".


Lee Markum
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend