Author Topic: ARS4323E Unable to log load information  (Read 173 times)

yousuf_gani

  • Newbie
  • *
  • Posts: 45
    • View Profile
ARS4323E Unable to log load information
« 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

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 1285
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: ARS4323E Unable to log load information
« Reply #1 on: March 16, 2017, 04:08:06 AM »
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.
#Install, #Educate, #Repair, #Upgrade, #Migrate, #Enhance, #Optimize.

Call:  +1-866-533-7742
Click:  http://JustinDerrick.com/
eMail:  jd@justinderrick.com
Wiki:  http://CMOD.wiki/

Interests:  #AIX6 #AIX7 #Linux #Multiplatforms #DB2v9 #DB2v10 #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #Training

yousuf_gani

  • Newbie
  • *
  • Posts: 45
    • View Profile
Re: ARS4323E Unable to log load information
« Reply #2 on: March 16, 2017, 04:16:29 AM »
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

  • Newbie
  • *
  • Posts: 45
    • View Profile
Re: ARS4323E Unable to log load information
« Reply #3 on: March 16, 2017, 08:43:11 AM »
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

  • Hero Member
  • *****
  • Posts: 597
    • View Profile
Re: ARS4323E Unable to log load information
« Reply #4 on: March 17, 2017, 05:54:19 AM »
Yousuf - thank you for posting the resolution to this problem.

Ed Arnold

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 1285
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: ARS4323E Unable to log load information
« Reply #5 on: March 17, 2017, 07:12:09 AM »
Glad I could help to get this resolved so quickly!  :)

Take care.

-JD.
#Install, #Educate, #Repair, #Upgrade, #Migrate, #Enhance, #Optimize.

Call:  +1-866-533-7742
Click:  http://JustinDerrick.com/
eMail:  jd@justinderrick.com
Wiki:  http://CMOD.wiki/

Interests:  #AIX6 #AIX7 #Linux #Multiplatforms #DB2v9 #DB2v10 #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #Training