Error Help!

[amit_saini]

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

[simsondevadoss]

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

[PrashantSangle]

Hi,

Is this your complete script??

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

Regards

[avinashelite]

Hi Amit,

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

[rwunderlich]

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

-Rob

[amit_saini · Accepted solution]

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