oracle bi 12c cannot query data from mssql PDW

radityo

hi experts,

i have some issue when connecting BI 12c to MSSQL PDW.

I'm choose technology mssql 2012 and ODBC 3.5 on connection pool.

I'm able to importing metadata  (table, view etc)

but it failed when i tried to view data. the error is 'NQSError:10058 General error has occurred.

I'm using oracle Linux OS.

i already tried this kind of setting to connect to another DB (MS SQL 2012), and it works.

does anybody here know the solutions?

ps: i try to use windows server and it works (using SQL Server Native driver, not Data Direct)

thanks

RS

rmoff

Have you set up the ODBC correctly on the Linux server?

Once you deploy the RPD / if you're working online, it'll work for import metadata using your local Windows DSN, but when you query the data it does it from the BI Server - which if it's running on Linux needs to have the necessary ODBC config.

Check the the obis1-query.log for details of the actual error you're hitting -- "NQSError:10058 General error has occurred." is just the first of the error stack. This post, whilst it goes way off into internals, may be useful to explain more to you about how ODBC works on Linux, and general troubleshooting.

radityo

hi rmoff,

thank for reply,

the odbc setting in server is correct, since i can query from MSSQL 2012.

except there is different approach for MSSQL PDW.

actually PDW is MS SQL 2014.

may be you have experience on this

regards,

tyo

rmoff

Did you check the log file?

And just because one ODBC connection is right, it doesn't necessarily follow that the other would be.

radityo

hi,

i found this in my admin tool log

[2016-08-24T16:36:58.644+07:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 3308]  [nQSError: 43113] Message returned from OBIS. [[

file: server\NQSODBC\NQSODBC35\Src\NQSOdbcHandleManager.cpp; line: 515

[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.

[nQSError: 16001] ODBC error state: 01000 code: 5703 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed language setting to us_english..

[nQSError: 16001] ODBC error state: 01000 code: 5701 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed database context to 'dm_sldk'..

[nQSError: 16001] ODBC error state: S1000 code: 104409 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Setting QuotedIdentifier to 'OFF' is not supported..

]]

nothing in obis1-query.log.

but in obis1-diagnostic.log i saw this message :

[2016-08-24T16:59:54.359+07:00] [OBIS] [ERROR:1] [] [] [ecid: 005EgtNmdeJFw00Fzzx0g0000EBr000Mw4,0:1] [sik: ssi] [tid: bbbfb700]  [nQSError: 16001] ODBC error state: S1000 code: 104409 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Setting QuotedIdentifier to 'OFF' is not supported.. [[

file: server/Query/Execution/DbGateway/Odbc35/../Odbc/Src/SQXDGOdbcConnection.cpp; line: 983

Properties: description=ExecutePhysical Exchange; producerID=0xed8088c0; requestID=0xb4ea0002; sessionID=0xb4ea0000; userName=weblogic;

[nQSError: 16001] ODBC error state: 01000 code: 5701 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed database context to 'dm_sldk'..

[nQSError: 16001] ODBC error state: 01000 code: 5703 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed language setting to us_english..

many thanks for your help.

regards,

tyo

rmoff

[SQL Server]Setting QuotedIdentifier to 'OFF' is not supported

That looks like the issue. I'm not so familiar with SQL Server but this makes it look like PDW won't accept it being OFF.

https://msdn.microsoft.com/en-GB/library/ms174393.aspx?f=255&MSPPError=-2147217396