Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
ETL Jobs failed due to Database Driver Error....in OBIA 7961(Case Management Analytics)

Dear All,
The Incremental ETL load was running in production perfectly fine from past few months. Suddenly from past 2-3 weeks i am facing sudden failure of ETL jobs with error Database Driver Error...,
And once i restart the load from DAC the job runs successfully.
I checked with the network team and DBA and they didn't found any logs.
I checked the logs in Informatica Admin console. Please find attached herewith.
Hope to get some pointers to resolve this issue.
Regards,
Tarang Jain
Answers
-
2016-08-02 08:36:35 : INFO : (38648 | 13308) : (RS | ADSIC_DWH_REP) : VMEMERALD : CNX_53117 : Repository service process failed to process request ID 250, request operation code 447, reply operation code 447. Return Status: 2.2016-08-02 08:36:35 : ERROR : (38648 | 13308) : (RS | ADSIC_DWH_REP) : VMEMERALD : OBJM_54542 : ORA-03135: connection lost contactProcess ID: 23073Session ID: 76 Serial number: 45741[...]2016-08-02 00:05:46 : ERROR : (106236 | 102124) : (IS | Adsic_Integration_Service) : VMEMERALD : LM_36060 : Detected a failure on the repository connection(s).
The connection seen to break or get terminated between your repository server and the database. Check the network, the availability of the database server and if there's for example a firewall blocking issue on one of the machines involved. Just some things off the top of my head since the forums here contain several hundred posts just on the ORA-03135 issue itself: https://www.google.com/search?q=ORA-03135+site:community.oracle.com
0 -
Hi Cristian,
Thanks for your reply.
I checked with network team and we have firewall settings enabled, however the firewall termination rule is set to 6 hours. So i am not sure now whether firewall is causing this issue.
any other thoughts.
Regards,
Tarang Jain
0 -
Yes: TEST this. Empirically rather than just "It's 6h it might not be this".
0 -
Hi Chris,
NO luck as of now, still the ETL is failing and restart execution plan works successfully. Checked with the network team they dont have any observations , network is perfectly fine. Also checked with DBA , he also didn't find any alert logs in DB.
Please provide some pointer which can help me to debug this issue.
Regards,
Tarang Jain
0 -
You mentioned Firewall settings but didn't test those? Or is that what you say your network team tested?
0 -
Hi Chris,
Network team tested and said that they didn't find any packet loss in network.
Regards,
Tarang Jain
0 -
With the information at hand I can't tell you much more than what I said before. You have to find the blocking issue. Problems like that can't materialize out of thing air. Something must have happened or has been changed.
0