Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

Maintenance job fails

Posted: Jan/22/2011   By: nikhil   Points:15   Category: .NET  - ASP.Net    Views:169   Vote Up (0)   Vote Down (0)    

Hi All

i am new to Sql server, i created a Maintenance task for Backup. when i execute the task i get below error.

Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'Mydomain\Mylogin', error code 0x6e. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

i tried to changing the MSSQLSERVER and SQL SERVER AGENT server built in accounts to 'Local Account', 'Local Services' and 'Network services' but all are giving the same error messages.

i tried changing to Log on as 'This Account'  and gave my 'Mydomain\Mylogin' account and password still it failed with same error.

'Mydomain\Mylogin'  has Admin rights.

please help

Thanks

Nagananda

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources

Cannot insert the value NULL into column 'COUNTY', table 'TPI.dbo.juror_tmp'; column does not allow nulls. UPDATE fails.

  

I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.

<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"
            style="margin-right: 59px"
           CellPadding="4"
            ForeColor="#333333" DefaultMode="Edit" DataKeyNames="UID">
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <EditItemTemplate>
                Edit Item Template<br /><asp:Label ID="uidlabel" runat="server" Text='<%# Bind("uid") %>' /><br />
                last_date ha:
                <asp:TextBox ID="last_dateTextBox" runat="server"
                    Text='<%# Bind("last_date", "{0:d}") %>' AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                first_name:
                <asp:TextBox ID="first_nameTextBox" runat="server"
                Text='<%# Bind("first_name") %>'
                    CausesValidation="True" ontextchanged="first_nameTextBox_TextChanged1" />
                <br />
                last_name:
                <asp:TextBox ID="last_nameTextBox" runat="server"
                    Text='<%# Bind("last_name") %>'
                    AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                mi:
                <asp:TextBox ID="miTextBox" runat="server" Text='<%# Bind("mi") %>'
                    AutoPostBack="True" CausesValidation="True" MaxLength="1" />
                <br />
                home_phone:
                <asp:TextBox ID="home_phoneTextBox" runat="server"
                    Text='<%# Bind("home_phone") %>' MaxLength="9&

Nerddinner Repository Dinner Edit fails to save

  

Hello,

  I'm trying to use the Nerddinner as a model to built my own project. I'm using the repository method but I cannot fiqure out why the Edit does not save to the database. I tested in the Nerddinner and it failed to save as well. Is this not functional in Nerdinner or could it be due to me using VS 2010 express?

I also started using MVC3 so I thought that could be the problem. I did some testing and was able to get my Edit to update to the database if I have the controller access the database instead of the repository.

Here's the relevant code from NerdDinner:

[HttpPost, Authorize]
        public ActionResult Edit(int id, FormCollection collection) {

            Dinner dinner = dinnerRepository.GetDinner(id);

            if (!dinner.IsHostedBy(User.Identity.Name))
                return View("InvalidOwner");

            try {
                UpdateModel(dinner, "Dinner");

                dinnerRepository.Save();

                return RedirectToAction("Details", new { id=dinner.DinnerID });
            }
            catch {
                return View(dinner);
            }
        }


And in the Repository:

public void Save()
        {
            db.SaveChanges();
        }


DateTime custom managed property search fails with " Your query is malformed. Please rephrase your query. "

  

I've created a front end search page in Silverlight 4 for SharePoint Search.  Currently we are using WSS 3.0 + Search Server Express 2008 (v 12.0.0.6421).  The page interacts with the MOSS version of the search web service at:   <site collection>/_vti_bin/search.asmx

The reason for this approach is the unique way the requirements specify the look and behavior of the results.  The built-in Search Center page or web parts will not satisfy these requirements.

We are going into production but I still cannot figure out how to search against my custom managed properties that are of Type DateTime.  If I cannot get this to work, it is a showstopper.

I've tried numerous variations on the SQL Syntax and cannot get it to work.  I know the error is in the date portion of the WHERE clause since I can remove it and searches work fine.

Here is a working query:

