cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Business One v10 FP 2108 for HANA TransactionNotification

pj_1989
Explorer

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?

Accepted Solutions (1)

Accepted Solutions (1)

pj_1989
Explorer
0 Kudos

It was a problem with trigger that somebody created on database.

Answers (2)

Answers (2)

pj_1989
Explorer
0 Kudos

The note does not apply to this problem.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Check this SAP note 3043725 - Large Electronic Documents Are Not Being Processed on SAP HANA Database

Regards,

Nagarajan