Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

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?

The Sprezzatura Group

The Sprezzatura Blog

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?

The Sprezzatura Group

The Sprezzatura Blog

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

View this thread on the Works forum...

  • third_party_content/community/commentary/forums_works/389a73f01f03295a8525788d007436f5.txt
  • Last modified: 2023/12/30 11:57
  • by 127.0.0.1