Re: SQL Error 403
Posted in 1993
> holder@gourde.med.ge.com (Kacy Holder) writes: > >We are using Informix OnLine and Star 5.0 on HP 730's with HPUX 9.0 >and are running into an odd problem with remote database access. >Some of the ESQL select statements will return Error Number -403 >which says: > >-403 The size of the received row disagrees with the expected size. > >This is an internal error that shows a problem in the communication >between the database server and the library functions that call it. >Make sure that your probram is at the same software level as the >database server in use. > >The software level *is* exactly the same and most selects work >just fine. Any idea on where I should start to look? You omit the following sentences in the message description: "...If so, please note all circumstances and contact the Informix Technical Support Department." Had you done that, somebody would very quickly have told you about bug #14144, ERROR 403 OCCURS WHEN RETRIEVE SITENAME FROM REMOTE SERVER, described thus: [The following SQL statement failed with Error 403 ] [ ] [ database ssu021a; ] [ select * from table1; ] [ select sitename from ssu021b@ymooky:systables; ] [ ] [The problem is caused by the "sitename" in the SELECT statement. ] If this is your problem, work around it by not selecting the sitename. The fix appears in version 5.01.UC1. Dave Cortesi