How do you fix error "Check and Posting is unable to accept data due to limited resources"

Melchor-FB-Support-Oracle

OPS local database has exceeded maximum recommended size"; "Check and Posting is unable to accept data due to limited resources"

Q: How do you fix error "Check and Posting is unable to accept data due to limited resources" in Simphony?

Melchor-FB-Support-Oracle

Issue Reported: Simphony displays an error message on the screen that cannot be passed by. Exact ErrorMessage/Symptoms: “OPS local database has exceeded maximum recommended size".

"Check and Posting is unable to accept data due to limited resources”

Business Impact: Affected terminal is not operational.

Steps to Reproduce: Launch Service Host à error message is displayed after Symphony loads on the WS

Solutions:

A: Shrinking the CheckandPosting/Local Datastore Database transaction logs

1. Open SQL Server Management Studio. 
2. Connect and login to the local database.
3. Expand Databases.
4. Right click on a database (CheckAndPosting / MCRSPOS / etc) and then choose Properties.
5. Choose Options.
6. Change Recovery Model from Full to Simple, then click OK.
7. Right click on the Database you just changed the properties for; select Tasks, then choose Shrink, and then choose Files.
8. Change the File type from Data to Log.
9. Choose Reorganize pages before releasing unused space.
10. Shrink file to the minimum number listed, 0Mb normally.
11. Repeat steps 7-10 until file size is 0 MB.
12. Once the file size is 0 MB, right click on the DB and choose Properties.
13. Go to Options and change the Recovery Model from Simple back to the original setting Full, then click OK.

Some systems may already set in Simple Recovery Mode. If so, do not change the recovery model. Leave it at Simple and proceed with steps 7-11, and do not change the Recovery Model to Full when complete.

 

 

B: Increasing Growth rates for the CheckandPosting DB

• Recommended settings are 256MB/Unrestricted for both Database and Logs

1. Open SQL Server Management Studio.
2. Connect and login to the Server.
3. Expand Databases.
4. Right click on a database (CheckAndPosting / MCRSPOS / etc) and then choose Properties.
5. Choose Files.
6. Under the AutoGrowth/MaxSize column, click on the ellipses (...) to access the configurations
7. Confirm AutoGrowth is enabled
8. Set File Growth to In Megabytes and set the amount to 256 MB.
9. Maximum File Size limitations is based on what version of SQL Server is installed and how large is the local disk drive.

• SQL Express 2008 : 4 GB
• SQL Server 2008 R2: 10 GB

1. Click OK to confirm changes.
2. Perform this for both items in the Files list : Database file and the related *_log file. 
3. Click OK in the Properties window to finish.

Link to KM/Documents Reviewed: 2155624.1