all groups > sql server data warehouse > january 2005 >
You're in the sql server data warehouse group:
The query could not be processed
sql server data warehouse:
Hello, I have 2 cubes, one runs smootly and another one has an error message 'The query could not be processed : The data provider didn't supply any further error information' Anyone know how to solve it, please let me know. Your advice would be appreciated. Thank you and Have a nice day!
What is the data source for the cube that returns an error? SQL Server 2000? Oracle? or what? -- Dave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Kit" <Kit@discussions.microsoft.com> wrote in message news:161001c504ea$abd24630$a401280a@phx.gbl... > Hello, > > I have 2 cubes, one runs smootly and another one has an > error message 'The query could not be processed : The > data provider didn't supply any further error information' > > Anyone know how to solve it, please let me know. Your > advice would be appreciated. > > Thank you and Have a nice day! > > Kit
Hi Dave, The data source is SQL Server 2000. And the OS is Windows Server 2003. Thank you. Kit [quoted text, click to view] >-----Original Message----- >What is the data source for the cube that returns an error? >SQL Server 2000? Oracle? or what? >-- >Dave Wickert [MSFT] >dwickert@online.microsoft.com >Program Manager >BI SystemsTeam >SQL BI Product Unit (Analysis Services) >-- >This posting is provided "AS IS" with no warranties, and confers no rights. > >"Kit" <Kit@discussions.microsoft.com> wrote in message >news:161001c504ea$abd24630$a401280a@phx.gbl... >> Hello, >> >> I have 2 cubes, one runs smootly and another one has an >> error message 'The query could not be processed : The >> data provider didn't supply any further error information' >> >> Anyone know how to solve it, please let me know. Your >> advice would be appreciated. >> >> Thank you and Have a nice day! >> >> Kit > > >.
We can certainly load from SQL Server -- we do it all of the time. There must be some other configuration which is different between the two. Are they running the same MDAC stack? Can you provide more specifics? -- Dave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Kit" <Kit@discussions.microsoft.com> wrote in message news:17f301c50525$c6ca6950$a401280a@phx.gbl... > Hi Dave, > > The data source is SQL Server 2000. And the OS is > Windows Server 2003. > > Thank you. > > Kit > > >-----Original Message----- > >What is the data source for the cube that returns an > error? > >SQL Server 2000? Oracle? or what? > >-- > >Dave Wickert [MSFT] > >dwickert@online.microsoft.com > >Program Manager > >BI SystemsTeam > >SQL BI Product Unit (Analysis Services) > >-- > >This posting is provided "AS IS" with no warranties, and > confers no rights. > > > >"Kit" <Kit@discussions.microsoft.com> wrote in message > >news:161001c504ea$abd24630$a401280a@phx.gbl... > >> Hello, > >> > >> I have 2 cubes, one runs smootly and another one has an > >> error message 'The query could not be processed : The > >> data provider didn't supply any further error > information' > >> > >> Anyone know how to solve it, please let me know. Your > >> advice would be appreciated. > >> > >> Thank you and Have a nice day! > >> > >> Kit > > > > > >. > >
Hi Dave, Yes, they are running the same MDAC stack. I would like to tell you that all pcs that process the same cube use Windows XP, Office XP (by Pivot Table) and has installed OWC10 already. The trouble cube can be viewed in other pcs normally. So, I'm not sure some configuration in OS has some discrepancy. Please advice. Have a nice day, Kit [quoted text, click to view] >-----Original Message----- >We can certainly load from SQL Server -- we do it all of the time. >There must be some other configuration which is different between the two. >Are they running the same MDAC stack? >Can you provide more specifics? >-- >Dave Wickert [MSFT] >dwickert@online.microsoft.com >Program Manager >BI SystemsTeam >SQL BI Product Unit (Analysis Services) >-- >This posting is provided "AS IS" with no warranties, and confers no rights. > >"Kit" <Kit@discussions.microsoft.com> wrote in message >news:17f301c50525$c6ca6950$a401280a@phx.gbl... >> Hi Dave, >> >> The data source is SQL Server 2000. And the OS is >> Windows Server 2003. >> >> Thank you. >> >> Kit >> >> >-----Original Message----- >> >What is the data source for the cube that returns an >> error? >> >SQL Server 2000? Oracle? or what? >> >-- >> >Dave Wickert [MSFT] >> >dwickert@online.microsoft.com >> >Program Manager >> >BI SystemsTeam >> >SQL BI Product Unit (Analysis Services) >> >-- >> >This posting is provided "AS IS" with no warranties, and >> confers no rights. >> > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >news:161001c504ea$abd24630$a401280a@phx.gbl... >> >> Hello, >> >> >> >> I have 2 cubes, one runs smootly and another one has an >> >> error message 'The query could not be processed : The >> >> data provider didn't supply any further error >> information' >> >> >> >> Anyone know how to solve it, please let me know. Your >> >> advice would be appreciated. >> >> >> >> Thank you and Have a nice day! >> >> >> >> Kit >> > >> > >> >. >> > > > >.
In your original posting you said "I have 2 cubes, one runs smootly and another one has an error message 'The query could not be processed : The data provider didn't supply any further error information' Can you tell me more about the conditions when the error occurs on the second cube? For example, does the second cube return the same error regardless of what PCs query it? Can a PC which has an error on the second cube, can same PC query the first cube? -- Dave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Kit" <Kit@discussions.microsoft.com> wrote in message news:2c2201c50819$8b16a990$a401280a@phx.gbl... > Hi Dave, > > Yes, they are running the same MDAC stack. > > I would like to tell you that all pcs that process the > same cube use Windows XP, Office XP (by Pivot Table) and > has installed OWC10 already. The trouble cube can be > viewed in other pcs normally. So, I'm not sure some > configuration in OS has some discrepancy. Please advice. > > Have a nice day, > > Kit > > > > >-----Original Message----- > >We can certainly load from SQL Server -- we do it all of > the time. > >There must be some other configuration which is > different between the two. > >Are they running the same MDAC stack? > >Can you provide more specifics? > >-- > >Dave Wickert [MSFT] > >dwickert@online.microsoft.com > >Program Manager > >BI SystemsTeam > >SQL BI Product Unit (Analysis Services) > >-- > >This posting is provided "AS IS" with no warranties, and > confers no rights. > > > >"Kit" <Kit@discussions.microsoft.com> wrote in message > >news:17f301c50525$c6ca6950$a401280a@phx.gbl... > >> Hi Dave, > >> > >> The data source is SQL Server 2000. And the OS is > >> Windows Server 2003. > >> > >> Thank you. > >> > >> Kit > >> > >> >-----Original Message----- > >> >What is the data source for the cube that returns an > >> error? > >> >SQL Server 2000? Oracle? or what? > >> >-- > >> >Dave Wickert [MSFT] > >> >dwickert@online.microsoft.com > >> >Program Manager > >> >BI SystemsTeam > >> >SQL BI Product Unit (Analysis Services) > >> >-- > >> >This posting is provided "AS IS" with no warranties, > and > >> confers no rights. > >> > > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message > >> >news:161001c504ea$abd24630$a401280a@phx.gbl... > >> >> Hello, > >> >> > >> >> I have 2 cubes, one runs smootly and another one > has an > >> >> error message 'The query could not be processed : > The > >> >> data provider didn't supply any further error > >> information' > >> >> > >> >> Anyone know how to solve it, please let me know. > Your > >> >> advice would be appreciated. > >> >> > >> >> Thank you and Have a nice day! > >> >> > >> >> Kit > >> > > >> > > >> >. > >> > > > > > > >. > >
Hi Dave, Sorry, I did not explain you clearly due to my English is limited. Please let me to attempt to re-explain. 2 Cubes that I have are run under the same database. I don't have any special conditions. I accessed cubes using Pivot Table on a client site. The first cube has been processed well. On the other hand, when I tried to process the second cube, the error that is 'The query could not be processed : The data provider didn't supply any further error information' has been appeared. After that, I changed to other client pcs, there are no any errors for both cubes. All client pcs have been installed OWC10.exe, IE Version 6 as well as MS Office XP. And Cubes' Database Role Manager in AM are set for Guests. Thank you for your assistance. Kit [quoted text, click to view] >-----Original Message----- >In your original posting you said "I have 2 cubes, one runs smootly and >another one has an error message 'The query could not be processed : The >data provider didn't supply any further error information' > >Can you tell me more about the conditions when the error occurs on the >second cube? >For example, does the second cube return the same error regardless of what >PCs query it? Can a PC which has an error on the second cube, can same PC >query the first cube? > >-- >Dave Wickert [MSFT] >dwickert@online.microsoft.com >Program Manager >BI SystemsTeam >SQL BI Product Unit (Analysis Services) >-- >This posting is provided "AS IS" with no warranties, and confers no rights. > >"Kit" <Kit@discussions.microsoft.com> wrote in message >news:2c2201c50819$8b16a990$a401280a@phx.gbl... >> Hi Dave, >> >> Yes, they are running the same MDAC stack. >> >> I would like to tell you that all pcs that process the >> same cube use Windows XP, Office XP (by Pivot Table) and >> has installed OWC10 already. The trouble cube can be >> viewed in other pcs normally. So, I'm not sure some >> configuration in OS has some discrepancy. Please advice. >> >> Have a nice day, >> >> Kit >> >> >> >> >-----Original Message----- >> >We can certainly load from SQL Server -- we do it all of >> the time. >> >There must be some other configuration which is >> different between the two. >> >Are they running the same MDAC stack? >> >Can you provide more specifics? >> >-- >> >Dave Wickert [MSFT] >> >dwickert@online.microsoft.com >> >Program Manager >> >BI SystemsTeam >> >SQL BI Product Unit (Analysis Services) >> >-- >> >This posting is provided "AS IS" with no warranties, and >> confers no rights. >> > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >news:17f301c50525$c6ca6950$a401280a@phx.gbl... >> >> Hi Dave, >> >> >> >> The data source is SQL Server 2000. And the OS is >> >> Windows Server 2003. >> >> >> >> Thank you. >> >> >> >> Kit >> >> >> >> >-----Original Message----- >> >> >What is the data source for the cube that returns an >> >> error? >> >> >SQL Server 2000? Oracle? or what? >> >> >-- >> >> >Dave Wickert [MSFT] >> >> >dwickert@online.microsoft.com >> >> >Program Manager >> >> >BI SystemsTeam >> >> >SQL BI Product Unit (Analysis Services) >> >> >-- >> >> >This posting is provided "AS IS" with no warranties, >> and >> >> confers no rights. >> >> > >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >> >news:161001c504ea$abd24630$a401280a@phx.gbl... >> >> >> Hello, >> >> >> >> >> >> I have 2 cubes, one runs smootly and another one >> has an >> >> >> error message 'The query could not be processed : >> The >> >> >> data provider didn't supply any further error >> >> information' >> >> >> >> >> >> Anyone know how to solve it, please let me know. >> Your >> >> >> advice would be appreciated. >> >> >> >> >> >> Thank you and Have a nice day! >> >> >> >> >> >> Kit >> >> > >> >> > >> >> >. >> >> > >> > >> > >> >. >> > > > >.
Are the errors returned when you "process" the cube using Analysis Manager or when you "query" the cube using OWC? -- Dave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Kit" <Kit@discussions.microsoft.com> wrote in message news:047a01c50903$17876bf0$a401280a@phx.gbl... > Hi Dave, > > Sorry, I did not explain you clearly due to my English is > limited. Please let me to attempt to re-explain. > > 2 Cubes that I have are run under the same database. I > don't have any special conditions. I accessed cubes > using Pivot Table on a client site. The first cube has > been processed well. On the other hand, when I tried to > process the second cube, the error that is 'The query > could not be processed : The data provider didn't supply > any further error information' has been appeared. > > After that, I changed to other client pcs, there are no > any errors for both cubes. > > All client pcs have been installed OWC10.exe, IE Version > 6 as well as MS Office XP. And Cubes' Database Role > Manager in AM are set for Guests. > > Thank you for your assistance. > > Kit > > >-----Original Message----- > >In your original posting you said "I have 2 cubes, one > runs smootly and > >another one has an error message 'The query could not be > processed : The > >data provider didn't supply any further error > information' > > > >Can you tell me more about the conditions when the error > occurs on the > >second cube? > >For example, does the second cube return the same error > regardless of what > >PCs query it? Can a PC which has an error on the second > cube, can same PC > >query the first cube? > > > >-- > >Dave Wickert [MSFT] > >dwickert@online.microsoft.com > >Program Manager > >BI SystemsTeam > >SQL BI Product Unit (Analysis Services) > >-- > >This posting is provided "AS IS" with no warranties, and > confers no rights. > > > >"Kit" <Kit@discussions.microsoft.com> wrote in message > >news:2c2201c50819$8b16a990$a401280a@phx.gbl... > >> Hi Dave, > >> > >> Yes, they are running the same MDAC stack. > >> > >> I would like to tell you that all pcs that process the > >> same cube use Windows XP, Office XP (by Pivot Table) > and > >> has installed OWC10 already. The trouble cube can be > >> viewed in other pcs normally. So, I'm not sure some > >> configuration in OS has some discrepancy. Please > advice. > >> > >> Have a nice day, > >> > >> Kit > >> > >> > >> > >> >-----Original Message----- > >> >We can certainly load from SQL Server -- we do it all > of > >> the time. > >> >There must be some other configuration which is > >> different between the two. > >> >Are they running the same MDAC stack? > >> >Can you provide more specifics? > >> >-- > >> >Dave Wickert [MSFT] > >> >dwickert@online.microsoft.com > >> >Program Manager > >> >BI SystemsTeam > >> >SQL BI Product Unit (Analysis Services) > >> >-- > >> >This posting is provided "AS IS" with no warranties, > and > >> confers no rights. > >> > > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message > >> >news:17f301c50525$c6ca6950$a401280a@phx.gbl... > >> >> Hi Dave, > >> >> > >> >> The data source is SQL Server 2000. And the OS is > >> >> Windows Server 2003. > >> >> > >> >> Thank you. > >> >> > >> >> Kit > >> >> > >> >> >-----Original Message----- > >> >> >What is the data source for the cube that returns > an > >> >> error? > >> >> >SQL Server 2000? Oracle? or what? > >> >> >-- > >> >> >Dave Wickert [MSFT] > >> >> >dwickert@online.microsoft.com > >> >> >Program Manager > >> >> >BI SystemsTeam > >> >> >SQL BI Product Unit (Analysis Services) > >> >> >-- > >> >> >This posting is provided "AS IS" with no > warranties, > >> and > >> >> confers no rights. > >> >> > > >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in > message > >> >> >news:161001c504ea$abd24630$a401280a@phx.gbl... > >> >> >> Hello, > >> >> >> > >> >> >> I have 2 cubes, one runs smootly and another one > >> has an > >> >> >> error message 'The query could not be processed : > >> The > >> >> >> data provider didn't supply any further error > >> >> information' > >> >> >> > >> >> >> Anyone know how to solve it, please let me know. > >> Your > >> >> >> advice would be appreciated. > >> >> >> > >> >> >> Thank you and Have a nice day! > >> >> >> > >> >> >> Kit > >> >> > > >> >> > > >> >> >. > >> >> > > >> > > >> > > >> >. > >> > > > > > > >. > >
The errers returned when I "query" the cube on IE (Pivot Table) using OWC. [quoted text, click to view] >-----Original Message----- >Are the errors returned when you "process" the cube using Analysis Manager >or when you "query" the cube using OWC? >-- >Dave Wickert [MSFT] >dwickert@online.microsoft.com >Program Manager >BI SystemsTeam >SQL BI Product Unit (Analysis Services) >-- >This posting is provided "AS IS" with no warranties, and confers no rights. > >"Kit" <Kit@discussions.microsoft.com> wrote in message >news:047a01c50903$17876bf0$a401280a@phx.gbl... >> Hi Dave, >> >> Sorry, I did not explain you clearly due to my English is >> limited. Please let me to attempt to re-explain. >> >> 2 Cubes that I have are run under the same database. I >> don't have any special conditions. I accessed cubes >> using Pivot Table on a client site. The first cube has >> been processed well. On the other hand, when I tried to >> process the second cube, the error that is 'The query >> could not be processed : The data provider didn't supply >> any further error information' has been appeared. >> >> After that, I changed to other client pcs, there are no >> any errors for both cubes. >> >> All client pcs have been installed OWC10.exe, IE Version >> 6 as well as MS Office XP. And Cubes' Database Role >> Manager in AM are set for Guests. >> >> Thank you for your assistance. >> >> Kit >> >> >-----Original Message----- >> >In your original posting you said "I have 2 cubes, one >> runs smootly and >> >another one has an error message 'The query could not be >> processed : The >> >data provider didn't supply any further error >> information' >> > >> >Can you tell me more about the conditions when the error >> occurs on the >> >second cube? >> >For example, does the second cube return the same error >> regardless of what >> >PCs query it? Can a PC which has an error on the second >> cube, can same PC >> >query the first cube? >> > >> >-- >> >Dave Wickert [MSFT] >> >dwickert@online.microsoft.com >> >Program Manager >> >BI SystemsTeam >> >SQL BI Product Unit (Analysis Services) >> >-- >> >This posting is provided "AS IS" with no warranties, and >> confers no rights. >> > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >news:2c2201c50819$8b16a990$a401280a@phx.gbl... >> >> Hi Dave, >> >> >> >> Yes, they are running the same MDAC stack. >> >> >> >> I would like to tell you that all pcs that process the >> >> same cube use Windows XP, Office XP (by Pivot Table) >> and >> >> has installed OWC10 already. The trouble cube can be >> >> viewed in other pcs normally. So, I'm not sure some >> >> configuration in OS has some discrepancy. Please >> advice. >> >> >> >> Have a nice day, >> >> >> >> Kit >> >> >> >> >> >> >> >> >-----Original Message----- >> >> >We can certainly load from SQL Server -- we do it all >> of >> >> the time. >> >> >There must be some other configuration which is >> >> different between the two. >> >> >Are they running the same MDAC stack? >> >> >Can you provide more specifics? >> >> >-- >> >> >Dave Wickert [MSFT] >> >> >dwickert@online.microsoft.com >> >> >Program Manager >> >> >BI SystemsTeam >> >> >SQL BI Product Unit (Analysis Services) >> >> >-- >> >> >This posting is provided "AS IS" with no warranties, >> and >> >> confers no rights. >> >> > >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >> >news:17f301c50525$c6ca6950$a401280a@phx.gbl... >> >> >> Hi Dave, >> >> >> >> >> >> The data source is SQL Server 2000. And the OS is >> >> >> Windows Server 2003. >> >> >> >> >> >> Thank you. >> >> >> >> >> >> Kit >> >> >> >> >> >> >-----Original Message----- >> >> >> >What is the data source for the cube that returns >> an >> >> >> error? >> >> >> >SQL Server 2000? Oracle? or what? >> >> >> >-- >> >> >> >Dave Wickert [MSFT] >> >> >> >dwickert@online.microsoft.com >> >> >> >Program Manager >> >> >> >BI SystemsTeam >> >> >> >SQL BI Product Unit (Analysis Services) >> >> >> >-- >> >> >> >This posting is provided "AS IS" with no >> warranties, >> >> and >> >> >> confers no rights. >> >> >> > >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in >> message >> >> >> >news:161001c504ea$abd24630$a401280a@phx.gbl... >> >> >> >> Hello, >> >> >> >> >> >> >> >> I have 2 cubes, one runs smootly and another one >> >> has an >> >> >> >> error message 'The query could not be processed : >> >> The >> >> >> >> data provider didn't supply any further error >> >> >> information' >> >> >> >> >> >> >> >> Anyone know how to solve it, please let me know. >> >> Your >> >> >> >> advice would be appreciated. >> >> >> >> >> >> >> >> Thank you and Have a nice day! >> >> >> >> >> >> >> >> Kit >> >> >> > >> >> >> > >> >> >> >. >> >> >> > >> >> > >> >> > >> >> >. >> >> > >> > >> > >> >. >> > > > >.
From the PCs that are getting errors, can you see and query other cubes, e.g. Foodmart? Or is this error only being returned for this one cube? -- Dave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Kit" <Kit@discussions.microsoft.com> wrote in message news:1dab01c50a8c$6ceb5b30$a601280a@phx.gbl... > The errers returned when I "query" the cube on IE (Pivot > Table) using OWC. > > > >-----Original Message----- > >Are the errors returned when you "process" the cube > using Analysis Manager > >or when you "query" the cube using OWC? > >-- > >Dave Wickert [MSFT] > >dwickert@online.microsoft.com > >Program Manager > >BI SystemsTeam > >SQL BI Product Unit (Analysis Services) > >-- > >This posting is provided "AS IS" with no warranties, and > confers no rights. > > > >"Kit" <Kit@discussions.microsoft.com> wrote in message > >news:047a01c50903$17876bf0$a401280a@phx.gbl... > >> Hi Dave, > >> > >> Sorry, I did not explain you clearly due to my English > is > >> limited. Please let me to attempt to re-explain. > >> > >> 2 Cubes that I have are run under the same database. I > >> don't have any special conditions. I accessed cubes > >> using Pivot Table on a client site. The first cube has > >> been processed well. On the other hand, when I tried > to > >> process the second cube, the error that is 'The query > >> could not be processed : The data provider didn't > supply > >> any further error information' has been appeared. > >> > >> After that, I changed to other client pcs, there are no > >> any errors for both cubes. > >> > >> All client pcs have been installed OWC10.exe, IE > Version > >> 6 as well as MS Office XP. And Cubes' Database Role > >> Manager in AM are set for Guests. > >> > >> Thank you for your assistance. > >> > >> Kit > >> > >> >-----Original Message----- > >> >In your original posting you said "I have 2 cubes, one > >> runs smootly and > >> >another one has an error message 'The query could not > be > >> processed : The > >> >data provider didn't supply any further error > >> information' > >> > > >> >Can you tell me more about the conditions when the > error > >> occurs on the > >> >second cube? > >> >For example, does the second cube return the same > error > >> regardless of what > >> >PCs query it? Can a PC which has an error on the > second > >> cube, can same PC > >> >query the first cube? > >> > > >> >-- > >> >Dave Wickert [MSFT] > >> >dwickert@online.microsoft.com > >> >Program Manager > >> >BI SystemsTeam > >> >SQL BI Product Unit (Analysis Services) > >> >-- > >> >This posting is provided "AS IS" with no warranties, > and > >> confers no rights. > >> > > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message > >> >news:2c2201c50819$8b16a990$a401280a@phx.gbl... > >> >> Hi Dave, > >> >> > >> >> Yes, they are running the same MDAC stack. > >> >> > >> >> I would like to tell you that all pcs that process > the > >> >> same cube use Windows XP, Office XP (by Pivot Table) > >> and > >> >> has installed OWC10 already. The trouble cube can > be > >> >> viewed in other pcs normally. So, I'm not sure some > >> >> configuration in OS has some discrepancy. Please > >> advice. > >> >> > >> >> Have a nice day, > >> >> > >> >> Kit > >> >> > >> >> > >> >> > >> >> >-----Original Message----- > >> >> >We can certainly load from SQL Server -- we do it > all > >> of > >> >> the time. > >> >> >There must be some other configuration which is > >> >> different between the two. > >> >> >Are they running the same MDAC stack? > >> >> >Can you provide more specifics? > >> >> >-- > >> >> >Dave Wickert [MSFT] > >> >> >dwickert@online.microsoft.com > >> >> >Program Manager > >> >> >BI SystemsTeam > >> >> >SQL BI Product Unit (Analysis Services) > >> >> >-- > >> >> >This posting is provided "AS IS" with no > warranties, > >> and > >> >> confers no rights. > >> >> > > >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in > message > >> >> >news:17f301c50525$c6ca6950$a401280a@phx.gbl... > >> >> >> Hi Dave, > >> >> >> > >> >> >> The data source is SQL Server 2000. And the OS > is > >> >> >> Windows Server 2003. > >> >> >> > >> >> >> Thank you. > >> >> >> > >> >> >> Kit > >> >> >> > >> >> >> >-----Original Message----- > >> >> >> >What is the data source for the cube that > returns > >> an > >> >> >> error? > >> >> >> >SQL Server 2000? Oracle? or what? > >> >> >> >-- > >> >> >> >Dave Wickert [MSFT] > >> >> >> >dwickert@online.microsoft.com > >> >> >> >Program Manager > >> >> >> >BI SystemsTeam > >> >> >> >SQL BI Product Unit (Analysis Services) > >> >> >> >-- > >> >> >> >This posting is provided "AS IS" with no > >> warranties, > >> >> and > >> >> >> confers no rights. > >> >> >> > > >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in > >> message > >> >> >> >news:161001c504ea$abd24630$a401280a@phx.gbl... > >> >> >> >> Hello, > >> >> >> >> > >> >> >> >> I have 2 cubes, one runs smootly and another > one > >> >> has an > >> >> >> >> error message 'The query could not be > processed : > >> >> The > >> >> >> >> data provider didn't supply any further error > >> >> >> information' > >> >> >> >> > >> >> >> >> Anyone know how to solve it, please let me > know. > >> >> Your > >> >> >> >> advice would be appreciated. > >> >> >> >> > >> >> >> >> Thank you and Have a nice day! > >> >> >> >> > >> >> >> >> Kit > >> >> >> > > >> >> >> > > >> >> >> >. > >> >> >> > > >> >> > > >> >> > > >> >> >. > >> >> > > >> > > >> > > >> >. > >> > > > > > > >. > >
I can see and query other cubes except the cube that returned the error. [quoted text, click to view] >-----Original Message----- >From the PCs that are getting errors, can you see and query other cubes, >e.g. Foodmart? Or is this error only being returned for this one cube? >-- >Dave Wickert [MSFT] >dwickert@online.microsoft.com >Program Manager >BI SystemsTeam >SQL BI Product Unit (Analysis Services) >-- >This posting is provided "AS IS" with no warranties, and confers no rights. > >"Kit" <Kit@discussions.microsoft.com> wrote in message >news:1dab01c50a8c$6ceb5b30$a601280a@phx.gbl... >> The errers returned when I "query" the cube on IE (Pivot >> Table) using OWC. >> >> >> >-----Original Message----- >> >Are the errors returned when you "process" the cube >> using Analysis Manager >> >or when you "query" the cube using OWC? >> >-- >> >Dave Wickert [MSFT] >> >dwickert@online.microsoft.com >> >Program Manager >> >BI SystemsTeam >> >SQL BI Product Unit (Analysis Services) >> >-- >> >This posting is provided "AS IS" with no warranties, and >> confers no rights. >> > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >news:047a01c50903$17876bf0$a401280a@phx.gbl... >> >> Hi Dave, >> >> >> >> Sorry, I did not explain you clearly due to my English >> is >> >> limited. Please let me to attempt to re-explain. >> >> >> >> 2 Cubes that I have are run under the same database. I >> >> don't have any special conditions. I accessed cubes >> >> using Pivot Table on a client site. The first cube has >> >> been processed well. On the other hand, when I tried >> to >> >> process the second cube, the error that is 'The query >> >> could not be processed : The data provider didn't >> supply >> >> any further error information' has been appeared. >> >> >> >> After that, I changed to other client pcs, there are no >> >> any errors for both cubes. >> >> >> >> All client pcs have been installed OWC10.exe, IE >> Version >> >> 6 as well as MS Office XP. And Cubes' Database Role >> >> Manager in AM are set for Guests. >> >> >> >> Thank you for your assistance. >> >> >> >> Kit >> >> >> >> >-----Original Message----- >> >> >In your original posting you said "I have 2 cubes, one >> >> runs smootly and >> >> >another one has an error message 'The query could not >> be >> >> processed : The >> >> >data provider didn't supply any further error >> >> information' >> >> > >> >> >Can you tell me more about the conditions when the >> error >> >> occurs on the >> >> >second cube? >> >> >For example, does the second cube return the same >> error >> >> regardless of what >> >> >PCs query it? Can a PC which has an error on the >> second >> >> cube, can same PC >> >> >query the first cube? >> >> > >> >> >-- >> >> >Dave Wickert [MSFT] >> >> >dwickert@online.microsoft.com >> >> >Program Manager >> >> >BI SystemsTeam >> >> >SQL BI Product Unit (Analysis Services) >> >> >-- >> >> >This posting is provided "AS IS" with no warranties, >> and >> >> confers no rights. >> >> > >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >> >news:2c2201c50819$8b16a990$a401280a@phx.gbl... >> >> >> Hi Dave, >> >> >> >> >> >> Yes, they are running the same MDAC stack. >> >> >> >> >> >> I would like to tell you that all pcs that process >> the >> >> >> same cube use Windows XP, Office XP (by Pivot Table) >> >> and >> >> >> has installed OWC10 already. The trouble cube can >> be >> >> >> viewed in other pcs normally. So, I'm not sure some >> >> >> configuration in OS has some discrepancy. Please >> >> advice. >> >> >> >> >> >> Have a nice day, >> >> >> >> >> >> Kit >> >> >> >> >> >> >> >> >> >> >> >> >-----Original Message----- >> >> >> >We can certainly load from SQL Server -- we do it >> all >> >> of >> >> >> the time. >> >> >> >There must be some other configuration which is >> >> >> different between the two. >> >> >> >Are they running the same MDAC stack? >> >> >> >Can you provide more specifics? >> >> >> >-- >> >> >> >Dave Wickert [MSFT] >> >> >> >dwickert@online.microsoft.com >> >> >> >Program Manager >> >> >> >BI SystemsTeam >> >> >> >SQL BI Product Unit (Analysis Services) >> >> >> >-- >> >> >> >This posting is provided "AS IS" with no >> warranties, >> >> and >> >> >> confers no rights. >> >> >> > >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in >> message >> >> >> >news:17f301c50525$c6ca6950$a401280a@phx.gbl... >> >> >> >> Hi Dave, >> >> >> >> >> >> >> >> The data source is SQL Server 2000. And the OS >> is >> >> >> >> Windows Server 2003. >> >> >> >> >> >> >> >> Thank you. >> >> >> >> >> >> >> >> Kit >> >> >> >> >> >> >> >> >-----Original Message----- >> >> >> >> >What is the data source for the cube that >> returns >> >> an >> >> >> >> error? >> >> >> >> >SQL Server 2000? Oracle? or what? >> >> >> >> >-- >> >> >> >> >Dave Wickert [MSFT] >> >> >> >> >dwickert@online.microsoft.com >> >> >> >> >Program Manager >> >> >> >> >BI SystemsTeam >> >> >> >> >SQL BI Product Unit (Analysis Services) >> >> >> >> >-- >> >> >> >> >This posting is provided "AS IS" with no >> >> warranties, >> >> >> and >> >> >> >> confers no rights. >> >> >> >> > >> >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in >> >> message >> >> >> >> >news:161001c504ea$abd24630 $a401280a@phx.gbl... >> >> >> >> >> Hello, >> >> >> >> >> >> >> >> >> >> I have 2 cubes, one runs smootly and another >> one >> >> >> has an >> >> >> >> >> error message 'The query could not be >> processed : >> >> >> The >> >> >> >> >> data provider didn't supply any further error >> >> >> >> information' >> >> >> >> >> >> >> >> >> >> Anyone know how to solve it, please let me >> know. >> >> >> Your >> >> >> >> >> advice would be appreciated. >> >> >> >> >> >> >> >> >> >> Thank you and Have a nice day! >> >> >> >> >> >> >> >> >> >> Kit >> >> >> >> > >> >> >> >> > >> >> >> >> >. >> >> >> >> > >> >> >> > >> >> >> > >> >> >> >. >> >> >> > >> >> > >> >> > >> >> >. >> >> > >> > >> > >> >. >> > > > >.
Very strange. What is different about that cube? Other PCs can access it, but some can't. They are all running the same version of PTS (all ran the SP3 version of ptslite.exe from the SP3 distribution in the \msolap\install\pts folder). All are running the same version of OWC. I assume that all of these are on the same domain and the same user is accessing the cube -- you might check the security setups if this isn't the case. -- Dave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Kit" <Kit@discussions.microsoft.com> wrote in message news:201201c50cbe$db0e6380$a401280a@phx.gbl... > I can see and query other cubes except the cube that > returned the error. > > > >-----Original Message----- > >From the PCs that are getting errors, can you see and > query other cubes, > >e.g. Foodmart? Or is this error only being returned for > this one cube? > >-- > >Dave Wickert [MSFT] > >dwickert@online.microsoft.com > >Program Manager > >BI SystemsTeam > >SQL BI Product Unit (Analysis Services) > >-- > >This posting is provided "AS IS" with no warranties, and > confers no rights. > > > >"Kit" <Kit@discussions.microsoft.com> wrote in message > >news:1dab01c50a8c$6ceb5b30$a601280a@phx.gbl... > >> The errers returned when I "query" the cube on IE > (Pivot > >> Table) using OWC. > >> > >> > >> >-----Original Message----- > >> >Are the errors returned when you "process" the cube > >> using Analysis Manager > >> >or when you "query" the cube using OWC? > >> >-- > >> >Dave Wickert [MSFT] > >> >dwickert@online.microsoft.com > >> >Program Manager > >> >BI SystemsTeam > >> >SQL BI Product Unit (Analysis Services) > >> >-- > >> >This posting is provided "AS IS" with no warranties, > and > >> confers no rights. > >> > > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message > >> >news:047a01c50903$17876bf0$a401280a@phx.gbl... > >> >> Hi Dave, > >> >> > >> >> Sorry, I did not explain you clearly due to my > English > >> is > >> >> limited. Please let me to attempt to re-explain. > >> >> > >> >> 2 Cubes that I have are run under the same > database. I > >> >> don't have any special conditions. I accessed cubes > >> >> using Pivot Table on a client site. The first cube > has > >> >> been processed well. On the other hand, when I > tried > >> to > >> >> process the second cube, the error that is 'The > query > >> >> could not be processed : The data provider didn't > >> supply > >> >> any further error information' has been appeared. > >> >> > >> >> After that, I changed to other client pcs, there > are no > >> >> any errors for both cubes. > >> >> > >> >> All client pcs have been installed OWC10.exe, IE > >> Version > >> >> 6 as well as MS Office XP. And Cubes' Database Role > >> >> Manager in AM are set for Guests. > >> >> > >> >> Thank you for your assistance. > >> >> > >> >> Kit > >> >> > >> >> >-----Original Message----- > >> >> >In your original posting you said "I have 2 cubes, > one > >> >> runs smootly and > >> >> >another one has an error message 'The query could > not > >> be > >> >> processed : The > >> >> >data provider didn't supply any further error > >> >> information' > >> >> > > >> >> >Can you tell me more about the conditions when the > >> error > >> >> occurs on the > >> >> >second cube? > >> >> >For example, does the second cube return the same > >> error > >> >> regardless of what > >> >> >PCs query it? Can a PC which has an error on the > >> second > >> >> cube, can same PC > >> >> >query the first cube? > >> >> > > >> >> >-- > >> >> >Dave Wickert [MSFT] > >> >> >dwickert@online.microsoft.com > >> >> >Program Manager > >> >> >BI SystemsTeam > >> >> >SQL BI Product Unit (Analysis Services) > >> >> >-- > >> >> >This posting is provided "AS IS" with no > warranties, > >> and > >> >> confers no rights. > >> >> > > >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in > message > >> >> >news:2c2201c50819$8b16a990$a401280a@phx.gbl... > >> >> >> Hi Dave, > >> >> >> > >> >> >> Yes, they are running the same MDAC stack. > >> >> >> > >> >> >> I would like to tell you that all pcs that > process > >> the > >> >> >> same cube use Windows XP, Office XP (by Pivot > Table) > >> >> and > >> >> >> has installed OWC10 already. The trouble cube > can > >> be > >> >> >> viewed in other pcs normally. So, I'm not sure > some > >> >> >> configuration in OS has some discrepancy. Please > >> >> advice. > >> >> >> > >> >> >> Have a nice day, > >> >> >> > >> >> >> Kit > >> >> >> > >> >> >> > >> >> >> > >> >> >> >-----Original Message----- > >> >> >> >We can certainly load from SQL Server -- we do > it > >> all > >> >> of > >> >> >> the time. > >> >> >> >There must be some other configuration which is > >> >> >> different between the two. > >> >> >> >Are they running the same MDAC stack? > >> >> >> >Can you provide more specifics? > >> >> >> >-- > >> >> >> >Dave Wickert [MSFT] > >> >> >> >dwickert@online.microsoft.com > >> >> >> >Program Manager > >> >> >> >BI SystemsTeam > >> >> >> >SQL BI Product Unit (Analysis Services) > >> >> >> >-- > >> >> >> >This posting is provided "AS IS" with no > >> warranties, > >> >> and > >> >> >> confers no rights. > >> >> >> > > >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in > >> message > >> >> >> >news:17f301c50525$c6ca6950$a401280a@phx.gbl... > >> >> >> >> Hi Dave, > >> >> >> >> > >> >> >> >> The data source is SQL Server 2000. And the > OS > >> is > >> >> >> >> Windows Server 2003. > >> >> >> >> > >> >> >> >> Thank you. > >> >> >> >> > >> >> >> >> Kit > >> >> >> >> > >> >> >> >> >-----Original Message----- > >> >> >> >> >What is the data source for the cube that > >> returns > >> >> an > >> >> >> >> error? > >> >> >> >> >SQL Server 2000? Oracle? or what? > >> >> >> >> >-- > >> >> >> >> >Dave Wickert [MSFT] > >> >> >> >> >dwickert@online.microsoft.com > >> >> >> >> >Program Manager > >> >> >> >> >BI SystemsTeam > >> >> >> >> >SQL BI Product Unit (Analysis Services) > >> >> >> >> >-- > >> >> >> >> >This posting is provided "AS IS" with no > >> >> warranties, > >> >> >> and > >> >> >> >> confers no rights. > >> >> >> >> > > >> >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote > in > >> >> message > >> >> >> >> >news:161001c504ea$abd24630 > $a401280a@phx.gbl... > >> >> >> >> >> Hello, > >> >> >> >> >> > >> >> >> >> >> I have 2 cubes, one runs smootly and > another > >> one > >> >> >> has an > >> >> >> >> >> error message 'The query could not be > >> processed : > >> >> >> The > >> >> >> >> >> data provider didn't supply any further > error > >> >> >> >> information' > >> >> >> >> >> > >> >> >> >> >> Anyone know how to solve it, please let me > >> know.
Those cubes are built from the same database. Anyway, I will check the security setups and inform you the result. Dave, Thank you for your help. Kit [quoted text, click to view] >-----Original Message----- >Very strange. What is different about that cube? Other PCs can access it, >but some can't. They are all running the same version of PTS (all ran the >SP3 version of ptslite.exe from the SP3 distribution in the >\msolap\install\pts folder). All are running the same version of OWC. I >assume that all of these are on the same domain and the same user is >accessing the cube -- you might check the security setups if this isn't the >case. >-- >Dave Wickert [MSFT] >dwickert@online.microsoft.com >Program Manager >BI SystemsTeam >SQL BI Product Unit (Analysis Services) >-- >This posting is provided "AS IS" with no warranties, and confers no rights. > >"Kit" <Kit@discussions.microsoft.com> wrote in message >news:201201c50cbe$db0e6380$a401280a@phx.gbl... >> I can see and query other cubes except the cube that >> returned the error. >> >> >> >-----Original Message----- >> >From the PCs that are getting errors, can you see and >> query other cubes, >> >e.g. Foodmart? Or is this error only being returned for >> this one cube? >> >-- >> >Dave Wickert [MSFT] >> >dwickert@online.microsoft.com >> >Program Manager >> >BI SystemsTeam >> >SQL BI Product Unit (Analysis Services) >> >-- >> >This posting is provided "AS IS" with no warranties, and >> confers no rights. >> > >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >news:1dab01c50a8c$6ceb5b30$a601280a@phx.gbl... >> >> The errers returned when I "query" the cube on IE >> (Pivot >> >> Table) using OWC. >> >> >> >> >> >> >-----Original Message----- >> >> >Are the errors returned when you "process" the cube >> >> using Analysis Manager >> >> >or when you "query" the cube using OWC? >> >> >-- >> >> >Dave Wickert [MSFT] >> >> >dwickert@online.microsoft.com >> >> >Program Manager >> >> >BI SystemsTeam >> >> >SQL BI Product Unit (Analysis Services) >> >> >-- >> >> >This posting is provided "AS IS" with no warranties, >> and >> >> confers no rights. >> >> > >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in message >> >> >news:047a01c50903$17876bf0$a401280a@phx.gbl... >> >> >> Hi Dave, >> >> >> >> >> >> Sorry, I did not explain you clearly due to my >> English >> >> is >> >> >> limited. Please let me to attempt to re-explain. >> >> >> >> >> >> 2 Cubes that I have are run under the same >> database. I >> >> >> don't have any special conditions. I accessed cubes >> >> >> using Pivot Table on a client site. The first cube >> has >> >> >> been processed well. On the other hand, when I >> tried >> >> to >> >> >> process the second cube, the error that is 'The >> query >> >> >> could not be processed : The data provider didn't >> >> supply >> >> >> any further error information' has been appeared. >> >> >> >> >> >> After that, I changed to other client pcs, there >> are no >> >> >> any errors for both cubes. >> >> >> >> >> >> All client pcs have been installed OWC10.exe, IE >> >> Version >> >> >> 6 as well as MS Office XP. And Cubes' Database Role >> >> >> Manager in AM are set for Guests. >> >> >> >> >> >> Thank you for your assistance. >> >> >> >> >> >> Kit >> >> >> >> >> >> >-----Original Message----- >> >> >> >In your original posting you said "I have 2 cubes, >> one >> >> >> runs smootly and >> >> >> >another one has an error message 'The query could >> not >> >> be >> >> >> processed : The >> >> >> >data provider didn't supply any further error >> >> >> information' >> >> >> > >> >> >> >Can you tell me more about the conditions when the >> >> error >> >> >> occurs on the >> >> >> >second cube? >> >> >> >For example, does the second cube return the same >> >> error >> >> >> regardless of what >> >> >> >PCs query it? Can a PC which has an error on the >> >> second >> >> >> cube, can same PC >> >> >> >query the first cube? >> >> >> > >> >> >> >-- >> >> >> >Dave Wickert [MSFT] >> >> >> >dwickert@online.microsoft.com >> >> >> >Program Manager >> >> >> >BI SystemsTeam >> >> >> >SQL BI Product Unit (Analysis Services) >> >> >> >-- >> >> >> >This posting is provided "AS IS" with no >> warranties, >> >> and >> >> >> confers no rights. >> >> >> > >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in >> message >> >> >> >news:2c2201c50819$8b16a990$a401280a@phx.gbl... >> >> >> >> Hi Dave, >> >> >> >> >> >> >> >> Yes, they are running the same MDAC stack. >> >> >> >> >> >> >> >> I would like to tell you that all pcs that >> process >> >> the >> >> >> >> same cube use Windows XP, Office XP (by Pivot >> Table) >> >> >> and >> >> >> >> has installed OWC10 already. The trouble cube >> can >> >> be >> >> >> >> viewed in other pcs normally. So, I'm not sure >> some >> >> >> >> configuration in OS has some discrepancy. Please >> >> >> advice. >> >> >> >> >> >> >> >> Have a nice day, >> >> >> >> >> >> >> >> Kit >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >-----Original Message----- >> >> >> >> >We can certainly load from SQL Server -- we do >> it >> >> all >> >> >> of >> >> >> >> the time. >> >> >> >> >There must be some other configuration which is >> >> >> >> different between the two. >> >> >> >> >Are they running the same MDAC stack? >> >> >> >> >Can you provide more specifics? >> >> >> >> >-- >> >> >> >> >Dave Wickert [MSFT] >> >> >> >> >dwickert@online.microsoft.com >> >> >> >> >Program Manager >> >> >> >> >BI SystemsTeam >> >> >> >> >SQL BI Product Unit (Analysis Services) >> >> >> >> >-- >> >> >> >> >This posting is provided "AS IS" with no >> >> warranties, >> >> >> and >> >> >> >> confers no rights. >> >> >> >> > >> >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote in >> >> message >> >> >> >> >news:17f301c50525$c6ca6950 $a401280a@phx.gbl... >> >> >> >> >> Hi Dave, >> >> >> >> >> >> >> >> >> >> The data source is SQL Server 2000. And the >> OS >> >> is >> >> >> >> >> Windows Server 2003. >> >> >> >> >> >> >> >> >> >> Thank you. >> >> >> >> >> >> >> >> >> >> Kit >> >> >> >> >> >> >> >> >> >> >-----Original Message----- >> >> >> >> >> >What is the data source for the cube that >> >> returns >> >> >> an >> >> >> >> >> error? >> >> >> >> >> >SQL Server 2000? Oracle? or what? >> >> >> >> >> >-- >> >> >> >> >> >Dave Wickert [MSFT] >> >> >> >> >> >dwickert@online.microsoft.com >> >> >> >> >> >Program Manager >> >> >> >> >> >BI SystemsTeam >> >> >> >> >> >SQL BI Product Unit (Analysis Services) >> >> >> >> >> >-- >> >> >> >> >> >This posting is provided "AS IS" with no >> >> >> warranties, >> >> >> >> and >> >> >> >> >> confers no rights. >> >> >> >> >> > >> >> >> >> >> >"Kit" <Kit@discussions.microsoft.com> wrote >> in >> >> >> message
Hi, I am also running with the same issue.It is working fine most of the PCs but failing in only one PC with the same error. But when i have try to access same cube in Excel it works fine. Any solution?? Thanks Robert --
Don't see what you're looking for? Try a search.
|
|
|