AR POST IN PROGRESS 1

[NewCCTech]

Hi All,

I got probelm when i tried to post AR Receipt Batches. when hit Post button, then sometimes it posts the whole batch, sometimes it post part (2 or 3 entries) of the batch, sometimes it does not post any of the bacth, just becomes freezing and shows POST IN PROGRESS.

Anyone has any idea on what happens to my AR?

Thanks!

 

[Jay Converse]

Version?
Service packs?
Database?
Network deployment?
Workstation OS?

 

[NewCCTech]

Version 54A
Service Pack 3
SQL 2008
Windows Server 2008

 

[Jay Converse]

Network deployment, i.e., speed and cabling?
Workstation OS?
Does it happen on all PCs?
Does it happen on the server?
Have you done a Dbdump/Dbload lately?
What's the recovery model on the database?
Do you run a maintenance plan on the database?

 

[NewCCTech]

--Don't think it is network deployment problem 'cause sometimes users can post a batch (2 entries) successfully.

--workstation OS: should be Windows XP or Vista

--For now it happens on all PCs whichever we tried on

--Yes, it happens on Server too
--Have not done any Dbdump/Dbload lately, but we do moves ACCPAC from one server to another server a couple of weeks ago

--did not run a maintenance plan on the database



Thanks!

 

[Jay Converse]

1. "we do moves ACCPAC from one server to another server a couple of weeks ago"

How did you do that? Detach and attach?
Did you move the Accpac programs, too? If so, did you Regacc /u before you moved them?
Did the problems start when you took the old server offline?

2. "did not run a maintenance plan on the database"
Then start one.

 

[NewCCTech]

Hi tuba2007

Thanks for your response!

First I need to correct my previouse posting.
===
1. "we do moves ACCPAC from one server to another server a couple of weeks ago"

Actually, we did not move ACCAPC server, we just switch our domain to another domain.

===

Second, I looked at the DBSpy


LINK-14: 10:42:40.25 OPEN-TABLE ( table=OESAP , flags=1 )
LINK-14: 10:42:40.26 handle <-- 58
LINK-14: 10:42:40.26 GET-TABLE-INFO ( table=OESAP )
LINK-14: 10:42:40.26
LINK-14: 10:42:40.26 GET-TABLE-INFO ( table=OESAP )
LINK-14: 10:42:40.26
LINK-14: 10:42:40.29 GET-DRVR-INFO ( )
LINK-14: 10:42:40.29
LINK-14: 10:42:40.31 GET ( handle=57, keyno=0 )
LINK-14: 10:42:40.31
LINK-14: 10:42:40.31 GET ( handle=58, keyno=0 )
LINK-14: 10:42:40.32
LINK-14: 10:42:40.32 GET ( handle=55, keyno=0 )
LINK-14: 10:42:40.32
LINK-14: 10:42:40.35 IS-REC-LOCKED ( handle=55 )
LINK-14: 10:42:40.35 ==> 124 <DBS_RECORD_NOT_LOCKED>
LINK-14: 10:42:40.35 LOCK ( handle=55, keyno=0 )
LINK-14: 10:42:40.35
LINK-14: 10:42:40.35 UPDATE ( handle=55 )
LINK-14: 10:42:40.35
LINK-14: 10:42:40.39 INSERT ( handle=36 )
LINK-14: 10:42:40.39
LINK-14: 10:42:40.41 INSERT ( handle=24 )
LINK-14: 10:42:40.41
LINK-14: 10:42:40.48 IS-REC-LOCKED ( handle=20 )
LINK-14: 10:42:40.48 ==> 124 <DBS_RECORD_NOT_LOCKED>
LINK-14: 10:42:40.49 LOCK ( handle=20, keyno=0 )
LINK-14: 10:42:40.49
LINK-14: 10:42:40.49 UPDATE ( handle=20 )

that is where it stoped.

I checked OESAP, double checked all salespersons related to the AR receipt batches and they are active. Since our database is huge, it will take forever to do Data Dump/Load, so we are trying to troubleshoot on record level.

So do you have any idea aside to do something on database level?

Appreciate you great help!

 

[NewCCTech]

Also I got the error message when the post in progress stops responding.

Description:
A problem caused this program to stop interacting with Windows.

Problem signature:
Problem Event Name: AppHangB1
Application Name: A4WCONTAINERXP.EXE
Application Version: 5.4.0.25
Application Timestamp: 447a08df
Hang Signature: 847c
Hang Type: 0
OS Version: 6.0.6002.2.2.0.16.7
Locale ID: 1033
Additional Hang Signature 1: 32ed8e7663c1099cab64ef437ff86965
Additional Hang Signature 2: 9309
Additional Hang Signature 3: c639fad98ae62ccf500b0732ccea9213
Additional Hang Signature 4: 847c
Additional Hang Signature 5: 32ed8e7663c1099cab64ef437ff86965
Additional Hang Signature 6: 9309
Additional Hang Signature 7: c639fad98ae62ccf500b0732ccea9213


any idea on this?

Thanks!

 

[Jay Converse]

Run an index rebuild, it's basic SQL maintenance that your IT staff should have been doing at least monthly, if not weekly.

 

[NewCCTech]

Hi tuba2007,

I am so excited that our database got fixed and is working very well after running an index rebuild. Thanks tuba2007 for your great help!