SELECT Size, Rank, Path, Title, Description, Write, RequestSubmittedDate, DocumentType, RequestPromisedDate, ProblemDescription, DatePublished, RequestOwner, RequestingDepartment, DocumentAuthor, ProjectNumber, ProjectDescription, RequestStatus FROM scope() WHERE CONTAINS ('"nmr"') ORDER BY "Rank" DESC

yet if I try to use a date literal in the WHERE clause as in the following query modification, I get the "malformed" error.

SELECT Size, Rank, Path, Title, Description, Write, RequestSubmittedDate, DocumentType, RequestPromisedDate, ProblemDescription, DatePublished, RequestOwner, RequestingDepartment, DocumentAuthor, ProjectNumber, ProjectDescription, RequestStatus FROM scope() WHERE CONTAINS ('"nmr"') AND "RequestSubmittedDate" >= '2010-01-15' ORDER BY "Rank" DESC

I've tried several variations such as:

 AND "RequestSubmittedDate" >= '2010-01-15 05:00:00'

 AND RequestSubmittedDate >= '2010-01-15 05:00:00'

 Is this a known issue with WSS 3 / Search Server 2008?  If so, does it work under 2010?

I've tried downloading the SharePoint Search Service Tool from CodePlex (by Steve Paschka and Larry Kuhn) and it demonstrates the same behavior.  I suspect there is something wrong server side that cannot handle DateTime queries but I'm not sure.

*** UPDATE ***

I went to the SearchCenter page, updated the Properties XML in the Web Part properties to add my RequestSubmittedDate field into the fields list.  I entered an Advanced Query looking for items where RequestSubmittedDate < 2010-08-15 and received the same error.  See the ULS logs in the 12 hive:

High      Full Text Query: SELECT WorkId, Rank, Title, Author, Size, Path, Description, Write, SiteName, CollapsingStatus, HitHighlightedSummary, HitHighlightedProperties, ContentClass, IsDocument, PictureThumbnailURL  from scope() where freetext(defaultproperties,'+nmr') And ("scope" = 'All Sites') And (RequestSubmittedDate < '2010/08/15 05:00:00') 
Monitorable <Exception><HR>0x80040e14</HR><eip>000000006EA2FB7C</eip><module>d:\office\source\search2\ytrip\tripoli\icommand\qryspec.cxx</module><line>1799</line></Exception> 
Monitorable In CRootQuerySpec::Execute - caught exception: 0x80040e14, translated to: 0x80040e14 - File:d:\office\source\search2\ytrip\tripoli\icommand\qryspec.cxx Line:767 
High      Log Query: Your query is malformed. Please rephrase your query. More Information: One or more errors occurred during processing of command. 
Monitorable Error while executing web part: Microsoft.Office.Server.Search.WebControls.SrhdcGenericException: Your search cannot be completed because of a service error. Try your search again or contact your administrator for more information. ---> Microsoft.Office.Server.Search.Query.QueryMalformedException: Your query is malformed. Please rephrase your query.     at Microsoft.Office.Server.Search.Query.FullTextSqlQuery.Execute()     at Microsoft.Office.Server.Search.WebControls.SearchResultHiddenObject.GetResultData()     --- End of inner exception stack trace ---     at Microsoft.Office.Server.Search.WebControls.SearchResultHiddenObject.GetResultData()     at Microsoft.Office.Server.Search.WebControls.SearchResultHiddenObject.get_ResultsReturned()     at Microsoft.Office.Server.Search.WebControls.C... 
*** END OF UPDATE ***


Sharepoint Backup fails, timer does not exist

  

I have Sharepoint 3.0 installed. I was able to do successfull backup many times. One day a backup was not completed successfully.

Now I get this error when I try to backup.

  **************************************8       

The backup/restore job failed because there is already another job scheduled. Delete the timer job from the Timer Job Definitions page, and then restart the backup/restore job.   at Microsoft.SharePoint.ApplicationPages.StartBackupPage.Ok_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

**********

When I try to delete the timer definition job.. I get the following error:

