Sage 100

Client has ScanForce Warehouse Automation with Auto Import running on the server. It frequently errors with Error 15 and various program names and line numbers. The latest was Error 15 in program CI_ITEMWAREHOUSE.PVC at line 0197. IM003: Specified driver could not be loaded due to system error 8: Not enough storage is available to process.

Can anyone shed any light on this error? The Sgae KB has no hits and ScanForce says (at least on the last error which was an SO program) it's not one of their programs.

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Doing a Google search on the error 8 it looks like it could be an issue with the heap size needed increased using a registry edit or possibly a corrupt odbc my
driver.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

https://stackoverflow.com/questions/507853/system-error-code-8-not-enough-storage-is-available-to-process-this-command

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Greg - Is your client on Premium? What version are they on? If not on Premium, do they use SQL Mirroring (and ergo the same client using PvxPlus)? 

It sounds like Premium or SQL Mirroring is in play. If the Error 15 is appearing on the screen (as opposed to the ScanForce logfile), you could click on Info, click on Debug and at the prompt type the following to get the actual SQL error:

? MSG(-1)
CLIP_BOARD WRITE MSG(-1)

The 2nd line copies to the clipboard so you can paste it in Notepad or somewhere. Not sure what version you're on but on mine that line means a Write to IM_ItemWarehouse is attempted. The SQL error should tell you more. If SQL Mirroring is in play then maybe you have to reactivate / deactivate it OR unsync / re-sync the tables with the utility OR something along those line. In fact I think they have a log file of their own in \Home perhaps and I bet it did the MSG(-1) for you and put it in the log so you wouldn't have to.

Hope that helps.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------

Original Message:
Sent: 04-04-2019 21:46
From: Doug Higgs
Subject: ScanForce Auto Import Error

https://stackoverflow.com/questions/507853/system-error-code-8-not-enough-storage-is-available-to-process-this-command

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

@Alnoor Cassim, they are on Standard using SQL Mirror and this morning ScanForce is suggesting that it could be related to SQL Mirror.​ I will capture the message next time it happens.
@Doug Higgs I knew what you meant LOL, would it hurt/help to increase the Heap Size even if they are not on Advanced?​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 04-04-2019 22:10
From: Alnoor Cassim
Subject: ScanForce Auto Import Error

Greg - Is your client on Premium? What version are they on? If not on Premium, do they use SQL Mirroring (and ergo the same client using PvxPlus)?

It sounds like Premium or SQL Mirroring is in play. If the Error 15 is appearing on the screen (as opposed to the ScanForce logfile), you could click on Info, click on Debug and at the prompt type the following to get the actual SQL error:

? MSG(-1)
CLIP_BOARD WRITE MSG(-1)

The 2nd line copies to the clipboard so you can paste it in Notepad or somewhere. Not sure what version you're on but on mine that line means a Write to IM_ItemWarehouse is attempted. The SQL error should tell you more. If SQL Mirroring is in play then maybe you have to reactivate / deactivate it OR unsync / re-sync the tables with the utility OR something along those line. In fact I think they have a log file of their own in \Home perhaps and I bet it did the MSG(-1) for you and put it in the log so you wouldn't have to.

Hope that helps.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------


Original Message:
Sent: 04-04-2019 21:46
From: Doug Higgs
Subject: ScanForce Auto Import Error

https://stackoverflow.com/questions/507853/system-error-code-8-not-enough-storage-is-available-to-process-this-command

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc

@Greg Stiles  I am not sure of he answer to that question.  I believe you are asking because it wouldn't help by increasing the heap size on the server if the processing is at the workstation.  If it is the ScanForce host is exceeding the allocated memory heap then the heap size should be increased on the computer the host program is executing on.  That said, if the host program is running on a workstation, yet the program is executing on the server (advanced and premium), is the memory heap on the workstation or the server being used?  I do not know.  Maybe Alnoor or someone else can answer that.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 04-05-2019 10:50
From: Greg Stiles
Subject: ScanForce Auto Import Error

@Alnoor Cassim, they are on Standard using SQL Mirror and this morning ScanForce is suggesting that it could be related to SQL Mirror.​ I will capture the message next time it happens.
@Doug Higgs I knew what you meant LOL, would it hurt/help to increase the Heap Size even if they are not on Advanced?​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 04-04-2019 22:10
From: Alnoor Cassim
Subject: ScanForce Auto Import Error

Greg - Is your client on Premium? What version are they on? If not on Premium, do they use SQL Mirroring (and ergo the same client using PvxPlus)?

It sounds like Premium or SQL Mirroring is in play. If the Error 15 is appearing on the screen (as opposed to the ScanForce logfile), you could click on Info, click on Debug and at the prompt type the following to get the actual SQL error:

? MSG(-1)
CLIP_BOARD WRITE MSG(-1)

