Integrated Security: determine

Showing posts with label determine. Show all posts

Wednesday, March 7, 2012

Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I can’t determine if it’s
failing to run or if it’s running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DB’s. Thanks for being there to help.
1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I can’t determine if it’s
> failing to run or if it’s running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DB’s. Thanks for being there to help.
>
|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:

> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/inf...suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>
|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
|||Thanks for your help
"Tibor Karaszi" wrote:

> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
>

Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I can’t determine if it’s
failing to run or if it’s running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DB’s. Thanks for being there to hel
p.1. Define a report file for the plan and check that report file for error me
ssages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I can’t determine if it’s
> failing to run or if it’s running
> and finding a problem. The logs are not indicating any reasons for failure
.
> Integrity check is successful on other DB’s. Thanks for being there to h
elp.
>|||Thanks Tibor. Can you direct me to a location that indicates the procedure f
or
defining a report?
"Tibor Karaszi" wrote:

> 1. Define a report file for the plan and check that report file for error
messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/in..._suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>|||EM, Management, Maintenance Plans, right-click your plan to open it. The rig
ht-most ( think) tab has
this option. You can also right-click an existing plan and open (something l
ike) history and try to
find the error messages there. I don't use maint plans, so it is a little bi
t sketchy...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor. Can you direct me to a location that indicates the procedure
for
> defining a report?
> "Tibor Karaszi" wrote:
>|||Thanks for your help
"Tibor Karaszi" wrote:

> EM, Management, Maintenance Plans, right-click your plan to open it. The r
ight-most ( think) tab has
> this option. You can also right-click an existing plan and open (something
like) history and try to
> find the error messages there. I don't use maint plans, so it is a little
bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
>

Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I canâ't determine if itâ's
failing to run or if itâ's running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DBâ's. Thanks for being there to help.1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I canâ't determine if itâ's
> failing to run or if itâ's running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DBâ's. Thanks for being there to help.
>|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:
> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> > failing to run or if itâ's running
> > and finding a problem. The logs are not indicating any reasons for failure.
> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >
>|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
>> 1. Define a report file for the plan and check that report file for error messages.
>> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
>> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
>> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
>> > Log backup and Optimizations are successful. I canâ't determine if itâ's
>> > failing to run or if itâ's running
>> > and finding a problem. The logs are not indicating any reasons for failure.
>> > Integrity check is successful on other DBâ's. Thanks for being there to help.
>> >
>>|||Thanks for your help
"Tibor Karaszi" wrote:
> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> > Thanks Tibor. Can you direct me to a location that indicates the procedure for
> > defining a report?
> >
> > "Tibor Karaszi" wrote:
> >
> >> 1. Define a report file for the plan and check that report file for error messages.
> >>
> >> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> >>
> >> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> >> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> >> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> >> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> >> > failing to run or if itâ's running
> >> > and finding a problem. The logs are not indicating any reasons for failure.
> >> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >> >
> >>
> >>
>

Integrity and Optimization failures

Hi All-
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrity
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--I suggest you specify a report file for the Maint plan and check for specific error messages in that
report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integrity
> checks while the database is in single user mode to no avail. How can I A.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 4/20/2005
Time: 10:13:13 AM
User: N/A
Computer: XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for specific error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> > Hi All-
> >
> > I have a websense log database that the Optimization and Integrity check
> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> > appears to be a problem. I even tried running the optimization and integrity
> > checks while the database is in single user mode to no avail. How can I A.
> > determine what the problem is and B. correct it?
> >
> > Thank You for your help in advance!
> >
> > --GREENTHUMB--
>
>|||The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
report file. In there you will find the error messages from SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
>> I suggest you specify a report file for the Maint plan and check for specific error messages in
>> that
>> report file.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> > Hi All-
>> >
>> > I have a websense log database that the Optimization and Integrity check
>> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
>> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
>> > appears to be a problem. I even tried running the optimization and integrity
>> > checks while the database is in single user mode to no avail. How can I A.
>> > determine what the problem is and B. correct it?
>> >
>> > Thank You for your help in advance!
>> >
>> > --GREENTHUMB--
>>|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> > Hi Tibor-
> >
> > I have enabled writing to the Event Log and notification to my e-mail but
> > the error message is extremely vague:
> >
> > Event Type: Warning
> > Event Source: SQLSERVERAGENT
> > Event Category: Job Engine
> > Event ID: 208
> > Date: 4/20/2005
> > Time: 10:13:13 AM
> > User: N/A
> > Computer: XXXXXXXXX
> > Description:
> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> > 1 (Step 1).
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> I suggest you specify a report file for the Maint plan and check for specific error messages in
> >> that
> >> report file.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> >> > Hi All-
> >> >
> >> > I have a websense log database that the Optimization and Integrity check
> >> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> >> > appears to be a problem. I even tried running the optimization and integrity
> >> > checks while the database is in single user mode to no avail. How can I A.
> >> > determine what the problem is and B. correct it?
> >> >
> >> > Thank You for your help in advance!
> >> >
> >> > --GREENTHUMB--
> >>
> >>
> >>
>
>|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
--
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
>> The vagueness of that message is exactly why I suggested to specify in
>> the maint plan to create a
>> report file. In there you will find the error messages from SQL Server.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>> > Hi Tibor-
>> >
>> > I have enabled writing to the Event Log and notification to my e-mail
>> > but
>> > the error message is extremely vague:
>> >
>> > Event Type: Warning
>> > Event Source: SQLSERVERAGENT
>> > Event Category: Job Engine
>> > Event ID: 208
>> > Date: 4/20/2005
>> > Time: 10:13:13 AM
>> > User: N/A
>> > Computer: XXXXXXXXX
>> > Description:
>> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
>> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
>> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job
>> > failed.
>> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run
>> > was step
>> > 1 (Step 1).
>> >
>> > For more information, see Help and Support Center at
>> > http://go.microsoft.com/fwlink/events.asp.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> I suggest you specify a report file for the Maint plan and check for
>> >> specific error messages in
>> >> that
>> >> report file.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> >> > Hi All-
>> >> >
>> >> > I have a websense log database that the Optimization and Integrity
>> >> > check
>> >> > jobs fail on. My problem is I cannot determine WHY exactly these
>> >> > jobs have
>> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands
>> >> > nothing
>> >> > appears to be a problem. I even tried running the optimization and
>> >> > integrity
>> >> > checks while the database is in single user mode to no avail. How
>> >> > can I A.
>> >> > determine what the problem is and B. correct it?
>> >> >
>> >> > Thank You for your help in advance!
>> >> >
>> >> > --GREENTHUMB--
>> >>
>> >>
>> >>
>>

