SQL9573 & BW

[Ganimede-Dignan]

Hi,

in a just migrated from Oracle to ASE box we can see a dump with SQL9573 ODS data activation. The box is a Netweaver 7.02 SP 16.

Have you got any idea?

I've already read note number 1802963 but it's not applicable.

Thank you.

[Former Member]

Hi,

I have the same error after OS/DB migration to ASE 16.0.1.2 on a BW731SP12 on some ODS changelog tables while activating ODS

Database error 3812 with INS access to table /BIC/B0000152000

>[ASE error SQL 1918][SAP][ASE ODBC Driver][Adaptive Server

>Enterprise]Non-clustered index (index id = 2) is being

>rebuit.#[ASE Error SQL9573][SAP][ASE ODBC Driver][Adaptive

> Server Enterprise]The server failed to create or update a ro

>in table '/BIC/B0000152000' because the values of the row's

>partition key columns do not fit into any of the table'a

>partitions.#[ASE Error SQL3812][SAP][ASE ODBC

>Driver][Adaptive Server Enterprise]Tje datastream for token

>215 should only be sent after other datastreams. It can not

>be a command datastream on it's own. This is an internal

>error.#

After a rebuild online of involved tables on ASE side with user SAPSR3, activation was successfull.

reorg rebuild "/BIC/B0000152000" with online

[victoria_normand]

Hello Ganimede,
SQL error 9573 has been reported in the past but should be already fixed on newer ASE versions and also with last BW correction collection.
For reference: 1802963 - SYB: [ASE Error SQL9573] during BW rollup

Which ASE version do you have ?

Regards,

Victoria.

[Ganimede-Dignan]

15.7 SP 135

Regards.

[Ganimede-Dignan]

Not only... 1802963 is for 7.30, 7.31 and 7.40 NW releases.

Regards.

[Ganimede-Dignan]

SQL error 9573 when accessing table "/BIC/B0000460000".

Error Text of the Database: "[ASE Error SQL1918][SAP][ASE ODBC Driver][Adaptive

  Server Enterprise]Non-clustered index (index id = 2) is being rebuilt.#[ASE

  Error SQL16601][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Warning:

  Serial sort is being used rather than parallel sort in"