We had a situation like EAL services are running in Service Panel but still EAL Data sync not showing up in EAS console.
Some points we can check in EAL while trouble shooting:
1. If you see any socket errors and Data sync not available in EAS console, you can restart EAL services. It will fix the issue in maximum chances.
2. We need to check schema passwords used for HFM and EAL.
3. We need to check Target and Source. If it is HFM to Essbase, we can check Essbase connections, and HFM regions.
4. If source and target is schema and HFM, we need to check schema connectivity and HFM regions.
5. Check out password for dss_admin (default admin username for EAL, while doing configuration we will give this username and password) in EAL setup correct or not.
6. Check out schema passwords connect or not.
7. Chec the log files in below location:
D:\Oracle\EAL_Home\EssbaseAnalyticsLink\Work\dss.log
D:\Oracle\EAL_Home\EssbaseAnalyticsLink\Work\eal.log
8. Port numbers are reachable or not:
- Verify ports 5024, 5423 ports are open.
- Check for any recent security updates or anti virus updates that happened?
In our case, EAL Data sync not showing up as available in EAS console. So, We tried to reconfigure EAL and code.xml file got corrupted and showing up as 1 KB where as in other Environment it is more than that size.
So, we restored files from backup and restarted services. Ran Region default for Testing. It ran successfully and Data sync is available now and Data sync Data is now On.
Oracle update on the same for our future reference:
Analysis and follow up done by Kamalanathan Prabhakaran.
Thanks,
Mady
Some points we can check in EAL while trouble shooting:
1. If you see any socket errors and Data sync not available in EAS console, you can restart EAL services. It will fix the issue in maximum chances.
2. We need to check schema passwords used for HFM and EAL.
3. We need to check Target and Source. If it is HFM to Essbase, we can check Essbase connections, and HFM regions.
4. If source and target is schema and HFM, we need to check schema connectivity and HFM regions.
5. Check out password for dss_admin (default admin username for EAL, while doing configuration we will give this username and password) in EAL setup correct or not.
6. Check out schema passwords connect or not.
7. Chec the log files in below location:
D:\Oracle\EAL_Home\EssbaseAnalyticsLink\Work\dss.log
D:\Oracle\EAL_Home\EssbaseAnalyticsLink\Work\eal.log
8. Port numbers are reachable or not:
- Verify ports 5024, 5423 ports are open.
- Check for any recent security updates or anti virus updates that happened?
In our case, EAL Data sync not showing up as available in EAS console. So, We tried to reconfigure EAL and code.xml file got corrupted and showing up as 1 KB where as in other Environment it is more than that size.
So, we restored files from backup and restarted services. Ran Region default for Testing. It ran successfully and Data sync is available now and Data sync Data is now On.
Oracle update on the same for our future reference:
Analysis and follow up done by Kamalanathan Prabhakaran.
Thanks,
Mady
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
ReplyDeleteReasons to Learn Oracle Hyperion Planning
I read your post. It is very informative and helpful to me. I admire the message valuable information you provided in your article.
ReplyDeletedevops online training
I read your post. It is very informative ad helpful to me. I admire the message valuable information you provided in your article.
ReplyDeletepower bi training