ERROR: Subreport: script

Showing posts with label script. Show all posts

Tuesday, March 27, 2012

Estimating Disk Space

Thanks for your replies Tibor / John.
Is there any script/tool available to estimate the size of
the target database. I have the table structures and
estimated rows.
Thanks,
HariI believe that the book "Inside SQL Server 2000" from MS Press comes with such a tool. The book is a
"must" IMO for any intermediate/advanced SQL Server person anyhow, IMO... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:2429f01c45f3c$1f2b89c0$a401280a@.phx.gbl...
> Thanks for your replies Tibor / John.
> Is there any script/tool available to estimate the size of
> the target database. I have the table structures and
> estimated rows.
> Thanks,
> Harisql

Friday, March 9, 2012

errors from a child dts package

I am executing a child dts package from an activex script. While I get no errors when executing the child package independently, I get errors when executing it thru an activex script. Can anyone help?

Also, can anyone give me a sample code to display error messages from each step in a log file ?
Thanks

Here is the activex script I use:

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Function Main()

Main = DTSTaskExecResult_Success
Dim SQLConn
Dim DB2Conn
SQLStr = "DRIVER=SQL Server;SERVER=GPDSQLIRV01;DATABASE=DailySales"
DB2Str = "DSN=SYSHDB2P"

Set SQLConn = CreateObject("ADODB.Connection")
Set DB2Conn = CreateObject("ADODB.Connection")

SQLConn.Open SQLStr, "script", "script"
DB2Conn.Open DB2Str, "hgrprd1", "ddcsgr1"

db2sql = "SELECT MAX(INSERT_TIME) AS INSERT_TIME FROM H.SA48 WHERE REC_TYPE = 'D' "
set db2sqltxt48 = db2conn.execute(db2sql)

SSsql = "SELECT INSERT_TIME FROM SA48_date_tbl"
set SSsqltxt48 = sqlconn.execute(SSsql)

db2sql49 = "SELECT AS_OF_DT FROM H.SA49 "
set db2sqltxt49 = db2conn.execute(db2sql49)

SSsql49 = "SELECT AS_OF_DT FROM SA49_date_tbl"
set SSsqltxt49 = sqlconn.execute(SSsql49)

If db2sqltxt48("insert_time") <> SSsqltxt48("insert_time") And db2sqltxt49("as_of_dt") <> SSsqltxt49("as_of_dt") then

Dim oPkg, oStep
Dim sServer, sUID, sPWD, iSecurity , sPkgPWD, sPkgName, sErrMsg
Set oPkg = CreateObject("DTS.Package")

' Assign parameters
sServer = "GPDSQLIRV01"
sUID = "script"
sPWD = "script"
iSecurity = DTSSQLStgFlag_UseTrustedConnection
sPkgPWD = ""
sPkgName = "DTS_Load_ProductTables"

' Load Child Package
oPkg.LoadFromSQLServer sServer, sUID, sPWD, iSecurity , sPkgPWD, "", "", sPkgName

oPkg.Execute

For Each oStep In oPkg.Steps
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
Main = DTSTaskExecResult_Failure
MsgBox "hello"
End If
Next

oPkg.Uninitialize
Set oStep = Nothing
Set oPkg = Nothing

End If

db2sqltxt48.close
SSsqltxt48.close
db2sqltxt49.close
SSsqltxt49.close

db2conn.close
sqlconn.close

Set db2sqltxt48 = Nothing
Set SSsqltxt48 = Nothing
Set db2sqltxt49 = Nothing
Set SSsqltxt49 = Nothing

Set db2conn = Nothing
Set sqlconn = Nothing

End Function......and the reason most of this isn't a stored procedure is?

What's the p[ackage suppose to do?|||Originally posted by Brett Kaiser
......and the reason most of this isn't a stored procedure is?

What's the p[ackage suppose to do?

Brett

The child package has several steps. Each step is downloading data from a DB2 table on the mainframe to a corresponding table on the SQLServer

Thanks|||Are you doing a lot of manipulation?

Is the whole process built already?

I usually transfer everything to a staging enviroment and then manipulate the data after it migrated.

Just seems easier..

As fa as logging errors, can you echo them out to a text file...do inserts in to a table might not work in the evnt you have to roll back..|||Originally posted by Brett Kaiser
Are you doing a lot of manipulation?

Is the whole process built already?

I usually transfer everything to a staging enviroment and then manipulate the data after it migrated.

Just seems easier..

As fa as logging errors, can you echo them out to a text file...do inserts in to a table might not work in the evnt you have to roll back..

Brett
No, no processing at all. Just select from the table on the mainframe and insert into the one on the SQLSERVER.
Regarding error messages coming from each step of the child package, can you give some sample code to capture the error code and message, and echo it to a text file in the parent package?

Thanks
Anil

Wednesday, February 15, 2012

Error: Server: Msg 1101, Level 17, State 10 when I run script

