Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Why no error message when execute SP failed?

Dear Experts,

I found a strange behavior when reloading my QV file.

I made a typo about a stored procedure name, so of course there no line fetched by that stored procedure (you can simply regard this scenario as: there's no such sp exists in the connected db).

But my point is, there is no error message popped out when reloading, neither anything logged down in the log file.

Is this a product bug or did I missed setting any options?

Thanks in advance.

Patrick

14 Replies
Sokkorn
Master
Master

Hi Patrick,

Let debug together by create new QlikView document and use only one script SQL exec db.dbo.spName; then see what happen after we reload script.

Regards,

Sokkorn

Not applicable
Author

Hi Sokkorn,

I've tried these scenario and more, but QV just doesn't regard SP failure as an error.

I wonder if this really is a bug.

Patrick

Sokkorn
Master
Master

Hi Patrick,

It can be a bug. Anyhow, we may contact support@qlik.com or Ms. Sara Leslie can clarify on this.

Regards,

Sokkorn

Not applicable
Author

Hi Sokkorn,

Thank you very much.

I'll report this and post the result if there's any solution or explanation.

Patrick

Sokkorn
Master
Master

Thank Patrick. Keep post here to let me and everyone know

Regards,

Sokkorn