 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
LeeD
Joined: 17 May 2007 Posts: 311 Country: New Zealand |
|
Validator hang |
|
Hi
The following code makes the 'validate' option in the script editor (windows ed 3.5.2) hang the scheduler, but it runs fine in the debugger. Any idea why?
The rest of the job db is the standard sample one.
dim process, string, "staging_test"
dim stepnumber, number, "60"
dim (procini, string)
concat (process, ".ini", procini)
dim (files, string)
dim (filetypes, string)
dim (masterfiletypes, string)
dim (agentport, number, "1096")
dim (procdate, string)
dim (stagingagent, string)
dim (stagingpkgpath, string)
dim (filepathonstaging, string)
dim (currentfile, string)
dim (filesempty, boolean, false)
dim (filetypesempty, boolean, false)
dim (pwd, string)
dim (uname, string)
dim (username, string)
dim (commandstring, string)
Dim (process_id, number)
dim (msg, string)
CD( "c:\\fds\\scripts\\" )
//grab external values
IniFileGetKey( "env.ini", "Agents", "staging", stagingagent )
IniFileGetKey( "env.ini", "Applications", "stagingpkg", stagingpkgpath )
IniFileGetKey( "env.ini", "Applications", "stagingfiles", filepathonstaging )
IniFileGetKey( "pwd.ini", "Agents", "pwd", pwd )
IniFileGetKey( "pwd.ini", "Agents", "uname", uname )
dim checkstep, boolean
inifilegetkey(procini, "Process", "files", files)
isequal files, "", checkstep
if checkstep, stepfiles, useprocfiles
stepfiles:
inifilegetkey(procini, stepnumber, "files", files)
useprocfiles:
inifilegetkey(procini, stepnumber, "filetypes", masterfiletypes)
dim currentfiletype, string
dim filesempty, boolean
dim filematchestype, boolean
//connect to staging agent
concatex( "corp\\", uname, username)
RAConnect( stagingagent, agentport, username, pwd )
RASetWorkDir(stagingpkgpath )
LoopUntil( filesempty, moveon )
set filetypes, masterfiletypes
set filetypesempty, false
gettoken (",", files, currentfile)
LoopUntil( filetypesempty, nextfile )
gettoken (",", filetypes, currentfiletype)
match currentfile, currentfiletype, filematchestype
if filematchestype, fetchpkg, nexttype
fetchpkg:
Concatex ("Ran SSIS package on file ", currentfile, " ", currentfiletype, msg)
addfdslog( process, stepnumber, "INFO", msg)
concatex ("run24x7SSIS.bat ", currentfile, commandstring)
RARun( commandstring, process_id )
nexttype:
IsEqual( filetypes, "", filetypesempty )
continue
nextfile:
IsEqual( files, "", filesempty )
continue
moveon:
raDisconnect
|
|
Thu Mar 26, 2009 11:51 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7953
|
|
|
|
Hi, this is caused by a known bug. The syntax checker may enter endless loop while validating nested loops containing conditional logic with jumps. To see what I mean, comment out for a moment nested LoopUntil and press F7. The script should validate just fine
|
|
Fri Mar 27, 2009 12:03 am |
|
 |
LeeD
Joined: 17 May 2007 Posts: 311 Country: New Zealand |
|
|
|
Thanks that explains it.
|
|
Fri Mar 27, 2009 12:05 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|