I installed 6.1 on an XP Professional development machine and it's throwing this error
when querying an Oracle 9i database via ODBC:
[Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal
error in remote procedure call, connection closed.
There are no problems with any other queries on the site using the same machine, which
leads me to think that there aren't really any network issues. The exact same query on
the production server works without problems, which hasn't had 6.1 installed. In this
instance, the production server is also querying the same database and retrieving
exactly the same data.
The column that seems to be at the heart of it is a nullable long that contains either
null or a WDDX packet (stores a user's preferences). If I comment out the WDDX column
from the query or remove the inner join that binds the "accounts" table with the
"accounttype" table but still reference the WDDX column, the query works fine.
And it makes no difference if you restrict the query to retrieve a row where the WDDX
column either contains a null or a WDDX packet -- the same error is displayed.
If the query is repeatedly re-run, 1 time in every 10 it works. If you loop over the
WDDX packet that's retrieved, after the end of the packet, there are a load of nulls
and a few assorted characters (just output them using Asc()).
If you copy the query that's displayed in the "Error Executing Database Query" part of
the browser and paste it into Oracle Enterprise Manager, the query retreives the data
fine. And if you view the data via OEM using "View Contents", in the rows with WDDX
packets, the data looks fine. So, it appears to be a retreive issue, not a data issue.
The development box was running MDAC 2.7.something, so I upgraded to 2.8, but that
made no difference -- the query throws the same error:
If you run a cut-own query (below) that _just_ retrieves just the WDDX column and
which has the inner join to the other table, 9 times out of 10, it works. The rest of
the time, if you cfdump the output, the "prefs" column in the cfdump output contains
the data below the query:
select a.prefs,
t.accounttype
from accounts a INNER JOIN types t
ON a.typeid = t.typeid
where a.accountid = 600;
X�� [01004][ODBC Socket][Oracle][ODBC]String data, right truncated.ing data,
right truncated IOD'><number>7.0</number></var><var name='METERAUDIT'><struct><var
name='CANSIZE'><number>20.0</number></var><var
name='INPUTUNITS'><string>percentages</string></var></struct></var></struct></data></wddxPacket>
B E F G H I K L M N Z ' " " * - � � � � �
� � � � � � � � � � � � � � � � � � � : p
Weirdness! Any ideas? Thanks.
--
Aidan Whitehall <mailto:[EMAIL PROTECTED]>
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd +44 (0)1695 51775
Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards>
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
