SQL Anywhere database replication - write error 1450 invalid argument

Author

write error 1450 invalid argument

Thomas Shouse

2006-01-26, 4:56 pm

Hello all,

I have ASA 9.0.2 patch level 3207. We use remote message agent running as a
service. I have a single consolidated database that no users connect to, and
6 replicating remote databases that users connect to via ODBC using my font
end application. The remote database servers have a WAN of T-1 or better to
the consolidated database server.

Here are our remote message agent parameters:
-c " uid=espub;pwd=xxxx;e
ng=enginename;dbn=da
tabasename"
-t
-m 256M
-l 1048576
-v
-g 1
-o d:\folder\live\Replo
g\rep.log
-os 15M
D:\folder\LIVE

One of the remote databases has begun to stop replication once or twice a
week with the following error recorded in the replication log file:

I. 01/26 08:51:04. write " \\CONSSERVER\FOLDERN
AME\remotedatabasena
me.2oq"
failure 1450: Invalid argument

We have checked routers, switches, DNS, and find no difference on this one
remote database server compared with the other 5. The folders on the
consolidated database server are all shared identically and this was running
for months until this problem appeared.

Does anyone know what the fix is? Thanks in advance for any recommendations.

Tom Shouse
Epic-Premier Insurance Solutions, Inc.
Mesa, AZ

Reg Domaratzki $iAnywhere Solutions$

2006-01-27, 9:23 am

Can you please post the entire SQL Remote log where this error occurs?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Thomas Shouse" <tshouse@epicsol.com> wrote in message
news:43d91f02$1@foru
ms-1-dub...
> Hello all,
>
> I have ASA 9.0.2 patch level 3207. We use remote message agent running as
a
> service. I have a single consolidated database that no users connect to,
and
> 6 replicating remote databases that users connect to via ODBC using my
font
> end application. The remote database servers have a WAN of T-1 or better
to
> the consolidated database server.
>
> Here are our remote message agent parameters:
> -c " uid=espub;pwd=xxxx;e
ng=enginename;dbn=da
tabasename"
> -t
> -m 256M
> -l 1048576
> -v
> -g 1
> -o d:\folder\live\Replo
g\rep.log
> -os 15M
> D:\folder\LIVE
>
> One of the remote databases has begun to stop replication once or twice a
> week with the following error recorded in the replication log file:
>
> I. 01/26 08:51:04. write " \\CONSSERVER\FOLDERN
AME\remotedatabasena
me.2oq"
> failure 1450: Invalid argument
>
> We have checked routers, switches, DNS, and find no difference on this one
> remote database server compared with the other 5. The folders on the
> consolidated database server are all shared identically and this was
running
> for months until this problem appeared.
>
> Does anyone know what the fix is? Thanks in advance for any
recommendations.
>
> Tom Shouse
> Epic-Premier Insurance Solutions, Inc.
> Mesa, AZ
>
>
>
>
>
>

Thomas Shouse

2006-01-30, 1:23 pm

Reg,
The bottom few lines of the replog follows. Thanks so much for looking at
this problem:

I. 01/30 13:03:13. INSERT INTO
DBA. Task(Task_ID,Object_
Code,Parent_Task_ID,
WF_Object_Code,Step_
ID,

Launch_ID,Session_ID
,Initial_Task_Ind,Ac
tive_Date,Late_Date,
Task_Desc,

Task_Note,Priority,C
ategory,Creation_Dat
e,Creation_User_ID,A
ssigned_Date,

Assigned_User_ID,Sta
rted_Date,Started_Us
er_ID,Completion_Dat
e,

Completion_User_ID,R
egarding_Type,Regard
ing_Multiple_Ind,Ref
_Role_Type,

Ref_Entity_ID,Ref_Bo
ok_Entity_ID,Ref_Con
tract_ID,Ref_Claim_I
D,Object_ID,

Object_Desc,Task_Req
uired_Ind,Note_Requi
red_Ind,Close_Date,C
lose_User_ID,

Skip_Date,Skip_User_
ID,Party_Sub_Type,Cr
eated_By_Task_ID,Ses
sion_Desc,

External_Entity_ID,E
xternal_Contact_ID,V
iew_ID,Unattend_Ind,

Unattend_Create_Ind,
Unattend_Post_Ind,Un
attend_Send_Ind,

Unattend_Complete_In
d,Ref_Object_Code,Re
f_Object_ID,Ref_Sub_
Object_ID,

Target_Printer,Site_
ID,Unread_Message_In
d,Remote_Proc_Shift,
Recur_Seq,

Protect_Late_Ind,Not
e_Class,Launch_Optio
ns,Session_Owner_Use
r_ID)

