RDB Blob issue

Johnson, Harold A EDUC:EX Harold.A.Johnson@gems1.gov.bc.ca
Thu, 17 Mar 2005 09:32:14 -0800


As a further note, It may not have been the upgrade to 7.1 that caused this,
but a DBTUNE.   :-)


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Johnson, Harold A
EDUC:EX
Sent: 2005 March 16 1:17 PM
To: powerh-l@lists.sowder.com
Subject: RDB Blob issue


Hi all.  we recently upgraded our RDB DB to 7.1 and now get the following
error when touching a table containing a blob field when using 840d.

(viewable_letter_blob is the blob field)  This works under 710g1.  If you
don't reference the blob field, the access is ok.

any ideas?

cheers



> access letter_issued in sfas_database

> select if not viewable_letter_blob is null

> rep letter_idx

> go

*W* Data access error. (LETTER_ISSUED)

*W* DMS-E-GENERAL, A general exception has occurred during operation 'open

blob'. (LETTER_ISSUED)

*W* %SQL-F-CURALROPE, Cursor CR8 was already open (LETTER_ISSUED)

*W* End of segmented string. (LETTER_ISSUED)

2005-MAR-16                       SFAS_WWW_DIC                         PAGE
1 
 

      Letter

       Idx

 

     900,121,251


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.