Problem with or_view (OpenInsight 32-Bit)
At 11 MAY 2011 05:09:22PM David Nicol wrote:
Can anyone tell me why this code generates an FS231: Warning! Network Service Configuration Error?
Answer=16
list=LIST ENTRIES WITH TRANS_TYPE EQ "Disburse" AND WITH PROPERTY EQ ':Answer:' PROPERTY UNIT PAYMENT'
retval=or_view("",list)
At 12 MAY 2011 07:53AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Normally, you'd get this at login, not in the middle of an appplication. What this initially implies is that the list statement is accessing a file on a secondary server somewhere.
So, a few questions, in no particular order.
OI Version?
Network OS?
LH Driver version?
Can you LIST ENTRIES without an error?
Are any of these fields symbolics?
World leaders in all things RevSoft
At 12 MAY 2011 01:33PM David Nicol wrote:
I'm using Netware 6.5 for the server, XP on the workstation.
The Network Driver is Universal Driver 3.0.0.2 and OI version 4.13.
"PAYMENT" is a symbolic field and I can use System Monitor to RLIST "LIST 10 ENTRIES"
At 13 MAY 2011 06:59AM Mike Ruane wrote:
Dave-
If you try this with RUN_REPORT instead of OR_VIEW, do you see a different result?
Mike
At 13 MAY 2011 09:23AM Jared Bratu wrote:
Is this the same system you were trying to OpenInsight 9.x working with? I seem to recall you discovered removing the MFS would resolve the problem. Is this still the case or was this a different problem?
At 13 MAY 2011 04:06PM David Nicol wrote:
When I try to use Run_Report("",list), I get this error:
SYS1000: Error loading program "RUN_REPORT"
At 13 MAY 2011 04:07PM David Nicol wrote:
No Jared, this is a completely different problem.
At 16 MAY 2011 08:14AM Mike Ruane wrote:
Dave-
What version of OI are you using?
Mike
At 16 MAY 2011 02:53PM David Nicol wrote:
I'm using Netware 6.5 for the server, XP on the workstation.
The Network Driver is Universal Driver 3.0.0.2 and OI version 4.13.
"PAYMENT" is a symbolic field and I can use System Monitor to RLIST "LIST 10 ENTRIES"
At 17 MAY 2011 07:09AM Mike Ruane wrote:
Dave-
An old version of OI, but the statement should still work.
If you run the statement in a program, doing a set_status(0) before the RLIST command, is there a different outcome?
Mike
At 17 MAY 2011 09:09AM Jared Bratu wrote:
I understand it is a different problem but is it the same system? We never fully identified why removing the MFS resolve the problem for OI 9.x. I'm just looking for correlations between issues.
At 17 MAY 2011 02:25PM David Nicol wrote:
When I try it with Run_Report, I get SYS1000: Error loading program "RUN_REPORT" as I did before.
When using or_view, the view screen flashes on and then disappears. I get the error FS231 as I did before.
Using set_status(0) doesn't make any difference.
At 17 MAY 2011 03:29PM Warren Auyong wrote:
RUN_REPORT doesn't exist in 4.x, use the RLIST routine instead.
At 17 MAY 2011 08:08PM Sean FitzSimons wrote:
Dave,
Also try rebuilding the index on the PAYMENT field.
Sean
At 18 MAY 2011 02:14PM David Nicol wrote:
I have pinned the problem down to the symbolic field 'PAYMENT'. If I run the or_view without the symbolic field, it displays the correct records and fields. If I add PAYMENT the view screen flashes and gives the FS231 error. Subsequent running of or_view without the symbolic doesn't display unless I log off and log on again.
Anyone have suggestions?
Here is the code for the symbolic 'Payment'
DECLARE SUBROUTINE BTREE.EXTRACT
PROPERTY={PROPERTY}
IF PROPERTY=@USER0 THEN
BANK=@USER0
AR =@USER0
AP =@USER0
END ELSE
SEARCH=TYPE":@VM:"Bank":@FM:"PROPERTY":@VM:PROPERTY:@FM;KEYS=';FLAG='
OPEN "DICT.LEDGER" TO DICT_LEDGER ELSE RETURN 0
BTREE.EXTRACT(SEARCH,"LEDGER",DICT_LEDGER,KEYS,"S",FLAG)
BANK=FIELD(KEYS,"*",2,1)
SEARCH=TYPE":@VM:"A/R":@FM:"PROPERTY":@VM:PROPERTY:@FM;KEYS=';FLAG='
BTREE.EXTRACT(SEARCH,"LEDGER",DICT_LEDGER,KEYS,"S",FLAG)
AR=FIELD(KEYS,"*",2,1)
SEARCH=TYPE":@VM:"A/P":@FM:"PROPERTY":@VM:PROPERTY:@FM;KEYS=';FLAG='
BTREE.EXTRACT(SEARCH,"LEDGER",DICT_LEDGER,KEYS,"S",FLAG)
AP=FIELD(KEYS,"*",2,1)
@USER0=PROPERTY
@USER0=BANK
@USER0=AR
@USER0=AP
END
ACCT={ACCOUNT};AMT={AMOUNT};TT={TRANS_TYPE};CT={CHEQUE_TYPE};@ANS="
FOR I=1 TO COUNT(ACCT, @VM)+1
IF ACCT EQ BANK AND TT EQ "Receipt" THEN @ANS+=AMT
IF ACCT EQ AR AND TT EQ "Invoice" THEN @ANS+=AMT
IF ACCT EQ BANK AND TT EQ "Cheque" THEN @ANS+=AMT
IF ACCT EQ AP AND TT EQ "Disburse" AND CT=Auto" THEN @ANS+=AMT
IF ACCT EQ BANK AND TT EQ "Disburse" AND CT=Man." THEN @ANS+=AMT
NEXT I
FLUSH
GARBAGECOLLECT
At 18 MAY 2011 03:02PM Sean FitzSimons wrote:
Dave,
What happens when you use the following statement from the System Monitor:
RLIST "LIST 10 ENTRIES PAYMENT"
Do you you receive the FS231 error? Have you tried debugging/isolating the location of the FS231 error within the PAYMENT field?
Sean
At 19 MAY 2011 03:44AM Keith Alvey wrote:
Hi Dave,
Have you tried porting this code to a function and calling the function from the Payment symbolic … you may well get a more useful error message, plus it will make debugging of it much easier !!
Cheers,
Simon
At 19 MAY 2011 07:34AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
What happens when you access the DICT.LEDGER file?
World leaders in all things RevSoft
At 19 MAY 2011 08:39AM Mike Ruane wrote:
I was wondering about that too - return 0? Not so good….
At 20 MAY 2011 01:45PM David Nicol wrote:
I was trying to be cute and save CPU cycles. This was originally a symbolic from ARev running on a 286, if anyone remembers. I removed the @USER1 from the symbolic and it all works fine on an Intel Core I7
Thanks for the help.
Dave