[User-Defined Object - Table Name] , 'There are values in table @UNE_QCFRMHED' SAP Business One

[nikunjmehta2290]

Dear all,

Recently , I have unregister the UDO and try to register same UDO but getting error. I have also tried with delete object and register again but remain same.

I need add few more UDF into UDO and try to again register and getting this error.

[User-Defined Object - Table Name] , 'There are values in table @UNE_QCFRMHED'

How can resolve it?

Regards,

Nikunj Mehta

[kai_f]

Hi Nikunj,

it is not possible to register a UDO when there are still records inside that table.

So you have to delete those records first. You can add those records after you register your UDO again.

Regards,

Kai

[nikunjmehta2290]

Thanks for the response.

I have found records after the executed the query. But I cannot remove it because it's live database and I need to just add few more column into UDO line level to show this new UDF into UDO.

What is the next solution?

Regards,

Nikunj Mehta

[Johan_H]

Hi Nikunj Mehta,

You can do it like this:

1. Create a test company database from the latest backup of the live company database.
2. Create a query, that inserts the existing records from [@UNE_QCFRMHED] in the test database into [@UNE_QCFRMHED] in the live database. Use named fields. DO NOT RUN IT, just get it ready.
3. Preferably after office hours continue with the following steps:
4. Delete the records from [@UNE_QCFRMHED] in the live database.
5. Register the UDO and add your new fields.
6. Run the query you creating during step 2.

If you want to be really sure, you can create 2 test databases from the latest backup of the live database, and test the whole procedure in the second test database first.

The only other solution is creating a new table, a copy of [@UNE_QCFRMHED] with a different name, and have the UDO use that table.

Regards,

Johan

[azizelmir]

Hi nik2290,

Please run this query to see if there is data in this table:

SELECT * FROM [@UNE_QCFRMHED]

If yes, try deleting data on this table and re-register the UDO.

Thank you,

Aziz

[nikunjmehta2290]

Thanks for the response.

I have found records after the executed the query. But I cannot remove it because it's live database and I need to just add few more column into UDO line level to show this new UDF into UDO.

What is the next solution?

Regards,

Nikunj Mehta