Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
SunilChauhan
Champion II
Champion II

its not showing any output-Stored procedure

connection string

Load *;

SQl execute precedurename;

it s running and showing script line error.

its not showing any output

hope some one help me?

Sunil Chauhan
10 Replies
tresesco
MVP
MVP

How does the error message look like?

SunilChauhan
Champion II
Champion II
Author

Thanks for your reply

Error: Script line error:

Sunil Chauhan
tresesco
MVP
MVP

Which line? could you post a screenshot?

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

If you would like help debugging script code, it would help to post the script code so that we are not all just guessing. The actual code, not just pseudocode

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
SunilChauhan
Champion II
Champion II
Author

01/07/2014 07:19:11:      Execution started.

01/07/2014 07:19:11: 0025  load *

01/07/2014 07:19:11: 0027  SQL

01/07/2014 07:19:11: 0028

01/07/2014 07:19:11: 0029  EXEC [spr_Employee]

01/07/2014 07:19:11: 0034  exit script

01/07/2014 07:19:11:       Error: Script line error:

01/07/2014 07:19:14:      Execution finished.

Sunil Chauhan
tresesco
MVP
MVP

EXEC or Execute ?

SunilChauhan
Champion II
Champion II
Author

tried both

still not working

Sunil Chauhan
tresesco
MVP
MVP

Doesn't your procedure expect any parameters to be passed? You are not passing any!

jonathandienst
Partner - Champion III
Partner - Champion III

That's the log. Please include the code.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein