Connection error in Information Design Tool

[Former Member]

Hi all,

I have problem in Information design Tool to create connection and successfully refresh data  from MS excel.

I have 64 bit PC, but 32 bit MS Office.

I create System DSN through 32 bit odbcad32.exe (version Excel 12.0 and selected appropriate workbook - xlsx file)

In IDT, I created new project a then new Relational connection. I selected Microsoft - MS Excel 2013 - ODBC Drivers.

Then I select created Data Source name. Test connection is successful.

But in Show values Tab, when I press Refresh button, following error is shown

Error occurred in refresh.

[Microsoft][ODBC Excel Driver]Invalid use of null pointer

Details:

Error:

Error while refreshing the data provider.

Cause of Error

[Microsoft][ODBC Excel Driver]Invalid use of null pointer

Any idea how can I solve it?

Thank you.

Best regards,

Martin Laurinec

[former_member205064]

Hi Martin,

I was able to create UNX Universe successfully by following these steps:-

1.Odbc should be 32bit for IDT

created from location c:\Windows\SysWOW64\odbcad32.exe

2.Create relation connection in IDT select

Microsoft excel ->Odbc,

Test connection ->successfull.

3.Create Data Foundation over your Connection.

Insert Table from the selected connection.

save the Data Foundation.

4.Create Business Layer on Data Foundation.

create a query to check if the data is getting pouplated from Excel.

[Former Member]

Hi Reunak,

thanks for your reply.

I did exactly the steps you mention in 1. and 2.

But then in Connection - Show values tab I see error message after I click Refresh button.

So in Data Foundation, I can't insert any table from my Connection.

Best regards,

Martin Laurinec

[former_member205064]

try creating a universe on a simple excel file, i.e. excel should not have lots of data, for test purpose.

could be the issue with the particular excel file.

[Former Member]

Of course, I try it with really simple excel 10 rows, 4 columns...

But still the same error message

[Former Member]

Hi Martin,

Can you share that excel file with us?

~Swapnil

[Former Member]

sure, just for test connection, I create this excel...

[Former Member]

Hi Martin,

Does this file have the blank cells? If yes then can we try by removing them?

~Swapnil

[Former Member]

Hi Swapnil,

file has filled cells in the picture, other cells are blank.

That shouldn't be a point I think.

[Former Member]

Hi Martin,

I believe there must be something wrong with your excel file. Raunak has tested this and it has worked for him in the first go.

I thought perhaps that PDBC is not allowing null values in the excel file.

Can we trace IDT for this work flow? Please follow the KBA: 1586166 - How to enable tracing for BI4.x client applications and provide the logs.

~Swapnil

[Former Member]

Hi Martin,

One more test would be helpful for you, test the same workflow on any other machine.

Logs will help us to understand what exactly is going wrong in the background.

~Swapnil

[Former Member]

Hi,

I provide trace from IDT file

InformationDesignTool_8748_2015_11_27_13_06_03_698_trace.glf

FILE_TYPE:DAAA96DE-B0FB-4c6e-AF7B-A445F5BF9BE2

ENCODING:UTF-8

RECORD_SEPARATOR:30

COLUMN_SEPARATOR:124

ESC_CHARACTER:27

COLUMNS:Location|Guid|Time|Tzone|Trace|Log|Importance|Severity|Exception|DeviceName|ProcessID|ThreadID|ThreadName|ScopeTag|MajorTick|MinorTick|MajorDepth|MinorDepth|RootName|RootID|CallerName|CallerID|CalleeName|CalleeID|ActionID|DSRRootContextID|DSRTransaction|DSRConnection|DSRCounter|User|ArchitectComponent|DeveloperComponent|Administrator|Unit|CSNComponent|Text

SEVERITY_MAP: |None| |Success|W|Warning|E|Error|A|Assertion

HEADER_END

tracemgr.cpp:358:void __thiscall TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 1

|da258807-05c0-b604-a922-987c9775a356|2015 11 27 14:06:03:700|+0100|Error| |==|E| |InformationDesignTool| 8748|6656|| |0|0|0|0|-|-|-|-|-|-|||||||||||| |ODBC |MS Excel 2013 |JobId:1152831864 |ENTER SQLGetDiagRec

        SQLSMALLINT    3

        SQLHANDLE    0x42598238

        SQLSMALLINT    1

        SQLTCHAR *    0x46A1F12C

        SQLINTEGER *    0x46A1ECB0

        SQLTCHAR *    0x46A1ED28

        SQLSMALLINT    513

        SQLSMALLINT *    0x46A1ECC8

