topic Re: Error Help! in QlikView

Error Help!

amit_saini — Mon, 16 Mar 2015 04:34:58 GMT

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,

Re: Error Help!

simsondevadoss — Mon, 16 Mar 2015 05:01:39 GMT

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

Re: Error Help!

PrashantSangle — Mon, 16 Mar 2015 05:03:59 GMT

Hi,

Is this your complete script??

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

Regards

Re: Error Help!

avinashelite — Mon, 16 Mar 2015 05:22:13 GMT

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!

rwunderlich — Mon, 16 Mar 2015 06:04:21 GMT

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

-Rob

Re: Error Help!

amit_saini — Mon, 16 Mar 2015 06:09:25 GMT

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