VALUES
(394291500,'Correspo
nd',NULL,NULL,NULL,N
ULL,389504500,NULL,'
11:46:12.796
2006/01/ 30',NULL,'Correspond
ence',NULL,NULL,NULL
,'11:46:12.796
2006/01/ 30',1246106,'11:46:1
2.796 2006/01/ 30',1246106,'11:46:1
2.796
2006/01/ 30',1246106,NULL,NUL
L,NULL,NULL,'CN',104
03114,2820105,151705
00,0,43255500,'Insur
ed:
Daily Express, LLC, Policy:
LVA100194- 01','Y',NULL,NULL,NU
LL,NULL,NULL,NULL,NU
LL,NULL,10403114,- 1000,NULL,NULL,'N',N
ULL,NULL,NULL,NULL,N
ULL,NULL,NULL,500,NU
LL,NULL,NULL,'N','X'
,NULL,NULL)
I. 01/30 13:03:13. COMMIT
I. 01/30 13:03:13. INSERT INTO
DBA. Event_Log(View_ID,Ob
ject_Code,Sub_Object
_Code,Task_ID,Doc_ID
,

Event_Code,Log_Date,
Object_ID,Sub_Object
_ID,Eff_Date,Log_Use
r_ID)

VALUES
(NULL,'Task',NULL,39
4291500,NULL,'CREATE
','11:46:12.858
2006/01/ 30',394291500,NULL,N
ULL,1246106)
I. 01/30 13:03:13. COMMIT
I. 01/30 13:03:13. INSERT INTO
DBA. Event_Log(View_ID,Ob
ject_Code,Sub_Object
_Code,Task_ID,Doc_ID
,

Event_Code,Log_Date,
Object_ID,Sub_Object
_ID,Eff_Date,Log_Use
r_ID)

VALUES
(NULL,'Correspond',N
ULL,394291500,NULL,'
CREATE','11:46:12.858
2006/01/ 30',43255500,NULL,NU
LL,1246106)
I. 01/30 13:03:13. COMMIT
I. 01/30 13:03:13. INSERT INTO
DBA. Event_Log(View_ID,Ob
ject_Code,Sub_Object
_Code,Task_ID,Doc_ID
,

Event_Code,Log_Date,
Object_ID,Sub_Object
_ID,Eff_Date,Log_Use
r_ID)

VALUES
(NULL,'Invoice',NULL
,394284500,NULL,'MOD
IFY','11:46:13.546
2006/01/ 30',11917500,NULL,NU
LL,6636114)
I. 01/30 13:03:13. COMMIT
I. 01/30 13:03:13. Scanning logs starting at offset 0143459388343
I. 01/30 13:03:13. Processing transaction logs from directory
" D:\epicsolutions\LIV
E"
I. 01/30 13:03:13. Processing transactions from active transaction log
I. 01/30 13:03:23. Sending message to "espub"
(4-0143459388343-0143462298443-0)
I. 01/30 13:03:24. write " \\epic_cons\consolid
ated\esbellharbor.2z9" failure
1450: Invalid argument
I. 01/30 13:03:24. write " \\epic_cons\consolid
ated\esbellharbor.2za" failure
1450: Invalid argument
I. 01/30 13:03:25. write " \\epic_cons\consolid
ated\esbellharbor.2zb" failure
1450: Invalid argument
I. 01/30 13:03:26. write " \\epic_cons\consolid
ated\esbellharbor.2zc" failure
1450: Invalid argument
I. 01/30 13:03:27. write " \\epic_cons\consolid
ated\esbellharbor.2zd" failure
1450: Invalid argument
I. 01/30 13:03:27. Resend requests are being queued
E. 01/30 13:03:27. Sending messages failed
I. 01/30 13:03:28. Execution completed

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:43da3642$1@foru
ms-2-dub...
> Can you please post the entire SQL Remote log where this error occurs?
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "Thomas Shouse" <tshouse@epicsol.com> wrote in message
> news:43d91f02$1@foru
ms-1-dub...
> a
> and
> font
> to
> running
> recommendations.
>
>

Thomas Shouse

2006-02-06, 8:24 pm

Hi,

I did look up this error code on Microsoft web site
http://msdn.microsoft.com/library/d... 1300-1699_.asp

But it still doesn't give any help:
"Insufficient system resources exist to complete the requested service."

