Skip navigation
This discussion is archived
2225 Views 2 Replies Latest reply: Feb 22, 2011 4:59 PM by VHARNUM RSS
VHARNUM Rookie 21 posts since
Jan 21, 2008

Has received 1 of 9 achievements.
Currently Being Moderated

Feb 22, 2011 6:05 AM

Coredbutil.exe fails LANDesk 8.8

Hello,

 

I started having a bunch of my scan files going into the error scan directory.  When I looked into the issue it seems that my scans are erroring out with:

Database exception: SCAEC10.SCN, LDInv.dll

-2146825023

Item cannot be found in the collection corresponding to the requested name or ordinal.

Update Table:TCP Column:ADDRESS PK:, Thread ID: 12428.

 

 

I found a tid that said I should run a coredbutil to repair corruption in the database and to do a build.

 

When I ran the utility it errored out almost immediately with:

 

ExecuteNonQuery error for sql: Alter table Computer add on Varchar(255)

System.Data.OleDb.OleDbException: Incorrect syntax near the keyword 'on'.

 

I've attached the log.  Anybody have any advice!  Could really use some ideas to get this resolved.

 

Thank you,

Velma

Attachments:
  • Bd0g SupportEmployee 112 posts since
    Nov 16, 2007

    Has received 4 of 9 achievements.
    Currently Being Moderated
    1. Feb 22, 2011 10:16 AM (in response to VHARNUM)
    Re: Coredbutil.exe fails LANDesk 8.8

    Coredbutil is trying to add a column called 'ON' as per your datamart. ON is a reserved word in SQL and cannot be used as a column.

     

    Nate is removing that from your datamart.xml so coredbutil can run.

     

    -Brandon

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software