Sage 100 ERP not responding to SOTA.INI file updated to Timeout=45000

I have a custom routine in Sales Order Entry that takes a line item code, and queries all Serial Numbers associated to the same item that is being built on Work Orders. Sage 100 will consider the routine still running until a user has selected desired Serial Numbers in the queried results, and returns them to the line item.

Because we want to allow the users more than 10 seconds to make a selection, we want to extend the system timeout to 45 seconds. Currently, after 10 seconds we get the following:

"Script Control: The Script you are executing is taking longer than expected to run. Click End to abort the script, or Continue to continue script execution."

My reseller is wanting me to take this up with sage as it is a functional setting described in Sage Summit 2014 that we can extend the system timeout in the SOTA.INI file. However, here is the updated SOTA.INI but I still get the script control at 10 seconds. I've re-launched Sage and do not get the desired result. Not sure what to do next to debug this issue. Did I miss something in the SOTA.INI? Thank you for the help!

[Config]
Serial=701435756
Users=1
Buttoncursor=0
Resourcelib=90wres32.dll
RetryDeviceError=1
Disabled3detch=0

[WindowFrame]
TypeSizeLoc=1,570,440,0,0
Caption=Sage 100 ERP
MessageBar=22

[Font]
Points=11
Charset=0
Name=Courier New
Bold=0
LockFont=1

[RDBS]
rdb=MASSQLADO

[MASSQLADO]
OPN=[ADO]
DSN=
CON=CONNECT='Provider=SQLOLEDB~Integrated Security=SSPI'

[MSSQL]
DRIVER=SQL Server Native Client 10.0
EXTROPT=' (UPDLOCK)'
TOP=-1
TIMEOUT=45000
AUTOCOMMIT=ON
CACHESIZE=1
NONULLS=1
DEBUGIT=--
TEXTMAX=7168
IDENTDELIM=[]
STRCOMPARE=SQL
CACHEMETADATA=1
INVALIDDATE=1

[ADO]
EXTROPT=' (UPDLOCK)'
;UNIQUE=0
CURSORCLOSE=YES
TOP=-1
;CURSOR_TYPE=DYNAMIC
;ROWSET_SIZE=100
TIMEOUT=45000
;ISOLATION=COMMITED
;CONCURRENCY=OPT_VALUE
AUTOCOMMIT=ON
CACHESIZE=1
;KEYCACHETIME=250
NONULLS=1
DEBUGIT=--
TEXTMAX=7168
IDENTDELIM=[]
STRCOMPARE=SQL
PREPARE=Y
PREPARELIMIT=10
CACHEMETADATA=1
;FWDSECONDARY=3
INVALIDDATE=1

[ODBC]
EXTROPT=' (UPDLOCK)'
UNIQUE=0
CURSORCLOSE=YES
TOP=-1
CURSOR_TYPE=DYNAMIC
;ROWSET_SIZE=100
TIMEOUT=45000
ISOLATION=COMMITED
CONCURRENCY=OPT_VALUE
AUTOCOMMIT=ON
NONULLS=1
;DEBUGIT=--

[SQL]
DSN=MASSQL

[DFDM-FILELIST]
BSC-1=E:\data\acct4\v2014\MAS90\MAS_WAS\WOWAS\woowas.soa
BSC-2=E:\data\acct4\v2014\MAS90\MAS_WAS\CIWAS\CI_Item.M4T
RDK-1=E:\data\acct4\v2014\MAS90\MAS_WAS\ARWAS\AR_TransactionPaymentHistory.M4T
RDK-2=E:\data\acct4\v2014\MAS90\MAS_WAS\ARWAS\AR_OpenInvoice.M4T
RDK-3=E:\data\acct4\v2014\MAS90\MAS_WAS\ARWAS\AR_InvoiceHistoryDetail.M4T
BSC-3=E:\data\acct4\v2014\MAS90\MAS_WAS\WOWAS\wo1was.soa
BSC-4=E:\data\acct4\v2014\MAS90\MAS_WAS\IMWAS\IM_ItemWarehouse.M4T
BSC-5=E:\data\acct4\v2014\MAS90\MAS_WAS\SOWAS\SO_SalesOrderDetail.M4T
BSC-6=E:\data\acct4\v2014\MAS90\MAS_TST\SOTST\SO_SalesOrderDetail.M4T
BSC-7=E:\data\acct4\v2014\MAS90\MAS_TST\SOTST\SO_SalesOrderDetailTST.M4T
BSC-8=E:\data\acct4\v2014\MAS90\MAS_WAS\SOWAS\SO_SalesOrderHeader.M4T
BSS-1=\\accounting\acct4\v2014\MAS90\MAS_WAS\IMWAS\IM_ItemCost.M4T
BSS-2=
RDK-4=E:\data\acct4\v2014\MAS90\MAS_WAS\ARWAS\AR_InvoiceHistoryHeader.M4T
RDK-5=\\accounting\acct4\v2014\MAS90\MAS_WAS\GLWAS\GL_CompanyActiveBatch.M4T
RDK-6=\\accounting\acct4\v2014\MAS90\MAS_WAS\RAWAS\RA_ReceiptsDetail.M4T
RDK-7=\\accounting\acct4\v2014\MAS90\MAS_WAS\RAWAS\RA_ReceiptsHeader.M4T
[FILERUN]
BSC=syzcon,
[ACCOUNTING-CMD-CS]
Background=White
Foreground=Black
ProgSave=Blue
SyntaxColored=Y
SyntaxSearch=Reverse
SyntaxVariables=GreenDk
SyntaxLiterals=CyanDk
SyntaxRemarks=Blue
SyntaxErrors=Red
SyntaxMnemonics=BlueDk
SyntaxLabels=MagentaDk
ScreenWide=80
ScreenHigh=25

  • 0
    Are you modifying the SOTA.ini file on the server, the workstation, or both? I know that when modifying SOTA.ini to allow debug options I needed to also modify SOTAPGM.INI
  • 0 in reply to Jon_K
    Hey Jon,

    Thank you for the reply.

    I am modifying the files on the MAS90 server in the Launcher folder. All three of the following INI files have the timeouts set to "45000":

    SOTA.INI
    SOTACHR.INI
    SOTAPGM.INI

    Still timing out at roughly 10 seconds.
  • 0 in reply to dhedstrom

    Take a look at this: https://sagecity.na.sage.com/support_communities/sage100_erp/f/97/p/37754/114846#114846

    It would seem that you need to add:

    ScriptTimeout = 45000

    in the [Config] section of the SOTA.INI file, possibly in the other .ini files as well

    Also, there are 2 sets of SOTA.INI files, one for the client launcher, and one set in your MAS90\Launcher folder.

    To be honest, I'm not sure which is more important to set but if it were me I would try setting them both. For instance on my Sage server I have the client installed and then on a separate array I have the server piece installed so I have 2 seperate SOTA.ini files. See below:

    Client: C:\Sage\Sage 100 ERP Workstation\MAS90\Launcher\SOTA.ini

    Server: D:\Sage\SageShare\Sage 100 Advanced ERP\MAS90\Launcher\SOTA.ini

    Let me know if that helps you at all.