ARS4323E Unable to log load information

Previous topic - Next topic

yousuf_gani

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

Justin Derrick

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

yousuf_gani

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...

yousuf_gani

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.


Ed_Arnold

Yousuf - thank you for posting the resolution to this problem.

Ed Arnold
#zOS #ODF

Justin Derrick

Glad I could help to get this resolved so quickly!  :)

Take care.

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR