Добрый день.
Установлена система, чистая, SAP ERP 6 EHP 7 NW 7.42 на Sybase ASE 16.
Ядро последней версии, есть необходимость обновить версии некоторых пакетов, в частности:
Code:
SAPK-74707INSAPBSFND SAP_BS_FND 747 SAP_BS_FND 747: SP 0007
SAPKH61707 SAP_APPL 617 SAP_APPL 617: SP 0007
SAPK-61707INSAPFIN SAP_FIN 617 SAP_FIN 617: SP 0007
SAPK-74708INSAPBSFND SAP_BS_FND 747 SAP_BS_FND 747: SP 0008
SAPKH61708 SAP_APPL 617 SAP_APPL 617: SP 0008
SAPK-61708INSAPFIN SAP_FIN 617 SAP_FIN 617: SP 0008
При обновлении, возникает ошибка:
Code:
[ASE Error SQL175][SAP][ASE ODBC Driver][Adaptive Server Enterprise] Functions may only be nested to level 32.
Я сейчас, конечно, выставлю сообщение в SAP, но может кому удалось решить эту проблему?
Пробовал на Sybase ASE 15 SP132, та же проблема.
Запрос на котором всё падает:
Code:
3 ETP355XCDS View statements:
3 ETP000 CREATE VIEW "PPHMRP_PERF" AS SELECT "PPHMRPLOG_STAT"."MANDT" AS
3 ETP000 "MANDT", "PPHMRPLOG_STAT"."UUID", "PPHMRPLOG_STAT"."MRP_COMMENT",
3 ETP000 "PPHMRPLOG_STAT"."MRPSTARTTIME" AS "STARTTIMESTAMP",
3 ETP000 "PPHMRPLOG_STAT"."MRPENDTIME" AS "ENDTIMESTAMP",
3 ETP000 "PPHMRPLOG_STAT"."UNAME", "PPHMRPLOG_STAT"."MATERIALS_PLANNED",
3 ETP000 "PPHMRPLOG_STAT"."MATERIALS_FAILED",
3 ETP000 "PPHMRPLOG_STAT"."ABAP_MATERIALS_PLANNED",
3 ETP000 "PPHMRPLOG_STAT"."HANA_MATERIALS_PLANNED",
3 ETP000 "PPHMRPLOG_STAT"."HANA_TIME_OVERALL",
3 ETP000 "PPHMRPLOG_STAT"."ABAP_TIME_OVERALL",
3 ETP000 "PPHMRPLOG_STAT"."HANA_MDPS_READ",
3 ETP000 "PPHMRPLOG_STAT"."HANA_PLAF_INS_W_BOM",
3 ETP000 "PPHMRPLOG_STAT"."HANA_PLAF_W_BOM_P_MAT", "PPHMRPLOG_STAT"."REGEN",
3 ETP000 "PPHMRPLOG_STAT"."COMPS", "PPHMRPLOG_STAT"."TRANS",
3 ETP000 "PPHMRPLOG_STAT"."PLMOD", cast( cast( cast( cast( cast( cast(
3 ETP000 cast( cast( cast( cast( cast( cast( cast( cast( cast( cast(
3 ETP000 cast( cast( cast( cast( cast( cast( cast( cast( cast( cast(
3 ETP000 cast( cast( cast( cast( cast( cast( cast( cast( cast( cast(
3 ETP000 cast( cast( cast( cast( cast( cast( cast( cast( cast( cast(
3 ETP000 cast( cast( cast( cast( "PPHMRPLOG_STAT"."HANA_EBAN_DEL" as int )
3 ETP000 + "PPHMRPLOG_STAT"."HANA_EBAN_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_EBAN_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_EKPO_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_EKET_DEL" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_EKET_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_EKET_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_PLAF_DEL" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_PLAF_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_PLAF_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_RESB_DEL" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_RESB_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."HANA_DBVM_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_EBAN_DEL" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_EBAN_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_EBAN_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_PLAF_DEL" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_PLAF_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_PLAF_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_EKET_DEL" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_EKET_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_EKET_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_RESB_DEL" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_RESB_INS" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_RESB_UPD" as int ) as int ) +
3 ETP000 "PPHMRPLOG_STAT"."ABAP_DBVM_UPD" as int ) SUM_ITEMS,
3 ETP000 "PPHMRPLOG_STAT"."WO_AUTH", "PPHMRPLOG_STAT"."NOT_LOCKED",
3 ETP000 "PPHMRPLOG_STAT"."ERROR_STRING", "PPHMRPLOG_STAT"."SELSTRING" FROM
3 ETP000 "PPHMRPLOG_STAT" "PPHMRPLOG_STAT"