topic Re: QV 12 General error in QlikView

QV 12 General error

Jardinillo — Wed, 12 Jun 2019 12:17:57 GMT

Hello:

When I launch the recharge I get the following error:

General error

The name 'table1' already exists.

rename table [table2] to table1

With QV 11, the recharge is carried out without any problem with the same script

Please, do you know how to solve this error?

Thank you

Re: QV 12 General error

marcus_sommer — Wed, 12 Jun 2019 13:47:36 GMT

A field/table couldn't be renamed into one which exists already to this time. I think there were no changes between QV 11 and 12 or any bugs else something has changed within (the order of) your script and there is really already a table1 when you tries this renaming. A quick check would be to add a:

exit script;

before your renaming-statement and then to open the tableviewer.

- Marcus

Re: QV 12 General error

Jardinillo — Wed, 12 Jun 2019 14:06:04 GMT

I made an exit script and there is no error

Re: QV 12 General error

marcus_sommer — Wed, 12 Jun 2019 14:16:20 GMT

That's ok. An now take a look ino the tableviewer - per menu or ctrl + t - and you should see anywhere a table1 and quite probably you could identify which data it contains and where and why it was loaded.

- Marcus

Re: QV 12 General error

Jardinillo — Wed, 12 Jun 2019 14:49:11 GMT

Thank you very much for your help

Re: QV 12 General error

rwunderlich — Wed, 12 Jun 2019 19:47:39 GMT

A table cannot be renamed to an existing name. In QV11, this error was simply ignored and the script carried on. QV12 was updated to treat this as a true error that would stop script execution. An improvement in my opinion.

To "solve" this problem, you can simply remove the statement. In QV11 it was doing nothing so you don't need it in QV12.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: QV 12 General error

Jardinillo — Thu, 13 Jun 2019 08:52:29 GMT

Hello,
It worked for me in the following way:

set ErrorMode = 0;

Rename table1 to table2;

set ErrorMode = 1;

Thank you very much for your help

Re: QV 12 General error

rubenmarin — Thu, 13 Jun 2019 11:15:11 GMT

Hi, I think that that's the same than removing the rename table instruction.

I would recomend to follow and solve the error, not just ignore it. Why there is a rename of the table and why already exists a table with that name? should data be concatenated?