on 2024 Sep 26 4:24 PM
SQL Anywhere 17 MobiLink comm server sync error: We randomly see this error when we setup a new user and sometimes with existing users, we get this error during sync and it takes several minutes to drop the failed sync.
<Main> [-10002] Consolidated database server or ODBC error: ODBC: [SAP][SQL Anywhere - Oracle][Oracle]ORA-06553: PLS-306: wrong number or types of arguments in call to 'ML_GET_BLOCKED_INFO'
This appears internal to MobiLink code. We are currently upgrading from Sybase 9 to SQL Anywhere 17 if this somehow resulted in the error as the parameters to ML_GET_BLOCKED_INFO are different between the two versions. This doesn't explain how it works most of the time and fails some of the time though.
The error repeats until manual intervention is taken. It appears that restarting the database and Mobilink service(s) clears the error, but this is not an acceptable fix in our client's production systems. We see the error on two users yesterday and restarting the database and rebooting the comm server does not clear the error on both users.
The ML_GET_BLOCKED_INFO error indicates "wrong number or types of arguments in call to 'ML_GET_BLOCKED_INFO'" so what would be calling it with the wrong number of parameters? Under our Sybase 9 schema (FAST) there is no ML_GET_BLOCKED_INFO but I could've sworn I saw one with only two parameters whereas the Sybase 17 version has two paramters.
Just curoius as to what's up with the wrong number of parameters, as well as everything else.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It sounds possible that after the upgrade, the procedure definition is out of date and some active database connections are still using the old procedure definition until they are restarted. Have you tried running a recompile on the procedure in Oracle instead of restarting the entire database to see if that helps?
ALTER PROCEDURE ML_GET_BLOCKED_INFO COMPILE;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.