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