We are running MS Great Plains v8 and SQL 2000. One of
our other sites uses some custom program for which they have an in
house developer. Last Friday he contacted me stating that the
integration was suddenly failing. Now, I am not a SQL guy, nor am I a GP guy. I have had to scratch
and claw just to be able to do the basic administration so the last I do is touch them or even look at them unnecessarily. So
nothing has changed on my side. The ONLY thing I noticed is that the
MSSQLOLAPService crashed on Thursday night. It does this fairly
regularly as it hits its upper memory limit. I just restart the service and
all is well for another week or two. So I naturally attributed their
issues which began on Friday, to the OLAP service crashing on Thursday
(and remaining crashed until mid day Friday). Seemed logical. So on
Friday night, all of the integration routines ran successfully. I figured
problem solved. Well today he is saying that he is still having the
problem. So here is where I really need help in a hurry (sorry to be so
longwinded):
- The integration is pulling information from the custom program
(which is where they enter their orders I believe) into Great Plains.
- When run, the integration fails on every document and the log
states "Error: Please check and reenter the date." with a status code
of: 0x80040009 (-2147221495). Source is: Ln 1689 Col 2, Update module,
Last CBOM field read was root.'Date', Last window field visited was
'Delete Button' of window 'SOP_Entry' of form 'SOP_Entry'
- He insists that all is correct from his perspective. As well, he
says that this was all working as recently as Friday morning and that
he has made no changes.
I am not sure where to start in trying to resolve this. Could really use some guidance/help.
