cancel
Showing results for 
Search instead for 
Did you mean: 

mobilink 16 error ODBC: [Sybase][ODBC Driver]Syntax error or access violation (ODBC State = 42000, Native error code = 0)

Former Member
0 Kudos

I use the scripted sync in mobilink 16.0 .. my consolidate and remote databases is ASA 16.0 also

But when i try to sincronize with one table i have thos error

-10002] Consolidated database server or ODBC error:  ODBC: [Sybase][ODBC Driver]Syntax error or access violation (ODBC State = 42000, Native error code = 0)
[-10058] Unable to open upload_insert

Already review the table schema in the store procedures and scripts of mobilink and dont have any error.  If i run the store procedure run fine without errors.

Anyone have experience with this kind of error?

Also in the publications have anothers tables that dont have any error when sinc with dbmlsync.

this is he scripts in the:

Create Procedure tbl_LogTarjeta_inserted ()                

result (
Cod_tienda varchar (10),                                                                                                                                                                                                                                        
ID_Caja varchar (15),                                                                                                                                                                                                                                           
transaccion integer,                                                                                                                                                                                                                                        
Cod_Autorizador integer ,                                                                                                                                                                                                                                    
fechaTransaccion timestamp ,                                                                                                                                                                                                                                 
Tipo varchar (15),                                                                                                                                                                                                                                              
trackEnvio long varchar ,                                                                                                                                                                                                                                
fechaRespuesta timestamp ,                                                                                                                                                                                                                                   
trackRespuesta long varchar                                                                                                                                                                                                                           
)
begin
select
Cod_tienda,                                                                                                                      
ID_Caja,                                                                                                                         
transaccion,                                                                                                                     
Cod_Autorizador,                                                                                                                 
fechaTransaccion,                                                                                                                
Tipo,                                                                                                                            
trackEnvio,                                                                                                                      
fechaRespuesta,                                                                                                                  
trackRespuesta                                                                                                                 
from tbl_LogTarjeta a
where exists (select 1 from Tbl_TrxTrasladable b where a.ID_Caja = b.ID_Caja and a.Transaccion = b.Transaccion )
end

table tbl_LogTarjeta

(

Cod_tienda,                                                                                                                      
ID_Caja,                                                                                                                         
transaccion,                                                                                                                     
Cod_Autorizador,                                                                                                                 
fechaTransaccion,                                                                                                                
Tipo,                                                                                                                            
trackEnvio,                                                                                                                      
fechaRespuesta,                                                                                                                  
trackRespuesta                                                                                                                  

)

using (

procedure tbl_LogTarjeta_inserted for upload insert )