tracemgr.cpp:358:void __thiscall TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 2

|5213c76a-7599-04d4-9aff-abe31b77b379|2015 11 27 14:06:03:701|+0100|Error| |==|E| |InformationDesignTool| 8748|6656|| |0|0|0|0|-|-|-|-|-|-|||||||||||| |ODBC |MS Excel 2013 |JobId:1152831864 |EXIT SQLGetDiagRec with return code 0 (SQL_SUCCESS)

        SQLSMALLINT    3

        SQLHANDLE    0x42598238

        SQLSMALLINT    1

        SQLTCHAR *    0x46A1F12C [HY009]

        SQLINTEGER *    0x46A1ECB0 (70)

        SQLTCHAR *    0x46A1ED28 [[Microsoft][ODBC Excel Driver]Invalid use of null pointer ]

        SQLSMALLINT    513

        SQLSMALLINT *    0x46A1ECC8 (58)

tracemgr.cpp:358:void __thiscall TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 3

|81909cdc-3f6c-b044-a94a-1e61af9055ba|2015 11 27 14:06:03:703|+0100|Error| |==|E| |InformationDesignTool| 8748|6656|| |0|0|0|0|-|-|-|-|-|-|||||||||||| |ODBC |MS Excel 2013 |JobId:1152831864 |ENTER SQLGetDiagRec

        SQLSMALLINT    3

        SQLHANDLE    0x42598238

        SQLSMALLINT    2

        SQLTCHAR *    0x46A1F12C

        SQLINTEGER *    0x46A1ECB0

        SQLTCHAR *    0x46A1ED28

        SQLSMALLINT    513

        SQLSMALLINT *    0x46A1ECC8

tracemgr.cpp:358:void __thiscall TraceManager::Trace::FlushToTrace(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,enum ITraces::Level): TraceLog message 4

|45cc1e0c-8630-4734-7b03-f6783fdd2276|2015 11 27 14:06:03:704|+0100|Error| |==|E| |InformationDesignTool| 8748|6656|| |0|0|0|0|-|-|-|-|-|-|||||||||||| |ODBC |MS Excel 2013 |JobId:1152831864 |EXIT SQLGetDiagRec with return code 100(SQL_NO_DATA)

        SQLSMALLINT    3

        SQLHANDLE    0x42598238

        SQLSMALLINT    2

        SQLTCHAR *    0x46A1F12C [HY009]

        SQLINTEGER *    0x46A1ECB0 (70)

        SQLTCHAR *    0x46A1ED28 [[Microsoft][ODBC Excel Driver]Invalid use of null pointer ]

        SQLSMALLINT    513

        SQLSMALLINT *    0x46A1ECC8 (58)

csgenjob.cpp:990:void __thiscall CSCore::GenericJob::Prepare(const class bo_utf8string &): TraceLog message 5

|2afc29ac-95b6-7df4-89e3-b6cca874a60c|2015 11 27 14:06:03:705|+0100|Error| |>=|E|X|InformationDesignTool| 8748|6656|| |0|0|0|0|-|-|-|-|-|-||||||||||||Uncaught Exception in SilentScope: CS::DBDriver_Prepare: 0.007

Error=[Microsoft][ODBC Excel Driver]Invalid use of null pointer 

csgenjob.cpp:987:void __thiscall CSCore::GenericJob::Prepare(const class bo_utf8string &): TraceLog message 6

|791ffd0f-4b2b-05b4-3bb6-3aec567003bc|2015 11 27 14:06:03:706|+0100|Error| |>=|E|X|InformationDesignTool| 8748|6656|| |0|0|0|0|-|-|-|-|-|-||||||||||||Uncaught Exception in SilentScope: CS::GenericJob_Prepare: 0.008

Error=[Microsoft][ODBC Excel Driver]Invalid use of null pointer 

csjob.cpp:920:enum ConnectionServer::Status __thiscall CSCore::OpenJob::Describe(const class bo_utf8string &,class ConnectionServer::DescriptionSet &) throw(class ConnectionServer::Error,class std::exception): TraceLog message 7

|c8e32d17-1524-7774-891c-3096f843b1fa|2015 11 27 14:06:03:707|+0100|Error| |>=|E|X|InformationDesignTool| 8748|6656|| |0|0|0|0|-|-|-|-|-|-||||||||||||Uncaught Exception in SilentScope: CS::OpenJob_Describe: 0.009

Error=[Microsoft][ODBC Excel Driver]Invalid use of null pointer