question

HARBILASBAL-6065 avatar image
0 Votes"
HARBILASBAL-6065 asked LukasYu-msft commented

Error processing ssas dimension

Hi,

I have ssas cube with one dimension pointing to SQL server. When I try to process this dim in SSDT 2015, I am constantly getting below error.

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: [500] Could not execute the specified command: Input string was not in a correct format.;Input string was not in a correct format.
Input string was not in a correct format..
SQL queries
SELECT
DISTINCT
[dbo_Users].[dbo_UsersLoginID0_0] AS [dbo_UsersLoginID0_0]
FROM
OPENROWSET
(
N'SQLNCLI11.1',
N'',
N'
SELECT [LoginID] AS [dbo_UsersLoginID0_0]
FROM
(
SELECT VendorUserID, LoginID
FROM dbo.Users_Macys
)
AS [Users_Macys] '
)
AS [dbo_Users]

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft edited

Hi ,

Have you exam the the query in your SSMS enviroment to see if the query could run?

I think the query has missed the second arguement for openrowset function ,that should be { 'datasource' ; 'user_id' ; 'password' | 'provider_string' } ? You could check and exam the OPENROWSET fuction at MS Doc: OPENROWSET (Transact-SQL)


Regards,
Lukas


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HARBILASBAL-6065 avatar image
0 Votes"
HARBILASBAL-6065 answered

Hi,

I have simply build dimension from view in data source view. But when I process the dimension, I am getting this error.

Actually, the openrowset SQL is embedded in the error. I haven't build it manually.


95914-image.png



image.png (20.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

It looks like an error raised by the database engine. What datasource are you using ? Was other dimension processed correctly? Could this table be viewed in database engine ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HARBILASBAL-6065 avatar image
0 Votes"
HARBILASBAL-6065 answered LukasYu-msft commented

The issue was that if there are 2 data sources (DS) in ssas, one of the DS is made primary. Now, the data source view (DSV) can have tables from both DS but later the dimensions cant be processed because it tries to set up linked server queries between 2 DS.
So, I had to have single DS, single DSV and then process dim. Then it does not need to have linked server queries.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So, I had to have single DS, single DSV and then process dim. Then it does not need to have linked server queries.


I am not aware that 2 DS are required to be linked server. Did you solve the problem by implying this solution?

0 Votes 0 ·

Yes, the problem was solved.

0 Votes 0 ·

Thanks for your feedback, you could mark your solution as answer so other people could view and benifit from it.

0 Votes 0 ·