.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

The conversion returned status value 4 and status text "Text was truncated or one or morecharacters

Posted By:      Posted Date: November 01, 2010    Points: 0   Category :Sql Server
 

[Datatype Conversion  Name [69]] Error: Data conversion failed while converting column
"TaskDescription" (35) to column "C_TaskDescription" (276).
 The conversion returned status value 4 and status text "Text was truncated or one or morecharacters had no match in the target code page.".

The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020

This is working fine in VS2005.  Above both errors Only after upgradation of the package  to 2008.

Thanks,

Thiru




View Complete Post


More Related Resource Links

SSIS Text was truncated with status value 4

  
I am developing a SSIS package, trying to update an existing SQL table from a CSV flat file. All of the columns are successfully updating except for one column. If I ignore this column on truncate, my package completes successfully. So I know this is a truncate problem and not error. This column is empty for almost every row. However, there are a few rows where this field is 200-300 characters. My data conversion task identified this field as a DT_WSTR, but from what I've read elsewhere maybe this should be DT_NTEXT. I've tried both and I even set the DT_WSTR to 500. But none of this fixed my problem. How can I fix? What data type should this column be in my SQL table? Error: 0xC02020A1 at Data Flow Task 1, Source - Berkeley812_csv [1]: Data conversion failed. The data conversion for column "Reason for Delay in Transition" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". Error: 0xC020902A at Data Flow Task 1, Source - Berkeley812_csv [1]: The "output column "Reason for Delay in Transition" (110)" failed because truncation occurred, and the truncation row disposition on "output column "Reason for Delay in Transition" (110)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. Error

The status code returned from the server was: 500

  
  I am getting the following eroor , when using the UpdatePanel of Ajax Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server.The status code returned from the server was: 500 To my strange ,the error is thrown not all the time , only in some rare cases which could not be found out . I tried to increase the AsyncPostBackTimeout to 300 which was 60 but i could n't  get the error down  installing the ajax set up in server is must or not ?  We just placed the ajax dlls in the server. Please can anybody help me with right solution.   Regards G Suresh Kumar         

Blurry text in WPF - current status?

  
Hi,   I was trying to find out if the blurry text I'm seeing in my WPF application could be due to something I'm doing wrong. But then I realized that other people's examples have it as well, and discovered several reported issues with blurry text rendering in WPF (all of them from some time ago) and I tried to find out whether a solution exists now. But I couldn't.   So, I guess this is the right place to ask: has this issue with blurry text rendering in WPF been addressed by now? Or do we really need to live with it (and hopefully our customers too)?   Although I noticed it right away, I never paid much attention to it because I thought "it's probably a setting somewhere", but so it seems not? Or has this changed?   Here at home, I'm on an "old" analog 19" monitor (1280x1024), and I tried all combinations of "smooth edges of screen fonts". It also shows on the Vista-based machine at the office with a 24" LCD screen.   What am I missing?   Koen   ---------- System specs: CPU: AMD XP 2400+ RAM memory: 1024 MB Graphics card: ASUS V9520 VS OS: Windows XP SP2 DirectX: 9.0c

How To add both Text and Bar Status for Password Strength in ASP.NET AJAX

  
 hai One and All,    here i am going to show u how to  add both Text and Bar Status for Password Strength in ASP.NET AJAX    Let Me take up the .aspx page first:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------     <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %><%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"    Namespace="System.Web.UI" TagPrefix="asp" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server">    <title>Untitled Page</title>    <link href="StyleSheet.css" rel="stylesheet" type="text/css" /></head><body>    <form id="form1" runat="server"

How to change Progressbar status Text in setup project dynamically

  

Hello ,

I create a Setup for my project in Visual Studio.I want to change the progress bar status Text at runtime.The default status text is "Please Wait" .To change the Status Text I call the API method "MsiGetMode" .But there are two parameter of this method one is "install (Handle to the installation provided to a DLL custom action or obtained through <see cref="MsiOpenPackage"/>, <see cref="MsiOpenPackageEx"/>, or <see cref="MsiOpenProduct"/>) " How can i get this first parameter in my installer class.And second parameter is "runmode(Specifies the run mode)" .If there is any other way how can i do that.

Please help me

Thanks & Regards,

Vipin Kumar


Conversion of text files from ANSI to UTF-8

  
reading and writing text files in ANSI format and
writing html-files in Charset ISO-8859-1 (Western Europe).

update user status in database when ever user logoff

  

actually i came across this senario for new project where userstatus must change to log off when ever he do fallowing activity.I have maintain user status when he log in to web based system.

Activities are

if

1.user click log off

2.or user click browser close button or close brwoser tab.

3.or Fource fully shut down his Pc

I am able to get first 2 but not the last one.I googled it but not get any satified ans for that.

I m looking for guidens for this. Any help is grate help for me as i want it.And also other suggesstion also welcomed.

