Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Thank you Sunny. This works.
Thank you Vishwanath. I tried both the ways that Sunny and you had suggested. Both are working great.