12:13
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Antwort: [ADSM-L] SQL error
Eric,
How about
select * from backups where node_name='KL127EAC' and cast(type as char) like
'IMAGE%'
Cheers,
Rick
On Tue, Mar 12, 2013 at 11:57 AM, Loon, EJ van - SPLXM < eric-van.l...@klm.
You would expect the SQL world to be standardized, but you will find wide
disparities in implementations and dialects. ENUM is a case in point. In
PostgreSQL, the ENUM type is actually a data type separate from the built in
NUMERIC and TEXT data types, so the regular numeric and string operat
lay/tivolidoccentral/Tivoli
> +Storage+Manager
> https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
> +Storage+Manager/page/Home
>
> "ADSM: Dist Stor Manager" wrote on 2013-03-12
> 07:12:43:
>
> > From: Rick Harderwijk
> > To: ADSM-L@
tral/Tivoli
+Storage+Manager
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
+Storage+Manager/page/Home
"ADSM: Dist Stor Manager" wrote on 2013-03-12
07:12:43:
> From: Rick Harderwijk
> To: ADSM-L@vm.marist.edu,
> Date: 2013-03-12 07:13
> Subject:
/developerworks/wikis/display/tivolidoccentral/Tivoli
+Storage+Manager
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
+Storage+Manager/page/Home
"ADSM: Dist Stor Manager" wrote on 2013-03-12
05:49:27:
> From: "Loon, EJ van - SPLXM"
> To: ADSM
-L@VM.MARIST.EDU] On Behalf Of
> Ullrich Mänz
> Sent: dinsdag 12 maart 2013 11:11
> To: ADSM-L@VM.MARIST.EDU
> Subject: Antwort: [ADSM-L] SQL error
>
> Hi Eric,
>
> try to add the table name as follows:
>
> select * from backups where backups.node_name='KL127EAC&
lto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Ullrich Mänz
Sent: dinsdag 12 maart 2013 11:11
To: ADSM-L@VM.MARIST.EDU
Subject: Antwort: [ADSM-L] SQL error
Hi Eric,
try to add the table name as follows:
select * from backups where backups.node_name='KL127EAC' and backups.type like
'IMAGE%&
: Re: SQL error
Eric,
Maybe the wildcard % is not valid for the datatype of TYPE which is
ENUMERATED(OBJECT_TYPE).
Have you tried * ?
Rick
On Tue, Mar 12, 2013 at 10:49 AM, Loon, EJ van - SPLXM <
eric-van.l...@klm.com> wrote:
> Hi TSM-ers!
>
> I'm trying to retrieve all
Eric,
Maybe the wildcard % is not valid for the datatype of TYPE which is
ENUMERATED(OBJECT_TYPE).
Have you tried * ?
Rick
On Tue, Mar 12, 2013 at 10:49 AM, Loon, EJ van - SPLXM <
eric-van.l...@klm.com> wrote:
> Hi TSM-ers!
>
> I'm trying to retrieve all image backups for a specific node. I'm
>
Datum: 12.03.2013 10:50
Betreff:[ADSM-L] SQL error
Gesendet von: "ADSM: Dist Stor Manager"
Hi TSM-ers!
I'm trying to retrieve all image backups for a specific node. I'm
issuing the following query:
select * from backups where node_name='KL127EAC&#
Hi TSM-ers!
I'm trying to retrieve all image backups for a specific node. I'm
issuing the following query:
select * from backups where node_name='KL127EAC' and type like 'IMAGE%'
This returns the following error:
ANR2921E The SQL data type of expression 'TYPE' is
ENUMERATED(OBJECT_TYPE
t; Date: 02/22/2011 08:50 AM
>> Subject: TDP SQL error
>> Sent by: "ADSM: Dist Stor Manager"
>>
>> Hi all,
>>
>> I have TDP SQL 5.5.4.0 installed on a Windows 2008 x64 boox runningSQL
Server
>> 2008. I am getting the RIGH0053E error when trying to
Hi all,
I have TDP SQL 5.5.4.0 installed on a Windows 2008 x64 boox running SQL Server
2008. I am getting the RIGH0053E error when trying to open the TDPSQL GUI.
I have double checked all pre-reqsand everything is in place. The
tdpsql.cfg file is NOT present at the appropriate directory thoug
Manager [ads...@vm.marist.edu] för Sanju Chacko
[sanju.cha...@thomsonreuters.com]
Skickat: den 22 september 2009 20:23
Till: ADSM-L@VM.MARIST.EDU
Ämne: TDP for SQL error
Any one has come across this error?
Client os = Windows 2003 x64
TSm version 5.5.2
TDP version 5.5.2
TSm server 5.5.3
I
Any one has come across this error?
Client os = Windows 2003 x64
TSm version 5.5.2
TDP version 5.5.2
TSm server 5.5.3
I tried re-installing both tsm and tdp but didn't help. Ran chkdsk too.
09/09/2009 12:09:38 ACO5436E A failure occurred on stripe number (0), rc
= 418
09/09/2009 12:09
1. Are you able to perform a backup using the the internal backup
tool within the SQL Server Management Studio?
2. Do you have other SQL Servers in your environment?
Are they having the same problem?
3. Are you running in a cluster? If so, are you specifying the
"/SQLSERVER=srv-name" par
Here are the results of the querys. Everything looks okay to me. Any other
suggestions?
C:\Documents and Settings\Administrator.FTNET>osql -E -S ftdb1 -q "SELECT
@@VERSION"
Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)
Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Micro
Bob,
Sometimes this occurs when you are running SQL Server Express
or a previous SQL Server installation did not completely
install and/or uninstall correctly.
What version of SQL Server are you running?
Run these commands and paste the results:
osql -E -S server-name -q "SELECT @@VERSION"
I have gone so far as to create a "new" account with all the correct
permissions but am still receiving the same errors. Thanks for the info - I
had already read most of the posts here that returned this specific error.
Thanks,
Bob
+
From another post with the same problem:
was related to service account for SQL missing from registry. Reset account
and all is fine...
- Original Message -
From: "bobrains" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, October 02, 2007 10:42 AM
Subject: [ADSM-L] TDP For SQ
I have installed TDP for SQL onto an existing system and am receiving error
ACO5402E. I am also receiving the following error in the Windows Application
event log.
SQLVDI: Loc=IdentitySQLServer. Desc=MSSQL$FTDB1. ErrorCode=(1060) The specified
service does not exist as an installed service. Pr
Para: ADSM-L@VM.MARIST.EDU
Assunto: Re: [ADSM-L] SQL error
Constantly. Opened a PMR yesterday afternoon.
Fred Johanson
TSM Administrator
University of Chicago
773-702-8464
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Vinicius Fraga
Sent: Thursday
Subject: [ADSM-L] SQL error
Have anyone got this error
07/07/2007 00:30:01 == Log file pruned using log retention
period of 60 day(s)
07/07/2007 00:30:01 == 28 out of 2038 entries pruned from
the top of this log
07/07/2007 00:30:01
Have anyone got this error
07/07/2007 00:30:01 == Log file pruned using log retention
period of 60 day(s)
07/07/2007 00:30:01 == 28 out of 2038 entries pruned from
the top of this log
07/07/2007 00:30:01
==
Paul,
In addition to Richard's suggestions, you should also check
the TDPSQL.LOG file as well as the redirected output of the
TDPSQLC command that you do in your command script.
In some cases, when things work correctly while logged in,
but do not work correctly as scheduled, it means that the
"l
On Jun 22, 2006, at 10:01 PM, Paul Dudley wrote:
06/22/2006 23:33:23 ANR2579E Schedule SQL_FULL_BACKUPS in domain
STANDARD for node DEVSQL_DATABASE failed (return code 1900).
Paul - Sounds like a faulty PRESchedulecmd.
Check that out; and maybe see what the client schedule log and
dsmerr
We have TSM server 5.2 and have installed TDP for SQL on a client.
We can run manual full and differential SQL backups OK using the GUI,
however we cannot get scheduled backups working.
We have registered the license using the command:
Reg lic file(mssql.lic) Number=4
The output of the "q lic"
-
From: Richard Sims [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 09, 2005 13:55
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL error
Eric - Do the ADSM QuickFacts notes on that msg meet your conditions?
It's exasperating that so many TSM messages are this vague.
Richard
On Mar 9, 2
Eric,
If Richard's pointers provide no help, go to:
http://www.ibm.com/us/
and in the Search box, enter:
ANS1309W
There are a few hits that might help.
Thanks,
Del
"ADSM: Dist Stor Manager" wrote on 03/09/2005
05:10:04 AM:
> Hi *SM-e
Eric - Do the ADSM QuickFacts notes on that msg meet your conditions?
It's exasperating that so many TSM messages are this vague.
Richard
On Mar 9, 2005, at 5:10 AM, Loon, E.J. van - SPLXM wrote:
ANS1309W (RC9) Requested data is offline
Hi *SM-ers!
One of our SQL guys tries to backup his SQL node to our test server.
Everything works fine when he uses our production server, but when he backs
up to the test server he receives the following error:
ANS1309W (RC9) Requested data is offline
In the tdpsql.log I see the following lines:
Donald,
Are you running Data Protection for SQL on the
same physical machine that is currently running the
SQL Server? You will need to run Data Protection for SQL
on node2 if the SQL Server is currently running on node2.
If you are, verify that you have the correct permissions,
to run a backup (S
Has anyone run into this message before?
We have a MS SQL 7.0 cluster, the TDP SQL agent (2.2.0.01) works fine on
node1 where the sql server was installed to the cluster. but whenever we
fail to node2 the TDP agent cannot backup the database, it is unable to
access the SQL server and returns the AC
: Sql Error
Robert,
You might want to read through this Microsoft KB article (Q328306):
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql
to see if anything helps. If not, it sounds like you may need to contact the
IBM Support Team. They can obtain a trace and find
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Del
> Hoobler
> Sent: Wednesday, February 11, 2004 5:40 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Sql Error
>
> Robert,
>
> Looks like Data Protection for SQL
obert
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del
Hoobler
Sent: Wednesday, February 11, 2004 5:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Sql Error
Robert,
Looks like Data Protection for SQL is not talking to the local SQL server
correctly.
Robert,
Looks like Data Protection for SQL is not
talking to the local SQL server correctly.
What happens when you issue this command:
TDPSQLC QUERY SQL *
Can you connect to the SQL server that way?
Are you running on a cluster?
Is it a named instance?
Have you tried specifying the SQL Serve
Hi to all
When trying to restore a SQL Database on a different machine got this error
message:
Starting Sql database restore...
ACO5424E Could not connect to SQL server; SQL server returned:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access
denied.
[Microsoft][
>I'm pretty sure it's the one with SQL option...being that SQL runs seems to
be running on all the same
>servers as navision. It's SQL server developer edition version 8.00.
regards, Martin
If you are using the SQL option, then you have a couple options. Basically,
since SQL is really handling th
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
E.ID.US> cc:
Sent by: "ADSM: Subject: Re: Navision backup and SQL
error
Dist Stor
Manager"
1. maybe this one:
http://msgs.adsm.org/cgi-bin/get/adsm0211/930.html
-Original Message-
From: Martin Jeppesen [mailto:[EMAIL PROTECTED]
Sent: 23 June 2003 17:20
To: [EMAIL PROTECTED]
Subject: Navision backup and SQL error
Hi all
Just joined the list and have 2 questions waiting!
1.
We
Firstly, welcome to the list. I would recommend that you browse the
QuickFacts that wise Richard has put together at:
http://people.bu.edu/rbs/ADSM.funcdir whenever you have questions about
ITSM. Secondly, keep an eye out for monthly FAQ's put out by Mark
Stapleton (search ADSM.ORG for previous
Hi all
Just joined the list and have 2 questions waiting!
1.
We have quite a few SQL servers to backup and until now no problems, but I
do have 2 sql servers that I just can't seem to get working like they
should.
I keep getting the error:
ACO5422E Received the following from the MS SQL server
Matt,
RC=418 means that there was a TSM API error.
Look in the tdpsql.log and/or dsierror.log to find out the cause.
You are correct, all of the returns codes
are not currently documented. We are working
to get these into the documentation in the future.
Thanks,
Del
>...Is the return code component generated by SQL itself, and is there an online
>resource anywhere where i can look up their meanings?
As was explained in postings about 3 weeks ago, the TDPs employ the TSM API to
do their work, and so the return code is most likely from the API, and its
manual l
ITSMers,
We've got a TDP 2.2 client (NT4 sp6) backing up to a TSM server (AIX 4.3.3,
TSM 4.2.2) which is failing as below.
02/09/03 23:30:43 ANR2579E Schedule JUNO_SQL in domain JUNOSQL for node
SQLJUNO1032_TDP failed (return code 418).
The TSM error message isn't ent
Rajesh,
Probably not. The COM and VDI setup is handled
completely by the SQL Server. TDP for SQL does not
do anything in regards to installing this.
It sounds like something is missing or corrupted
from the SQL Server install... especially if your
other SQL 7 Servers are working fine.
Thanks,
No, SQL SErver 2000 is not installed on that Server.
Thanks for the articles but I had alreday gone thru' them. Changing the registry will
be the last option because my other SQL servers have the same registry key values as
this one and they are working fine.
Would reinstalling the TDP help?
Ra
Rajesh,
Does SQL 2000 also happen to be installed on that machine?
Did you look at the following Q articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280759
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q323602
Some others that may be of interest:
http://suppor
I have run into a problem with the SQL TDP v 2.2. When I try to backup a SQL7.0
database with the SQL TDP GUI I get the following error:
The Virtual Device Interface is not registered with the Common Object Model.
Microsoft has some workaround for the problem about changing a registry entry. But i
> I got today trying to run a a backup from a TDP MsSql 2.2.0 gui:
> ACO5422E Received the following from the MS SQL Server
> Try to find explanation without any success .. I success from the gui
to
> do a restore.
Please call IBM support. More information is needed.
You can look in the SQL
Hi
I got today trying to run a a backup from a TDP MsSql 2.2.0 gui:
ACO5422E Received the following from the MS SQL Server
Try to find explanation without any success .. I success from the gui to
do a restore.
Please help !!
Regards Robert Ouzen
No, Del..I wasn't aware of this. thanks
>>> [EMAIL PROTECTED] 05/28/02 17:18 PM >>>
> The TDP is 1.1.2
> The TSM client is 4.1.0
Larry,
I am sure you are already aware of this but I thought
I would mention it anyway. TDP for SQL 1.1.2 went
out of service on 01/26/2002. See this web page:
ht
[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: TDP for MS-SQL error on restore
The TDP is 1.1.2
The TSM client is 4.1.0
>>> [EMAIL PROTECTED] 05/28/02 03:27PM >>>
I got the same error before and the problem is in the version o API. By the
way what's the
Upgrade the TSM client to 4.1.3.11. This what I did.
From: Lawrence Clark <[EMAIL PROTECTED]> on 05/28/2002 03:59
PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: TDP for MS-SQL error on restore
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: TDP for MS-SQL error on restore
> "ANS1017E (RC-50) Session rejected: TCP/IP connections failure DB-LIB
message:
> Read on TDPSQL-sqladsm-2002150210-5370 failed,
cc:
Subject: Re: TDP for MS-SQL error on restore
> "ANS1017E (RC-50) Session rejected: TCP/IP connections failure DB-LIB
message:
> Read on TDPSQL-sqladsm-2002150210-5370 failed, status=995.
> See SQL server error log for more details."
>
> SQL server error log shows
> "ANS1017E (RC-50) Session rejected: TCP/IP connections failure DB-LIB
message:
> Read on TDPSQL-sqladsm-2002150210-5370 failed, status=995.
> See SQL server error log for more details."
>
> SQL server error log shows the following:
> "BackupMedium::ReportIoError: read failure on backup device
'T
While trying to restore a 5GB MS SQL Server database in to another database with the
same configuration our DBA is getting the following error:
"ANS1017E (RC-50) Session rejected: TCP/IP connections failure DB-LIB message:
Read on TDPSQL-sqladsm-2002150210-5370 failed, status=995.
See SQL serve
cc:
Sent by: Subject: Sql error during restore
"ADSM: Dist
Hi,
Has anyone run into the following error message when restoring via the TDP
agent?
Info on our environment:
Mssql 6.5
Tsm client - Tsm 3.7.2
Tsm server: Tsm3.7.4
The message we are getting is:
SQL server: SSREPORT, TSM server: dsm, SQL status: DB-LIB message: Attempt
to insert duplicate key r
:
Sent by: Subject: sql error
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
IST.EDU>
02/07/2001
04:26 AM
Can anybody know how it works??
Please check this out and give me a clear answer..
Thanks in advance..
05/31/2001 11:58:46,COMMAND LINE : sqldsmc /backupfull:* /adsmnode:donghwa_sql
/adsmpwd:donghwa_sql /logfile:c:\progra~1\tivoli\tsm\mssql\sql.log /logprune:14
05/31/2001 11:58:46,Loggin
cc:
Sent by: Subject: Re: tsm sql error messages
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
IST.EDU>
05/26/2001
) (Greenville: 864-322-4399)
(Toll-Free: 888-413-4399)
Mark
StapletonTo: [EMAIL PROTECTED]
Groups: Don't Expand
Sent by: Subject: Re: tsm sql error messages
Del Hoobler wrote:
> Did you try specifying a valid sql userid and password?
> For example:
>
>sqldsmc /backupfull:* /SQLUSer:userid /SQLPWD:password
>
> The default is "sa" for /SQLUSER and "" (blank) for SQLPWD.
...which begs a question:
Why in the name of God's greasy gonads did the TD
ervername".
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
1h@N?1
cc:
Sent b
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, May 17, 2001 5:21 AM
>To: [EMAIL PROTECTED]
>Subject: tsm sql error messages
>ACO4210E -- Failed to connect to SQL server.
>* gui ½ÇÇà½Ã error meg.
>05/17/2001 15:49:54,ACO42
Please check following error messages and give me an advice..
Thanks in advance..
C:\Program Files\Tivoli\TSM\MSSQL>sqldsmc /backupfull:*
Tivoli Storage Manager
Tivoli Data Protection for Microsoft SQL Server - Version 1, Release 1, Level 2
(C) Copyright IBM Corporation 1997, 1999. Al
11/14/2000
10:04:23 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: SQL error
I have 6 SQL servers running the client 2 of them are getting the foll
I have 6 SQL servers running the client 2 of them are getting the following
error:
11/14/2000 01:08:19,Backed up - DIRECTORY, type: DB, size: 532129653, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: CP_ITS_SQLQA, TSM server:
dsm, SQL status: DB-LIB message: Incorrect syntax near the keyw
71 matches
Mail list logo
