Duplication Error
i have taple translatio witch have theses coloumn
ID,TypeID,Status,ComID,RecordID,Translator
in this table we assign a certain company with a certain typeID to a certain translator .
so next time when the translator log he goes to the company that he assigned to it when he log to the company page,
there is another company page n arabic that is transalted by the translators , in the arabic page there is a button when you can send this company to transaltion.
but a duplicate have been happen made because user send the same documnet to the translation table so many time so translator transalte the same company profile more than one time witch is not good.
we handle the duplicate of the send to translation button put still there is duplicate record in the database witch is more taht 3000 record
how ican to remove thsi record from the DB without make ant other erroe
View Complete Forum Thread with Replies
Related Forum Messages:
Error Catching On Data Duplication In A Sql2005 Db
Hello, everyone. I am having problems catching a data duplication issue. I hope I can get an answer in this forum. If not, I would appreciate it if someone can direct me to the right forum. I am working on a vs2005 app which is connected to a sql2005 db. Precisely, I am working on a registration form. Users go to the registration page, enter the data, ie. name, address, email, etc. and submit to register to the site. The INSERT query works like a charm. The only problem is that I am trying to reject registrations for which an email address was used. I put a constraint on the email field in the table and now if I try to register using an e-mail address that already exists in the database I get a violation error (only visible on the local machine) on the sql's email field, which is expected. How can I catch that there is already an email address in the database and stop the execution of the code and possibly show a message to the user to use a different address? Thank you for all your help. Antonio
View Replies !
Duplication
How can I achieve the following... I have a Membership No. field which comes from a bookings table, so multiple membership no. do exist. What I want to achieve is a list of membership No.s with no duplication. Sorry to be so dumb, but we all have to start somewhere.
View Replies !
Report Job Duplication
HI I have created a job to run a reporting services job which then named it in the job scheduler 354EEF12-404F-46BD-B54F-708B5027837F. I then renamed the job to Rpt ETL log. However it I was surpised to see two emails come with reference to this report. It seems to have created another one with the long job names. Is there any way to stop this as I would really like to name to schduled rpt jobs without it duplicating. Many Thanks Robert
View Replies !
Prevent Duplication On UPDATE
Hello I noticed a spelling mistake in the data in a column of several tables, I used the following syntax to alter the spelling: UPDATE [dbo].[Prod_Cat] SET [ProdName]=N'merseyside' WHERE ProdName = 'mmserseyside' The above code correctly updated the spelling error, but it also inserted a new row with the corrected data. So I found myself with two Identical rows containing the corrected information. I had to manually delete the extra row. Because if I had put in a DELETE statement, I would have then lost both rows. What do I need to do to prevent this happening next time. As I find that I need to update the names of some products, but I don't want to duplicate them. Thanks Lynn
View Replies !
Track Duplication Of Records
Hello, I have a table which consists of 27,000 of records. Among these records, there is one record which is a duplication of another record. Is there any way to track this record from the same table by the SQL statement ? I have been advised to use the following statement but it does not help: Select count(*) As Duplicate, columnname from tablename group by columnname Scrolling 27,000 lines of records with bare eyes is very painful. Any help is appreciated. Cheers
View Replies !
Duplication In The Primary Key Column
Hi I have a set of excel files that i need to export to sql2005 using ssis. Now the issue is that i have no idea about he data ie it may have duplication in the primary key column. If i export it as it is to sql server, it will cause me problems. Is there any way i can filter out the rows which have duplication in the primary key column? Umer
View Replies !
De-Duplication Performance Issue
Hi All, Scenario: De-duplication logic should pick one record from source and check with all the destination records and insert if not duplicate. Else raise error. There are average 8 to 10 lookup check for each logic path. Key fields used for de-duplication check are FirstName, LastName, DOB, Gender, SSN. Issues: · Since picking row by row and processing the performance is constrained. · Since 8-10 comparison is done using lookup performance downstream. (Lookup is used without caching, if cashing is used the package is failing after sometimes as if memory is failing. Can we handle this memory problem?) Please give some suggestion to improve the performance. Current performance is around 2500 records per hour, but there are 8 lac records in total to process. I am looking for guidance on this issue. If someone can guide me on how to do it better it would help me a lot. Thanks, S Suresh
View Replies !
How To Avoid PrimaryKey Duplication?
Hi, I having a problem with my query... I want to copy data from 4 different database to 1 database... but if the destination database have already the same Primary Key the copying stops/terminated and not copying others that is not yet in the destination... I don't have knowledge in T-SQL like IF...ELSE my database is SQL Server 2000 but i'm using SQL 2005 Express Management for the query... What i'm doing is like this: Use osa (Destination Database) Go DELETE FROM tblFaculty (*I'll delete first the datas to avoid duplication) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM cislucena.dbo.tMasFaculty) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM amapn.dbo.tMasFaculty) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM abe.dbo.tMasFaculty) INSERT INTO tblFaculty (FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode) (SELECT FacultyID, LastName, FirstName, MiddleName, Rank, DeptCode FROM aclc.dbo.tMasFaculty) My problem is if the facultyID (PrimaryKey) which i'm copying is already on the destination which is osa, the copying stops/terminated regardless whether there is more to copy. On the 4 source database, there might data that other database also has. That's why the copying is terminated. All i want to do is to check first each FacultyID if it is already on the destination before copying it to avoid error or duplication of Primary Key so it won't terminate the copying. How is this possible sir? Anyone care to help? Thanks in advance! More Power! Best Regards
View Replies !
Single Field Duplication Problem
I have a table with many fields but there is a single field that I do not want duplicates. If I index this specific field preventing duplicates, the entire record does not append. (The field in question is not keyed). Thanks Bill Howard
View Replies !
Insert Statement Results In Data Duplication Using MDAC 2.8
I am using Remote Data service to Query an Sql Server Database using MDAC. The Os in which server is loaded in Window 2003 and the MDAC 2.8 version is installed. Now I create a table X with identity column. Then when I try to insert records in that table using Insert into X select * from Y statement. The statement gets executed by when i check the X table I find that the duplicate records are present with different identity no's. Even when i truncate and retry the same thing occurs. What could be the reason for the same?? Regards Pranali.cons
View Replies !
Fix Legacy Data - Missing Primary Key + Duplication Record + Large Table
We have a large table which is very old and not much ppl take care about, recently there is a performance problem from the report need to query to this table. Eventally we find that this table have primary key missing and there is duplicate data which make "alter table add primary key" don't work Besides the data size of this table require unacceptable time to execute something like "insert into new_table_with_pk from select distinct * from old table" Do you have any recommendation of fixing this? As the application run on oracle , sybase and sql server, is that cross database approace will work?
View Replies !
SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit): Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified. This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005. Extract from log: <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI) MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,) MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close) MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2 <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 Gathering darwin properties for failure handling. Error Code: 2 MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified. You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes). I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation. Any ideas?
View Replies !
[XML Task] Error: An Error Occurred With The Following Error Message: There Are Multiple Root Elements.
I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message: [XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.". The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it: <?xml version="1.0" encoding="UTF-8"?> <ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract> There is only 1 ESDU root element and only 1 package element. Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/> <xsl:template name="identity" match="@*|node()"> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:template> <xsl:template match="kw"> <xsl:copy> <xsl:apply-templates select="@*"/> <xsl:attribute name="ihs_cats_seq" select="position()"/> <xsl:apply-templates select="node()"/> </xsl:copy> </xsl:template> </xsl:stylesheet> Its 5th line is the first xsl:template element. What is going on here? I do not see multiple root elements in either the XML document or the XSLT stylesheet. Thanks!
View Replies !
An Internal Error Occurred On The Report Server. See The Error Log For More Details. RsInternal Error)
We have reports deployed in the Report Server. While connecting from client, we are getting the error "An internal error occurred on the report server. See the error log for more details. rsInternal Error)" Then we went to Report Server, Reporting Service and SQL Server service are all are running fine. Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help. We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error? Please help.
View Replies !
Just Started Getting This Error When Trying To Connect To SQL From ASP.NET--error: 26 - Error Locating Server/Instance Specified
This has worked fine for weeks, and months. I'm running Vista Ultimate. SQL 2005 is set as my Default instance, and SQL2000 is set as (local)SQL2000. Today, actually half way through today, I restarted my computer after installing Photoshop Updates. Upon getting my computer back up and running, I cannot access SQL2000 from any website on my computer, nor can I access it from SQL2005 Management Stdio. I CAN access it from Enterprise Manager (SQL2000 tool). Whenever I run an web app that connects to it I get this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Now I usually get these when ASP.NET can't point to the right spot, but in this case I'm pointing exactly where I need to go. Any thoughts? --Edit I should also add my password got changed a few days ago on our Domain. This was the first time restarting after the PW change.
View Replies !
Error 7399: OLE DB Provider 'MSDAORA' Reported An Error. OLE DB Error
My link server was working just fine until friday evening. It stopped worked over the week end. with and error Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error . ---my oracle 10g client is working just fine --TNS names looks fine ---i recreated the link but i am still getting the same error. I need your help because a lot of jobs are using that link on Monday it is going to be crazzzy.
View Replies !
614 Error On A User Database And 806 Error On Tempdb Seen In The Error Log
Hi, We have a production SQLServer 6.5 running with service pack SP5a update: I got the following 2 errors..... 1. Error : 806, Severity: 21, State: 1 Could not find virtual page for logical page 67833121 in database 'tempdb' database 'tempdb' 2. I got error when I ran a job for Update statistics Error : 614, Severity: 21, State: 3 A row on page 2697653 was accessed that has an illegal length of -8631 in database 'abc'. For Error 2: I ran update statistics using query analyser. It is fine Is there anything I have to do further? For Error 1 : The work around given by Microsoft ================================================= I ran DBCC CHECKTABLE(syslogs) I am getting the following message on : master: Checking syslogs The total number of data pages in this table is 1. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 11 data rows. DBCC execution completed. If DBCC printed error messages, see your System Administrator. model: Checking syslogs The total number of data pages in this table is 47. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 532 data rows. DBCC execution completed. If DBCC printed error messages, see your System Administrator. tempdb: Checking syslogs The total number of data pages in this table is 1. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 31 data rows. DBCC execution completed. If DBCC printed error messages, see your System Administrator. I ran dbcc checkdb on master,model and tempdb . Still I get the same problem. for tempdb: Checking 8 The total number of data pages in this table is 1. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 19 data rows. for master: Checking 8 The total number of data pages in this table is 1. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 27 data rows. for model: Checking 8 The total number of data pages in this table is 47. *** NOTICE: Notification of log space used/free cannot be reported because the log segment is not on its own device. Table has 532 data rows. All system databases and userdatabase recovered successfully when I restarted sqlserver. Please advice how to get rid of this problem. Thanks in advance, Anu
View Replies !
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB Error Has Occurred. Error Code: 0x8000FFFF.
Hi All, Recently in an SSIS package I am getting the following error for a particular Data flow task. Error: 2008-01-25 12:01:48.58 Code: 0xC0202009 Source: Import Datasynapse Data User Events Source [3017] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF. End Error Error: 2008-01-25 12:01:48.73 Code: 0xC004701A Source: Import Datasynapse Data DTS.Pipeline Description: component "User Events Source" (3017) failed the pre-execute phase and returned error code 0xC0202009. End Error Our guess is when the data size of User Events table is more it throws this error. If we try to transfer small subset of data it succeeds. What could be reason for this error? Since this is very urgent, immediate response would be very much appreciated. Thanks & Regards, Prakash Srinivasan
View Replies !
The Push Method Returned One Or More Error Rows. See The Specified Error Table. [ Error Table Name = ]
Hi, I have application in which i am performing synchronization between SQL Server 2000 and SQL Server 2005 CE. I have one table "ItemMaster" in my database.There is no relationship with this table,it is standalone.I am updating its values from Windows Mobile Device. I am performing below operations for that. Step : 1 Pull To Mobile Code BlockmoSqlCeRemoteDataAccess.Pull("ItemMaster", "SELECT * FROM ItemMaster", lsConnectString,RdaTrackOption.TrackingOn); Step : 2 Using one device form i am updating table "ItemMaster" table's values. Step : 3 Push From Mobile Code BlockmoSqlCeRemoteDataAccess.Push("ItemMaster", msConnectString); So i am getting an error on 3rd step. While i am trying to push it says, "The Push method returned one or more error rows. See the specified error table. [ Error table name = ]". I have tried it in different ways but still i am getting this error. Note : Synchronization is working fine.There is not issue with my IIS,SQL CE & SQL Server 2k. Can any one help me?I am trying for that since last 3 days.
View Replies !
Strange Error In Error Log (error 17824)
We are encounrtering a strange error in out sql error log: source: ods error: 17824, severity 10, state 0 source: ods unable to write to ListenOn connection '.pipesqlquery', loginname 'op', hostname 'BOR0181' This error occurs multiple times per day from several client stations. It started when we enabled replication on that server, and started replicating the whole database to another server. Can somebody give me an idea on what the problem could be ? Bart Roelant Capsugel Belgium
View Replies !
Error :(provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Server) (Microsoft SQL Server, Error: 53)
Hi, I am trying to connect to my SQL Server 2005 but it gave me following error message. TITLE: Connect to Server ------------------------------ ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) So, Please help me to solve this problem. tnks.
View Replies !
Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' Reported An Error.Authentication Failed.
I am trying to create an excel file using openrowset in ms sql 2000.but i get the following error when I try to create the file...My stored procedure code is below as well...Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.Authentication failed.What can I do?-- here is my codeCreate PROCEDURE MCA_SP_CREATE_EXCEL @File_Name as varchar(50) = ''ASBEGINSET NOCOUNT ONdeclare @File_Name as varchar(50)DECLARE @Cmd varchar(1000)DECLARE @fn varchar(500)DECLARE @provider varchar(100)DECLARE @ExcelString varchar(100)-- New File Name to be createdIF @File_Name = ''Select @fn = 'C:Test.xls'ELSESelect @fn = 'C:' + @File_Name + '.xls'-- FileCopy command string formationSELECT @Cmd = 'Copy C:Template.xls ' + @fn-- FielCopy command execution through Shell CommandEXEC MASTER..XP_CMDSHELL @cmd, NO_OUTPUT-- Mentioning the OLEDB Rpovider and excel destination filenameset @provider = 'Microsoft.Jet.OLEDB.4.0'set @ExcelString = 'Excel 8.0;Database=' + @fn-- Executing the OPENROWSET Command for copying the select contents to Excel sheet.exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT FirstName,LastName,Phone,Address,City,State,Zip FROM [Sheet1$]'') select au_fname as FirstName,au_lname as LastName,phone,address,city,State,Zip from authors')exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT StoreId, OrderNo, OrderDate, Quantity FROM [Sheet2$]'') select stor_id as StoreId,Ord_Num as OrderNo,Ord_Date as OrderDate,qty as Quantity from sales')SET NOCOUNT OFFEND
View Replies !
Error = Arithmetic Overflow Error Converting Expression To Data Type Smalldatetim
$exception {"Arithmetic overflow error converting expression to data type smalldatetime. The statement has been terminated."} System.Exception {System.Data.SqlClient.SqlException} occurs here is my code protected void EmailSubmitBtn_Click(object sender, EventArgs e) { SqlDataSource NewsletterSqlDataSource = new SqlDataSource(); NewsletterSqlDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["NewsletterConnectionString"].ToString(); //Text version NewsletterSqlDataSource.InsertCommandType = SqlDataSourceCommandType.Text; NewsletterSqlDataSource.InsertCommand = "INSERT INTO NewsLetter (EmailAddress, IPAddress, DateTimeStamp) VALUES (@EmailAddress, @IPAddress, @DateTimeStamp)"; //storeprocedure version //NewsletterSqlDataSource.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; //NewsletterSqlDataSource.InsertCommand = "EmailInsert"; NewsletterSqlDataSource.InsertParameters.Add("EmailAddress", EmailTb.Text); NewsletterSqlDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString()); NewsletterSqlDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now.ToString()); int rowsAffected = 0; try { rowsAffected = NewsletterSqlDataSource.Insert(); } catch (Exception ex) { Server.Transfer("NewsletterProblem.aspx"); } finally { NewsletterSqlDataSource = null; } if (rowsAffected != 1) { Server.Transfer("NewsletterProblem.aspx"); } else { Server.Transfer("NewsletterSuccess.aspx"); }
View Replies !
Irregular Error In SQL 2000-Named Pipes Provider, Error: 40, Could Not Establish Connection
I have a web application developed in VS.NET 2005 [using C# as code behind]; and it uses SQL Server 2000 Enterprise edition as backend. The application runs fine, though it gives an error on IRREGULAR intervals on SQL data requests. Error Details: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) My problem is this: 1) Why does it show an error of SQL 2005, while I use SQL 2000. SQL 2005 is not even installed on the server, though VS.NET 2005 is installed. 2) The error comes only at irregular intervals. Users are able to login properly otherwise. 3) Application starts working again if we do either of the following: (a) Restart IIS (b) Restart application pool (c) Restart server. 4) Named pipes and TCP/IP are added to the "Network Configuration" of the SQL server 2000. 5) Error does not come on any specific page; or any specific code; or at any specific time. 6) We do not have any background service or any other activity happening on the server; and the server hosts only this application, within a single virtual root. Any thoughts on why is this happening, and how to resolve this?
View Replies !
Error: CrystalDecisions.CrystalReports.Engine.FormulaException: Error In File C:DOCUME~1AM-TK-~1ASPNETLOCALS~
Hello, I am having a crystal report using datastored in a dataset. When I select one of items in a dropdownlist, it gives me this error message. Note that I used that code before in another web page using a different crystal report and a different dataSet and it worked successfully, but this time it doesn't work....anyone can tell me what causes this error and how to solve it??? NOTE: I am using a vb code behind in my .aspx page Error in File C:DOCUME~1AM-TK-~1ASPNETLOCALS~1Temp emp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: CrystalDecisions.CrystalReports.Engine.FormulaException: Error in File C:DOCUME~1AM-TK-~1ASPNETLOCALS~1Temp emp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [FormulaException: Error in File C:DOCUME~1AM-TK-~1ASPNETLOCALS~1Temp emp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.] .F(String , EngineExceptionErrorID ) .A(Int16 , Int32 ) .@(Int16 ) CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext) CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext) CrystalDecisions.Web.ReportAgent.u(Boolean N) CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Page.ProcessRequestMain()
View Replies !
Urgent : DB-Library Error 10007: General SQL Server Error: Check Messages From The SQL
DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh
View Replies !
Error Handling In MSSQL - If Error During Call Remote Stored Prcedure I Need SQL Code
Hi All, I want to catch the next MSSQL error in my SQL code with following continue calculations Server: Msg 17, Level 16, State 1, Line 1 SQL Server does not exist or access denied. If REMOTE_SERVER_1 is inaccessible (as in (a) below) the executing of SQL will not continue with (b) - I need the code in (b) to run despite whether the previous exec was successful or not - Any ideas? begin transaction (a) exec REMOTE_SERVER_1...bankinsert '1' , '1' , 1 , 0 , 0 (b) print @@error commit transaction where REMOTE_SERVER_1 is link to server created by EXEC sp_addlinkedserver @server = 'REMOTE_SERVER_1', @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = 'MYCOMP1', @catalog = 'mirror2' EXEC sp_addlinkedsrvlogin @rmtsrvname = 'REMOTE_SERVER_1', ..... Exec sp_serveroption 'REMOTE_SERVER_1', 'data access', 'true' Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc', 'true' Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc out', 'true' Exec sp_serveroption 'REMOTE_SERVER_1', 'collation compatible', 'true' Any help will be greatly appreciated
View Replies !
Error: 26 - Error Locating Server/Instance Specified - (My Hosting Company Says It's In My Connection String) NOT!
Hi All... I am trying to move my site (incomplete) for testing and I am finding that the Db connection process to be the most difficult, well back to my problem. I can't seem to get past this error and am frustrated with overall connectivity problems. Please help!!! =================================================================================== An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 Now you all must admit that, if your somewhat new to this databasing, It's a ***. The source for my application is Visual Web Designer 2005 Express It is an ASP.Net driven site with membership roles and all the good stuff. the latest theory is that I need to change the provider config in the web.config file from AspNetSqlProvider to something else. Most of my complications and frustrations come from GoDaddy and no access to the shared server (understandibly). I hope I gave enough info for help and not too much.. Dave
View Replies !
Flat File Source Error Output Conversion Error With UNICODE Files
i have a weird situation here, i tried to load a unicode file with a flat file source component, one of file lines has data like any other line but also contains the character "ÿ" which i can't see or find it and replace it with empty string, the source component parses the line correctly but if there is a data type error in this line, the error output for that line gives me this character "ÿ" instead of the original line. simply, the error output of flat file source component fail to get the original line when the line contains hidden "ÿ". i hope you can help me with issue. Thanks in advance.
View Replies !
OLEDB Destination Error In SSIS Package Not Returning Error Column/desc
I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table. The new table redirects insert errors. This process worked fine until about 3 weeks ago. I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code. Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge. I receive the following information. Error Code -1071607685 Error Column 0 Error Desc No status is available. The only thing I can find for the above error code is DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE To add to the confusion, I can not see any errors in the data written to the error table. It appears that after a certain point is reached in the processing, everything, or most records, error out. Any help is appreciated. Thanks Derrick
View Replies !
Service Broker Application Is Getting Error + Connection Attempt Failed With Error: '10060
hi , i am creating a service broker application between two different instance.when i am initiating a dialog from the source my message remain in the sys.transmission_queue.but its transmission_status column is empty. i attached the profiler with both source and target by including all the service broker event. in my source profiler i am getting the error like -- Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'. with event Broker:connection and in the target profiler error is --This message could not be delivered because the security context could not be retrieved. with event Broker:Message Undelivarible. i have checked my port also using telnet with remotely and localy both working fine. i am using port no. 4001 and i have mentioned the port no. in the address of the route. bt still getiing the error. please help!!!!!!!!!!!
View Replies !
Sql Server 2005 Dev Edition Error - Unexpected Error While Updating Installed Files
I am attempting to install SQL Server 2005 Developer Edition onto a Windows XP Pro SP2 machine, but unfortunately each time that I attempt to install I receive an error message in the summary log as follows: Product : Microsoft SQL Server 2005 Product Version: 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup Last Action : InstallFinalize Error String : The setup has encountered an unexpected error while Updating Installed Files. The error is : Fatal error during installation. Error Number : 29528 There is probably a simple solution for the issue but unfortunately I am unaware of what it is? I can€™t tell if the issue is specific to registry settings, security, file types, etc€¦ The information below surrounds the error w/in the log, any suggestions would be greatly appreciated? Thanks, Jennifer MSI (s) (6C:94) [16:02:23:713]: Executing op: SetTargetFolder(Folder=C:WINNTsystem32) MSI (s) (6C:94) [16:02:23:713]: Executing op: SetSourceFolder(Folder=1System) MSI (s) (6C:94) [16:02:23:713]: Executing op: FileCopy(SourceName=sqlctr90.dll,SourceCabKey=sqlctr90.dll.7188DA12_A95E_46B7_8623_9D93B5260E2A,DestName=sqlctr90.dll,Attributes=16384,FileSize=66264,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=2005.90.1399.0,Language=1033,InstallMode=58982400,,,,,,,) MSI (s) (6C:94) [16:02:23:713]: File: C:WINNTsystem32sqlctr90.dll; To be installed; Won't patch; No existing file MSI (s) (6C:94) [16:02:23:713]: Source for file 'sqlctr90.dll.7188DA12_A95E_46B7_8623_9D93B5260E2A' is compressed MSI (s) (6C:94) [16:02:23:713]: Note: 1: 2318 2: C:WINNTsystem32sqlctr90.dll MSI (s) (6C:94) [16:02:23:713]: Note: 1: 2360 MSI (s) (6C:94) [16:02:23:713]: Note: 1: 2360 MSI (s) (6C:94) [16:02:23:723]: Executing op: CacheSizeFlush(,) MSI (s) (6C:94) [16:02:23:723]: Executing op: InstallProtectedFiles(AllowUI=0) MSI (s) (6C:94) [16:02:23:723]: Executing op: ActionStart(Name=CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C,,) MSI (s) (6C:94) [16:02:23:733]: Executing op: CustomActionSchedule(Action=CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1025,Source=BinaryData,Target=InstallFTERef,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData) MSI (s) (6C:2C) [16:02:23:743]: Invoking remote custom action. DLL: C:WINNTInstallerMSI64E.tmp, Entrypoint: InstallFTERef FTECa.DLL: INFO: FTE: InstallFTERef(), Entering... FTECa.DLL: INFO: FTE: GetFTERefInstallParams: FTERef : C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData FTECa.DLL: INFO: FTE: InstallFTERef: File created: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTDataoiseCHS.txt Size=1000 IDR=1696 . . . . . . FTECa.DLL: INFO: FTE: InstallFTERef: File created: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData sSVE.xml Size=1035 IDR=1142 FTECa.DLL: INFO: FTE: InstallFTERef: File created: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTDataoiseTHA.txt Size=1036 IDR=697 FTECa.DLL: INFO: FTE: InstallFTERef: File created: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData sTHA.xml Size=1037 IDR=1142 FTECa.DLL: INFO: FTE: InstallFTERef: File created: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTDataoiseTRK.txt Size=1038 IDR=2224 MSI (s) (6C:94) [16:02:24:454]: Executing op: ActionStart(Name=Rollback_UpdateETWMOFWithGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing registry updates,) FTECa.DLL: INFO: FTE: InstallFTERef: File created: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData sTRK.xml Size=1039 IDR=1142 MSI (s) (6C:94) [16:02:24:454]: Executing op: CustomActionSchedule(Action=Rollback_UpdateETWMOFWithGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_UpdateETWMOFWithGUID,CustomActionData=100Removing registry updates100000{2373A92B-1C1C-4E71-B494-5CA97F96AA19}MSSQLSERVERC:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn) MSI (s) (6C:94) [16:02:24:454]: Executing op: ActionStart(Name=Do_UpdateETWMOFWithGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Updating Installed Files,) MSI (s) (6C:94) [16:02:24:454]: Executing op: CustomActionSchedule(Action=Do_UpdateETWMOFWithGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_UpdateETWMOFWithGUID,CustomActionData=010Updating Installed Files100000{2373A92B-1C1C-4E71-B494-5CA97F96AA19}MSSQLSERVERC:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn) MSI (s) (6C:10) [16:02:24:464]: Invoking remote custom action. DLL: C:WINNTInstallerMSI64F.tmp, Entrypoint: Do_UpdateETWMOFWithGUID <Func Name='LaunchFunction'> Function=Do_UpdateETWMOFWithGUID <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_UpdateETWMOFWithGUID PerfTime Start: Do_UpdateETWMOFWithGUID : Tue Feb 13 16:02:24 2007 <Func Name='Do_UpdateETWMOFWithGUID'> Calling installSqlEvent Trance The arguments that are passed to InstallSqlEventTrace are InstanceName: MSSQLSERVER , ProductCodeL: {2373A92B-1C1C-4E71-B494-5CA97F96AA19} , BinPath: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn INFO: Checking installed version INFO: Writing MOF file ERROR: Unable to open registry key: HRESULT = 0x80070005, Key = SYSTEMCurrentControlSetControlWMISecurity The value returned is -2147024891 <EndFunc Name='Do_UpdateETWMOFWithGUID' Return='1603' GetLastError='0'> PerfTime Stop: Do_UpdateETWMOFWithGUID : Tue Feb 13 16:02:24 2007 Gathering darwin properties for failure handling. Error Code: 1603 MSI (s) (6C!D0) [16:02:37:273]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation. Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation. <EndFunc Name='LaunchFunction' Return='1603' GetLastError='203'> MSI (s) (6C:94) [16:02:37:283]: User policy value 'DisableRollback' is 0 MSI (s) (6C:94) [16:02:37:283]: Machine policy value 'DisableRollback' is 0 Action ended 16:02:37: InstallFinalize. Return value 3.
View Replies !
Upgrading From SP1 To SP2 Causes Setup Program To Terminate With MSP Error: 29527 / Error Code 1603
Trying to update my local developer version of SQL Server 2005 SP1 to SP2. The setup program terminates with the following information dumped from the logs. Not sure if it is related, but I recently installed the SQL Server 2005 Compact Edition (tools, runtime, etc) on the same development machine. It is a little too deep for me to figure out Darryl Here are the last few lines of the HotFix.Log 04/24/2007 14:46:48.374 MSP Error: 29527 The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is : Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 138 ---------------------------------------------------------- Failed to read property "InstallIds" {"MachineConfiguration", "", "DUTTONDARRYL1"} from cache Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection:etProperty Source Line Number: 164 ---------------------------------------------------------- Unable to write property into cache: IsClustered Source File Name: datastoredatastorecacheschema.cpp Compiler Timestamp: Wed Jun 14 16:28:00 2006 Function Name: DataStoreCacheSchema::writeProperty Source Line Number: 115 ---------------------------------------------------------- Unable 04/24/2007 14:46:48.694 MSP returned 1603: A fatal error occurred during installation. 04/24/2007 14:46:48.790 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller" 04/24/2007 14:46:48.790 Registry: Cannot read registry key value "Debug" 04/24/2007 14:46:48.806 Copy Engine: Error, unable to install MSP file: c:f01fc31fd0988e3807HotFixSQLFilessqlrun_sql.msp 04/24/2007 14:46:48.822 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/24/2007 14:46:48.822 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800 ****************************************************** Now the SQL9_Hotfix_KB921896_sqlrun_sql.msp.log shows this as the last few lines MSI (s) (A4:38) [14:46:48:630]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server Database Services 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log. MSI (s) (A4:38) [14:46:48:630]: Note: 1: 1729 MSI (s) (A4:38) [14:46:48:630]: Transforming table Error. MSI (s) (A4:38) [14:46:48:630]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:646]: Transforming table Error. MSI (s) (A4:38) [14:46:48:646]: Transforming table Error. MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:646]: Transforming table Error. MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:646]: Transforming table Error. MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:646]: Transforming table Error. MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:662]: Transforming table Error. MSI (s) (A4:38) [14:46:48:678]: Transforming table Error. MSI (s) (A4:38) [14:46:48:678]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:678]: Transforming table Error. MSI (s) (A4:38) [14:46:48:678]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:678]: Transforming table Error. MSI (s) (A4:38) [14:46:48:678]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A4:38) [14:46:48:678]: Product: Microsoft SQL Server 2005 -- Configuration failed. MSI (s) (A4:38) [14:46:48:678]: Attempting to delete file c:WINDOWSInstaller6749ee3.msp MSI (s) (A4:38) [14:46:48:678]: Unable to delete the file. LastError = 32 MSI (s) (A4:38) [14:46:48:694]: Cleaning up uninstalled install packages, if any exist MSI (s) (A4:38) [14:46:48:694]: MainEngineThread is returning 1603 MSI (s) (A4:2C) [14:46:48:694]: Destroying RemoteAPI object. MSI (s) (A4:04) [14:46:48:694]: Custom Action Manager thread ending. === Logging stopped: 4/24/2007 14:46:48 === MSI (c) (58:E4) [14:46:48:694]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (58:E4) [14:46:48:694]: MainEngineThread is returning 1603 === Verbose logging stopped: 4/24/2007 14:46:48 === ************************************************************* The Summary.txt looks like this Time: 04/24/2007 14:46:48.854 KB Number: KB921896 Machine: DUTTONDARRYL1 OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Failed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 DEVELOPER Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 DEVELOPER Reporting Services (MSSQLSERVER) ENU SP1 9.00.2047.00 x86 DEVELOPER Notification Services ENU SP1 9.00.2047.00 x86 DEVELOPER Integration Services ENU SP1 9.00.2047.00 x86 DEVELOPER SQL Server Native Client ENU 9.00.2047.00 x86 Client Components ENU SP1 9.1.2047 x86 DEVELOPER MSXML 6.0 Parser ENU 6.00.3890.0 x86 SQLXML4 ENU 9.00.2047.00 x86 Backward Compatibility ENU 8.05.1704 x86 Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x86 ********************************************************************************** Products Disqualified & Reason Product Reason ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID ********************************************************************************** Product Installation Status Product : Database Services (MSSQLSERVER) Product Version (Previous): 2047 Product Version (Final) : Status : In Progress Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29527
View Replies !
Error: SQL Server Internal Error. Text Manager Cannot Continue With Current Statement..
When my production server processing some queries suddenly the SQL Server service crashed and following error was in the error log: SQL Server Internal Error. Text manager cannot continue with current statement. The server is running SQL Server 2000 with SP4. I am really concerned because this is a production sever and there are over 300 users access concurrently. Please help me to find a solution. Thanks, Roshan.
View Replies !
Error: Fcb::close-flush: Operating System Error 21(The Device Is Not Ready.) Encountered
We are using sql server 2005 Enterprise Edition with service pack1 I got the following error messages in the SQL log The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. fcb::close-flush: Operating system error 21(The device is not ready.) encountered. I got these errors for about 2 hrs and after that I see these messages in the sql log Starting up database ' ' 1 transactions rolled forward in database '' (). This is an informational message only. No user action is required. 0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required. Recovery is writing a checkpoint in database ' ' ( ). This is an informational message only. No user action is required. CHECKDB for database '' finished without errors on (local time). This is an informational message only; no user action is required. Can anyone please help me in troubleshooting this issue. Why this migh have happened. any help would be appreciated. Thanks
View Replies !
SQL Reporting - An Internal Error Occurred On The Report Server. See The Error Log For More Details. (rsInternalError)
I have created an RDL file programatically. When I execute the code I get the error as mentioned below: Error: Sub report cannot be shown. An internal error occurred on the report server. See the error log for more details. (rsInternalError) When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result. Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer. Any Suggestion/feedback is highly appreciated. Thank You. The code of the sample RDL is shown below: <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <DataSources> <DataSource Name="DataSource1"> <DataSourceReference>DataSource1</DataSourceReference> <rd:DataSourceID>fe4806ee-0358-4a87-b764-ac5de049545e</rd:DataSourceID> </DataSource> </DataSources> <BottomMargin>0.25in</BottomMargin> <RightMargin>0.25in</RightMargin> <PageWidth>11in</PageWidth> <ReportParameters> <ReportParameter Name="machine_id"> <DataType>String</DataType> <Prompt>machine_id</Prompt> </ReportParameter> <ReportParameter Name="from_date"> <DataType>String</DataType> <AllowBlank>true</AllowBlank> <Prompt>From Date</Prompt> </ReportParameter> <ReportParameter Name="to_date"> <DataType>String</DataType> <AllowBlank>true</AllowBlank> <Prompt>To Date</Prompt> </ReportParameter> </ReportParameters> <rd:DrawGrid>true</rd:DrawGrid> <InteractiveWidth>8.5in</InteractiveWidth> <rd:SnapToGrid>true</rd:SnapToGrid> <Body> <ReportItems> <Table Name="table1"> <DataSetName>Main_Report</DataSetName> <TableGroups> <TableGroup> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox2"> <rd:DefaultName>textbox2</rd:DefaultName> <ZIndex>1</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>=Fields!syscode.Value</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.25in</Height> </TableRow> </TableRows> <RepeatOnNewPage>true</RepeatOnNewPage> </Header> <Grouping Name="table1_Group1"> <PageBreakAtEnd>true</PageBreakAtEnd> <GroupExpressions> <GroupExpression>=Fields!syscode.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> </TableGroups> <Details> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Subreport Name="subreport1"> <Parameters> <Parameter Name="machine_id"> <Value>=Fields!machine_ip.Value</Value> </Parameter> <Parameter Name="syscode"> <Value>=Fields!syscode.Value</Value> </Parameter> <Parameter Name="from_date"> <Value>=Parameters!from_date.Value</Value> </Parameter> <Parameter Name="to_date"> <Value>=Parameters!to_date.Value</Value> </Parameter> </Parameters> <ReportName>Holding_Summary_Multi_Period</ReportName> </Subreport> </ReportItems> </TableCell> </TableCells> <Height>0.25in</Height> </TableRow> </TableRows> </Details> <TableColumns> <TableColumn> <Width>10.5in</Width> </TableColumn> </TableColumns> <Height>0.5in</Height> </Table> </ReportItems> <Height>0.75in</Height> </Body> <rd:ReportID>d0a1293a-e98c-4f75-9597-03426d2e7218</rd:ReportID> <LeftMargin>0.25in</LeftMargin> <DataSets> <DataSet Name="Main_Report"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>select account_syscode as syscode , 'display Name' as display_name , * from mars_customer_list where machine_ip = @machine_id</CommandText> <QueryParameters> <QueryParameter Name="@machine_id"> <Value>=Parameters!machine_id.Value</Value> </QueryParameter> </QueryParameters> <DataSourceName>DataSource1</DataSourceName> </Query> <Fields> <Field Name="syscode"> <rd:TypeName>System.Int64</rd:TypeName> <DataField>syscode</DataField> </Field> <Field Name="display_name"> <rd:TypeName>System.String</rd:TypeName> <DataField>display_name</DataField> </Field> <Field Name="customer_syscode"> <rd:TypeName>System.Int64</rd:TypeName> <DataField>customer_syscode</DataField> </Field> <Field Name="account_syscode"> <rd:TypeName>System.Int64</rd:TypeName> <DataField>account_syscode</DataField> </Field> <Field Name="machine_ip"> <rd:TypeName>System.String</rd:TypeName> <DataField>machine_ip</DataField> </Field> </Fields> </DataSet> </DataSets> <Code>Shared offset As Integer Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer If reset offset = pagenumber - 1 End If Return pagenumber - offset End Function </Code> <Width>10.5in</Width> <InteractiveHeight>11in</InteractiveHeight> <Language>en-US</Language> <PageFooter> <ReportItems> <Image Name="image1"> <Sizing>Fit</Sizing> <Left>8.875in</Left> <MIMEType /> <Width>1.5in</Width> <Source>External</Source> <Style /> <Value>bottom_right_logo.gif</Value> </Image> </ReportItems> <Height>0.5in</Height> <PrintOnLastPage>true</PrintOnLastPage> <PrintOnFirstPage>true</PrintOnFirstPage> </PageFooter> <TopMargin>0.5in</TopMargin> <PageHeight>8.5in</PageHeight> </Report>
View Replies !
Error Opening Reporting Services Site --- Server Error In '/Reports' Application
I recently installed SQL Server 2005 Enterprise on a machine running Server 2003. I have successfully configured Reporting Services (see below for summary of settings) - Used the defaults for the Repor tServer and Report Manager Virtual Directories - Windows Service Identity set to domain user. The domain user is part of the administrator group on the machine and has sysadmin rights to the database - Web Service Identity set to NT AuthorityNetworkService When I open http://localhost/reports/, I get the following error: I have check a bunch of forums, but have no success. Any advise would be greatly appreciated!! Server Error in '/Reports' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. ' Source Error: [No relevant source lines] Source File: Line: 0 Show Detailed Compiler Output: c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3a890e9c0 068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl34a099978 068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3de5a2332 0958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3498aee86 042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3cd47089b 0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl3f180608d 0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628assemblydl323449648 068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs" Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433 for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727 Copyright (C) Microsoft Corporation 2001-2005. All rights reserved. error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. ' Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View Replies !
Subscription Error : Failure Sending Mail: An Error Has Occurred During Report Processing
Hello, On the development server, I am trying to work with subscriptions . Report Server is windows authenticated. When no paramters exist for the report, the sucbscription is successful. But if there are paramters for the report, email delivery fails. These are not data driven subscriptions. Did anyone face the same problem ? Can anyone tell me where to start debugging since logfiles just say failure to send the email. Thanks, SqlNew
View Replies !
ERROR [HY000] Or ERROR [23000] At Random Times When Using Sql Native Client Via ODBC
The following (VB.Net) code causes exceptions at seemingly random times. Any suggestions? Not sure if the problem is in .Net's ODBC support or in Sql Native Client. If MARS is off, usually after less than 100 loops: Code Snippet System.Data.Odbc.OdbcException was unhandled ErrorCode=-2146232009 Message="ERROR [HY000] [Microsoft][SQL Native Client]Connection is busy with results for another command" Source="SQLNCLI.DLL" Turning MARS is on bypasses that error, so it will sometimes survive a thousand or so runs before hitting: Code Snippet System.Data.Odbc.OdbcException was unhandled ErrorCode=-2146232009 Message="ERROR [23000] [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'Number', table 'tempdb.dbo.#TempTable___..(shortened to fit).. _________000000002F3F'; column does not allow nulls. INSERT fails. Source="SQLNCLI.DLL" Code here: (Console Application, empty database, Visual Studio 2005, .Net 2.0, Windows XP,SQL Server 2005 or SQL Express 2005, Local or Remote) Code Snippet Module Module1 Sub Main() 'Dim connection As New SqlClient.SqlConnection("database=TestDB;server=.sqlexpress;Integrated Security=SSPI;") 'Doesn't crash 'Dim connection As New OleDb.OleDbConnection("Provider=SQLNCLI;database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Doesn't crash 'Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Crashes Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;MARS_Connection=yes") 'Crashes VBMath.Randomize() Dim run_count As Integer = 1 connection.Open() Console.WriteLine("Connected!!") While True 'connection.Open() Dim testcmd As New Odbc.OdbcCommand("CREATE TABLE [#TempTable] (Number int PRIMARY KEY)", connection) testcmd.ExecuteNonQuery() testcmd.Dispose() testcmd = Nothing Dim dtTemp As New DataTable Dim daTemp As New Odbc.OdbcDataAdapter("SELECT * FROM [#TempTable]", connection) daTemp.MissingSchemaAction = MissingSchemaAction.AddWithKey daTemp.Fill(dtTemp) Dim cbTemp As New Odbc.OdbcCommandBuilder(daTemp) Dim viewTemp As New DataView(dtTemp, Nothing, "Number", DataViewRowState.CurrentRows) Dim i As Integer For i = 1 To 1000 Dim test_number As Integer = CInt(Rnd() * 2000) If viewTemp.Find(test_number) = -1 Then 'Keep it unique Dim new_temp_row As DataRowView = viewTemp.AddNew() new_temp_row("Number") = test_number new_temp_row.EndEdit() End If Next daTemp.Update(dtTemp) 'daTemp.Dispose() 'daTemp = Nothing 'cbTemp.Dispose() 'cbTemp = Nothing 'dtTemp.Dispose() 'dtTemp = Nothing 'viewTemp.Dispose() 'viewTemp = Nothing Dim testcmd2 As New Odbc.OdbcCommand("DROP TABLE [#TempTable]", connection) testcmd2.ExecuteNonQuery() testcmd2.Dispose() testcmd2 = Nothing 'connection.Close() 'GC.Collect() 'Console.Write(".") run_count += 1 End While End Sub End Module Usually the ".Update" triggers the exception, but sometimes the other sql commands do it. Have tried various experiments with disposing of objects immediately when finished, but no effect. Opening and closing the connection each loop seems to delay the errors, but it still happens eventually.
View Replies !
RDA - Vb 2005 App - Desktop && Pocket Pc Emulator - Error: 80072F76 Native Error: 28035
RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035 PDA info: .NET CF 1.0 env-string... MS SQL client MS SQLCE 2.0 dev MS SQLCE 2.0 DESKTOP info: Microsoft SQL Server Management Studio Express 9.00.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600 copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip modified its CONFIG.XML to... <?xml version="1.0" encoding="utf-8" ?> <Configuration> <DatabaseServer>192.168.1.89</DatabaseServer> <DatabaseName>D1Temp</DatabaseName> <DatabaseLogin>sa</DatabaseLogin> <DatabasePassword></DatabasePassword> <SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL> <LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=My DocumentsMyFav.sdf;</LocalDBConnect> <LocalDBLocation>My Documents</LocalDBLocation> <LocalDBName>MyFav.sdf</LocalDBName> <IISLogin>192.168.1.89/Jason</IISLogin> <IISPassword>batman2005</IISPassword> </Configuration> error is "Header information is either corrupted or missing. [,,, header name,,]" have spent weeks google-ing trying to get this to work, to no avail. Has ANYONE got RDA PULL to work with above setups?
View Replies !
Linq: SQL Network Interfaces, Error: 26 - Error Locating Server/Instance Specified
Hello, I have deployed myWebApp on the IIS. All went well now, but the site does not have any connection with the database. I've already done a search on the error 26, which gave me alot of hints about solving the problem.Still I'm gettting this error. I already enabled the remote connections through the sql surface area configuration.Could it have something to do with the fact that I use LINQ? I can't find any connectionstring to modify anywhere ... Help would be appreciated.
View Replies !
|
TRACKER
