DP 5.5 SQL integration (289 Views)
Reply
Occasional Contributor
necdet
Posts: 8
Registered: ‎11-09-2005
Message 1 of 5 (289 Views)

DP 5.5 SQL integration

Hi everyone,

I have a problem whit SQL 2005 on DP 5.5 can someone help me. I put the error file in here. I have a SQL on ia64 machines and this is my client machines with W2003. The outher is x86 my cell manager. In txt DP says the database is not exists but i can make a query in SQL. How can itake a backup. Thanks for your help for now.

[Normal] From: BSM@sam08.net.intra "New5" Time: 04.04.2006 18:32:52
OB2BAR application on "sam12.net.intra" successfully started.

[Normal] From: OB2BAR_Main@sam05.net.intra "(DEFAULT)" Time: 04.04.2006 18:32:51

Hewlett-Packard Data Protector Backup and Restore Agent for Microsoft SQL Server 7.0/2000

connected to SQL Server version 9.0 on machine SAM12

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel IA-64)
Oct 14 2005 00:20:58
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

[Normal] From: OB2BAR_Main@sam05.net.intra "(DEFAULT)" Time: 04.04.2006 18:32:51
Character set: Turkish
Sort order : case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

[Normal] From: OB2BAR_Main@sam05.net.intra "(DEFAULT)" Time: 04.04.2006 18:32:51
Direct mode is disabled.

[Warning] From: OB2BAR_Main@sam05.net.intra "(DEFAULT)" Time: 04.04.2006 18:32:51
Error has occurred while opening database 'sam'. Check if the database exists on the server.
See Data Protector debug.log and SQL Server error log for details.

[Warning] From: OB2BAR_Main@sam05.net.intra "(DEFAULT)" Time: 04.04.2006 18:32:51
No databases to back up. Exiting.

[Normal] From: BSM@sam08.net.intra "New5" Time: 04.04.2006 18:32:54
OB2BAR application on "sam12.net.intra" disconnected.

[Critical] From: BSM@sam08.net.intra "New5" Time: 04.04.2006 18:32:54
None of the Disk Agents completed successfully.
Session has failed.

[Normal] From: BSM@sam08.net.intra "New5" Time: 04.04.2006 18:32:54

Backup Statistics:

Session Queuing Time (hours) 0,00
----------------------------------------
Completed Disk Agents ........ 0
Failed Disk Agents ........... 0
Aborted Disk Agents .......... 0
----------------------------------------
Disk Agents Total ........... 0
========================================
Completed Media Agents ....... 0
Failed Media Agents .......... 0
Aborted Media Agents ......... 0
----------------------------------------
Media Agents Total .......... 0
========================================
Mbytes Total ................. 0 MB
Used Media Total ............. 0
Disk Agent Errors Total ...... 0



Session failed!

Necdet
Honored Contributor
Joseph T. Wyckoff
Posts: 2,722
Registered: ‎05-31-2000
Message 2 of 5 (289 Views)

Re: DP 5.5 SQL integration

Poke around a bit at the command prompt to see if we can pin this down.

On the SQL server, at the command prompt, find the omniback directory.

Typically this will be something like

c:\program files\omniback

cd into the bin directory

c:\program files\omniback\bin

We will run the same tool that Storage Data Protector uses - sql_bar.exe to see a view of SQL.

sql_bar list_inst

You should get a list of MS-SQL "instances" usually including

(DEFAULT)

But possibly another instance name, or several.

In my case

(DEFAULT)
INSTANCE2

The probe an instance to see what databases it contains:

sql_bar dbinfo -instance:"(DEFAULT)"

master
model
msdb
northwind
pubs
production

Similarly probe any additional instance


sql_bar dbinfo -instance:"INSTANCE2"

master
model
msdb
development


SDP is complaining that it can't see your database, this, more or less, is the tool that SDP is using to see it.

Once you have a failure at this level, the response center can do very concise debugs.

Obvious sorts of issues might be...

1. The database in question is in a different instance
2. The database in question no longer exists
3. Character set issues
4. SQL bugs
5. SDP bugs
6. You are on the wrong server

7. Security issues - can we see ANYTHING? Make sure the INET service user can log into SQL as an SA / Administrator.
-You may also get different results with out command line commands, depending on what user you are logged in as.

8. Security issues (SDP may not have enough rights to read this particular database, even if it can read others.) This is very unlikely, but technically possible.

Patches... I usually advise patches - although I have no information to suggest that is an issue right now.

Nonetheless, if you get a chance, take a look at:

http://support.openview.hp.com/patches/dp/dp.jsp
Omniback and NT problems? double check name resolution, DNS/HOSTS...
Honored Contributor
Joseph T. Wyckoff
Posts: 2,722
Registered: ‎05-31-2000
Message 3 of 5 (289 Views)

