SQLException: ERROR: Failed to update RowID generator

Hi,

We are getting the below exception when we try load data into child table.

SQLException: ERROR: Failed to update RowID generator

How to resolve this?

Thanks
Sreelatha

Hi Sreelatha,

Can you provide more details?
Is there accompanying errors in the server log?
Please let us know the schema of you parent and child tables, copy command you are using to load and example of data (just couple of lines)

Regards
Andrei

Hi Andrei,

Thanks for the reply.
Error displayed in log :

Sat, 28 Nov 2009 12:14:31 GMT+05:30 ERROR [DatabaseLoad] -> Error While Loading : org.postgresql.util.PSQLException: ERROR: Can not prepare request: Failed to update RowID generator

There is no accompanying error.

Thanks
Sreelatha

Hi,

This error is repeating when I try to load data.

GridSQL -> SQLException: ERROR: Can not prepare request: Failed to update RowID generator

If we alter the table with no inherit and load data it is working fine.Then after that again we altered the table with inherit.

With this work around we are table to load data.
But what is the problem causing the error.

Thanks
Sri