Spam - ORA-03106: fatal two-task communication protocol

[Former Member]

Hi gurus.

I'm having this error always I import a queue.

Before the error I continue with the "import queue" and it goes to the end, no problem.

Could any one help me how to solve this?

Above the abend details.

Runtime Error DBIF_SETG_SQL_ERROR

Database error text........: "ORA-03106: fatal two-task communication protocol

error"

Internal call code.........: "[SETG/GET /INDX_HIER ]"

-

---

"DBIF_SETG_SQL_ERROR" C

"SAPLSHI2" or "LSHI2U25"

"STREE_READ_BUFFERED_DATA_GENER"

-

---

System environment:

SAP Release.............. "640"

Application server....... "PCINTRA"

Network address.......... "192.168.200.100"

Operating system......... "Windows NT"

Release.................. "5.1"

Hardware type............ "Intel 80686 (Mo"

Character length......... 8 Bits

Pointer length........... 32 Bits

Work process number...... 1

Short dump setting....... "full"

Database server.......... "PCINTRA"

Database type............ "ORACLE"

Database name............ "NWW"

Database owner........... "SAPNWW"

Character set............ "English_United State"

SAP kernel............... "640"

Created on............... "Mar 21 2007 23:47:09"

Created in............... "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10"

Database version......... "OCI_920_SHARE "

Patch level.............. "175"

Patch text............... " "

Supported environment....

Database................. "ORACLE 8.1.7.., ORACLE 9.2.0.."

SAP database version..... "640"

Operating system......... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2"

Thanks in advance

Paulo

[Former Member]

Hi All,

we have same error occuring intermitently in BW system. It started after upgrade to 10.2.0.2. and sap notes 1005758 and 952388 applied.

Have OSS message open but no use so far.

Anyone has suggestions ??

regards

[arijanasvaljek]

Hello,

I also have this problem from time to time on BW system. If you've solve it could you please tell me how ?

My config is :

SAP NetWeaver BI 7.0

Oracle 10.2.0.2 (not yet applied note 1005758)

Regards,

Arijana

[Former Member]

Please apply note 1005758 and ensure you have applied all the mandatory patches from note 817096. These are required for the smooth and efficient operation of the database. When installing the patches, it will remove the 5225799 CPU patch and 5092134 interim patch needs to be reinstalled again.

[Former Member]

We resoloved by reapplying patch . Initially we had applied about 30 patches by mopatch, probably one of patches in queue updated 3 files. We didnot apply any CPU patches.

Reapplying 5099995 fixed it.

[Former Member]

Hi guys,

It's due to the Oracle bug 4523125.

Please refer Note 1005758 to fix the problem.

Please reward points if this info help

[kishore_soma]

Hi Ben,

i m also getting the same error. we are using ORacle 10.2.2 on Linux.

The problem is that the Updates are not getting processed and are waiting for V2 update process which is processing one of the v2 process for much time and status is running sequential read - VBdata table.

the status of the updates are - v1 processed. Find the error log of SM21 below-

-

---

NiConnect Unsuccessful, Return Code: -0003

> Host: ACPLAPP

> Service: sapgw01

Communication error, CPIC return code 020, SAP return code 665

> CPI-C function: CMINIT(SAP)

SQL error 3106 . Work processes in reconnect status

Perform rollback

Work process has left reconnect status

Run-time error "DBIF_SETG_SQL_ERROR" occurred

> Short dump "070828 020442 SAPPRD AMTFINISHING" generated

Transaction Canceled 00 671 ( DBIF_SETG_SQL_ERROR 20070828020442SAPPRD AMTFINISHING0091 )

Perform rollback

Update terminated

> Update key: 46CE6156C66E4997E1000000C0A80107

> Update module: G_PCA_0_POSTING

SQL error 3113 . Work processes in reconnect status

-

---

Kindly suggest

Thnx

Kishore

[Former Member]

Hi Kishore,

Did you check note 1005758? What's your linux version? 64bit or 32bit?

[Former Member]

Hi Kishore,

Did you solve you problem? I have the same error messages on SM21, and the same Oracle version of you.

Did you apply Patch 5099995 (base bug 5092134)?

Thanks,

Federico Biavati

[Former Member]

Hi Paulo,

I've got the same problem on an Oracle 10g database.

What is your database/version please ?

Do you solve de problem ? How ?

Regards

Pascal

[Former Member]

Hi Pascal.

Not solved ....

Oracle 10.2g.

My installation is a test environment (win xp, 1.5g memory). I think my problem is related to small resources. What is your environment?

Regards,

Paulo