Which database supported by SAP PI serialization

[former_member816597]

Hi Experts,

I am using MS SQL 2005 express database. But while I am doing serialization in PI it is not working.

Please help.

Ram Mittal

[iaki_vila]

Hi Ram,

The problem is not in PI is in the Database itself or the driver choosen. I had this problem before in Oracle and i had to do some change in the DB like this blog said

If your are in MS SQL you must check how to do it serizalizable or to talk with your DB if the serialization is enabled.

Regards.

[former_member816597]

Thanks but actually here my admin have no idea about the same.

Also in above link settings are for oracle not for Microsift sql express.

Can you have any settings list of SQL

[iaki_vila]

Hi Ram,

You can talk with your DB team to try with this instruction form MS SQL documentation: SET TRANSACTION ISOLATION LEVEL (Transact-SQL)

Regards.