Sql Anywhere 12.0.1.3797

[eric_verhorstert]

We ussually start the upload with the SQL command 'SYNCHRONIZE PROFILE upload'.

On 1 database it is not possible to start the upload in this way. Typing in the SQL command we see error "Synchronization profile 'upload' not found.

When we start dbmlsync and enter subscription "upload" (and of course the db connection info) all works fine.

Any suggestion why the sql statement is not working are welcome.

Thanks

[jeff_albion · Accepted solution]

Hi Eric,

It sounds like there might be a problem with the 'upload' profile, but it's not immediately clear what that could be.

What does:

SELECT * FROM sp_get_last_synchronize_result();

return after this error from the 'SYNCHRONIZE' command?

What does :

SELECT * FROM SYS.SYSSYNCPROFILE;

return for this database?

Regards,

Jeff Albion

SAP Active Global Support

[eric_verhorstert · Accepted solution]

Select * from sys.syncprofile returns nothing.

I noticed that on other db it returns the info we expected.

Is there a way to add the profile. If we run 'create synchronization profile uploadtope 'subscription=upload;' we get error

SQLSTATE = 42000

[Sybase][ODBC Driver]Syntax error or access violation

Thanks

Eric

[jeff_albion · Accepted solution]

Hi Eric,

Select * from sys.syncprofile returns nothing.
I noticed that on other db it returns the info we expected.

Okay, that explains why the SYNCHRONIZE command is failing for this database then.

Is there a way to add the profile. If we run 'create synchronization profile uploadtope 'subscription=upload;' we get error

That's very strange - I'm not sure I understand how you're seeing that error in this case. Was that command executed via Interactive SQL? The following works okay for myself on 12.0.1.3994:

create synchronization profile uploadtope 'subscription=upload;';
select * from sys.syssyncprofile;

object_id,profile_name,profile_defn
3186,'uploadtope',subscription=upload;

Is this running on a database that was initalized with version 12 or is it an upgraded database from an earlier version? (SELECT * FROM SYS.SYSHISTORY)?

Do you also see this error if you try the same command on a brand new SQL Anywhere 12 database?

Regards,

Jeff Albion

SAP Active Global Support

[eric_verhorstert · Accepted solution]

Thanks,

We executed the script within our program. There must be something wrong.

Executed it in dbisqlc and the problem is solved.

Thanks again