topic Re: Varable Value not loaded correctly into INLINE table in QlikView

Varable Value not loaded correctly into INLINE table

sreenivaskollur — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm new to QlikView development, could someone help me to fix this issue?

I'm using the below script to capture the error details if the hive connection is failed.

Sample script,

ODBC CONNECT TO [HIVE-DB];

LET vCapturedError=ScriptErrorDetails;

TRACE $(vCapturedError);

LOAD * INLINE [

DB, Connection_Status, Error

HIVE-DB, Failed, '$(vCapturedError)'

];

If I trace a variable vCapturedError, it shows the output as below, which the actual error:

SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

But when I read the same variable value in LOAD * INLINE table, it is just loading a piece of it as:

'SQL##f - SqlState: IM002

Please help to fix it?

Your help is much appreciated, thank you!

Re: Varable Value not loaded correctly into INLINE table

sunny_talwar — Mon, 30 Jan 2017 01:28:30 GMT

Change the delimiter from Comma to a pipe. Because delimiter is comma, the data up until comma is read in that field.....

ODBC CONNECT TO [HIVE-DB];

LET vCapturedError=ScriptErrorDetails;

TRACE $(vCapturedError);

LOAD * INLINE [

DB | Connection_Status | Error

HIVE-DB | Failed | '$(vCapturedError)'

] (delimiter is |);

Re: Varable Value not loaded correctly into INLINE table

vishsaggi — Mon, 30 Jan 2017 01:29:28 GMT

Try this if this may work for you?

ODBC CONNECT TO [HIVE-DB];

LET vCapturedError = ScriptErrorDetails;

TRACE $(vCapturedError);

LOAD *, '$(vCapturedError)' as Error INLINE [

DB, Connection_Status

HIVE-DB, Failed

];

Re: Varable Value not loaded correctly into INLINE table

sunny_talwar — Mon, 30 Jan 2017 01:29:52 GMT

Or you can also use double quotes around your variable

ODBC CONNECT TO [HIVE-DB];

LET vCapturedError=ScriptErrorDetails;

TRACE $(vCapturedError);

LOAD * INLINE [

DB, Connection_Status, Error

HIVE-DB, Failed, "$(vCapturedError)"

];

Re: Varable Value not loaded correctly into INLINE table

vishsaggi — Mon, 30 Jan 2017 01:33:48 GMT

Hi Sunny, I used your inline but it still truncates data after comma? It is not giving me full text?

Re: Varable Value not loaded correctly into INLINE table

sunny_talwar — Mon, 30 Jan 2017 01:36:51 GMT

This one too?

ODBC CONNECT TO [HIVE-DB];

LET vCapturedError=ScriptErrorDetails;

TRACE $(vCapturedError);

LOAD * INLINE [

DB | Connection_Status | Error

HIVE-DB | Failed | '$(vCapturedError)'

] (delimiter is |);

Re: Varable Value not loaded correctly into INLINE table

vishsaggi — Mon, 30 Jan 2017 02:17:52 GMT

Nope i just copy pasted the whole script still it shows truncated script. Is it working at your end?

Re: Varable Value not loaded correctly into INLINE table

sunny_talwar — Mon, 30 Jan 2017 02:21:42 GMT

I guess the square brackets were the next set of issue... but this worked

LET vCapturedError='SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified';

TRACE $(vCapturedError);

LOAD * INLINE "

DB | Connection_Status | Error

HIVE-DB | Failed | '$(vCapturedError)'

" (delimiter is |);

So this should work for OP

ODBC CONNECT TO [HIVE-DB];

LET vCapturedError=ScriptErrorDetails;

TRACE $(vCapturedError);

LOAD * INLINE "

DB | Connection_Status | Error

HIVE-DB | Failed | '$(vCapturedError)'

" (delimiter is |);

Re: Varable Value not loaded correctly into INLINE table

vishsaggi — Mon, 30 Jan 2017 12:39:45 GMT

Cool. This worked. Did not know about this double quotes in INLINE. Thanks for trying this.

Re: Varable Value not loaded correctly into INLINE table

sunny_talwar — Mon, 30 Jan 2017 12:48:47 GMT

Absolutely

Re: Varable Value not loaded correctly into INLINE table

sreenivaskollur — Mon, 30 Jan 2017 15:28:09 GMT

Thank you Sunny. This works.

Re: Varable Value not loaded correctly into INLINE table

sreenivaskollur — Mon, 30 Jan 2017 15:30:00 GMT

Thank you Vishwanath. I tried both the ways that Sunny and you had suggested. Both are working great.