dbTalk Databases Forums  

Proxy table error

sybase.public.sqlanywhere.linux sybase.public.sqlanywhere.linux


Discuss Proxy table error in the sybase.public.sqlanywhere.linux forum.

Reply
 
Thread Tools Display Modes
  #11  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM






I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote

Quote:
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #12  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM






Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #13  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM



Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #14  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM



Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #15  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM



Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #16  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM



Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #17  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM



Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #18  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM



Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #19  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM



Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
  #20  
Old   
Nick Elson
 
Posts: n/a

Default Re: Proxy table error - 05-16-2008 , 06:44 PM






Just some random thoughts ... that ...

HTH
"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

Quote:
I doubt an odbc trace will be of much assistance to
you since the server is the one asserting.

I would start by applying the latest ebf, (we're in the
3600's now), increase the amout of memory allocated
to the server (and if set excessively high already try
reducing it), check out the system memory usage
and the swap usage while this is occuring, ...

And finally, consider reducing the size of your
update, or running it through a forward only
operation.

If you need to decode what the update is actually
doing, try turning the CIS_OPTION option
up setting it to 6 (first) and rerunning the operation.


Other than that a discussion with support, and a
full repro. would be helpful.


"Hanan Brener" <hbrener (AT) allot (DOT) com> wrote in message
news:84210c29-4868-4939-9bbf-ace5be7b0fa6 (AT) b1g2000hsg (DOT) googlegroups.com...
We are working with Sybase 9.0.2 EBF 3397 on Linux. Running two ASA
databases on this Linux machine.
Using proxy table to update data between these databases sometimes
(once in few days) we get follow error -
SQLCODE -660 (or -656)
*** ERROR *** Assertion failed: 101413 (9.0.2.3397)
Unable to allocate a multi-page block of memory
The database dosn't corrapted after dbserver restart continue to work.
We are set in .obdc.ini file flag Trace=1 in section [ODBC] but trace
file odbctrace.out doesn't created on server machine.
Can anyone help us to explore and understand this problem.

Best Regards, Hanan Brener





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.