OnDemand User Group

Support Forums => MP Server => Topic started by: yousuf_gani on March 15, 2017, 09:52:31 AM

Title: ARS4323E Unable to log load information
Post 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

Title: Re: ARS4323E Unable to log load information
Post by: Justin Derrick 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.

Title: Re: ARS4323E Unable to log load information
Post by: yousuf_gani 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...

Title: Re: ARS4323E Unable to log load information
Post by: yousuf_gani 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.

Title: Re: ARS4323E Unable to log load information
Post by: Ed_Arnold on March 17, 2017, 05:54:19 AM

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

Ed Arnold

Title: Re: ARS4323E Unable to log load information
Post by: Justin Derrick on March 17, 2017, 07:12:09 AM

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

Take care.

-JD.