----- Original Message -----
Sent: Thursday, November 06, 2003 11:05
AM
Subject: [RBASE-L] - strange
errors
hey everyone,
About a year and a half ago or so, when we were
using r:tango 2000 on NT 4, we started getting a couple wierd errors from
oterro saying "general error during data source operation".
This is normaly pretty normal because usualy
you have another error before that like it will say syntax error and then
"general error...", but for these errors its 2 "general error..." messages
with no further explanation.
Er...here i have an example of what i
mean. Normaly an error is like this, where it has an error message,
then the general error message:
------------------------------------------------------------------------------------------
Error
An error occurred while processing your
request:
APPFILE Path:/pvglobal/
APPFILE
Name:ppo.taf
Position: update_tranmaster_befo_acct_scr
Class:
DBMS
Main Error Number: 122
Secondary Error Number: 0
Main Error
Message: [RBTI][Oterro ODBC Driver][PVGLOBAL]-ERROR- Column needdate must be
a valid DATE. ( 122)
Secondary Error Message: 22005
APPFILE
Path:/pvglobal/
APPFILE Name:ppo.taf
Position:
update_tranmaster_befo_acct_scr
Class: Internal
Main Error Number:
-101
Secondary Error Number: 0
Main Error Message: General error
during data source operation.
Secondary Error
Message:
APPFILE Path:/pvglobal/
APPFILE
Name:ppo.taf
Position: update_tranmaster_befo_acct_scr
Class:
Internal
Main Error Number: -101
Secondary Error Number: 0
Main
Error Message: General error during data source operation.
Secondary
Error Message:
------------------------------------------------------------------------------------------
But these wierd errors we have been getting
give no detail as to what the error is:
-------------------------------------------------------------------------------------------
Error
An error occurred while processing your
request:
APPFILE Path:/
APPFILE Name:utils.tcf
Position:
sel_transfers
Class: Internal
Main Error Number: -101
Secondary
Error Number: 0
Main Error Message: General error during data source
operation.
Secondary Error Message:
APPFILE
Path:/
APPFILE Name:utils.tcf
Position: sel_transfers
Class:
Internal
Main Error Number: -101
Secondary Error Number: 0
Main
Error Message: General error during data source operation.
Secondary
Error Message:
-------------------------------------------------------------------------------------------
the wierd thing about these errors too is that
it doesnt seem to matter what the sql is when they error, it just happens
randomly.
It works 99.999% of the time, which is really
good except that small percent is starting to grow large enough to become a
problem.
some example sql's its failed on
are:
--------------------------------------------------------------------------------
sel sum(acctidamount) from tranacctid where acctid=87594 and transtate
in ('A','B') and tranid not in (sel tranid from tranmaster where
districtno='64436' and trantype='cty')
sel sum(acctidamount) from tranacctid where TranState='A' and
acctid=113631 and tranid not in (sel tranid from tranmaster where
trantype='CTY' and districtno='64436')
sel count(distinct tranid) from tranactions where (tranaction is null
or tranaction='purchasing') and tranid in (sel tranid from tranmaster where
districtno='64436') and userno=986
--------------------------------------------------------------------------------
but like i said, it works almost all the time,
and when it fails, if we take the sql it failed on and paste it in at the
R> prompt or something, it works fine, so i think it might be a
configuration issue.
we were hoping r:tango 5 would clear this up,
we are on windows 2003 server, and on new hardware but still have this same
old problem.
a point of interest might be that we recently
moved some common functionality (to get the balance of an account) into a
tcf and since then, it has caused this error to happen more often in new
places.
Anyone know what the problem might be or have
any ideas?