Re: DP 5.5 SQL integration

The session output suggests

See Data Protector debug.log and SQL Server error log for details.

What does the SQL log record? How about the Windows Event Viewer Logs?

This suggests a security issue to me, although again it is unclear.
Omniback and NT problems? double check name resolution, DNS/HOSTS...
Occasional Contributor
necdet
Posts: 8
Registered: ‎11-09-2005
Message 4 of 5 (289 Views)

Re: DP 5.5 SQL integration

He is the debug.log file. From my SQL server.

05.04.2006 16:47:50 INET.616.2396 ["lib/cmn/win32io.c /main/dp56/6":312] A.06.00.%B1 b249
OB2_OpenFile: CreateFile() failed, errcode=3 [file=C:/Program Files/OmniBack/config/server//install/updated_cm]

05.04.2006 16:49:56 OB2BAR_Main.3828.2872 ["integ/sql_7/sql7_dmo.cpp /main/dp56/3":1274] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_PrintInstances", StackFcn="main"

Function trace (currentLevel=0):
Level 0: main()

"SQL7_PrintInstances" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:50:01 OB2BAR_Main.2644.2140 ["integ/sql_7/sql7_dmo.cpp /main/dp56/3":1274] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_PrintInstances", StackFcn="main"

Function trace (currentLevel=0):
Level 0: main()

"SQL7_PrintInstances" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:50:28 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":300] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_PackBarlist", StackFcn="BarGui_FillWlObject"

Function trace (currentLevel=0):
Level 0: BarGui_FillWlObject()

"MSSQL_PackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:50:36 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":300] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_PackBarlist", StackFcn="BarGui_FillWlObject"

Function trace (currentLevel=0):
Level 0: BarGui_FillWlObject()

"MSSQL_PackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:50:39 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":550] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_UnpackBarlist", StackFcn="BarGui_FillIntegs"

Function trace (currentLevel=0):
Level 0: BarGui_FillIntegs()

"MSSQL_UnpackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:50:42 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":300] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_PackBarlist", StackFcn="BarGui_FillWlObject"

Function trace (currentLevel=0):
Level 0: BarGui_FillWlObject()

"MSSQL_PackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:50:46 OB2BAR_Main.2872.3828 ["integ/sql_7/sql7_common.cpp /main/dp56/9":956] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_GetFileProperties", StackFcn="SQL7_SetSQLDatabase"

Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

"SQL7_GetFileProperties" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:50:46 OB2BAR_Main.2872.3828 ["integ/sql_7/sql7_common.cpp /main/dp56/9":625] A.06.00.%B1 b249
[SQL7_SetSQLDatabase] Failed getting DB file properties for file number 0 in group number 0 for TEST. Err code: -2147221502,
[SQL-DMO]Code execution exception: EXCEPTION_DATATYPE_MISALIGNMENT
Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()


05.04.2006 16:53:12 OB2BAR_Main.552.540 ["integ/sql_7/sql7_common.cpp /main/dp56/9":956] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_GetFileProperties", StackFcn="SQL7_SetSQLDatabase"

Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

"SQL7_GetFileProperties" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:53:12 OB2BAR_Main.552.540 ["integ/sql_7/sql7_common.cpp /main/dp56/9":625] A.06.00.%B1 b249
[SQL7_SetSQLDatabase] Failed getting DB file properties for file number 0 in group number 0 for TEST. Err code: -2147221502,
[SQL-DMO]Code execution exception: EXCEPTION_DATATYPE_MISALIGNMENT
Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()


05.04.2006 16:55:42 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":550] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_UnpackBarlist", StackFcn="BarGui_FillIntegs"

Function trace (currentLevel=0):
Level 0: BarGui_FillIntegs()

"MSSQL_UnpackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:55:46 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":300] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_PackBarlist", StackFcn="BarGui_FillWlObject"

Function trace (currentLevel=0):
Level 0: BarGui_FillWlObject()

"MSSQL_PackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:55:49 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":300] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_PackBarlist", StackFcn="BarGui_FillWlObject"

Function trace (currentLevel=0):
Level 0: BarGui_FillWlObject()

"MSSQL_PackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:56:01 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":300] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_PackBarlist", StackFcn="BarGui_FillWlObject"

Function trace (currentLevel=0):
Level 0: BarGui_FillWlObject()

"MSSQL_PackBarlist" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 16:56:03 GUICORE.1504.1620 ["lib/bargui/mssql.c /main/dp56/12":300] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="MSSQL_PackBarlist", StackFcn="BarGui_FillWlObject"

