SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Wrong number of parameters;270 not enough values
Environment:
6.6 integrated with SAP
Symptoms:
Customer was not able to install iVend addon due to error in Addon log file “SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Wrong number of parameters;270 not enough values:”
Problem Statement:
At the time of installing iVend Addon on SAP error was coming add-on Failed to update the database.
Resolution/Work Around:
Analyzed the addon log file and it displayed the error :
User :manager, Method :Main, Error Message :1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Wrong number of parameters;270 not enough values: 'N': line 1 col 64 (at pos 63)
Date :18-Jul-18 1:17:10 PM.
------------------------------------------------------------------------------------------
User :manager, Method :, Error Message :DataBase Script Running at , Date :18-Jul-18 1:25:29 PM.
------------------------------------------------------------------------------------------
User :manager, Method :InsertDataInAlertsSetup, Error Message :1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Wrong number of parameters;270 not enough values: 'N': line 1 col 64 (at pos 63)
Date :18-Jul-18 1:25:33 PM.
------------------------------------------------------------------------------------------
User :manager, Method :HandleB1AlertsTables, Error Message :1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Wrong number of parameters;270 not enough values: 'N': line 1 col 64 (at pos 63)
Date :18-Jul-18 1:25:33 PM.
------------------------------------------------------------------------------------------
User :manager, Method :Main, Error Message :1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Wrong number of parameters;270 not enough values: 'N': line 1 col 64 (at pos 63)
Date :18-Jul-18 1:25:33 PM.
Suggested to open the SAPB1 and remove the field CXSUser as per below screenshot and then check iVend addon
Reference Screenshot :
Recommendations /Suggestion:
Suggested to check the addon log file for detail error.
Related Articles
Error in Tax Code Setup [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;339 invalid number
************************* INTERNAL PURPOSE **************************** The article is about the approach to trace /troubleshoot the error coming in SAP Environment : iVend Version 6.6.7989 SAP B1 9.3 Problem Statement: Facing issue in creating the ...Integration ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;339 invalid number:
****************************** INTERNAL ARTICLE ******************************* Product version 6.6 integrated with Sap B1 Purpose The purpose of this document is to resolve the error in SAP B1 Integration for HANA. Problem statement Record stucked ...When starts the addon error getting and showing 'ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC]
Environment iVend Version 6.6 Problem Statement iVend Integration service log displays the error ,how ever iVend Service is getting updated successfully. iVend Integration service log displays the error : 'error message : SBO : Connection Error : ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...