DBIF_REPO_SQL_ERROR after stopping JOB

[former_member862857]

Hi everyone,

Could you help me to understand the cause of this error.

I have a job that runs in test environment and in production (same amount of data)

only difference test no archive prod yes

in testing there are never any problems.

usually the job takes no more than 5000 seconds, but sometimes this same production job can take up to 12 hours.

i realized but not sure that maybe veam could be the cause of this interruption..

what could be the cause of this interruption which then leads me to interrupt the job or to go along with the times

|

|How to correct the error |

| Database error text........: "ORA-03114: not connected to ORACLE" |

| Triggering SQL statement...: "CX_SY_OPEN_SQL_DB=============CP " |

| Internal call code.........: "[REPO/*/43/LOAD/CX_SY_OPEN_SQL_DB=============CP |

| ]" |

| Please check the entries in the system log (Transaction SM21). |

| |

| If the error occures in a non-modified SAP program, you may be able to |

| find an interim solution in an SAP Note. |

| If you have access to SAP Notes, carry out a search with the following |

| keywords: |

| |

| "DBIF_REPO_SQL_ERROR" " " |

| "SAPLBSVA" or "LBSVAF14" |

| "STATUS_READ"

[janos_mucsi-besze]

Hi, this can be even caused by the long runtime. And as a result some 3rd party tool (like Firewall Software) kills the process due to the long runtime. If I were you I would check the network settings for any time value for stale connection checking.

[former_member862857]

What parameters do you recommend me to increase?

the problem occurs only in production environment while in test it doesn't (the systems are identical).

these below are the times as you can see sometimes they go really long with the times.

[janos_mucsi-besze]

Hi,

Either try to increase the runtime-related vaues for dead- or stale connection checking, or tune that longrunning job so that it makes the job quicker and finishes in time.

[aprao]

Please refer the given link below for your information.

https://answers.sap.com/questions/10951392/ora-03114-not-connected-to-oracle.html

Thanks

Prasad Rao