|
Home > Archive > SQL Anywhere database > May 2005 > DATABASE INTERNAL ERROR
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 |
DATABASE INTERNAL ERROR
|
|
| DiPauli 2005-05-16, 11:23 am |
| Please,
my customer send me a ASA 9.0.1.1873 DATABASE that seem corrupted.
When we view data from a specific table (customer table), we have the
following error:
-----
SQLSTATE = S1000
DATABASE INTERNAL ERROR. Assertion failed:102300 (9.0.1.1873)
File associated with given page id is invalid or not open.
-----
How can I restore DB ? (there is not log file...)
Any idea ???
Thank you in advance
Di Pauli Renato
---------------------------------------------
FIT ENGINEERING S.r.l.
via Fiumicino, 7
33082 AZZANO DECIMO (PN)
tel. 0434 - 64.04.71
fax 0434 - 63.38.77
dipauli@fiteng.it
www.fiteng.it
| |
| Breck Carter [TeamSybase] 2005-05-16, 11:23 am |
| Stop the engine and make a backup file copy of the .DB file so there
won't be any further damage. Then contact Sybase Technical Support;
they may be able to help you:
http://www.sybase.com/contactus/support#tech
You may able to recreate a working database by running dbunload. Use
the -e option to exclude the customer table so you can at least get
all the other data.
Breck
On 16 May 2005 08:38:22 -0700, "DiPauli" <dipauli@fiteng.it> wrote:
>Please,
>my customer send me a ASA 9.0.1.1873 DATABASE that seem corrupted.
>When we view data from a specific table (customer table), we have the
>following error:
>-----
>SQLSTATE = S1000
>DATABASE INTERNAL ERROR. Assertion failed:102300 (9.0.1.1873)
>File associated with given page id is invalid or not open.
>-----
>How can I restore DB ? (there is not log file...)
>Any idea ???
>Thank you in advance
>Di Pauli Renato
>---------------------------------------------
>FIT ENGINEERING S.r.l.
>via Fiumicino, 7
>33082 AZZANO DECIMO (PN)
>tel. 0434 - 64.04.71
>fax 0434 - 63.38.77
>dipauli@fiteng.it
>www.fiteng.it
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| DiPauli 2005-05-16, 11:23 am |
| Thank you Brek...
--
---------------------------------------------
FIT ENGINEERING S.r.l.
via Fiumicino, 7
33082 AZZANO DECIMO (PN)
tel. 0434 - 64.04.71
fax 0434 - 63.38.77
dipauli@fiteng.it
www.fiteng.it
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> ha scritto nel
messaggio news:pdgh811saht7ihh
kelr9qmc4ahktc28de2@
4ax.com...
> Stop the engine and make a backup file copy of the .DB file so there
> won't be any further damage. Then contact Sybase Technical Support;
> they may be able to help you:
> http://www.sybase.com/contactus/support#tech
>
> You may able to recreate a working database by running dbunload. Use
> the -e option to exclude the customer table so you can at least get
> all the other data.
>
> Breck
>
> On 16 May 2005 08:38:22 -0700, "DiPauli" <dipauli@fiteng.it> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
|
|
|
|
|