Integrity and Optimization failures

Friday, February 24, 2012

Integration Services Data Types Maximum Length

Hi,

Is there a way in-code to determine the maximum length of a Integration Services Data Type.

I need to determine based on the data type what the maximum length of a column is IN-CODE.

However, the column.Length property only gives me a length for DT_WSTR and DT_STR values. This is the only property that would seem to remotely give me the right answer.

I need to know the maximum lengths in columns for DT_BOOL, DT_CY, DT_I2, DT_I4, DT_I8, DT_NUMERIC, and DT_UI1. I can always hard-code these values into my program, but that makes no sense. There has to be some sort of way to determine what the maximum possible length of these values are.

For numeric values I could use the column.Precision value but that still leaves with with a lot of data types without a maximum length.
It might help if you explain why you want to know this information.

A DT_I4 is 4 bytes long, for instance, but it can hold -2,147,483,648 to 2,147,483,647. So which value do you want? Do you see the problem?

Data types are fixed in what they can handle, so why not just hard code them into your "IN-CODE"?|||In your example, for DT_I4, -2,147,483,648 is a length of 11 (excluding commas, but including the sign). Thats the kind of value I need to know. I apologize if I wasn't clear on that.

Well, yes, I could hard-code them. But I was wondering whether that type of information is actually stored (which really if you think about it, shouldn't be that difficult, and also worthwhile so a person does not have the compute what each one would be).

Hard-coding is something you also try to avoid if there is a way to avoid it (and hence my question as to whether I can avoid this or not).

Thanks

|||But that's just it, the length of a DT_I4 is 4, not 11.

The "length" of 11 is not stored anywhere. It's a limitation of the storage allocated to the data type. There are probably internal bounds checks, but I'm guessing they are not exposed. You could always try one of the many programming forums in MSDN to see if someone has an idea, as this really isn't an SSIS issue. SSIS data types are simply mapped to structures in .Net.

And the max length of a DT_STR is 8000 bytes. DT_WSTR is 4000 bytes. But more importantly, there is no such thing as a DT_STR, DT_I4, etc... in code. So what SSIS has as limitations may not be the same as the structures available in your code. (A DT_I4 equates to the Integer (Int32) structure.)|||

theddern wrote:
Hi,
Is there a way in-code to determine the maximum length of a Integration Services Data Type.
I need to determine based on the data type what the maximum length of a column is IN-CODE.
However, the column.Length property only gives me a length for DT_WSTR and DT_STR values. This is the only property that would seem to remotely give me the right answer.
I need to know the maximum lengths in columns for DT_BOOL, DT_CY, DT_I2, DT_I4, DT_I8, DT_NUMERIC, and DT_UI1. I can always hard-code these values into my program, but that makes no sense. There has to be some sort of way to determine what the maximum possible length of these values are.
For numeric values I could use the column.Precision value but that still leaves with with a lot of data types without a maximum length.

There is no maximum/minimum length for those data types. They are just what they are - they never change. The length simply isn't relevant.

-Jamie

|||

theddern wrote:
In your example, for DT_I4, -2,147,483,648 is a length of 11 (excluding commas, but including the sign).

No its not. The length of it is 4. 4 bytes that is.

If the value that you want is 11 then just cast it as a DT_STR and get the length of that.

-Jamie

|||So what you are saying is that I need to hard-code the lengths if I need to know those particular type of values?

|||

theddern wrote:
So what you are saying is that I need to hard-code the lengths if I need to know those particular type of values?

Yes! I just can't see the value in knowing the "lengths" of data types.|||And to clarify, I need to know what the maximum length (in characters) a particular column can be if that particular data was transfered to a command delimited flat file.

I was trying to figure that out based on IDTSColumn90.DataType because that would be the most logical place to start.
|||Are you wanting the display length for each data type?|||

theddern wrote:
And to clarify, I need to know what the maximum length (in characters) a particular column can be if that particular data was transfered to a command (sic) delimited flat file.

Why? If it is a delimited file, who cares?|||If he wanted to document specs for a fixed-length output file, he would find these useful. |||

theddern wrote:
So what you are saying is that I need to hard-code the lengths if I need to know those particular type of values?

No. I'm saying you don't need to care.

|||

Phil Brammer wrote:

theddern wrote:
And to clarify, I need to know what the maximum length (in characters) a particular column can be if that particular data was transfered to a command (sic) delimited flat file.

Why? If it is a delimited file, who cares?

Very very very good point.

This seems a very strange thing to want to do.

|||Yes

Wednesday, March 7, 2012

Integrity Check Failure

Integrity Check Failure

Integrity Check Failure

Integrity and Optimization failures

Integrity and Optimization failures

Integrity and Optimization failures

Friday, February 24, 2012

Integration Services Data Types Maximum Length

Integrated Security

Blog Archive

About Me