ORA-01740: missing quotes error when synchronizing mobilink

[Former Member]

Hi,

I'm getting a missing quotes error when synchronizing with mobilink.

followed by

[-10058] Unable to open download_delete_cursor

and the name of the table.

and name of the script

Script: {CALL "scriptversion".DOWNLOAD_DELETE_CURSOR_ABC (?, ?)}

How can I see what is causing this... I already checked the script for that table in the ml_scripts table.... nothing special there... the script looks exactly the same as in previous versions....

I'm assuming that it's the parameters that are creating the problem. but no idea on how to see them...

any suggestions?

thank you !

[jeff_albion · Accepted solution]

Hello,

I assume from your previous question you're current using MobiLink 12.x - which version and build are you using specifically?

>> the script looks exactly the same as in previous versions....

Are you also using MobiLink 12.x in your other versions, or were you using a different version of MobiLink previously?

>> How can I see what is causing this... I already checked the script for that table in the ml_scripts table.... nothing special there...

See what is being actually executed by the MobiLink server by adding "-vt -o mlsrv12.txt" to the mlsrv12 start-line to see the translated SQL that is resulting from this script. Post the log contents here so we can see the exact error in context.

>> I'm assuming that it's the parameters that are creating the problem.

Potentially - you should be able to use this syntax (See: the documentation), but it's possible that there is a mis-parse of your code because "{" and "}" usually indicate Named Script Parameters. Have you tried using them here instead? As per the download_delete_cursor event documentation, the two "?"s correspond to {ml s.last_table_download} and {ml s.username} respectively:

{CALL "scriptversion"."DOWNLOAD_DELETE_CURSOR_ABC"( {ml s.last_table_download}, {ml s.username})}

Regards,

Jeff Albion

SAP Active Global Support

[Former Member · Accepted solution]

Thank you for your answer. With versions I mean the version of the package that contains the scripts (upload/download cursors). Correct, I use mobilink 12.. exact version of the patch = SA12_Windows.1201_3994_EBF

I am going to inspect your answer further since there are several references in it and I will come back later to accept as anwser.

[former_member188493 · Accepted solution]

Please show us the exact error that is being captured in the mlsrv12.exe diagnostic log. Run with -v+. Copy and paste EVERYTHING you see around the error messages. Please DO NOT edit anything.

[Former Member · Accepted solution]

Hi,

thanks for your tip. I just did that and get a LOT of logging.

Not sure if my employer would appreciate me sharing DB details in public.

In private messaging I could send it through, but i guess that wouldn't help others with the same issue..

i also changed the startup parameters to -vt -o

And this is the result that I get (I modified scriptpackage name and cursorname a litle bit):

I'm guessing that  : p1  and : p2 is incorrect as parameter....and the complaints come from there..

Also, this time I ran another publication and now it's complaining on the newly added table and not on that random old table I mentioned on my previous post.

PS. error message is in dutch since the server is in dutch, but it's the missing quotes issue.

I. 2014-03-31 15:36:26. <1> COMMIT Transaction: prepare_for_download

I. 2014-03-31 15:36:26. <1> Translated SQL:

                        CALL "scriptversion".DOWNLOAD_DELETE_CURSOR_ABC (:p1, :p2)

E. 2014-03-31 15:36:26. <1> [-10002] Consolidated database server or ODBC error:  ODBC: [Sybase][iAnywhere Solutions - Oracle][Oracle]ORA-01740: Ontbrekend dubbele aanhalingsteken in identificatiesymbool.

                        ORA-01740: Ontbrekend dubbele aanhalingsteken in identificatiesymbool.

                         (ODBC State = 42000, Native error code = 1740)

E. 2014-03-31 15:36:26. <1> [-10002] Consolidated database server or ODBC error:  ODBC: [Sybase][iAnywhere Solutions - Oracle][Oracle]ORA-01740: Ontbrekend dubbele aanhalingsteken in identificatiesymbool.

                        ORA-01740: Ontbrekend dubbele aanhalingsteken in identificatiesymbool.

                         (ODBC State = 42000, Native error code = 1740)

E. 2014-03-31 15:36:26. <1> [-10058] Unable to open download_delete_cursor

I. 2014-03-31 15:36:26. <1> Error Context:

I. 2014-03-31 15:36:26. <1> Remote ID: c44a5403-74ba-4c98-bf6d-4e1db5fb24c9

I. 2014-03-31 15:36:26. <1> User Name: USR:66ed647c-20b1-4cff-9663-8147b0e7e2fd

I. 2014-03-31 15:36:26. <1> Modified User Name: USR:66ed647c-20b1-4cff-9663-8147b0e7e2fd

I. 2014-03-31 15:36:26. <1> Transaction: download

I. 2014-03-31 15:36:26. <1> Table Name: MY_NEWLY_ADDED_TABLE

I. 2014-03-31 15:36:26. <1> Script Version: scriptversion

I. 2014-03-31 15:36:26. <1> Script: {CALL "scriptversion".DOWNLOAD_DELETE_CURSOR_ABC (?, ?)}

I. 2014-03-31 15:36:26. <1> End of Error Context

I. 2014-03-31 15:36:26. <1> ROLLBACK Transaction: end_download

I. 2014-03-31 15:36:26. <1> ROLLBACK Transaction: end_synchronization

[Former Member · Accepted solution]

Just wanted to let you know that I haven't been able to figure this out...

The sql that is being executed is available in my previous post...

things have even got more weird and this makes me think I'm missing something basic...

Last month I imported an external DB, re-installed mobilink and created a script-package that already existed in a previous consolidated database called "package.V.3"

and everything works

Now I just copy the script-package and replace "package.V.3" with "package.V.3.1" and run it and commit.

then run the ML_ADD_MISSING_DNLD_SCRIPTS

Restart Mobilink
Update my subscription of my local database to the new version.

and I get the error mentioned in my Original post (missing quotes). and I'm getting this error now on a seemingly random table.

I checked the ml_table_script table and the script is there for the correct version.

I also did a filecompare of the 2 script-packages and they look the same except for the version number.

[former_member188493 · Accepted solution]

Try asking your question on the real SAP SQL Anywhere Forum - the software is better, and there are more people answering questions.

Please provide the actual code and the actual MobiLink diagnostic logs. No offense intended, but a prose description of the problem is of very little help without the actual code.

Put everything in the question; please don't link or refer back to material in other locations... nobody's getting paid, so they don't have time to go chasing stuff.

Thanks!

[Former Member · Accepted solution]

no offence taken. Thanks for the tip.