Object reference not set to an instance of an object.   at Microsoft.SharePoint.Administration.SPWebApplication.OnDeserialization()
   at Microsoft.SharePoint.Administration.SPPersistedObject.Initialize(SPConfigurationDatabase configurationDatabase, Guid id, Guid parentId, String name, SPObjectStatus status, Int64 version, XmlDocument state)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(Guid id, Guid parentId, Guid type, String name, SPObjectStatus status, Byte[] versionBuffer, String xml)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(SqlDataReader dr)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.RefreshCache(Int64 currentVersionOverride, List`1& newObjects, List`1& deletedObjects, Int64& newestObjectVersion)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.RefreshCache()
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(Guid id)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(SPPersistedObject obj)
   at Microsoft.SharePoint.Administration.SPPersistedObject.Delete()
   at Microsoft.SharePoint.Administration.SPJobDefinition.DeleteInternal(Boolean bTargetInstances, Boolean bLockAndRunningJobs)
   at Microsoft.SharePoint.Administration.SPJobDefinition.Delete()
   at Microsoft.SharePoint.ApplicationPages.JobEditPage.BtnDeleteJob_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

If I try again to delete it I get the following error:

The object with id d32c4ce6-0739-4e8c-94cc-29df0af5042c does not exist in the configuration store.  The object may have been deleted by another operation.   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(Guid id)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(SPPersistedObject obj)
   at Microsoft.SharePoint.Administration.SPPersistedObject.Delete()
   at Microsoft.SharePoint.Administration.SPJobDefinition.DeleteInternal(Boolean bTargetInstances, Boolean bLockAndRunningJobs)
   at Microsoft.SharePoint.Administration.SPJobDefinition.Delete()
   at Microsoft.SharePoint.ApplicationPages.JobEditPage.BtnDeleteJob_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
  &n

Backup-SPSite works but fails?

  

I'm running the following PowerShell Command as part of a script.  The $backupSite and $backupPath are valid and the file gets created successfully.

 

Backup-SPSite -Identity $backupSite -Path $backupPath –UseSqlSnapshot -Force -NoSiteLock

 

However, I have a command to send an email after the command finishes which doesn't execute.  When I use a trap for the exception the message is "Operation is not valid due to the current state of the object.".  However the SharePoint log indicates a successful backup and the file size is similar to what is was when backed up using stsadm.

 

Any ideas what parameter would prevent this error from ocurring?  I've investingated the AssignmentCollection but am not quite sure what to use since not examples seem to include it.

 

Any help to correct or further troubleshoot would be greatly appreciated.


Web.config always fails to load first time

  

Each time when I browse the wsdl, I get an error saying web.config is not well formatted. If I refresh the page , wsdl loads successfully. This happens on altrenate basis.

I have come custom role provider dll which I am referring inside my web.config.

Does any one has faced such problem. Any pointers will be of great help.


Best Regards, Vishnu

.net 4 framework fails to install on XP Pro SP3

  

(A) On Windows XP Professional SP3,  I cannot get the .NET 4.0 Framework to install.  If I run either of the following programs, nothing happens:

  • dotNetFx40_Full_setup.exe
  • dotNetFx40_Full_x86_x64.exe

dd_dotNetFx40_Full_x86_x64_decompression_log.txt

[12/8/2010, 13:29:23] === Logging started: 2010/12/08 13:29:23 ===
[12/8/2010, 13:29:23] Executable: D:\path_removed_for_privacy\dotNetFx40_Full_x86_x64.exe v4.0.30319.1
[12/8/2010, 13:29:23] --- logging level: standard ---
[12/8/2010, 13:29:23] Successfully bound to the ClusApi.dll
[12/8/2010, 13:29:23] Error 0x800706d9: Failed to open the current cluster
[12/8/2010, 13:29:23] Cluster drive map: ''
[12/8/2010, 13:29:23] Considering drive: 'A:\'...
[12/8/2010, 13:29:24] Drive 'A:\' is rejected because of the unknown or unsuitable drive type
[12/8/2010, 13:29:24] Considering drive: 'C:\'...
[12/8/2010, 13:29:24] Considering drive: 'D:\'...
[12/8/2010, 13:29:24] Considering drive: 'E:\'...
[12/8/2010, 13:29:24] Considering drive: 'I:\'...
[12/8/2010, 13:29:24] Drive 'I:\' is rejected because of the unknown or unsuitable drive type
[12/8/2010, 13:29:24] Considering drive: 'J:\'...
[12/8/2010, 13:29:24] Drive 'J:\' is rejected because of the unknown or unsuitable drive type
[12/8/2010, 13:29:24] Considering drive: 'K:\'...
[12/8/2010, 13:29:24] Drive 'K:\' is rejected because of the unknown or unsuitable drive type
[12/8/2010, 13:29:24] Considering drive: 'M:\'...
[12/8/2010, 13:29:24] Drive 'M:\' is rejected because of the unknown or unsuitable drive type
[12/8/2010, 13:29:24] Considering drive: 'Z:\'...
[12/8/2010, 13:29:24] Drive 'Z:\' is rejected because of the unknown or unsuitable drive type
[12/8/2010, 13:29:24] Drive 'C:\' has been selected as the largest fixed drive
[12/8/2010, 13:29:24] Directory 'C:\788875cedfed7260b1\' has been selected for file extraction

