Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Jardinillo
Contributor II
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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

rubenmarin

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?

View solution in original post

7 Replies
marcus_sommer

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
Contributor II
Contributor II
Author

 I made an exit script and there is no error

marcus_sommer

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
Contributor II
Contributor II
Author

Thank you very much for your help

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor II
Contributor II
Author

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

rubenmarin

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?