SQL Error when Loading a qvd from qvw

[#1]

Hi ,

I am a qlikview novice and I would need your suggestion.In one of our reports. We are using a qvw file which internally creates a temporary table and then inserts the records of the temp table into a sales table.

When I execute the load ,the load happens for sometimes and then an error pops up which says

"SQL State:07002,Errorcode:32, ErrorMsg: The # of binded parameters <the # of the parameters markers

The interesting part is when I change the database connection from production to quality and development , the load happens properly. I am not sure why this is happening only in production environment.

Any help in this matter would be appreciated.

Thanks,

Abhay

[rwunderlich]

You are INSERTing data from Qlikview into a SQL table using a "SQL INSERT ..." statement? What database server?

-Rob

[#3]

Hi Rob,

Thanks for the prompt response. The database server we are using is Greenplum.

Thanks,

Abhay

[djsampat]

Please upload a sample QVW file or the script.

From what you have mentioned, it would be advisable to set your script to get all the data from multiple tables and then use Resident Load to create your Combined Fact table and then you can drop your temp tables.

Alternatively, you can load all the information into qvd files with required data and then create your fact table.

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

If you are viewing this topic and found it informative, please like my comment.

Regards

Dhruv

[rwunderlich]

I just want to confirm that you are INSERTing back into the GreenPlum database? The reason I ask is that 99.99% of users have never used Qlikview to update a SQL database. It's an unusual case. I just want to confirm that you trying to update SQL, not trying to create a Qlikview in memory table or QVD.

-Rob

[#6]

Hi Rob,

My apologies. I am trying to insert data into qvd.

Thanks,

Abhay

[jagan]

Hi,

Check this thread hope it helps you.

Inserting records into Database using Qlikview Script

Regards,

Jagan.

[#8]

The following is a simple example of how you would read data from your SQL Server and then save the data that you've read into a QVD file that you can reuse by other QVW's.

Step 1: Use the Connect wizard to create the connection to your database.

Step 2: Load the data

TableSizes:
LOAD DatabaseName,
IndexName,
"Measured_Date",
NumberRows,
ServerName,
TableName;
SQL SELECT DatabaseName,
IndexName,
"Measured_Date",
NumberRows,
ServerName,
TableName
FROM ServerDatabaseSizes.dbo.TableSizes
where ServerName = 'DB1'
and DatabaseName = 'NotifyXP';

Step 3: Save the table you loaded into the desired QVD

Store TableSizes into TableSizes.qvd (QVD);

STORE is the keyword you want to search on in the QlikView help to understand more about the options.

Hope this helps you out.

[#9]

Thanks Dalton. The place where the script is failing is :

SQL State:07002,Errorcode:32, ErrorMsg: The # of binded parameters <the # of the parameters markers

sql

sql   create temp table Nirvana_Cancel as

Select

Extract(Month From Air_Itinerary.Cancelation_Date) BOOKEDMONTH

,Extract(Year From Air_Itinerary.Cancelation_Date) BOOKEDYEAR

,Dim_DemandChain.dmdchainposcode as AGENCYCODE

...........................................................................................

..............................................................

Any clue why this would happen?

Thanks,

Abhay

[#10]

Thanks Dhruv. The place where the script is failing is :

SQL State:07002,Errorcode:32, ErrorMsg: The # of binded parameters <the # of the parameters markers

sql

sql   create temp table Nirvana_Cancel as

Select

Extract(Month From Air_Itinerary.Cancelation_Date) BOOKEDMONTH

,Extract(Year From Air_Itinerary.Cancelation_Date) BOOKEDYEAR

,Dim_DemandChain.dmdchainposcode as AGENCYCODE

...........................................................................................

..............................................................

Any clue why this would happen?

Thanks,

Abhay