Hi All,
I can't not run the query to update data but it raice an error as below:
"Server: Msg 1101, Level 17, State 10, Line 1
Could not allocate new page for database 'TEMPDB'. There are no more pages
available in filegroup DEFAULT. Space can be created by dropping objects,
adding additional files, or allowing file growth."
HDD free space: 5GB
RAM: 1GB
CPU: 2.8MHz
SQL server 2000
Windows 2000 server
What should I do?
Please advice me on this.
Thanks in advance,
TNAs per the error message: Increate the size for your tempdb database (data, not log).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TN" <TN@.discussions.microsoft.com> wrote in message
news:72E79234-7E66-4C0F-9198-A2564A99BEE4@.microsoft.com...
> Hi All,
> I can't not run the query to update data but it raice an error as below:
> "Server: Msg 1101, Level 17, State 10, Line 1
> Could not allocate new page for database 'TEMPDB'. There are no more pages
> available in filegroup DEFAULT. Space can be created by dropping objects,
> adding additional files, or allowing file growth."
> HDD free space: 5GB
> RAM: 1GB
> CPU: 2.8MHz
> SQL server 2000
> Windows 2000 server
> What should I do?
> Please advice me on this.
> Thanks in advance,
> TN
>|||My tempdb is umlimited file growth.
"Tibor Karaszi" wrote:
> As per the error message: Increate the size for your tempdb database (data, not log).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TN" <TN@.discussions.microsoft.com> wrote in message
> news:72E79234-7E66-4C0F-9198-A2564A99BEE4@.microsoft.com...
> > Hi All,
> >
> > I can't not run the query to update data but it raice an error as below:
> >
> > "Server: Msg 1101, Level 17, State 10, Line 1
> > Could not allocate new page for database 'TEMPDB'. There are no more pages
> > available in filegroup DEFAULT. Space can be created by dropping objects,
> > adding additional files, or allowing file growth."
> >
> > HDD free space: 5GB
> > RAM: 1GB
> > CPU: 2.8MHz
> > SQL server 2000
> > Windows 2000 server
> >
> > What should I do?
> > Please advice me on this.
> >
> > Thanks in advance,
> > TN
> >
>
>|||Sometimes autogrow doesn't grow the files fast enough for the operation that needs the storage.
Solution is to pre-allocate storage.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TN" <TN@.discussions.microsoft.com> wrote in message
news:473EFAC4-F9E0-4CE8-A895-C146BCE11C6C@.microsoft.com...
> My tempdb is umlimited file growth.
> "Tibor Karaszi" wrote:
>> As per the error message: Increate the size for your tempdb database (data, not log).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "TN" <TN@.discussions.microsoft.com> wrote in message
>> news:72E79234-7E66-4C0F-9198-A2564A99BEE4@.microsoft.com...
>> > Hi All,
>> >
>> > I can't not run the query to update data but it raice an error as below:
>> >
>> > "Server: Msg 1101, Level 17, State 10, Line 1
>> > Could not allocate new page for database 'TEMPDB'. There are no more pages
>> > available in filegroup DEFAULT. Space can be created by dropping objects,
>> > adding additional files, or allowing file growth."
>> >
>> > HDD free space: 5GB
>> > RAM: 1GB
>> > CPU: 2.8MHz
>> > SQL server 2000
>> > Windows 2000 server
>> >
>> > What should I do?
>> > Please advice me on this.
>> >
>> > Thanks in advance,
>> > TN
>> >
>>|||Dear All,
I have the same problem with HP insight Manager 5.1
I have System Errors 17052, 17055 which related to storage full or file log full , I don't know
I'd like to say that I don't know how to deal with SQL Server as I'm not a programmer
I'm a system and infrastructure engineer, but I stucked in that situation, and I will appreciate it much to some one to tell me how to do what u have said ( i.e increase file size, or change location or file growth increase)
thanks alo
From http://www.developmentnow.com/g/118_2005_3_0_0_482538/Error-Server-Msg-1101-Level-17-State-10-when-I-run-script.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||On Oct 6, 9:25 pm, Egyptian Mind<msaleh.m...@.gmail.com> wrote:
> Dear All,
> I have the same problem with HP insight Manager 5.1
> I have System Errors 17052, 17055 which related to storage full or file log full , I don't know
> I'd like to say that I don't know how to deal with SQL Server as I'm not a programmer
> I'm a system and infrastructure engineer, but I stucked in that situation, and I will appreciate it much to some one to tell me how to do what u have said ( i.e increase file size, or change location or file growth increase)
> thanks alot
> Fromhttp://www.developmentnow.com/g/118_2005_3_0_0_482538/Error-Server-Ms...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com
Does it help if you set the recovery mode to simple? Also you may want
to truncate the log file.

Tuesday, March 27, 2012

Estimating Disk Space

Friday, March 9, 2012

errors from a child dts package

Wednesday, February 15, 2012

Error: Server: Msg 1101, Level 17, State 10 when I run script

Error: Server: Msg 1101, Level 17, State 10 when I run script

Error: Server: Msg 1101, Level 17, State 10 when I run script

ERROR: Subreport

Blog Archive

About Me