Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Jardinillo
New Contributor II

QV 12 General error

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

 

 

2 Solutions

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: QV 12 General error

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

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?

7 Replies
MVP & Luminary
MVP & Luminary

Re: QV 12 General error

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

Jardinillo
New Contributor II

Re: QV 12 General error

 I made an exit script and there is no error

MVP & Luminary
MVP & Luminary

Re: QV 12 General error

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

Jardinillo
New Contributor II

Re: QV 12 General error

Thank you very much for your help

MVP & Luminary
MVP & Luminary

Re: QV 12 General error

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

Jardinillo
New Contributor II

Re: QV 12 General error

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

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?