'String data, right truncated. Error in parameter...' errorWe are using ASE 12.5 as consolidated, ASA 9.0.2 3267 as remote.
The upload_update script for our 'request_queue' table is failing with the
following error:
E. 08/14 14:55:43. Message: ODBC: [DataDirect][ODBC Sybase Wire Protocol
driver]String data, right truncated. Error in parameter 3. (ODBC State =
22001, Native error code = 0). Table Name: Request_Queue. Primary Key(s):
11686
The definition of the remote table is as follows:
CREATE TABLE "dbo"."Request_Queue" (
"Request_Queue_Id" unsigned int NOT NULL ,
"Client" ...
POSSIBLE BUG IN Win32 DBI INSTALL MODULE: DBI "prepare" no work FW: List 'dbi-users' closed to public postsI have ActiveState Win32perl running. I installed fresh DBI, DBD, etc. from
perl ppm.pl> prompt. But prepare( ) doesn't work (see below). perldoc
DBI/DBD/DBI-FAQ are not useful since they assume it works. Any hints?
Art
www.mp3.com/ArthurSulit
Classical Artist
recently charted above Madonna
-----Original Message-----
From: Art Sulit [mailto:art@prs.net]
Sent: Saturday, January 20, 2001 1:51 PM
To: Webmaster@ActiveState.com
Subject: POSSIBLE BUG IN YOUR DBI INSTALL MODULE: DBI "prepare" no work
Hello,
THERE IS A POSSIBLE BUG IN YOUR DBI INSTALL M...
Error RIGHT Truncation of string of data.Hi there,
I am having the error RIGHT Truncation of string of data.
I am doing a procedure with 3 parameters in SYBASE
I am using a temp table to produce a report later on.
I did check the parameters lenght and each field of the table.
in case I am trying to insert an string longer than I defined in the
Database and in the
temp table I am working on. .. Everyhings looks fine...
Any other ideas?
Thank you and enjoy the day
Alice Leon aleon@sfu.ca
AISG SFU
Burnaby Campus
CANADA
...
Error: right truncation of string dataHi All,
This is using SQL Anywhere 10. I have two users, both who are members
of
the same group. As far as I can tell they both have the same permissions.
Using Sybase Central, I am able to go into a record in a particular table
and
modify a record, logged in as the other I get a "right truncation of string
data" error.
What could be wrong?
Check the setting of the string_rtruncation option for the two users.
-Dan
"Brian Scanlon" <brians@spectradata.com> wrote in message
news:462525f7$1@forums-1-dub...
> Hi All,
> This is us...
[perl5-dbi/dbi] 0c17b7: Include Jens' work for DBI-Test----==_mimepart_521d9d9e8d573_74699e7d4814086d
Date: Tue, 27 Aug 2013 23:50:06 -0700
Mime-Version: 1.0
Content-Type: text/plain;
charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-ID: <521d9d9e8e411_74699e7d48140935@hookshot-fe4-pe1-prd.aws.github.net.mail>
Branch: refs/heads/dir_search_hashes
Home: https://github.com/perl5-dbi/dbi
Commit: 0c17b78ff80873945276cd8ffc08876be8ebfd8d
https://github.com/perl5-dbi/dbi/commit/0c17b78ff80873945276cd8ffc08876be8ebfd8d
Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl>
Date: 2013-08-12 (Mon, 12 Aug 2013)...
sp_iqcheckdb error "Right truncation of string data"Hi all,
When run sp_iqcheckdb 'allocation database' I get "Right truncation of
string data". This also happens when I try repair or verify or when
running allocation against some table.
Also I get this error when using load table statement but not always.
IQ 12.7 ESD 7
Linux x64
- Sybase IQ/12.7.0/090824/P/ESD 7/Enterprise Linux64 -
amd64,Opteron64,X86_64/2.4.21-27.0.1.ELsmp/64bit/2009-08-24 16:32:40
Why is this happening and how to solve it.
...
Infomaker 7.0.3 select error, string data right truncationI have 7.0.3 with the latest EBF, build 10009. I have been getting
periodic error messages. A report in one pbl will run fine and then the
same or slightly modified report will run fine for a period in another pbl
and then we start getting a Select Error, 01004, String Data, right
truncation.
I thought the problem was a single or double quote in some string data but
I can get one report in one pbl run against the same data without a problem
and then a copy of that report in another pbl works for awhile and then
starts giving me this error message.
Any help is appreciated...
String data, right truncation error with DBD::ODBC and MS SQL Server 2000I'm using Perl, along with DBD::ODBC and MS SQL Server 2000, to create a
weblog system... anyways, i gotta everything working right and i'm importing
some old news records from another script's DB ( text file-based ) .. there
are 108 records in total... everything goes fine ( DB is created, all other
items are imported without problems ) until i hit one particular record.
#######################################
## Here is the DB structure i'm using: ##
#######################
CREATE TABLE coranto_csql (
Coranto_newsid varchar(255) not null,
Coranto_User ntext...
How to avoid "right truncation of string data" error during "dbunload -ar" ?We build a program to convert databases from 8.0.3 to 10.0.1 for our customers. The only thing the
have to do is a single click. At that moment we start a "dbunload -ar". Some of our curstomers get
the "right truncation of string data" error. I know there is an option "string_rtruncation", but the
default is "On". How can we avoid the "right truncation of string data" error during an "dbunload
-ar"? Can we set the "string_rtruncation" option off during the "dbunload -ar" process?
Data truncation should not be...
DBI:pg and DBI:db2 question...Hello!
I am porting an application from PostgreSQL to IBM-DB2 and need to know if it
is possible/feasable to have both DBI:pg and DBI:db2 installed on the same
machine.
Any and all help is much appreaciated!
Best regards
Marvin Dickens
On Sun, 23 Dec 2001 16:33:34 -0500, Marvin Dickens wrote:
>I am porting an application from PostgreSQL to IBM-DB2 and need to know =
if it=20
>is possible/feasable to have both DBI:pg and DBI:db2 installed on the =
same=20
>machine.
I assule it's DBD::pg and DBD::db2.
Of course it's possible. You can even u...
DBI works, but CGI + DBI bombs?Hello,
I have 2 scripts below, where DBI is used in the former and DBI and CGI is
used in the latter. The first script connects fine via command line, and
the latter fails to connect, but using the same DBI code from the
former. I'm puzzled and RTFM before deciding to send this email. Can
anyone shed any light on why my script fails to connect when using CGI.pm?
Thanks,
Jonathan Gines
Sr. Software Engineer
#---------------------------------------------------------------------------------------------------------------------------------
# DBI script that connects f...
[perl5-dbi/DBI-Test] a2d1b2: create separate tests for DBI and DBI::Mock ...----==_mimepart_51f946a54bb1b_2af891bd4c100430
Date: Wed, 31 Jul 2013 10:17:25 -0700
Mime-Version: 1.0
Content-Type: text/plain;
charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-ID: <51f946a54c721_2af891bd4c100582@hookshot-fe3-pe1-prd.aws.github.net.mail>
Branch: refs/heads/master
Home: https://github.com/perl5-dbi/DBI-Test
Commit: a2d1b22d134be0ca353e0f0b312fb14da24c798e
https://github.com/perl5-dbi/DBI-Test/commit/a2d1b22d134be0ca353e0f0b312fb14da24c798e
Author: Jens Rehsack <sno@netbsd.org>
Date: 2013-07-31 (Wed, 31 Jul 2013)
Changed ...
[perl5-dbi/dbi] 4fd6ec: Hardcoded version strings----==_mimepart_51acd0ebc0406_5660739de483190
Date: Mon, 03 Jun 2013 10:22:51 -0700
Mime-Version: 1.0
Content-Type: text/plain;
charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-ID: <51acd0ebc1382_5660739de48326b@hookshot-fe6-pe1-prd.aws.github.net.mail>
Branch: refs/heads/master
Home: https://github.com/perl5-dbi/dbi
Commit: 4fd6ec60fbe40e9e6923e287ca8bdb83fcc633b0
https://github.com/perl5-dbi/dbi/commit/4fd6ec60fbe40e9e6923e287ca8bdb83fcc633b0
Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl>
Date: 2013-06-03 (Mon, 03 Jun 2013)
Changed...
String data, right truncatedHi,
when I try to synchronize between a handheld and a ASE I'm getting the
error reported in the log attached at the end. This
problem began when I migrated my database from ASA to ASE. This work
perfectly with ASA but doesn't with ASE. Does
anybody know how to correct this issue?.
I'll appreciate any help
LOG:
I. 12/21 19:19:53. [0007]: upload_cursor INV_ENVASES (open for read and
write):
SELECT RUTA, CODIGO_PRESEN, DESCRIPCION_PRESEN,
EXI_AYER, CARGA, DESCARGA,
DEVOLUCION, EXI_HOY FROM INV_ENVASES WHERE RUTA = ? AND CODIGO_PRESEN =
? FOR UPDATE...