on 02-11-2022 1:43 PM
I'm trying to upgrade some databases from SAP v9.3 PL12 to SAP v10 FP2108.
I was able to upgrade some small new databases but ran into a problem with one of the bigger and older ones.
The problem is that TransactionNotification returns a problem:
It doesn't matter what object I'm updating (OUSR, ORDR etc.). The error is always the same.
Some of validations are done directly in TransactionNotification, other are started using CALL "anotherprocedure".
After a few tests:
If I use TransactionNotification from 9.3 version - I have this error.
If I use empty TransactionNotification - everything is ok
If I use TransactionNotification without some last added validation (that are started via CALL command) - everything is ok
If I use TransactionNotification with some last added validation but moved directly to TransactionProcedure - everything is ok
I analyzed these Stored Procedures that are referenced from Transaction Notification and I don't see a problem with a structure but probably with table OCRD (BP table).
If I run below stored procedure directly from HANA studio (it's only example)- it works.
But when I use it from Transaction Notification (I tested it as the only one validation in TN) - I have this error.
That's strange but everything has worked in 9.3. The problem doesn't exists if I change OCRD to OITM or other table
It looks like some kind of permission problem on database that was migrated to v10.
Has anyone encountered such a problem or has an idea how to further analyze it?
It was a problem with trigger that somebody created on database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The note does not apply to this problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check this SAP note 3043725 - Large Electronic Documents Are Not Being Processed on SAP HANA Database
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
9 | |
9 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.