OnDemand User Group
Support Forums => MP Server => Topic started by: yousuf_gani on March 15, 2017, 09:52:31 AM
-
Hi All
Suddenly My Ondemand Stopped Writing Log Information to the SYSTEM LOG(SL*) Table.
CMOD version: 9.5.0.6
Oracle: 11.2.0.4
OS: Linux
When checked with Verbose mode
Initially I got Below Error, but the LOAD was successful and wrote the SA2 table with LOADID
- ARS4323E Unable to log load information
Later Even the LOAD started FAILING with the Error Codes
- ARS1166E Unable to save load information
- ARS4311E Loading failed
- ARS4323E Unable to log load information
- Checked DB Tablespace and CACHE sizing everything has enough storage.
- IBM site asked to check the SYSTEM LOG but that is the problem we don't have anything in the SL* table after some period of days.
Could you please help to check the root cause of this Problem please. what can be the solution to address this problem.
Please do the needful help to help with this problem.
Thanks
Mohd Yousuf gani
-
Typically means problems with the database. I'm not super familiar with Oracle, but check it's diagnostics, and make sure the transaction logs aren't full.
Also, critical errors are often logged to the console. Check your console device for messages relating to the failures.
You may also want to consider forcing the last SL table closed with the arstblsp command.
-JD.
-
Hi Justin,
Thanks a lot for the Reply,
Initially I planned to Do the ARSMIANT -<> -r (for DB Statistics) with my Team in Remote.
Once I will also Check with the Oracle Team about your reference Points like
- transaction logs
- Consoloe Errors etcs
- As the Final Try I wil try to Close the Exisitng Sl2 table Closed and create a new table.
Thanks you so much for help...
-
Problem Fixed.
QUOTA not Set for the TABLESPACE. Which caused ARSLOAD not able to write to the TABLES.
Thanks a lot Justin Derrick for your Help to check the DB related problem.
-
Yousuf - thank you for posting the resolution to this problem.
Ed Arnold
-
Glad I could help to get this resolved so quickly! :)
Take care.
-JD.