Problems acessing certain tables

Hi all. I'm not sure I'm posting on the right forum, but I'll still do my question. So, I have ported an internal server, that as the function of database server, among others, to a new server. The specifications are the follwing: SERVER.OLD(i686) SERVER.NEW(x86_64) IBM IDS 9.40.UC6 --> IBM IDS 11.50.FC9DE So, I've migrated the databases, making the dbexport on SERVER.OLD, creating the instances on SERVER.NEW, and making dbimport. So far, no problem, since I can connect with dbaccess and can query the databases of the different instances. Now, the problem is when I try to compile some sources on an old server, that is now connected to the new server. This third server, is an I4GL server, where we compile some sources to maintain compatibility, with olders I4GL compilers/runners. The specifications are the follwing: SERVER.COMPILER INFORMIX-4GL Version 7.20.UD7 So, I'll describe the symptoms now. I have a record of a table. If I try to compile a 4gl with the record: | | The symbol "table" is not the name of a table in the | specified database. | See error number -4320. If I comment the record line, and make an unload of the same table, it compiles, and runs, loading the content of the table. Using dbschema: -206 - The specified table (cferreir.table) is not in the database. -111 - ISAM error: no record found. Using dbaccess: The table appears on the Info, but shows no columns at all. To finalize: - using the new database motor with a more recent compiler, I have no problems. - using the old database motor with the older compiler, I have no problem. So, why can't I compile with the new database motor and the old compiler? Hope that I'd been clear. Feel free to ask me more things, if you don't understand my questions. Any help would appreciated. Thanks :)

The table has DECIMAL columns on it? The behavior with dbaccess and dbschema can be reproduce after an engine restart and before you try to connect that old 4GL compiler to the engine? It sounds reasonably familiar, but as far as I can remember it shoudl not happen with 11.50.FC9... In any case, 4GL 7.20.UC7 was never certified for 11.50 since AFAIR it was already unsupported when 11.50 was released. Regards. On Tue, Aug 14, 2012 at 10:47 AM, FERNANDO ALMEIDA < fernandoalmeida346@gmail.com> wrote: > Hi all. > > I'm not sure I'm posting on the right forum, but I'll still do my question. > > So, I have ported an internal server, that as the function of database > server, > among others, to a new server. > The specifications are the follwing: > > SERVER.OLD(i686) SERVER.NEW(x86_64) > > IBM IDS 9.40.UC6 --> IBM IDS 11.50.FC9DE > > So, I've migrated the databases, making the dbexport on SERVER.OLD, > creating > the instances on SERVER.NEW, and making dbimport. > > So far, no problem, since I can connect with dbaccess and can query the > databases of the different instances. > > Now, the problem is when I try to compile some sources on an old server, > that > is now connected to the new server. This third server, is an I4GL server, > where we compile some sources to maintain compatibility, with olders I4GL > compilers/runners. > > The specifications are the follwing: > > SERVER.COMPILER > INFORMIX-4GL Version 7.20.UD7 > > So, I'll describe the symptoms now. > > I have a record of a table. If I try to compile a 4gl with the record: > > | > | The symbol "table" is not the name of a table in the > | specified database. > | See error number -4320. > > If I comment the record line, and make an unload of the same table, it > compiles, and runs, loading the content of the table. > > Using dbschema: > > -206 - The specified table (cferreir.table) is not in the database. > -111 - ISAM error: no record found. > > Using dbaccess: > > The table appears on the Info, but shows no columns at all. > > To finalize: > > - using the new database motor with a more recent compiler, I have no > problems. > - using the old database motor with the older compiler, I have no problem. > > So, why can't I compile with the new database motor and the old compiler? > > Hope that I'd been clear. Feel free to ask me more things, if you don't > understand my questions. > > Any help would appreciated. > Thanks :) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00235429cfac8d8c0104c736f91b

Fernando, it had decimals on it. But it wasn't the problem. I made an experience, recreating a specific table with user informix, and the problems gone, on the 4gl test program I made. So, as it isn't important to keep the objects owners, on this case, I edited the database.sql from the export, and replaced, all object creators owners. For example: create table "usera".tablea --to--> create table "informix".tablea create index "usera".indexa --to--> create index "informix".indexa and so on, for all objects. After that, dropped the database, and made dbimport again. And is it. So, I didn't understand well what is the problem, once the dbimport didn't complain about the users and objects creation. Besides that, OLDSERVER, didn't have that user. But now is running, and that's what matters now. Thanks for your help. :)

Table privileges... probably Regards On Tue, Aug 14, 2012 at 4:40 PM, FERNANDO ALMEIDA < fernandoalmeida346@gmail.com> wrote: > Fernando, it had decimals on it. But it wasn't the problem. > > I made an experience, recreating a specific table with user informix, and > the > problems gone, on the 4gl test program I made. > So, as it isn't important to keep the objects owners, on this case, I > edited > the database.sql from the export, and replaced, all object creators owners. > For example: > > create table "usera".tablea --to--> create table "informix".tablea > create index "usera".indexa --to--> create index "informix".indexa > > and so on, for all objects. > > After that, dropped the database, and made dbimport again. And is it. > > So, I didn't understand well what is the problem, once the dbimport didn't > complain about the users and objects creation. Besides that, OLDSERVER, > didn't > have that user. > But now is running, and that's what matters now. > > Thanks for your help. :) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00248c769162a796bf04c73bcd57