CALL ml_add_table_script ( 'default','tbl_LogTarjeta','upload_insert',
'INSERT INTO tbl_LogTarjeta (Cod_tienda,ID_Caja,transaccion,Cod_Autorizador,fechaTransaccion,Tipo,trackEnvio,fechaRespuesta,trackRespuesta)
Values ( { ml r.Cod_tienda}, { ml r.ID_Caja}, { ml r.transaccion}, { ml r.Cod_Autorizador}, { ml r.fechaTransaccion},{ ml r.Tipo},{ ml r.fechaRespuesta})' )

The message that is in the ml server is:
I. 2015-10-01 16:45:44. <13> PHASE: send_download: 0
I. 2015-10-01 16:45:44. <13> PHASE: wait_for_download_ack: 0
I. 2015-10-01 16:45:44. <13> PHASE: get_db_worker_for_download_ack: 0
I. 2015-10-01 16:45:44. <13> PHASE: connect_for_download_ack: 0
I. 2015-10-01 16:45:44. <13> PHASE: nonblocking_download_ack: 0
I. 2015-10-01 16:47:03. <14> Request from "Dbmlsync 16.0.2158" for: remote ID: bd6dee9f-9eff-474a-978a-6cbd5ec94ea0, user name: dba, version: default
I. 2015-10-01 16:47:03. <14> Synchronization connection with connection ID 'SPID 17' has been established
I. 2015-10-01 16:47:03. <14> ODBC isolation set to: Read Committed
I. 2015-10-01 16:47:03. <14> COMMIT Transaction: Begin connection
I. 2015-10-01 16:47:03. <14> The current synchronization is using a connection with connection ID 'SPID 17'
I. 2015-10-01 16:47:03. <14> COMMIT Transaction: Begin synchronization
E. 2015-10-01 16:47:03. <14> [-10002] Consolidated database server or ODBC error:  ODBC: [Sybase][ODBC Driver]Syntax error or access violation (ODBC State = 42000, Native error code = 0)
E. 2015-10-01 16:47:03. <14> [-10058] Unable to open upload_insert
I. 2015-10-01 16:47:03. <14> Error Context:
I. 2015-10-01 16:47:03. <14> Remote ID: bd6dee9f-9eff-474a-978a-6cbd5ec94ea0
I. 2015-10-01 16:47:03. <14> User Name: dba
I. 2015-10-01 16:47:03. <14> Modified User Name: dba
I. 2015-10-01 16:47:03. <14> Transaction: Upload
I. 2015-10-01 16:47:03. <14> Table Name: tbl_LogTarjeta
I. 2015-10-01 16:47:03. <14> Script Version: default
I. 2015-10-01 16:47:03. <14> Script: INSERT INTO tbl_LogTarjeta (Cod_tienda,ID_Caja,transaccion,Cod_Autorizador,fechaTransaccion,Tipo,trackEnvio,fechaRespuesta,trackRespuesta)
                        Values ( { ml r.Cod_tienda}, { ml r.ID_Caja}, { ml r.transaccion}, { ml r.Cod_Autorizador}, { ml r.fechaTransaccion},{ ml r.Tipo},{ ml r.fechaRespuesta})
I. 2015-10-01 16:47:03. <14> End of Error Context
I. 2015-10-01 16:47:03. <14> ROLLBACK Transaction: Upload
I. 2015-10-01 16:47:03. <14> COMMIT Transaction: End synchronization
I. 2015-10-01 16:47:03. <14> COMMIT Transaction: End connection
I. 2015-10-01 16:47:03. <14> Synchronization connection with connection ID 'SPID 17' has been disconnected
I. 2015-10-01 16:47:03. <14> Synchronization failed
I. 2015-10-01 16:47:03. <14> PHASE: sync_request: 688
I. 2015-10-01 16:47:03. <14> PHASE: receive_upload: 15
I. 2015-10-01 16:47:03. <14> PHASE: get_db_worker: 0
I. 2015-10-01 16:47:03. <14> PHASE: connect: 16
I. 2015-10-01 16:47:03. <14> PHASE: authenticate_user: 0
I. 2015-10-01 16:47:03. <14> PHASE: begin_sync: 0
I. 2015-10-01 16:47:03. <14> PHASE: apply_upload: 31
I. 2015-10-01 16:47:03. <14> PHASE: prepare_for_download: 0
I. 2015-10-01 16:47:03. <14> PHASE: fetch_download: 0
I. 2015-10-01 16:47:03. <14> PHASE: end_sync: 110
I. 2015-10-01 16:47:03. <14> PHASE: send_download: 0
I. 2015-10-01 16:47:03. <14> PHASE: wait_for_download_ack: 0
I. 2015-10-01 16:47:03. <14> PHASE: get_db_worker_for_download_ack: 0
I. 2015-10-01 16:47:03. <14> PHASE: connect_for_download_ack: 0
I. 2015-10-01 16:47:03. <14> PHASE: nonblocking_download_ack: 0

Thanks for any comments or help

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member207653
Active Participant
0 Kudos

http://dcx.sap.com/index.html#sa160/en/dbreference/insert-statement.html

Try to use ON EXISTING UPDATE parameter in that INSERT statement in the upload_insert event

Former Member
0 Kudos

This problem is caused by a duplicate key in the table then? 

Thanks for your help.

former_member207653
Active Participant
0 Kudos

It could be. But I have seen that error message in other contexts so does ON EXISTING UPDATE help?