Cache issue in SAP PI 7.5 Single Stack

[Former Member]

Hi All,

We are facing cache issue in SAP PI 7.5 . We have already tried below options.

1. Full Cache refresh

2. Partial Cache refresh

3. Java Node restart

4 Java node restart along with DB

5. Full server restart.

The exception talks about being unable to set the 4^th parameter in the DB statement. From the below statement that would mean Object ID (OBJ_ID) in Adapter Framework Cache Update table (XI_AF_CACHE_UPDT).

Failed to set the parameter 4 of the statement >>INSERT INTO XI_AF_CACHE_UPDT (UPDT_TIME, REF_ID, NODE_ID, OBJ_ID, OBJ_TYPE, EVENT, SEQ_NUM, OBJ_BYTE, FULLREFRESH) VALUES(?, ?, ?, ?

, ?, ?, ?, ?, ?)<<: Cannot assign a >>java.lang.String<< object of length 101 to a parameter with JDBC type >>VARCHAR(100)<<.

Warm Regards,

Rudra

[former_member182412]

Hi Rudra,

Check the object ID, it seems like the length of the object ID is 101 characters where database only accept 100 characters.

Regards,

Praveen.

[Former Member]

Hi Praveen,

As we know Object ID is created automatically and we have cross checked object id is having 32 characters here.

PI was working properly till yesterday and we didn't update any service pack or SCA/EAR files.

Warm Regards,

Rudra

[former_member186851]

Hello Rudra,

Did any changes happen at DB level or system level?

Did you cross check with Basis team?

[Former Member]

Hi Raghu,

There is no change at DB level as well.

Regards,

Rudra

[former_member186851]

Hello Rudra,

Then as of a sudden the system went down?

Even if the restart is not helping raise to SAP.