The 2nd line copies to the clipboard so you can paste it in Notepad or somewhere. Not sure what version you're on but on mine that line means a Write to IM_ItemWarehouse is attempted. The SQL error should tell you more. If SQL Mirroring is in play then maybe you have to reactivate / deactivate it OR unsync / re-sync the tables with the utility OR something along those line. In fact I think they have a log file of their own in \Home perhaps and I bet it did the MSG(-1) for you and put it in the log so you wouldn't have to.

Hope that helps.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA


Original Message:
Sent: 04-04-2019 21:46
From: Doug Higgs
Subject: ScanForce Auto Import Error

https://stackoverflow.com/questions/507853/system-error-code-8-not-enough-storage-is-available-to-process-this-command

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc

Heap size increase not help size increase

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

SQL Mirror log:
--------------------------------------------------
2019-04-05 09:44:32 error on WRITE
<*> Error #5: Data error on device or file
MSG: 22003: [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting numeric to data type numeric.
Original:\\mas-01\Acct\SageMAS\2016\MAS90\MAS_PL1\CIPL1\CI_Item.M4T
Mirror:[odb]SQLMIRRORING;MAS_PL1..CI_Item;USER=Sage100;
--------------------------------------------------

[EDIT] I had copied the wrong error - this is the correct log error with the overflow message I was referring to below.[EDIT]

I will resync the affected tables. This client has an issue where the cost of an item goes haywire and causes errors. Looks like I will need to investigate.

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 04-04-2019 22:24
From: Doug Higgs
Subject: ScanForce Auto Import Error

Heap size increase not help size increase

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Ah the "Arithmetic overflow error converting numeric to data type numeric" is a SQL error which always means a number, likely a cost in CI_item or IM_ItemWarehouse, or IM_ItemCost (at least the 1st two in this case when including last night's error) has gone haywire just like you're mentioning.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------

Original Message:
Sent: 04-05-2019 12:46
From: Greg Stiles
Subject: ScanForce Auto Import Error

SQL Mirror log:
--------------------------------------------------
2019-04-05 09:44:32 error on WRITE
<*> Error #5: Data error on device or file
MSG: 22003: [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting numeric to data type numeric.
Original:\\mas-01\Acct\SageMAS\2016\MAS90\MAS_PL1\CIPL1\CI_Item.M4T
Mirror:[odb]SQLMIRRORING;MAS_PL1..CI_Item;USER=Sage100;
--------------------------------------------------

[EDIT] I had copied the wrong error - this is the correct log error with the overflow message I was referring to below.[EDIT]

I will resync the affected tables. This client has an issue where the cost of an item goes haywire and causes errors. Looks like I will need to investigate.

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 04-04-2019 22:24
From: Doug Higgs
Subject: ScanForce Auto Import Error

Heap size increase not help size increase

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc

Greg I don't think you have to wait for error again. There is a log file already and I believe it runs everytime the mirror / write to the SQL table occurs. I don't know the name of it but it probably ends in .Log or .Txt, lives in \mas90\Home or further below, and very large in size.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------

Original Message:
Sent: 04-04-2019 22:24
From: Doug Higgs
Subject: ScanForce Auto Import Error

Heap size increase not help size increase

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Ding ding ding...

Total Whse Value in CI_Item. Checking IM_ItemWarehouse too...

Thanks @Alnoor Cassim​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 04-05-2019 12:51
From: Alnoor Cassim
Subject: ScanForce Auto Import Error

Greg I don't think you have to wait for error again. There is a log file already and I believe it runs everytime the mirror / write to the SQL table occurs. I don't know the name of it but it probably ends in .Log or .Txt, lives in \mas90\Home or further below, and very large in size.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------


Original Message:
Sent: 04-04-2019 22:24
From: Doug Higgs
Subject: ScanForce Auto Import Error

Heap size increase not help size increase

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc

FWIW - the SQL Mirror error log is located here:
..\MAS90\Home\Lib\_plus\mirror\error.log

Not sure about the full logfile. @Nicole Ronchetti?

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 04-05-2019 13:28
From: Greg Stiles
Subject: ScanForce Auto Import Error

Ding ding ding...

Total Whse Value in CI_Item. Checking IM_ItemWarehouse too...

Thanks @Alnoor Cassim​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 04-05-2019 12:51
From: Alnoor Cassim
Subject: ScanForce Auto Import Error

Greg I don't think you have to wait for error again. There is a log file already and I believe it runs everytime the mirror / write to the SQL table occurs. I don't know the name of it but it probably ends in .Log or .Txt, lives in \mas90\Home or further below, and very large in size.

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA


Original Message:
Sent: 04-04-2019 22:24
From: Doug Higgs
Subject: ScanForce Auto Import Error

Heap size increase not help size increase

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc