| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| String data, right truncated. Error in parameter 7. |
« View previous topic :: View next topic » |
| Author |
Message
|
| ruimadaleno |
 Posted: Mon Sep 01, 2014 5:36 am Post subject: String data, right truncated. Error in parameter 7. |
 |
|
Master
Joined: 08 May 2014
Posts: 274
|
Hi all,
we're getting the errors bellow in event viewer. CaptureStore1 uses a system datasource to insert monitoring (record and replay) info in database. Target Database is available and no errors found in database log.
"..String data, right truncated. Error in parameter 7.''. ..."
As far as i understand the root cause in a query sent to database which tries to insert a value with length above the max defined in table definition.
It might be some monitoring information whose size is above the defined in table ... but .. what information is in parameter 7 ? what is parameter 7 ? how can i get the SQL statement that is generating this error ?
my environment:
WBM 8.0.0.3
Windows Server 2008 R2 Standard
Errors in event viewer:
-------------
( BRKDVESB01A.default ) A database error occurred when processing a message for the data capture store ''CaptureStore1''.
Check that the database is correctly defined and available, and that the ODBC definition is correct. Review any other messages written to the system log and check the database logs to determine the cause of the failure. If the problem persists, contact your IBM support center.
------------
( BRKDVESB01A.default ) Database error: ODBC return code '-1' using ODBC driver manager ''odbc32.dll''.
The message broker encountered an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database concerning this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect datasource or table names. Correct either the database or message broker configuration.
-------------
( BRKDVESB01A.default ) Database error: SQL State ''22001''; Native Error Code '0'; Error Text ''[IBM][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 7.''.
The error has the following diagnostic information: SQL State ''22001'' SQL Native Error Code '0' SQL Error Text ''[IBM][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 7.''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database.
----------------
_________________
Best regards
Rui Madaleno |
|
| Back to top |
|
 |
| ruimadaleno |
| Posted: Fri Jan 09, 2015 4:32 am Post subject: |
|
|
Master
Joined: 08 May 2014
Posts: 274
|
Problem solved 
Cause: message flow running in broker, recording monitoring info to database tables via "record and replay" (it uses a datacapture store)
each message flow node has a label assigned to it. The label is typed by programmers. Monitoring adds additional info (subflow name) and records this to database tables. This info can grow up to sizes bigger than 100 characters wich is the database column size, generating the error observed in event viewer
Column name: EVENT_SRCADDR (7th column of the database - as pointed in errors)
Solution:
increase column size to 255 (recommendation from IBM through PMR)
_________________
Best regards
Rui Madaleno |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