"Thomas Shouse" <tshouse@epicsol.com> wrote in message
news:43de6875$1@foru
ms-1-dub...
> Reg,
> The bottom few lines of the replog follows. Thanks so much for looking at
> this problem:
>
>
>
>
> I. 01/30 13:03:13. INSERT INTO
> DBA. Task(Task_ID,Object_
Code,Parent_Task_ID,
WF_Object_Code,Step_
ID,
>
>
> Launch_ID,Session_ID
,Initial_Task_Ind,Ac
tive_Date,Late_Date,
Task_Desc,
>
>
> Task_Note,Priority,C
ategory,Creation_Dat
e,Creation_User_ID,A
ssigned_Date,
>
>
> Assigned_User_ID,Sta
rted_Date,Started_Us
er_ID,Completion_Dat
e,
>
>
> Completion_User_ID,R
egarding_Type,Regard
ing_Multiple_Ind,Ref
_Role_Type,
>
>
> Ref_Entity_ID,Ref_Bo
ok_Entity_ID,Ref_Con
tract_ID,Ref_Claim_I
D,Object_ID,
>
>
> Object_Desc,Task_Req
uired_Ind,Note_Requi
red_Ind,Close_Date,C
lose_User_ID,
>
>
> Skip_Date,Skip_User_
ID,Party_Sub_Type,Cr
eated_By_Task_ID,Ses
sion_Desc,
>
>
> External_Entity_ID,E
xternal_Contact_ID,V
iew_ID,Unattend_Ind,

>
>
> Unattend_Create_Ind,
Unattend_Post_Ind,Un
attend_Send_Ind,
>
>
> Unattend_Complete_In
d,Ref_Object_Code,Re
f_Object_ID,Ref_Sub_
Object_ID,
>
>
> Target_Printer,Site_
ID,Unread_Message_In
d,Remote_Proc_Shift,
Recur_Seq,
>
>
> Protect_Late_Ind,Not
e_Class,Launch_Optio
ns,Session_Owner_Use
r_ID)
>
> VALUES
> (394291500,'Correspo
nd',NULL,NULL,NULL,N
ULL,389504500,NULL,'
11:46:12.796
> 2006/01/ 30',NULL,'Correspond
ence',NULL,NULL,NULL
,'11:46:12.796
> 2006/01/ 30',1246106,'11:46:1
2.796 2006/01/ 30',1246106,'11:46:1
2.796
> 2006/01/ 30',1246106,NULL,NUL
L,NULL,NULL,'CN',104
03114,2820105,151705
00,0,43255500,'Insur
ed:
> Daily Express, LLC, Policy:
> LVA100194- 01','Y',NULL,NULL,NU
LL,NULL,NULL,NULL,NU
LL,NULL,10403114,- 1000,NULL,NULL,'N',N
ULL,NULL,NULL,NULL,N
ULL,NULL,NULL,500,NU
LL,NULL,NULL,'N','X'
,NULL,NULL)
> I. 01/30 13:03:13. COMMIT
> I. 01/30 13:03:13. INSERT INTO
> DBA. Event_Log(View_ID,Ob
ject_Code,Sub_Object
_Code,Task_ID,Doc_ID
,
>
>
> Event_Code,Log_Date,
Object_ID,Sub_Object
_ID,Eff_Date,Log_Use
r_ID)
>
> VALUES
> (NULL,'Task',NULL,39
4291500,NULL,'CREATE
','11:46:12.858
> 2006/01/ 30',394291500,NULL,N
ULL,1246106)
> I. 01/30 13:03:13. COMMIT
> I. 01/30 13:03:13. INSERT INTO
> DBA. Event_Log(View_ID,Ob
ject_Code,Sub_Object
_Code,Task_ID,Doc_ID
,
>
>
> Event_Code,Log_Date,
Object_ID,Sub_Object
_ID,Eff_Date,Log_Use
r_ID)
>
> VALUES
> (NULL,'Correspond',N
ULL,394291500,NULL,'
CREATE','11:46:12.858
> 2006/01/ 30',43255500,NULL,NU
LL,1246106)
> I. 01/30 13:03:13. COMMIT
> I. 01/30 13:03:13. INSERT INTO
> DBA. Event_Log(View_ID,Ob
ject_Code,Sub_Object
_Code,Task_ID,Doc_ID
,
>
>
> Event_Code,Log_Date,
Object_ID,Sub_Object
_ID,Eff_Date,Log_Use
r_ID)
>
> VALUES
> (NULL,'Invoice',NULL
,394284500,NULL,'MOD
IFY','11:46:13.546
> 2006/01/ 30',11917500,NULL,NU
LL,6636114)
> I. 01/30 13:03:13. COMMIT
> I. 01/30 13:03:13. Scanning logs starting at offset 0143459388343
> I. 01/30 13:03:13. Processing transaction logs from directory
> " D:\epicsolutions\LIV
E"
> I. 01/30 13:03:13. Processing transactions from active transaction log
> I. 01/30 13:03:23. Sending message to "espub"
> (4-0143459388343-0143462298443-0)
> I. 01/30 13:03:24. write " \\epic_cons\consolid
ated\esbellharbor.2z9"
> failure 1450: Invalid argument
> I. 01/30 13:03:24. write " \\epic_cons\consolid
ated\esbellharbor.2za"
> failure 1450: Invalid argument
> I. 01/30 13:03:25. write " \\epic_cons\consolid
ated\esbellharbor.2zb"
> failure 1450: Invalid argument
> I. 01/30 13:03:26. write " \\epic_cons\consolid
ated\esbellharbor.2zc"
> failure 1450: Invalid argument
> I. 01/30 13:03:27. write " \\epic_cons\consolid
ated\esbellharbor.2zd"
> failure 1450: Invalid argument
> I. 01/30 13:03:27. Resend requests are being queued
> E. 01/30 13:03:27. Sending messages failed
> I. 01/30 13:03:28. Execution completed
>
> "Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
> wrote in message news:43da3642$1@foru
ms-2-dub...
>
>

Sponsored Links