end of file

 

(B) Checking the directory C:\788875cedfed7260b1\ shows no files.

(C) I have manually extracted  dotNetFx40_Full_x86_x64.exe to a temporary folder.  From there I attempted to run setup.exe.  I get the following error:

Installation Blockers:
  1. You cannot use this setup program to install the .NET Framework. For more information, see the Readme file .

[12/8/2010, 13:0:35] Global Block Checks: StopBlockers evaluated to true.
[12/8/2010, 13:0:35] Final Result: Installation failed with error code: (0x000013EC), "A StopBlock was hit or a System Requirement was not met." (Elapsed time: 0 00:00:01).

 

(D)  As recommended in other discussion threads, I have run collect.exe.  vslogs.cab is shared here:

http://cid-6ab73d2a7b4943b1.office.live.com/browse.aspx/.Documents?Bsrc=EMSHOO&Bpub=SN.Notifications

 

Please advise on how to correct this installation failure.  This is blocking the installation of other software, and I'm completely stumped on how to fix it.

 

Thanks in advance,

David Marks

 


Loading of web.config fails first time and loads successfully second time

  

Each time when I browse the wsdl, I get an error saying web.config is not well formatted. If I refresh the page , wsdl loads successfully. This happens on altrenate basis.

I have come custom role provider dll which I am referring inside my web.config.

Does any one has faced such problem. Any pointers will be of great help.


Best Regards, Vishnu

64bit API call fails in VB

  

I have a program that makes extensive use of the RAS api calls. Has always worked fine in 32bit mode on Win7, but all attempts to convert it to 64 bit keep hitting a brick wall. I'm using VB2010 and .NET 4

Here's the function definition:

Declare Ansi Function RasEntryDlg Lib "rasdlg.dll" Alias "RasEntryDlgA" (ByVal lpszPhonebook As String, ByVal lpszEntry As String, ByRef lprasentrydlg As RASENTRY) As Integer

Here's the structure definition:

Public Structure RASENTRY 'defined in rasdlg.h as rasentrydlga
    Public dwsize As Integer
    Public
hwndowner As IntPtr
    Public dwFlags As Integer
  

adodb.dll fails to run on windows7 64bit

  

I have a winform application and use adodb.ll to generate files ,  it runs fine on 32bit, but when moving to 64bit, it will cause the System.Runtime.InteropServices.COMException] = {"The following system error occurred:  Invalid class string.

could you tell me why?

the following is the related code:

        ADODB.Connection AdoConn = new ADODB.Connection();
        AdoConn.Provider = "MSOLAP";

        sConnection = "location=C:\Ex4e\bi\outputcubes\Stationery  Computer Mart UK\FinReps.cub;

SOURCE_DSN="Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data source=C:\Ex4e\bi\outputcubes\Stationery  Computer Mart UK\models\BI50FinRep.mdb;Extended Properties=;jet oledb:database password=B1owfish;;jet oledb:system database=C:\Ex4e\bi\outputcubes\Stationery  Computer Mart UK\models\BI50FinRep.mdw;;;";"
        AdoConn.Open(sConnection, "", "", 0);
        AdoConn.Close();


 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge