473,231 Members | 1,703 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

SQL job error

Hi all

Inherited environment :

Windows 2003 SP1 Ent
SQL 2000 Standard
16 GB RAM

BOOT INI Switches : /3GB /PAE

I understand that SQL 2000 standard can only address 2 GB and
therefore the /3GB switch will only rob the OS of a GB of RAM without
giving it to SQL as it can only use 2GB

We have an active X job invoked from a SQL job ran overnight which
copies large CSVs (5GB) from one folder to another on the SQL
server. This runs ok for a while (normally after a reboot) but
intermittently comes back with "Not enough server storage is available
to process this command"

The files can then be copied over manually without problem and the
rest of the job ran successfully

Could this error be related to only having 1 GB available to the OS as
its a file copy ?

Would it be best to remove both the /3GB AND /PAE switches or just
the /3GB switch to give the OS at least 2 GB to play with ?

Thankyou in advance for your replies

Cheers

Paul

Feb 6 '07 #1
2 2094
On Feb 6, 2:53 am, paulli...@hotmail.com wrote:
Hi all

Inherited environment :

Windows 2003 SP1 Ent
SQL 2000 Standard
16 GB RAM

BOOT INI Switches : /3GB /PAE

I understand that SQL 2000 standard can only address 2 GB and
therefore the /3GB switch will only rob the OS of a GB of RAM without
giving it to SQL as it can only use 2GB

We have an active X job invoked from a SQL job ran overnight which
copies large CSVs (5GB) from one folder to another on the SQL
server. This runs ok for a while (normally after a reboot) but
intermittently comes back with "Not enough server storage is available
to process this command"

The files can then be copied over manually without problem and the
rest of the job ran successfully

Could this error be related to only having 1 GB available to the OS as
its a file copy ?

Would it be best to remove both the /3GB AND /PAE switches or just
the /3GB switch to give the OS at least 2 GB to play with ?

Thankyou in advance for your replies

Cheers

Paul
Can you post the code the job executes?

Feb 6 '07 #2
On 6 Feb, 16:12, "Steve" <morrisz...@hotmail.comwrote:
On Feb 6, 2:53 am, paulli...@hotmail.com wrote:


Hi all
Inherited environment :
Windows 2003 SP1 Ent
SQL 2000 Standard
16 GB RAM
BOOT INI Switches : /3GB /PAE
I understand that SQL 2000 standard can only address 2 GB and
therefore the /3GB switch will only rob the OS of a GB of RAM without
giving it to SQL as it can only use 2GB
We have an active X job invoked from a SQL job ran overnight which
copies large CSVs (5GB) from one folder to another on the SQL
server. This runs ok for a while (normally after a reboot) but
intermittently comes back with "Not enough server storage is available
to process this command"
The files can then be copied over manually without problem and the
rest of the job ran successfully
Could this error be related to only having 1 GB available to the OS as
its a file copy ?
Would it be best to remove both the /3GB AND /PAE switches or just
the /3GB switch to give the OS at least 2 GB to play with ?
Thankyou in advance for your replies
Cheers
Paul

Can you post the code the job executes?- Hide quoted text -

- Show quoted text -

Here it is :

'
************************************************** ***********************************************
' copy download files to processing folder and remove timestamp from
file name
'
************************************************** ***********************************************
Option Explicit

Function Main()
Dim oFSO, strDownLoadPath, strProcessingPath, strFolder, strFiles,
strFile, intCount, strFlagpos, uDate
Dim strMinDate, strInFileNameDate, strOutFileName, intEndPos, intLen
Dim rsFileNames, strFilename, strFound, stroutFileNamedate

' set global log message

DTSGlobalVariables("Log_Step").Value = "Data Load"
DTSGlobalVariables("Log_Obj1").Value = "Copy files to Processing
folder"
DTSGlobalVariables("Log_Obj2").Value = "starting "
DTSGlobalVariables("Log_DataText").Value = " "
DTSGlobalVariables("Log_DataNumber").Value = 0
DTSGlobalVariables("Log_Comment").Value = "running "

' find flag file and get earliest time stamp

' get files in download directory

strDownLoadPath = DTSGlobalVariables("DownLoadFolder").Value & "\"
strProcessingPath = DTSGlobalVariables("ProcessingFolder").Value & "\"

Set oFSO = CreateObject("scripting.filesystemobject")
' get date in globals

strMinDate = DTSGlobalVariables("MinFlagDate").Value
' get expected files names from globals and check if in download
folder with timestmp

Set rsFileNames = CreateObject("ADODB.Recordset")
Set rsFileNames = DTSGlobalVariables("DownLoadFiles").Value

if rsfilenames.recordcount = 0 then

DTSGlobalVariables("Log_Obj2").Value = "data missing "
DTSGlobalVariables("Log_DataText").Value = "coping Failed"
DTSGlobalVariables("Log_Comment").Value ="No file names in global
area "

main = DTSTaskExecResult_Failure
Set rsFileNames = Nothing
Set oFSO = Nothing
exit function
end if
rsFileNames.movefirst

While Not rsFileNames.EOF

strFilename = rsFileNames.fields("ConfigChar").Value

If LCase(Left(strFilename, 6)) = "static" Then
strInFileNameDate = strFilename & ".csv"
Else
strInFileNameDate = strFilename & strMinDate & ".csv"
End If
stroutFileNamedate = strFilename & ".csv"

' set surrent file in log message

DTSGlobalVariables("Log_Obj2").Value = strInFileNameDate

' MsgBox strDownLoadPath & strInFileNameDate & " " &
strProcessingPath & stroutFileNamedate

oFSO.copyFile strDownLoadPath & strInFileNameDate,
strProcessingPath & stroutFileNamedate


rsFileNames.movenext

Wend

DTSGlobalVariables("Log_Obj2").Value = " "
DTSGlobalVariables("Log_DataText").Value = " "
DTSGlobalVariables("Log_Comment").Value =" "
Set rsFileNames = Nothing
Set oFSO = Nothing

Main = DTSTaskExecResult_Success

End Function
'------------------------------------------
Feb 7 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: AIM | last post by:
Error in msvc in building inheritance.obj to build hello.pyd Hello, I am trying to build the boost 1.31.0 sample extension hello.cpp. I can not compile the file inheritance.cpp because the two...
2
by: Gregory | last post by:
Hi, One of the disadvantages of using error handling with error codes instead of exception handling is that error codes retuned from a function can be forgotten to check thus leading to...
13
by: deko | last post by:
I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next
7
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.