Unsolved
This post is more than 5 years old
6 Posts
0
21955
August 30th, 2006 13:00
sql error 1051 with IT Assistant 7.2 or 8.0
Hello,
I'm trying to create software updates or performance monitoring (8.0) in IT assistant.
My system runs with Windows 2003 server SP1 and SQL Server 2000 SP3.
I tried both IT assistant 7.2 and 8.0 and i still get the same message when validating actions :
SQL error 1051
can someone please help ?
regards
I'm trying to create software updates or performance monitoring (8.0) in IT assistant.
My system runs with Windows 2003 server SP1 and SQL Server 2000 SP3.
I tried both IT assistant 7.2 and 8.0 and i still get the same message when validating actions :
SQL error 1051
can someone please help ?
regards
Message Edited by cedric.martin on 08-30-200609:33 AM
0 events found
No Events found!
rc1
16 Posts
0
August 30th, 2006 19:00
Ok, so
1. You have entered a range of IP addresses in the discovery section and done a full discover and inventory on the servers, right?
2. Ther servers all have OMSA (Server Administrator) on them, right?
3. Now you go to software update and you have imported the repository, etc., right?
4. And you pick a device type (PE1850) and you do a "Comparison", right?
Is this the stuff that is not working? Can you say more about what you are trying to do exactly? Did this work in 7.2 but now does not work in 8.0, or can you just do a new install of 8.0? 8.0 comes with SQL 2005, can you move to that (although you should not have to), or do you _have_ to stay with SQL2000?
But if you are having trouble with Performance Monitoring too, then it almost seems like you have some sort of a installation/db issue. Can you do a clean install?
More info/background would be useful.
cedric.martin
6 Posts
0
August 31st, 2006 06:00
Well,
I've done a full discover and inventory with adresse range method, all is right here.
all server i try to manage have Server administrator on them
i have imported repository and i try to do a compare with my PE1855 devices
this is not working, i have the "sql error 1051" at this moment
This is not working with 7.2 and 8.0.
I tried to do a full reinstall (of IT assistant) but i have to stay with SQL2000, other Db are hosted on my server and i can't move to SQL2005.
I have the same problem with performance monitoring too.
Last thing I tried is setting up IT Assistant 7.2 on another machine without SQL2000 (basic install with MSDE) and i don't have the problem (but i can't keep this server for me as it's a test server)
Searched on this forum and on Internet but just can't find any clue ... thanks for help
rc1
16 Posts
0
August 31st, 2006 13:00
If you bring up Tools | Application Logs... do you get any more useful details to your SQL error?
cedric.martin
6 Posts
0
September 1st, 2006 07:00
Errorcode : 1051
Errormessage : Error in SQL-report
Details : DBConnection::executeWithResultSet:Stmt execution error.22003:
[Microsoft][ODBC SQL Server Driver][SQL Server]Overflow converting
from expression to datatype datetime.
but I didn't find anything in Tools|Application Logs about SQL errors
Kajanov
19 Posts
0
September 4th, 2006 11:00
Error Message:Error in the SQL statement.
DPYeilding
80 Posts
0
September 14th, 2006 16:00
application (Example: MSDE 2000/SQL Server 2000 etc - which is used
by IT Assistant) then IT Assistant database will be detached from
the database application. Run the following command manually to
attach it back to the application.
- Below command shows the default location of SQL Server.
Use the exact path to locate the database files.
'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ITAssist_Data.MDF',
@filename2 = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ITAssist_Log.LDF'
on command prompt, run this command by using "OSQL -E."
- After executing the command, ensure that IT Assistant services
("DSM IT Assistant Connection Service" and "DSM IT Assistant
Network Monitor") are up and running.