Doing a POC and received the following error when starting a collection:
Collection Service failed to process discovery collection. PreparedStatementCallback; bad SQL grammar call updateElement(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect number of arguments for PROCEDURE smsdb.updateElement; expected 18, got 17
Anyone encounter this before? Additional troubleshooting steps I should take?
In above file please check number of parameters for the procedure "updateElement". On fresh installation it is showing 17 but on customer balance according to error it is saying 18. Can you please check and verify it? And if it is still showing 18 instead of 17 then can you please arrange a webex with customer? So we can take a look at balance and figure it out the issue.
I was onsite with the customer yesterday. The were unable to log into the system (couldn't remember the user name and password). What is the default user name and password upon installation? Is there a password recovery procedure?
Working with Phil Bachman our local CSE for Balance I have scheduled a WebEx session with the customer tomorrow to get beyond the above issue of login. Please let me know ASAP if there is a faster or better way to resolve the above issue to get you the data you previously asked for about the SQL error.