Function trace (currentLevel=0):
Level 0: BarGui_FillWlObject()

"MSSQL_PackBarlist" not found on stack, this was an excessive DbgFcnOut() call


4/5/2006 5:03:00 PM OB2BAR_Main.1104.2932 ["integ/sql_7/sql7_common.cpp /main/dp56/9":956] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_GetFileProperties", StackFcn="SQL7_SetSQLDatabase"

Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

"SQL7_GetFileProperties" not found on stack, this was an excessive DbgFcnOut() call


4/5/2006 5:03:00 PM OB2BAR_Main.1104.2932 ["integ/sql_7/sql7_common.cpp /main/dp56/9":625] A.06.00.%B1 b249
[SQL7_SetSQLDatabase] Failed getting DB file properties for file number 0 in group number 0 for TEST. Err code: -2147221502,
[SQL-DMO]Code execution exception: EXCEPTION_DATATYPE_MISALIGNMENT
Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()


4/5/2006 5:05:17 PM OB2BAR_Main.1860.3276 ["integ/sql_7/sql7_common.cpp /main/dp56/9":956] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_GetFileProperties", StackFcn="SQL7_SetSQLDatabase"

Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

"SQL7_GetFileProperties" not found on stack, this was an excessive DbgFcnOut() call


4/5/2006 5:05:17 PM OB2BAR_Main.1860.3276 ["integ/sql_7/sql7_common.cpp /main/dp56/9":625] A.06.00.%B1 b249
[SQL7_SetSQLDatabase] Failed getting DB file properties for file number 0 in group number 0 for TEST. Err code: -2147221502,
[SQL-DMO]Code execution exception: EXCEPTION_DATATYPE_MISALIGNMENT
Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()


4/5/2006 5:07:56 PM OB2BAR_Main.3520.1020 ["integ/sql_7/sql7_common.cpp /main/dp56/9":956] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_GetFileProperties", StackFcn="SQL7_SetSQLDatabase"

Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

"SQL7_GetFileProperties" not found on stack, this was an excessive DbgFcnOut() call


4/5/2006 5:07:56 PM OB2BAR_Main.3520.1020 ["integ/sql_7/sql7_common.cpp /main/dp56/9":625] A.06.00.%B1 b249
[SQL7_SetSQLDatabase] Failed getting DB file properties for file number 0 in group number 0 for TEST. Err code: -2147221502,
[SQL-DMO]Code execution exception: EXCEPTION_DATATYPE_MISALIGNMENT
Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()


05.04.2006 17:35:31 OB2BAR_Main.2204.2208 ["integ/sql_7/sql7_common.cpp /main/dp56/9":956] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_GetFileProperties", StackFcn="SQL7_SetSQLDatabase"

Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

"SQL7_GetFileProperties" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 17:35:31 OB2BAR_Main.2204.2208 ["integ/sql_7/sql7_common.cpp /main/dp56/9":625] A.06.00.%B1 b249
[SQL7_SetSQLDatabase] Failed getting DB file properties for file number 0 in group number 0 for TEST. Err code: -2147221502,
[SQL-DMO]Code execution exception: EXCEPTION_DATATYPE_MISALIGNMENT
Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()


05.04.2006 17:58:14 OB2BAR_Main.2000.3416 ["integ/sql_7/sql7_common.cpp /main/dp56/9":956] A.06.00.%B1 b249
DbgStack: DbgFcnOut() function does not match function on stack!
ExitFcn="SQL7_GetFileProperties", StackFcn="SQL7_SetSQLDatabase"

Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

"SQL7_GetFileProperties" not found on stack, this was an excessive DbgFcnOut() call


05.04.2006 17:58:14 OB2BAR_Main.2000.3416 ["integ/sql_7/sql7_common.cpp /main/dp56/9":625] A.06.00.%B1 b249
[SQL7_SetSQLDatabase] Failed getting DB file properties for file number 0 in group number 0 for TEST. Err code: -2147221502,
[SQL-DMO]Code execution exception: EXCEPTION_DATATYPE_MISALIGNMENT
Function trace (currentLevel=3):
Level 3: SQL7_SetSQLDatabase()
Level 2: SQL7_SetSQLDatabase()
Level 1: SQL7_Backup()
Level 0: main()

Honored Contributor
Joseph T. Wyckoff
Posts: 2,722
Registered: ‎05-31-2000
Message 5 of 5 (289 Views)

Re: DP 5.5 SQL integration

SDP 6.0 is presently in BETA.

Report bugs on the beta site, or inaccordance with whatever instructions you were given there.

http://ovweb.external.hp.com/datamanagement/backup_beta_index.htm

Good Luck.
Omniback and NT problems? double check name resolution, DNS/HOSTS...
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.