 | |
#11
 
| |||
| |||
|
Re: Proxy table error -
05-16-2008
, 06:44 PM
|
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 |
#12
| |||
| |||
|
|
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 |
#13
| |||
| |||
|
|
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 |
#14
| |||
| |||
|
|
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 |
#15
| |||
| |||
|
|
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 |
#16
| |||
| |||
|
|
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 |
#17
| |||
| |||
|
|
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 |
#18
| |||
| |||
|
|
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 |
#19
| |||
| |||
|
|
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 |
#20
| |||
| |||
|
|
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 |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.