thanks in advance

Deeno


getting a email delivert status when sending email using msdb.dbo.sp_send_dbmail

  

Hi All,

Can some help me regarding following.

I have set a job in sql server 2008 to send reminder emails for product expiration.
Now I want a report which will specify the list of the emails sent with the email status details like queued ,sent,delivered, failed.

I can fetch the emails that are sent by querying the like following

select * from sysmail_mailitems SM inner join sysmail_profile SP on SM.Profile_Id = SP.Profile_Id
and SP.Name ='ReminderProfile'

The problem is only getting a perfect status of email whether it is delived or failed. How I can get those status ?
Please help.

Thanks,
Amol
 


How to make the Workflow Status remain "In Progress" when a task is "Rejected"

  

Hi Sir/Mam,

I have a work flow running on a list, when a task is Rejected at a stage then the Workflow status is set to "Completed". Instead of this I want the Status to remain as "In Progress", so that in future after the modification of the document the Approver may Approve it and then take it to the next stages. This is not possible if the Workflow is set to "Completed".

Can you please suggest an easy way to do this

Thanks in Advance

Sai


Change the Workflow Status through code

  

HI Folks,

I have a scenario where i need to develop a 6 stage approval workflow(sequential) using WWF and depoly it to sharepoint. Everythigns fine till here.

Now we look ahead to change the Status field on the documents library which actually has the Workflow Name as the column name and its value being In Progress, depending on the stage of approval. Like(Approved 1, Approved 2, Approved 3.)

And if rejected the status should be rejected than Completed. Any idea how can we update this column of the List item.

I have tried item[workflowProperties.Workflow.ParentAssociation.Name]="Approved 1";

But this throws an error saying input string is not in a correct format.

Any information would be of great help :)

Thanks


Sreeharsha Alagani

Anonymous Web Site receives "The request failed with HTTP status 401: Unauthorized"

  

I set up a test website on my local box and was able to access sharepoint search using the querySearch web service from SP.  After I got it all working properly I transferred the code to the target website that is set up with anonymous access for all people on the fab floor.  However from this website I keep getting the 401 error.  It can't be SP because the same code worked from my local website "localhost".  Any suggestions?  we don't want to have to have the fab people log in so we can't not have the box anonymous.  I would appreciate any suggestions very much!!!

Using WSS 2007 with MOSS.

code:

  private void GetDefaultCredentials()
  {
    try
    {
      m_where = "get configuration data for credentials";
      string userid = ConfigurationManager.AppSettings[ "userid" ];
      string password = ConfigurationManager.AppSettings[ "password" ];
      string domain = ConfigurationManager.AppSettings[ "domain" ];

      m_where = "set search query credentials";
      m_query.Credentials = new NetworkCredential ( userid, password

Status "Installing" keeps stuck

  
Hi All..

I have a problem about status that is stucked.. I've read many forums that related to my problem, but still can't solved it yet :(

Here is my problem...

After 3 months I keep on uploading, removing, and uploading form, I have no problem.. Until today, when I want to upload my form, the status keeps on "Installing", instead of "Ready".
Then I removed my form using Timer Job Definitions, and I delete form.wsp. It works.
Afterwards, I try to upload form again, I have the same problem with stuck status. And then I delete again using same way.
I've tried more than 10 times, and the result still the same one.

Things that I've tried are:
- Reset IIS.
- Reset Application Pool.
- Check the services (e.g: Windows Sharepoint Services Administration, Search, Timer, Tracing) -- all are already started.
- Use "stsadm -o execadmsvcjobs"
- Reset Infopath Form ID
- Publish and change Infopath Form Name
- Command "net start SPTimerV3" and "net start SPAdmin"

Tried all things above, but still can't work. Status is still stuck.

Then, I try to upload other forms, but still have the same problem.

Please help me. I'm stuck already... :((

Is there anything I can do again?

Ma

Determining the status os the Batch job that process SSAS Cubes

  
Hi All, I have a cube and that is processed through a batch job. The problem I am facing is there are many packages which are calling this Batch job to process the cube. Is there a way to determine the state of the job before the packages call this batch job to process the cube. And in which database can I find all the information about the jobs on the server. Thanks for your help. Vineeshvineesh1701

The subscription status of the object could not be changed

  
Good day to all.. I have a problem. There are two sql servers with transactional replication Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) There was a table function without parameters, included in articles of publication. Then I had to change it with adding one parameter. I've changed it via alter function on the publisher. And then replication stopped with error message about invalid argument count in this function. I've decided to reinitialise subscribtion with new snapshot, but new snapshot can't be created ("The subscription status of the object could not be changed"). Then I've decided to drop this subscription and recreate it, but I can't drop it (same error - "The subscription status of the object could not be changed").. Dropping publication also was unsuccesfull. How I can repair replication now?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend