It does not matter how many rows of data have the stock number you are looking for. You are returning a single sum for a single stock number. You will receive only one row of data in return, the sum.
"Alan Wolfe" <[EMAIL PROTECTED]> wrote: >In this table the same stock number can apear a bunch of times, its like an >order table so thats a no go ): > >----- Original Message ----- >From: "Albert Berry" <[EMAIL PROTECTED]> >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> >Sent: Thursday, November 06, 2003 3:08 PM >Subject: [RBASE-L] - Re: strange errors > > >> The group by clause is not required, and may be giving the sytem >indigestion. �You are already restricting your total to the specific stock >number. >> >> "Alan Wolfe" <[EMAIL PROTECTED]> wrote: >> >> >Not sure if this sheds any more light on it either but we just got >another one of these errors for the following sql: >> > >> >sel sum(qtyremaining) from trandetail >> >where tranid in (sel tranid from tranmaster where districtno='73676' and >trantype='dw' and sget(reqno,2,1)='pr') >> >and stockno='6352-PP' group by stockno >> > >> >and the oterro log just returns a -1 for SQL_ERROR on a perfectly ok (as >far as i can tell) peice of sql, whats wierd is that only a couple minutes >earlier this same sql went through without error so i know it isnt the sql >thats the problem: >> > >> >SQLFreeStmt ****************** ENTER 11/06/2003 13:23:13.828 >> > hStmt HSTMT (0x27F8260) 41910880 >> > fOption UWORD (0x0) 0 >> >SQLExecDirect ****************** EXIT 11/06/2003 13:23:13.828 >> > hStmt HSTMT (0x297B7B4) 43497396 >> > szSqlStr UCHAR * "sel sum(qtyremaining) from trandetail where tranid in >(sel tranid from tranmaster where districtno='73676' and trantype='dw' and >sget(reqno,2,1)='pr') and stockno='6352-PP' group by stockno " >> > cbSqlStr SDWORD (0xC1) 193 >> > RETURN = (FFFFFFFF) -1 SQL_ERROR >> > >> >SQLError ****************** ENTER 11/06/2003 13:23:13.828 >> > hEnv HENV (0x0) 0 >> > hDbc HDBC (0x0) 0 >> > hStmt HSTMT (0x297B7B4) 43497396 >> > szSqlState UCHAR * "@o" >> > pfNativeError SDWORD * (0x3A0063) 3801187 0x1EFF630 >> > szErrorMsg UCHAR * "OUTPUT PARAM" >> > cbErrorMsgMax SWORD (0x200) 512 >> > pcbErrorMsg SWORD * (0x3CF8) 15608 0x1EFF63C >> >SQLError ****************** EXIT 11/06/2003 13:23:13.828 >> > hEnv HENV (0x0) 0 >> > hDbc HDBC (0x0) 0 >> > hStmt HSTMT (0x297B7B4) 43497396 >> > szSqlState UCHAR * "00000" >> > pfNativeError SDWORD * (0x0) 0 0x1EFF630 >> > szErrorMsg UCHAR * "" >> > cbErrorMsgMax SWORD (0x200) 512 >> > pcbErrorMsg SWORD * (0x0) 0 0x1EFF63C >> > RETURN = (64) 100 SQL_NO_DATA_FOUND >> > >> >SQLError ****************** ENTER 11/06/2003 13:23:13.828 >> > hEnv HENV (0x0) 0 >> > hDbc HDBC (0x0) 0 >> > hStmt HSTMT (0x297B7B4) 43497396 >> > szSqlState UCHAR * "" >> > pfNativeError SDWORD * (0x43014320) 1124156192 0x1EFEF00 >> > szErrorMsg UCHAR * "OUTPUT PARAM" >> > cbErrorMsgMax SWORD (0x200) 512 >> > pcbErrorMsg SWORD * (0xFFFFEE88) -4472 0x1EFEF04 >> >SQLError ****************** EXIT 11/06/2003 13:23:13.828 >> > hEnv HENV (0x0) 0 >> > hDbc HDBC (0x0) 0 >> > hStmt HSTMT (0x297B7B4) 43497396 >> > szSqlState UCHAR * "00000" >> > pfNativeError SDWORD * (0x0) 0 0x1EFEF00 >> > szErrorMsg UCHAR * "" >> > cbErrorMsgMax SWORD (0x200) 512 >> > pcbErrorMsg SWORD * (0x0) 0 0x1EFEF04 >> > RETURN = (64) 100 SQL_NO_DATA_FOUND >> > ----- Original Message ----- >> > From: Alan Wolfe >> > To: RBASE-L Mailing List >> > Sent: Thursday, November 06, 2003 12:37 PM >> > Subject: [RBASE-L] - Re: strange errors >> > >> > >> > Hi Buddy, >> > >> > In our case, this error pops up at random positions in sql that works >most of the time. >> > >> > It would be like it does the same select 1000 times and out of those, 1 >of the times it fails like this. >> > >> > When theres a witango error we have it email us what you'd normaly see >at the witango error screen so we are able to see the sql that caused the >error. When we execute this sql at the R> prompt or through oterro it works >fine, and it works the other 999 times so it's pretty strange. >> > ----- Original Message ----- >> > From: Walker, Buddy >> > To: RBASE-L Mailing List >> > Sent: Thursday, November 06, 2003 12:28 PM >> > Subject: [RBASE-L] - Re: strange errors >> > >> > >> > Alan >> > That (This type of data source is not nupported) has happened to me. >What I've done was to set a direct DBMS or Search Action and didn't select >an ODBC database. In another words the data source was blank >> > >> > Buddy >> > >> > >> > -----Original Message----- >> > From: Alan Wolfe [mailto:[EMAIL PROTECTED] >> > Sent: Thursday, November 06, 2003 2:16 PM >> > To: RBASE-L Mailing List >> > Subject: [RBASE-L] - Re: strange errors >> > >> > >> > im not sure if this helps but another part of this puzzle is that in the >witango.log it says this when those errors are hit: >> > >> > 06/11/2003 10:15:38 156.3.113.43 [EMAIL PROTECTED] 3392 4 >247312 [Error] -101 General error during data source operation. >> > 06/11/2003 10:15:41 156.3.113.43 [EMAIL PROTECTED] 3932 1 256 >[Error] -109 This type of data source is not supported by the server >license. >> > 06/11/2003 10:15:41 156.3.113.43 [EMAIL PROTECTED] 3932 1 257 >[Error] -4 Unable to connect to the specified data source. Verify that data >source is properly configured and that database server is online. >> > >> > I attached the errors from the log in case that sheds any more light on >things. >> > ----- Original Message ----- >> > From: Alan Wolfe >> > To: RBASE-L Mailing List >> > 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? >> > >> >> >> -- >> Albert Berry >> Full Time Consultant to >> PSD Solutions >> 350 West Hubbard, Suite 210 >> Chicago, IL 60610 >> 312-828-9253 Ext. 32 >> >> >> __________________________________________________________________ >> McAfee VirusScan Online from the Netscape Network. >> Comprehensive protection for your entire computer. Get your free trial >today! >> http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 >> >> Get AOL Instant Messenger 5.1 free of charge. �Download Now! >> http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 >> > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
