Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amit_saini
Honored Contributor III

Error Help!

Folks,

Could you please help me with below error:

SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

[Supplier Development Pipeline]:

SQL SELECT

`Global Supplier Number` as [%Supplier_GSN],

`Action closed date`,

    `Action need ref`,

    `Action Status`,

    `Action target date`,

    `Activity complete date`,

    `Activity start date`,

    `calendar desc`,

    Comments,

     `Date need identified`,

    `Development Action`,

    `Development Area`,

    `Development Concern/comments`,

    `Development Need (SMART)`,

    `Development need ref`,

    `Development priority`,

    `Development Status`,

    `Development target date`,

    `Development timescale`,

    `Global Supplier Number`,

    `Key Performance Indicator & target`,

    `KPI met?`,

     `Monitor KPI's until date`,

     Region,

    `SBD Lead`,

    Supplier

FROM `Supplier Development Pipeline`

Thanks,

AS

1 Solution

Accepted Solutions
amit_saini
Honored Contributor III

Re: Error Help!

Thanks u guys for your suggestion. I think I got the issue.

This issue exist because current table having different fields name and at script side they are different.

Thanks,
AS

5 Replies
simsondevadoss
Contributor III

Re: Error Help!

Its due to ODBC read failed. Please check the ODBC connection

Re: Error Help!

Hi,

Is this your complete script??

there is no error in script, Are you using any conactenate or join or group by clause ???

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Error Help!

Hi Amit,

I think one of the table syntax is written wrong I guess, please check the table syntax withe parameter if any.

Re: Error Help!

Is Supplier Development Pipeline an actual table or a Query? If a Query, does the Query expect input parameters?

-Rob

amit_saini
Honored Contributor III

Re: Error Help!

Thanks u guys for your suggestion. I think I got the issue.

This issue exist because current table having different fields name and at script side they are different.

Thanks,
AS

Community Browser