Home > Archive > SQL Anywhere Mobile > April 2005 > Urgent - Upload Error in Mobilink Server -









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Urgent - Upload Error in Mobilink Server -
Maggie

2005-04-15, 11:24 am

Hi

An upload of the same Key data into the same table from two
different mobilink users fires an UNIQUE KEY CONSTRAINT -
Primary key violation error when the foll. script were used.

CALL ml_add_table_script(
'default',
'EFB_EfbWpi_waypoint
_info', 'upload_update','Upd
ate
EFBC_CfbWpi_Waypoint
_Info SET CfbWpi_Waypoint_name
=
? ,CfbWpi_waypoint_typ
e= ? ,CfbWpi_onsite_offsh
ore= ?
,CfbWpi_latitude= ? ,CfbWpi_Lati_directi
on= ?
,CfbWpi_longitude= ? ,CfbWpi_Longi_direct
ion= ?
,CfbWpi_variation= ? ,CfbWpi_Fuel_avl_fla
g= ? ,CfbWpi_usage=
? ,CfbWpi_owner= ? ,CfbWpi_radio_freque
ncy= ?
,CfbWpi_elevation= ? ,CfbWpi_remarks= ? ,CfbWpi_size= ?
,CfbWpi_weight= ? ,CfbWpi_sector_chart
= ?
,CfbWpi_block_in_add
r= ? ,CfbWpi_area= ?
,CfbWpi_platform_let
ter= ? ,CfbWpi_state= ? ,CfbWpi_city= ?
,CfbWpi_CREATED_date
time= ? ,CfbWpi_modified_dat
etime =
? ,CfbWpi_waypoint_Sou
rce=? where CfbWpi_waypoint_iden
tity=
?');
CALL ml_add_table_script(
'default',
'EFB_EfbWpi_waypoint
_info', 'upload_insert','INS
ERT INTO
EFBC_CfbWpi_Waypoint
_Info(CfbWpi_waypoin
t_identity,CfbWpi_Wa
ypoint_name
,CfbWpi_waypoint_typ
e,CfbWpi_onsite_offs
hore,CfbWpi_latitude

,CfbWpi_Lati_directi
on,CfbWpi_longitude,
CfbWpi_Longi_directi
on
,CfbWpi_variation,Cf
bWpi_Fuel_avl_flag,C
fbWpi_usage,CfbWpi_o
wner
,CfbWpi_radio_freque
ncy,CfbWpi_elevation
,CfbWpi_remarks,CfbW
pi_size
,CfbWpi_weight,CfbWp
i_sector_chart,CfbWp
i_block_in_addr,CfbW
pi_area
,CfbWpi_platform_let
ter,CfbWpi_state,Cfb
Wpi_city,CfbWpi_CREA
TED_datetime
,CfbWpi_modified_dat
etime,CfbWpi_waypoin
t_Source ) VALUES (
? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? ,
? , ? , ? , ? ,? ,? ,? ,? ,?,?)');


To resolve this , we tried with the following set of
statements:

"
create or replace procedure Sp_InsertWayPt(waypo
int_identity
IN varchar2,Waypoint_na
me IN varchar2,waypoint_ty
pe IN
varchar2, onsite_offshore IN varchar2, latitude IN varchar2,
Lati_direction IN varchar2, longitude IN varchar2,
Longi_direction IN varchar2, variation IN varchar2,
Fuel_avl_flag IN varchar2, usage IN varchar2, owner IN
varchar2, radio_frequency IN varchar2, elevation IN
varchar2, remarks IN varchar2, psize IN varchar2, pweight IN
varchar2, sector_chart IN varchar2, block_in_addr IN
varchar2, parea IN varchar2, platform_letter IN varchar2,
state IN varchar2, city IN varchar2, CREATED_datetime IN
Date, modified_datetime IN Date, waypoint_Source IN
varchar2)
As
cnt integer;
Begin
select Count(*) into cnt From efbc_cfbwpi_waypoint
_info
Where cfbwpi_WayPoint_Iden
tity = waypoint_identity;
if cnt > 0 then
Delete From efbc_cfbwpi_waypoint
_info Where
cfbwpi_WayPoint_Iden
tity = waypoint_identity;
end if;
INSERT INTO
EFBC_CfbWpi_Waypoint
_Info(CfbWpi_waypoin
t_identity,CfbWpi_Wa
ypoint_name
,CfbWpi_waypoint_typ
e,CfbWpi_onsite_offs
hore,CfbWpi_latitude

,CfbWpi_Lati_directi
on,CfbWpi_longitude,
CfbWpi_Longi_directi
on
,CfbWpi_variation,Cf
bWpi_Fuel_avl_flag,C
fbWpi_usage,CfbWpi_o
wner
,CfbWpi_radio_freque
ncy,CfbWpi_elevation
,CfbWpi_remarks,CfbW
pi_size
,CfbWpi_weight,CfbWp
i_sector_chart,CfbWp
i_block_in_addr,CfbW
pi_area
,CfbWpi_platform_let
ter,CfbWpi_state,Cfb
Wpi_city,CfbWpi_CREA
TED_datetime
,CfbWpi_modified_dat
etime,CfbWpi_waypoin
t_Source ) VALUES
(waypoint_identity ,Waypoint_name,waypo
int_type,
onsite_offshore, latitude, Lati_direction, longitude,
Longi_direction, variation, Fuel_avl_flag, usage, owner,
radio_frequency, elevation, remarks, psize, pweight,
sector_chart, block_in_addr, parea, platform_letter,stat
e,
city, CREATED_datetime, modified_datetime, waypoint_Source);
end Sp_InsertWayPt;



Mobilink Script :

CALL ml_add_table_script(
'default',
'EFB_EfbWpi_waypoint
_info', 'upload_insert','Sp_
InsertWayPt(
? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? ,
? , ? , ? , ? ,? ,? ,? ,? ,?,?)');

CALL ml_add_table_script(
'default',
'EFB_EfbWpi_waypoint
_info', 'upload_Update','Upd
ate
EFBC_CfbWpi_Waypoint
_Info SET CfbWpi_Waypoint_name
=
? ,CfbWpi_waypoint_typ
e= ? ,CfbWpi_onsite_offsh
ore= ?
,CfbWpi_latitude= ? ,CfbWpi_Lati_directi
on= ?
,CfbWpi_longitude= ? ,CfbWpi_Longi_direct
ion= ?
,CfbWpi_variation= ? ,CfbWpi_Fuel_avl_fla
g= ? ,CfbWpi_usage=
? ,CfbWpi_owner= ? ,CfbWpi_radio_freque
ncy= ?
,CfbWpi_elevation= ? ,CfbWpi_remarks= ? ,CfbWpi_size= ?
,CfbWpi_weight= ? ,CfbWpi_sector_chart
= ?
,CfbWpi_block_in_add
r= ? ,CfbWpi_area= ?
,CfbWpi_platform_let
ter= ? ,CfbWpi_state= ? ,CfbWpi_city= ?
,CfbWpi_CREATED_date
time= ? ,CfbWpi_modified_dat
etime =
? ,CfbWpi_waypoint_Sou
rce = ? where CfbWpi_waypoint_iden
tity=
?');


For the above steps , we got the following error on
SYnchronisation :


I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: PILOT
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: upload_insert
EFB_EfbWpi_waypoint_
info (open for write):
Sp_InsertWayPt( ? , ? , ? , ? , ? ,? , ?
, ? , ? , ? ,? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? ,? ,?
,? ,?,?)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Translated
SQL:
Sp_InsertWayPt( ? , ? , ? , ? , ? ,? , ?
, ? , ? , ? ,? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? ,? ,?
,? ,?,?)
E. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Error:
[-10002] ODBC: [DataDirect][ODBC Oracle Wire Protocol
driver][Oracle]ORA-00900: invalid SQL statement (ODBC State
= 42000, Native error code = 900)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: upload_insert
EFB_EfbWpi_waypoint_
info (close)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Translated
SQL:
rollback to savepoint it16
W. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Warning:
[10039] Error detected while using multi-row cursor --
retrying with single row cursor
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Translated
SQL:
savepoint it16
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Inserted row:
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NE011
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: SCHUTTE
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: HEDA
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: ONSH
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 4011.684
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: N
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 9821.119
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: W
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: -7
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: N
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: PR
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: MRS ALFRED
SCHUTTE
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 0
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 1876 SUR
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: GUIDE ROCK,
NE 68942
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 0
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: OMAHA 821
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NEBRASKA
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: GUIDE ROCK
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 2005-04-15
20:21:59.000000
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 2005-04-15
20:21:59.000000
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: PILOT
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: upload_insert
EFB_EfbWpi_waypoint_
info (open for write):
Sp_InsertWayPt( ? , ? , ? , ? , ? ,? , ?
, ? , ? , ? ,? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? ,? ,?
,? ,?,?)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Cached ODBC
statement:
Sp_InsertWayPt( ? , ? , ? , ? , ? ,? , ?
, ? , ? , ? ,? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? ,? ,?
,? ,?,?)
E. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Error:
[-10002] ODBC: [DataDirect][ODBC Oracle Wire Protocol
driver][Oracle]ORA-00900: invalid SQL statement (ODBC State
= 42000, Native error code = 900)
E. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Error: Unable
to insert into table 'EFB_EfbWpi_waypoint
_info' using
upload_insert
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Error Context:
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: User Name:
EFBc0927a08cce340459
ad445af095c6be3#N192
PH
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Modified User
Name: EFBc0927a08cce340459
ad445af095c6be3#N192
PH
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Transaction:
upload
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Table Name:
EFB_EfbWpi_waypoint_
info
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Insert Row:
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NE011
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: SCHUTTE
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: HEDA
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: ONSH
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 4011.684
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: N
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 9821.119
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: W
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: -7
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: N
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: PR
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: MRS ALFRED
SCHUTTE
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 0
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 1876 SUR
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: GUIDE ROCK,
NE 68942
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 0
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: OMAHA 821
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NEBRASKA
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: GUIDE ROCK
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 2005-04-15
20:21:59.000000
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 2005-04-15
20:21:59.000000
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: PILOT
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Script
Version: default
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Script:
Sp_InsertWayPt( ? , ? , ? , ? , ? ,? , ? , ? , ? , ? ,? , ?
, ? , ? , ? ,? , ? , ? , ? , ? ,? ,? ,? ,? ,?,?)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: End of Error
Context
W. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Warning:
[10010] No handle_error script is defined. The default
action code (3000) will decide the error behavior
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: An error
occurred while uploading an insert row into table
'EFB_EfbWpi_waypoint
_info'. The inserted column values are
as follows:
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NE011
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: SCHUTTE
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: HEDA
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: ONSH
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 4011.684
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: N
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 9821.119
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: W
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: -7
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: N
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: PR
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: MRS ALFRED
SCHUTTE
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 0
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 1876 SUR
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: GUIDE ROCK,
NE 68942
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 0
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: OMAHA 821
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NULL
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: NEBRASKA
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: GUIDE ROCK
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 2005-04-15
20:21:59.000000
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: 2005-04-15
20:21:59.000000
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: PILOT
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: upload_insert
EFB_EfbWpi_waypoint_
info (close)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Translated
SQL:
rollback to savepoint it16
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: ROLLBACK
Transaction: end_upload
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_publication <connection> (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbRgn_Region_Hd
r (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbCM_Canned_Msg
_Hdr (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbFsy_FileConte
nt_Dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbAPrm_Ac_Param
_dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization Efb_Efbattp_attrib_p
rm_dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbEU_Efb_User_I
nfo (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbDLc_Delay_cod
e_Hdr (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbEq_Equipment_
hdr (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EFBXA_Actyp_Extr
a_Arm (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbActy_Aircraft
_type (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbAci_Aircraft_
info (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbAcDtl_aircraf
t_dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbCSgn_Cus_Call
_Sign (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbEmpi_employee
_Info (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbCusi_Customer
_Info (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbFC_fltcode_In
fo (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbWpi_waypoint_
info (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbSP_System_Par
am_Hdr (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbCG_GrossWt_CG
_Limit (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbSL_seat_layou
t_dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbFT_Fuel_Tanks
_Dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbFM_Fuel_momen
t_dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbCS_Cargo_spac
e_dtl (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbLpm_Leg_param
_Hdr (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbCst_closing_s
tation (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbTZ_TimeZone_H
dr (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization EFB_EfbPTW_PALT_Temp
_WAT (no script)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
end_synchronization <connection>
call Sp_DeleteSceneWayPt(
)
I. 04/15 20:29:42. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Translated
SQL:
call Sp_DeleteSceneWayPt(
)
I. 04/15 20:29:43. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: ROLLBACK
Transaction: end_synchronization
I. 04/15 20:29:43. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: end_connection
<connection> (no script)
I. 04/15 20:29:43. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: COMMIT
Transaction: end_connection
I. 04/15 20:29:43. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]: Disconnected
from consolidated database
I. 04/15 20:29:43. <1.4>
[EFBc0927a08cce34045
9ad445af095c6be3#N19
2PH]:
Synchronization failed
I. 04/15 20:37:51. <Main>: MobiLink server shutting down
I. 04/15 20:37:51. <Main>: MobiLink server undergoing hard
shutdown.
I. 04/15 20:37:51. <Main>: All connections and
synchronizations being terminated.
I. 04/15 20:37:52. <thread 1.4>: Shutting down
I. 04/15 20:37:52. <thread 1.5>: Shutting down
I. 04/15 20:37:52. <thread 1.3>: Shutting down
I. 04/15 20:37:52. <thread 1.2>: Shutting down
I. 04/15 20:37:52. <thread 1.1>: Shutting down
I. 04/15 20:37:53. <Main>: Removing download cache file
"C:\TEMP\rd00000024"
I. 04/15 20:37:53. <Main>: Removing download cache file
"C:\TEMP\rd0000004a"
I. 04/15 20:37:53. <Main>: Removing download cache file
"C:\TEMP\rd0000004d"
I. 04/15 20:37:53. <Main>: Removing download cache file
"C:\TEMP\rd0000004e"
I. 04/15 20:37:53. <Main>: Removing download cache file
"C:\TEMP\rd0000004f"
I. 04/15 20:37:53. <Main>: Removing download cache file
"C:\TEMP\rd00000058"
I. 04/15 20:37:53. <Main>: Disconnected
I. 04/15 20:37:54. <Main>: MobiLink server finished


Pls help us on this . This is an issue from our Customer's
end (LIVE server) .
Greg Fenton

2005-04-15, 8:24 pm

Maggie wrote:
>
> An upload of the same Key data into the same table from two
> different mobilink users fires an UNIQUE KEY CONSTRAINT -
> Primary key violation error when the foll. script were used.
>

This is something that you absolutely must *design* your distributed
application *not* to do. Primary keys must be generated such that they
are unique across *all* database nodes. There are a number of
strategies you can use to accomplish this:

- Global Autoincrement (recommended for most situations)
- UUIDs (also known as GUIDs)
- Key Pools
- Composite Keys

> Pls help us on this . This is an issue from our Customer's
> end (LIVE server) .

If this is an urgent matter (which it appears to be), you should open a
case with iAnywhere Technical Support. The newsgroups are not an
official support channel and are run on a voluntary basis.

http://www.ianywhere.com/support/co...ct_support.html

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com